DROP TABLE IF EXISTS `mode-61139648573_backup_table`;
DROP TABLE IF EXISTS `mode-61139648573_temp_table`;
CREATE TABLE `mode-61139648573_temp_table` AS (SELECT * FROM `mode-skeleton` WHERE 1=2);
ALTER TABLE `mode-61139648573_temp_table` ADD PRIMARY KEY(`id`);
INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Edge Hill Mens Leather Comfort Wide Fit Shoes - Brown','1664492830781','Rockport Edge Hill Mens Leather Comfort Wide Fit Shoes','Mens','brown','s07.5 s08.5 s09.0 s10.5 s11.0 ','rockport','87.00','250.00','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_1722_1396956c-648b-4385-9080-e0ebe5b1500d_medium.jpg?v=1569290629','//modefootwear.com.au/cdn/shop/products/IMG_1722_1396956c-648b-4385-9080-e0ebe5b1500d_large.jpg?v=1569290629','collections/rockport/products/rockport-edge-hill-mens-leather-comfort-walking-shoes?variant=13636434100285','1','10/20/2015','1','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Edge Hill Mens Leather Comfort Wide Fit Shoes - Black','1664492830781','Rockport Edge Hill Mens Leather Comfort Wide Fit Shoes','Mens','black','s07.5 s08.5 s09.0 s10.5 s11.0 ','rockport','87.00','250.00','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_1712_4c9796b3-0220-4ce5-a3d7-092484a5253d_medium.jpg?v=1569290629','//modefootwear.com.au/cdn/shop/products/IMG_1712_4c9796b3-0220-4ce5-a3d7-092484a5253d_large.jpg?v=1569290629','collections/rockport/products/rockport-edge-hill-mens-leather-comfort-walking-shoes?variant=13636434067517','2','10/20/2015','1','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport World Tour Classic Mens Comfort Wide Fit Walking Shoes - Chocolate Chip','7279195914301','Rockport World Tour Classic Mens Comfort Wide Fit Walking Shoes','Mens','chocolate','s07.5 s08.0 s08.5 s11.5 s14.0 ','rockport','79.00','230.00','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_0335_b1b94207-ccb9-46f6-9b4a-8e1cbff15e9d_medium.jpg?v=1712557070','//modefootwear.com.au/cdn/shop/files/IMG_0335_b1b94207-ccb9-46f6-9b4a-8e1cbff15e9d_large.jpg?v=1712557070','collections/rockport/products/rockport-world-tour-classic-mens-comfort-walking-shoes?variant=41176311234621','1','04/08/2024','2','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport World Tour Classic Mens Comfort Wide Fit Walking Shoes - Black','7279195914301','Rockport World Tour Classic Mens Comfort Wide Fit Walking Shoes','Mens','black','s07.5 s08.0 s08.5 s11.5 s14.0 ','rockport','79.00','230.00','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_0345_947efbc8-fcb9-40e4-81d3-2f6ebb7af7a1_medium.jpg?v=1712557071','//modefootwear.com.au/cdn/shop/files/IMG_0345_947efbc8-fcb9-40e4-81d3-2f6ebb7af7a1_large.jpg?v=1712557071','collections/rockport/products/rockport-world-tour-classic-mens-comfort-walking-shoes?variant=41176311267389','2','04/08/2024','2','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Aderner Mens Leather Wide Fit Slip On Shoes - Black','1664496107581','Rockport Aderner Mens Leather Wide Fit Slip On Shoes','Mens','black','s06.5 s07.5 s09.5 ','rockport','83.00','240.00','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_0388_e04cdfe8-795e-49a0-87f5-60f1f843350b_medium.jpg?v=1569290629','//modefootwear.com.au/cdn/shop/products/IMG_0388_e04cdfe8-795e-49a0-87f5-60f1f843350b_large.jpg?v=1569290629','collections/rockport/products/rockport-aderner-mens-leather-slip-on-shoes?variant=13636340875325','1','08/20/2015','3','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Allander Mens Leather Lighweight Comfortable Wide Fit Shoes - Black','7279195815997','Rockport Allander Mens Leather Lighweight Comfortable Wide Fit Shoes','Mens','black','s11.5 ','rockport','83.00','240.00','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/1_14f09e5c-b5d6-4ad0-8d49-3007633dfe83_medium.jpg?v=1712556977','//modefootwear.com.au/cdn/shop/files/1_14f09e5c-b5d6-4ad0-8d49-3007633dfe83_large.jpg?v=1712556977','collections/rockport/products/rockport-allander-mens-leather-lace-up-shoes?variant=41176310841405','1','04/08/2024','4','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Parissa Novelty Lace Up Womens Wide Fit Casual Shoes - Black','7049607872573','Rockport Parissa Novelty Lace Up Womens Wide Fit Casual Shoes','Womens','black','s10.0 ','rockport','79.95','199.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_0018_176a5add-4db8-4af9-8cc1-a016c3b6dd0f_medium.jpg?v=1688734599','//modefootwear.com.au/cdn/shop/files/IMG_0018_176a5add-4db8-4af9-8cc1-a016c3b6dd0f_large.jpg?v=1688734599','collections/rockport/products/rockport-parissa-novelty-lace-up-womens-wide-fit-casual-shoes?variant=40675020570685','1','07/05/2023','5','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Womens Pulsetech XCS Hiker Waterproof Wide Fit Leather Shoes - Bordo','7039082397757','Rockport Womens Pulsetech XCS Hiker Waterproof Wide Fit Leather Shoes','Womens','bordo','s06.5 s07.5 s10.0 ','rockport','79.95','219.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_2072_99622f4a-cb47-453a-97bd-a2f022825bd2_medium.jpg?v=1685514044','//modefootwear.com.au/cdn/shop/files/IMG_2072_99622f4a-cb47-453a-97bd-a2f022825bd2_large.jpg?v=1685514044','collections/rockport/products/rockport-womens-pulsetech-xcs-hiker-waterproof-wide-fit-leather-shoes?variant=40637395861565','1','09/30/2022','6','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Total Motion Sport Lace Up Womens Wide Fit Comfort Shoes - Pink','7039082364989','Rockport Total Motion Sport Lace Up Womens Wide Fit Comfort Shoes','Womens','pink','s08.0 s10.0 ','rockport','59.95','199.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_2260_4ad0762e-67fa-49be-a02f-7d585a8c1016_medium.jpg?v=1685514038','//modefootwear.com.au/cdn/shop/files/IMG_2260_4ad0762e-67fa-49be-a02f-7d585a8c1016_large.jpg?v=1685514038','collections/rockport/products/rockport-total-motion-sport-lace-up-womens-wide-fit-comfort-shoes?variant=40637395370045','1','04/17/2021','7','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport XCS Spruce Peak Hiker Waterproof Womens Wide Leather Shoes - Taupe','7052323160125','Rockport XCS Spruce Peak Hiker Waterproof Womens Wide Leather Shoes','Womens','taupe','s08.0 s10.0 ','rockport','79.95','219.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6671_5394cda4-655e-4e2b-a57a-ae9bc3031245_medium.jpg?v=1689457569','//modefootwear.com.au/cdn/shop/files/IMG_6671_5394cda4-655e-4e2b-a57a-ae9bc3031245_large.jpg?v=1689457569','collections/rockport/products/rockport-xcs-spruce-peak-hker-wateproof-womens-wide-leather-shoes?variant=40683409440829','1','07/16/2023','8','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport XCS Spruce Peak Hiker Waterproof Womens Wide Leather Shoes - Blue','7052323160125','Rockport XCS Spruce Peak Hiker Waterproof Womens Wide Leather Shoes','Womens','blue','s08.0 s10.0 ','rockport','79.95','219.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6663_395b1c6f-8a3f-41ff-a1a0-7682a6abb6f1_medium.jpg?v=1689457566','//modefootwear.com.au/cdn/shop/files/IMG_6663_395b1c6f-8a3f-41ff-a1a0-7682a6abb6f1_large.jpg?v=1689457566','collections/rockport/products/rockport-xcs-spruce-peak-hker-wateproof-womens-wide-leather-shoes?variant=40683409408061','2','07/16/2023','8','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Trustride Layered Comfortable Womens Wide Fit Leather Shoes - Black','7052327092285','Rockport Trustride Layered Comfortable Womens Wide Fit Leather Shoes','Womens','black','s07.0 s08.5 s09.0 ','rockport','79.95','220.00','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6581_5eb87e54-615e-4d75-b627-beb98f8db7bf_medium.jpg?v=1689460226','//modefootwear.com.au/cdn/shop/files/IMG_6581_5eb87e54-615e-4d75-b627-beb98f8db7bf_large.jpg?v=1689460226','collections/rockport/products/rockport-trustride-layered-comfortable-womens-wide-fit-leather-shoes?variant=40683416551485','1','07/16/2023','9','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Trustride Centre Zip Comfortable Womens Wide Fit Shoes - Black','7052328403005','Rockport Trustride Centre Zip Comfortable Womens Wide Fit Shoes','Womens','black','s10.0 ','rockport','79.95','199.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6602_e8e3af2c-4ace-47c4-839d-8933562acf3d_medium.jpg?v=1689461499','//modefootwear.com.au/cdn/shop/files/IMG_6602_e8e3af2c-4ace-47c4-839d-8933562acf3d_large.jpg?v=1689461499','collections/rockport/products/rockport-trustride-centre-zip-comfortable-womens-wide-fit-shoes?variant=40683417960509','1','07/16/2023','10','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Parissa Retro Comfortable Womens Wide Fit Leather Shoes - Black','7052325224509','Rockport Parissa Retro Comfortable Womens Wide Fit Leather Shoes','Womens','black','s07.0 ','rockport','79.95','199.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6627_b99593df-09d1-4642-8c71-6808559adce0_medium.jpg?v=1689459595','//modefootwear.com.au/cdn/shop/files/IMG_6627_b99593df-09d1-4642-8c71-6808559adce0_large.jpg?v=1689459595','collections/rockport/products/rockport-parissa-retro-comfortable-womens-wide-fit-leather-shoes?variant=40683414487101','1','07/16/2023','11','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Ayva Washable Penny Loafer Womens Wide Fit Leather Shoes - Black','7052324208701','Rockport Ayva Washable Penny Loafer Womens Wide Fit Leather Shoes','Womens','black','s06.5 s07.0 s07.5 ','rockport','79.95','199.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6588_d8f814d4-efcd-4292-bc6c-fe63587d80c0_medium.jpg?v=1689458483','//modefootwear.com.au/cdn/shop/files/IMG_6588_d8f814d4-efcd-4292-bc6c-fe63587d80c0_large.jpg?v=1689458483','collections/rockport/products/rockport-ayva-washable-penny-loafer-womens-wide-fit-leather-shoes?variant=40683412455485','1','07/16/2023','12','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Ayva Washable Penny Loafer Womens Wide Fit Leather Shoes - Vanilla','7052324208701','Rockport Ayva Washable Penny Loafer Womens Wide Fit Leather Shoes','Womens','vanilla','s06.5 s07.0 s07.5 ','rockport','79.95','199.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6681_b834a109-2149-4665-b7c0-44ab1c598563_medium.jpg?v=1689458485','//modefootwear.com.au/cdn/shop/files/IMG_6681_b834a109-2149-4665-b7c0-44ab1c598563_large.jpg?v=1689458485','collections/rockport/products/rockport-ayva-washable-penny-loafer-womens-wide-fit-leather-shoes?variant=40683412586557','3','07/16/2023','12','','','');

INSERT INTO `mode-61139648573_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Rockport Total Motion Lillie Ballet Womens Wide Fit Leather Shoes - Black','7052324798525','Rockport Total Motion Lillie Ballet Womens Wide Fit Leather Shoes','Womens','black','s06.5 s07.0 s07.5 ','rockport','79.95','220.00','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6611_2df0197c-9a53-4dd7-976d-4ff4a1c5324c_medium.jpg?v=1689459077','//modefootwear.com.au/cdn/shop/files/IMG_6611_2df0197c-9a53-4dd7-976d-4ff4a1c5324c_large.jpg?v=1689459077','collections/rockport/products/rockport-total-motion-lillie-ballet-womens-wide-fit-leather-shoes?variant=40683413667901','1','07/16/2023','13','','','');

DROP TABLE IF EXISTS `mode-61139648573`;
CREATE TABLE `mode-61139648573` AS SELECT * FROM `mode-61139648573_temp_table`;
ALTER TABLE `mode-61139648573` ADD PRIMARY KEY(`id`);
DROP TABLE IF EXISTS `mode-61139648573_temp_table`;

Total products in collection:: 13


Total displayed variants on website:: 17