DROP TABLE IF EXISTS `mode-61138731069_backup_table`;
DROP TABLE IF EXISTS `mode-61138731069_temp_table`;
CREATE TABLE `mode-61138731069_temp_table` AS (SELECT * FROM `mode-skeleton` WHERE 1=2);
ALTER TABLE `mode-61138731069_temp_table` ADD PRIMARY KEY(`id`);
INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Slatters Shackle Mens Comfortable Leather Boat Shoes - Navy','1814355214397','Slatters Shackle Mens Comfortable Leather Boat Shoes','Mens','navy','s06.0 s07.0 s07.5 s08.0 s08.5 s09.0 s09.5 s10.0 s10.5 s11.0 ','slatters','147.00','159.95','p3p101-150','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_2921_64c220ea-c060-4bef-99cb-25bf794a7987_medium.jpg?v=1602135733','//modefootwear.com.au/cdn/shop/products/IMG_2921_64c220ea-c060-4bef-99cb-25bf794a7987_large.jpg?v=1602135733','collections/sale/products/slatters-shackle-mens-comfortable-leather-boat-shoes?variant=13943279878205','1','07/30/2015','1','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - Black Weave','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','black','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_3239_medium.jpg?v=1693553901','//modefootwear.com.au/cdn/shop/files/IMG_3239_large.jpg?v=1693553901','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734983749693','1','12/22/2016','2','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - Steel Reptile','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','steel','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_3157_1f2abc41-ab9e-45a4-81fd-1434295269d7_medium.jpg?v=1693553890','//modefootwear.com.au/cdn/shop/files/IMG_3157_1f2abc41-ab9e-45a4-81fd-1434295269d7_large.jpg?v=1693553890','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734985453629','3','12/22/2016','2','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - White Reptile','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','white','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_3217_medium.jpg?v=1693553894','//modefootwear.com.au/cdn/shop/files/IMG_3217_large.jpg?v=1693553894','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734985486397','4','12/22/2016','2','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - Brown Reptile','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','brown','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6450_0f3357c0-92ba-427d-8ef0-fdd9c88bb863_medium.jpg?v=1693553911','//modefootwear.com.au/cdn/shop/files/IMG_6450_0f3357c0-92ba-427d-8ef0-fdd9c88bb863_large.jpg?v=1693553911','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734985551933','5','12/22/2016','2','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - Coral Reptile','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','coral','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_3175_medium.jpg?v=1693553900','//modefootwear.com.au/cdn/shop/files/IMG_3175_large.jpg?v=1693553900','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734985748541','6','12/22/2016','2','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - Raspberry Reptile','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','raspberry','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_3135_medium.jpg?v=1693553895','//modefootwear.com.au/cdn/shop/files/IMG_3135_large.jpg?v=1693553895','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734985945149','10','12/22/2016','2','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - Silver Weave','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','silver','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_3184_medium.jpg?v=1693553892','//modefootwear.com.au/cdn/shop/files/IMG_3184_large.jpg?v=1693553892','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734986043453','11','12/22/2016','2','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - White/Silver','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','white','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6438_4aa349af-3793-4e83-9dde-564c540c5cf2_medium.jpg?v=1693553903','//modefootwear.com.au/cdn/shop/files/IMG_6438_4aa349af-3793-4e83-9dde-564c540c5cf2_large.jpg?v=1693553903','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734986076221','12','12/22/2016','2','','','');

INSERT INTO `mode-61138731069_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs - Black Patent','7077546459197','Scholl Orthaheel Sonoma II Womens Supportive Comfort Thongs','Womens','black','s06.0 s10.0 s11.0 s12.0 ','scholl-orthaheel','65.95','69.95','p2p51-100','Sandals','NONE','//modefootwear.com.au/cdn/shop/files/IMG_4508_296a6e4c-7f1a-4870-bc73-ed1b15656c59_medium.jpg?v=1693553898','//modefootwear.com.au/cdn/shop/files/IMG_4508_296a6e4c-7f1a-4870-bc73-ed1b15656c59_large.jpg?v=1693553898','collections/sale/products/scholl-orthaheel-sonoma-ii-womens-supportive-comfort-thongs?variant=40734986502205','16','12/22/2016','2','','','');

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

Total products in collection:: 2


Total displayed variants on website:: 10