DROP TABLE IF EXISTS `mode-61142958141_backup_table`;
DROP TABLE IF EXISTS `mode-61142958141_temp_table`;
CREATE TABLE `mode-61142958141_temp_table` AS (SELECT * FROM `mode-skeleton` WHERE 1=2);
ALTER TABLE `mode-61142958141_temp_table` ADD PRIMARY KEY(`id`);
INSERT INTO `mode-61142958141_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/dress-slipon/products/rockport-aderner-mens-leather-slip-on-shoes?variant=13636340875325','1','08/20/2015','1','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('ECCO Mens Helsinki 2 Mens Slip On Comfortable Leather Dress Shoes - Black','6881393836093','ECCO Mens Helsinki 2 Mens Slip On Comfortable Leather Dress Shoes','Mens','black','s6-6.5 s7-7.5 s9-9.5 s10-10.5 s11-11.5 s12-12.5 ','ecco','195.00','259.95','p4p151-20','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_9357_9f439251-e0a1-4798-a7c8-da635201ffd6_medium.jpg?v=1698445945','//modefootwear.com.au/cdn/shop/files/IMG_9357_9f439251-e0a1-4798-a7c8-da635201ffd6_large.jpg?v=1698445945','collections/dress-slipon/products/ecco-mens-helsinki-2-mens-slip-on-comfortable-leather-dress-shoes?variant=40224715341885','1','09/09/2022','2','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('ECCO Mens Helsinki Mens Bike Toe Slip On Comfortable Leather Dress Shoes - Black','6616262246461','ECCO Mens Helsinki Mens Bike Toe Slip On Comfortable Leather Dress Shoes','Mens','black','s10-10.5 s11-11.5 ','ecco','153.00','219.95','p4p151-20','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/IMG_2974_878f3f7e-8f5b-4c9f-9808-5709bb874940_medium.jpg?v=1703330529','//modefootwear.com.au/cdn/shop/files/IMG_2974_878f3f7e-8f5b-4c9f-9808-5709bb874940_large.jpg?v=1703330529','collections/dress-slipon/products/ecco-mens-helsinki-mens-bike-toe-slip-on-comfortable-leather-dress-shoes?variant=39406022328381','1','09/18/2021','3','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Vinnie Mens Leather Slip On Comfort Shoes Made In Brazil - Coffee','1552851173437','Ferricelli Vinnie Mens Leather Slip On Comfort Shoes Made In Brazil','Mens','coffee','s09.0 s11.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_9086_76bcfc0a-8db4-4eca-ae60-bdec6185c70f_medium.jpg?v=1599196113','//modefootwear.com.au/cdn/shop/products/IMG_9086_76bcfc0a-8db4-4eca-ae60-bdec6185c70f_large.jpg?v=1599196113','collections/dress-slipon/products/ferricelli-vinnie-mens-leather-slip-on-comfort-shoes-made-in-brazil?variant=32073945120829','1','07/03/2018','4','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Vinnie Mens Leather Slip On Comfort Shoes Made In Brazil - Black','1552851173437','Ferricelli Vinnie Mens Leather Slip On Comfort Shoes Made In Brazil','Mens','black','s09.0 s11.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6023_10477c36-6679-4f34-ad75-39f01561af95_medium.jpg?v=1599195891','//modefootwear.com.au/cdn/shop/products/IMG_6023_10477c36-6679-4f34-ad75-39f01561af95_large.jpg?v=1599195891','collections/dress-slipon/products/ferricelli-vinnie-mens-leather-slip-on-comfort-shoes-made-in-brazil?variant=13210998243389','3','07/03/2018','4','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Craig Mens Wave Memory Comfort Technology Dress Shoes - Black','1552852058173','Ferricelli Craig Mens Wave Memory Comfort Technology Dress Shoes','Mens','black','s10.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_5941_03390927-5395-4e7e-824b-f45740bb813e_medium.jpg?v=1540634630','//modefootwear.com.au/cdn/shop/products/IMG_5941_03390927-5395-4e7e-824b-f45740bb813e_large.jpg?v=1540634630','collections/dress-slipon/products/ferricelli-craig-mens-leather-slip-on-comfort-dress-shoes-made-in-brazil?variant=13211006861373','1','07/03/2018','5','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Craig Mens Wave Memory Comfort Technology Dress Shoes - Brown','1552852058173','Ferricelli Craig Mens Wave Memory Comfort Technology Dress Shoes','Mens','brown','s10.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_7025_fc6a323d-60ef-4aba-bbd9-519e60062b7a_medium.jpg?v=1540634630','//modefootwear.com.au/cdn/shop/products/IMG_7025_fc6a323d-60ef-4aba-bbd9-519e60062b7a_large.jpg?v=1540634630','collections/dress-slipon/products/ferricelli-craig-mens-leather-slip-on-comfort-dress-shoes-made-in-brazil?variant=13211006894141','2','07/03/2018','5','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Voyager Mens Leather Gel Flex Comfort Shoes Made In Brazil - Black','1552862085181','Ferricelli Voyager Mens Leather Gel Flex Comfort Shoes Made In Brazil','Mens','black','s10.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_7718_medium.jpg?v=1569280317','//modefootwear.com.au/cdn/shop/products/IMG_7718_large.jpg?v=1569280317','collections/dress-slipon/products/ferricelli-voyager-mens-leather-gel-flex-comfort-shoes-made-in-brazil?variant=13211084587069','1','08/03/2018','6','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Larry Mens Wave Memory Comfort Technology Dress Shoes - Brown','1876697612349','Ferricelli Larry Mens Wave Memory Comfort Technology Dress Shoes','Mens','brown','s09.0 s10.0 s11.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_5756_cc9a6533-3b8a-4428-baf8-2de60372d5d5_medium.jpg?v=1555569892','//modefootwear.com.au/cdn/shop/products/IMG_5756_cc9a6533-3b8a-4428-baf8-2de60372d5d5_large.jpg?v=1555569892','collections/dress-slipon/products/ferricelli-larry-mens-wave-memory-comfort-technology-dress-shoes?variant=14137204473917','1','04/18/2019','7','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Larry Mens Wave Memory Comfort Technology Dress Shoes - Black','1876697612349','Ferricelli Larry Mens Wave Memory Comfort Technology Dress Shoes','Mens','black','s09.0 s10.0 s11.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_5695_b1092aa7-5846-43d7-87f4-625cc2c2d8b2_medium.jpg?v=1555569892','//modefootwear.com.au/cdn/shop/products/IMG_5695_b1092aa7-5846-43d7-87f4-625cc2c2d8b2_large.jpg?v=1555569892','collections/dress-slipon/products/ferricelli-larry-mens-wave-memory-comfort-technology-dress-shoes?variant=14137204506685','2','04/18/2019','7','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Kai Mens Wave Memory Comfort Technology Dress Shoes - Black','1576644870205','Ferricelli Kai Mens Wave Memory Comfort Technology Dress Shoes','Mens','black','s10.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_5883_medium.jpg?v=1542112277','//modefootwear.com.au/cdn/shop/products/IMG_5883_large.jpg?v=1542112277','collections/dress-slipon/products/ferricelli-kai-mens-wave-memory-comfort-technology-dress-shoes-1?variant=13344341459005','1','07/03/2018','8','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Xavier Mens Wave Memory Comfort Technology Dress Shoes - Brown','1614126579773','Ferricelli Xavier Mens Wave Memory Comfort Technology Dress Shoes','Mens','brown','s09.0 s10.0 s11.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_5787_1e86c148-04c7-43bf-962c-d53423501ab4_medium.jpg?v=1569287844','//modefootwear.com.au/cdn/shop/products/IMG_5787_1e86c148-04c7-43bf-962c-d53423501ab4_large.jpg?v=1569287844','collections/dress-slipon/products/ferricelli-xavier-mens-wave-memory-comfort-technology-dress-shoes?variant=13486945828925','1','11/30/2018','9','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Xavier Mens Wave Memory Comfort Technology Dress Shoes - Black','1614126579773','Ferricelli Xavier Mens Wave Memory Comfort Technology Dress Shoes','Mens','black','s09.0 s10.0 s11.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/1aa_6ed017db-285a-49b2-9910-995889634d07_medium.jpg?v=1569287845','//modefootwear.com.au/cdn/shop/products/1aa_6ed017db-285a-49b2-9910-995889634d07_large.jpg?v=1569287845','collections/dress-slipon/products/ferricelli-xavier-mens-wave-memory-comfort-technology-dress-shoes?variant=13486945861693','2','11/30/2018','9','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Savelli Easton Mens Comfort Slip On Leather Dress Shoes Made In Brazil - Black','1552862675005','Savelli Easton Mens Comfort Slip On Leather Dress Shoes Made In Brazil','Mens','black','s10.0 ','savelli','59.95','159.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6163_39b834f5-4c01-4746-9da8-c330106cdeb2_medium.jpg?v=1540635426','//modefootwear.com.au/cdn/shop/products/IMG_6163_39b834f5-4c01-4746-9da8-c330106cdeb2_large.jpg?v=1540635426','collections/dress-slipon/products/savelli-easton-mens-comfort-slip-on-leather-dress-shoes-made-in-brazil?variant=13211089731645','1','08/03/2018','10','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Savelli Roye Mens Comfort Leather Slip On Shoes Made In Brazil - Black','1552872046653','Savelli Roye Mens Comfort Leather Slip On Shoes Made In Brazil','Mens','black','s10.0 s12.0 ','savelli','59.95','159.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6075_8b1b7b57-1d9c-48b4-972f-a492faeff35b_medium.jpg?v=1540636013','//modefootwear.com.au/cdn/shop/products/IMG_6075_8b1b7b57-1d9c-48b4-972f-a492faeff35b_large.jpg?v=1540636013','collections/dress-slipon/products/savelli-roye-mens-comfort-leather-slip-on-shoes-made-in-brazil?variant=13211152089149','1','08/14/2018','11','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Savelli Roye Mens Comfort Leather Slip On Shoes Made In Brazil - Brown','1552872046653','Savelli Roye Mens Comfort Leather Slip On Shoes Made In Brazil','Mens','brown','s10.0 s12.0 ','savelli','59.95','159.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_7839_08575296-51cd-41d0-880e-06d28ea91f59_medium.jpg?v=1540636013','//modefootwear.com.au/cdn/shop/products/IMG_7839_08575296-51cd-41d0-880e-06d28ea91f59_large.jpg?v=1540636013','collections/dress-slipon/products/savelli-roye-mens-comfort-leather-slip-on-shoes-made-in-brazil?variant=13211152121917','2','08/14/2018','11','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Savelli Willis Mens Massage Ball Comfort Dress Shoes Made In Brazil - Brown','1552872276029','Savelli Willis Mens Massage Ball Comfort Dress Shoes Made In Brazil','Mens','brown','s10.0 s11.0 s12.0 ','savelli','59.95','159.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6207_88864c08-f634-44db-88c0-145f754b0f4a_medium.jpg?v=1541986541','//modefootwear.com.au/cdn/shop/products/IMG_6207_88864c08-f634-44db-88c0-145f754b0f4a_large.jpg?v=1541986541','collections/dress-slipon/products/savelli-willis-mens-dress-shoes-with-massage-balls-made-in-brazil?variant=13239250714685','1','08/14/2018','12','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Savelli Willis Mens Massage Ball Comfort Dress Shoes Made In Brazil - Black','1552872276029','Savelli Willis Mens Massage Ball Comfort Dress Shoes Made In Brazil','Mens','black','s10.0 s11.0 s12.0 ','savelli','59.95','159.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_7810_52bdf592-bda2-4b08-9245-29eec3c9207e_medium.jpg?v=1541986541','//modefootwear.com.au/cdn/shop/products/IMG_7810_52bdf592-bda2-4b08-9245-29eec3c9207e_large.jpg?v=1541986541','collections/dress-slipon/products/savelli-willis-mens-dress-shoes-with-massage-balls-made-in-brazil?variant=13239250681917','2','08/14/2018','12','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Ferricelli Sampson Mens Wave Memory Comfort Technology Leather Dress Shoes - Black','1678112587837','Ferricelli Sampson Mens Wave Memory Comfort Technology Leather Dress Shoes','Mens','black','s08.0 s10.0 ','ferricelli','59.95','179.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_5600_00ae95d4-25b0-4a85-a42f-064dde09cbfd_medium.jpg?v=1545366682','//modefootwear.com.au/cdn/shop/products/IMG_5600_00ae95d4-25b0-4a85-a42f-064dde09cbfd_large.jpg?v=1545366682','collections/dress-slipon/products/ferricelli-kai-mens-wave-memory-comfort-technology-dress-shoes?variant=13664763674685','1','12/21/2018','13','','','');

INSERT INTO `mode-61142958141_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Savelli Baz Mens Massage Ball Comfort Dress Shoes Made In Brazil - Brown','1552861134909','Savelli Baz Mens Massage Ball Comfort Dress Shoes Made In Brazil','Mens','brown','s12.0 ','savelli','59.95','159.95','p2p51-100','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6207_0316fbbe-f906-463b-bb67-a30d898fe069_medium.jpg?v=1541989452','//modefootwear.com.au/cdn/shop/products/IMG_6207_0316fbbe-f906-463b-bb67-a30d898fe069_large.jpg?v=1541989452','collections/dress-slipon/products/savelli-baz-mens-comfort-leather-slip-on-shoes-made-in-brazil?variant=13327169093693','1','08/02/2018','14','','','');

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

Total products in collection:: 14


Total displayed variants on website:: 20