DROP TABLE IF EXISTS `mode-60079308861_backup_table`;
DROP TABLE IF EXISTS `mode-60079308861_temp_table`;
CREATE TABLE `mode-60079308861_temp_table` AS (SELECT * FROM `mode-skeleton` WHERE 1=2);
ALTER TABLE `mode-60079308861_temp_table` ADD PRIMARY KEY(`id`);
INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens Ferrol M9U-6139 Comfort Leather Lace Up Casual Shoes - Navy','7012510269501','Pikolinos Mens Ferrol M9U-6139 Comfort Leather Lace Up Casual Shoes','Mens','navy','s08.0 s09.0 s10.0 ','pikolinos','129.95','299.95','p3p101-150','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6879_6c1a2787-4821-4558-9058-fb8297eb622f_medium.jpg?v=1679458238','//modefootwear.com.au/cdn/shop/products/IMG_6879_6c1a2787-4821-4558-9058-fb8297eb622f_large.jpg?v=1679458238','collections/pikolinos/products/pikolinos-mens-ferrol-m9u-6139-comfort-leather-lace-up-casual-shoes?variant=40555065180221','1','03/22/2023','1','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens Ferrol M9U-6139 Comfort Leather Lace Up Casual Shoes - Tan','7012510269501','Pikolinos Mens Ferrol M9U-6139 Comfort Leather Lace Up Casual Shoes','Mens','tan','s08.0 s09.0 s10.0 ','pikolinos','129.95','299.95','p3p101-150','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6893_e6a8ba3d-166f-4653-ae93-ebe61824de4f_medium.jpg?v=1679458250','//modefootwear.com.au/cdn/shop/products/IMG_6893_e6a8ba3d-166f-4653-ae93-ebe61824de4f_large.jpg?v=1679458250','collections/pikolinos/products/pikolinos-mens-ferrol-m9u-6139-comfort-leather-lace-up-casual-shoes?variant=40555065212989','2','03/22/2023','1','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens Cambil M5N-6010C3 Comfort Leather Lace Up Casual Shoes - Black','7012519575613','Pikolinos Mens Cambil M5N-6010C3 Comfort Leather Lace Up Casual Shoes','Mens','black','s08.0 s09.0 s10.0 s11.0 ','pikolinos','179.95','299.95','p4p151-20','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6848_81c55d88-be42-4051-b2fa-9fde03a4bac3_medium.jpg?v=1679459884','//modefootwear.com.au/cdn/shop/products/IMG_6848_81c55d88-be42-4051-b2fa-9fde03a4bac3_large.jpg?v=1679459884','collections/pikolinos/products/pikolinos-mens-cambil-m5n-6010c3-comfortable-leather-lace-up-casual-shoes?variant=40555098669117','1','03/22/2023','2','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens Cambil M5N-6010C3 Comfort Leather Lace Up Casual Shoes - Tan','7012519575613','Pikolinos Mens Cambil M5N-6010C3 Comfort Leather Lace Up Casual Shoes','Mens','tan','s08.0 s09.0 s10.0 s11.0 ','pikolinos','179.95','299.95','p4p151-20','Shoes','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6831_9c93c1ed-30f5-4642-a407-4b496e61e1d0_medium.jpg?v=1679459883','//modefootwear.com.au/cdn/shop/products/IMG_6831_9c93c1ed-30f5-4642-a407-4b496e61e1d0_large.jpg?v=1679459883','collections/pikolinos/products/pikolinos-mens-cambil-m5n-6010c3-comfortable-leather-lace-up-casual-shoes?variant=40555098701885','2','03/22/2023','2','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens Leon M4V-4074BFC1 Comfortable Leather Lace Up Shoes - Tan','7012521148477','Pikolinos Mens Leon M4V-4074BFC1 Comfortable Leather Lace Up Shoes','Mens','tan','s10.0 s11.0 ','pikolinos','179.95','259.95','p4p151-20','Shoes','NONE','//modefootwear.com.au/cdn/shop/files/leon_medium.jpg?v=1682993099','//modefootwear.com.au/cdn/shop/files/leon_large.jpg?v=1682993099','collections/pikolinos/products/pikolinos-mens-leon-m4v-4074bfc1-comfortable-leather-lace-up-shoes?variant=40555110105149','1','03/22/2023','3','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens Leon M4V-8081BFC1 Comfortable Leather Lace Up Boots - Brown','7012524818493','Pikolinos Mens Leon M4V-8081BFC1 Comfortable Leather Lace Up Boots','Mens','brown','s08.0 s11.0 ','pikolinos','199.95','275.00','p4p151-20','Boots','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6864_b17edbee-ae6e-448d-b4aa-56eab7cceddb_medium.jpg?v=1679461789','//modefootwear.com.au/cdn/shop/products/IMG_6864_b17edbee-ae6e-448d-b4aa-56eab7cceddb_large.jpg?v=1679461789','collections/pikolinos/products/pikolinos-mens-leon-m4v-8081bfc1-comfortable-leather-lace-up-boots?variant=40555130290237','1','03/22/2023','4','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens Berna M8J-8181 Comfortable Leather Lace Up Boots - Tan','7012529504317','Pikolinos Mens Berna M8J-8181 Comfortable Leather Lace Up Boots','Mens','tan','s08.0 ','pikolinos','199.95','289.95','p4p151-20','Boots','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6920_ef512b67-9164-47a9-8bed-3f2872fc6d5c_medium.jpg?v=1679462343','//modefootwear.com.au/cdn/shop/products/IMG_6920_ef512b67-9164-47a9-8bed-3f2872fc6d5c_large.jpg?v=1679462343','collections/pikolinos/products/pikolinos-mens-berna-m8j-8181-comfortable-leather-lace-up-boots?variant=40555160502333','1','03/22/2023','5','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens York M2M-8170 Comfortable Leather Lace Up Boots - Black','7012531961917','Pikolinos Mens York M2M-8170 Comfortable Leather Lace Up Boots','Mens','black','s09.0 s10.0 ','pikolinos','199.95','289.95','p4p151-20','Boots','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6954_cb9c64fc-4510-49ed-b046-b25cae866019_medium.jpg?v=1679462768','//modefootwear.com.au/cdn/shop/products/IMG_6954_cb9c64fc-4510-49ed-b046-b25cae866019_large.jpg?v=1679462768','collections/pikolinos/products/pikolinos-mens-york-m2m-8170-comfortable-leather-lace-up-boots?variant=40555176853565','1','03/22/2023','6','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Mens York M2M-8170 Comfortable Leather Lace Up Boots - Tan','7012531961917','Pikolinos Mens York M2M-8170 Comfortable Leather Lace Up Boots','Mens','tan','s09.0 s10.0 ','pikolinos','199.95','289.95','p4p151-20','Boots','NONE','//modefootwear.com.au/cdn/shop/products/IMG_6964_6d773fae-3e7f-4e30-ae2d-0d471da574b3_medium.jpg?v=1679462770','//modefootwear.com.au/cdn/shop/products/IMG_6964_6d773fae-3e7f-4e30-ae2d-0d471da574b3_large.jpg?v=1679462770','collections/pikolinos/products/pikolinos-mens-york-m2m-8170-comfortable-leather-lace-up-boots?variant=40555176886333','2','03/22/2023','6','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Womens W8J-8966 Comfortable Leather Ankle Boots - Off White','7039016566845','Pikolinos Womens W8J-8966 Comfortable Leather Ankle Boots','Womens','off','s07.0 s08.0 s09.0 s10.0 ','pikolinos','199.95','319.95','p4p151-20','Boots','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6943_2f9071e5-edc3-4457-bb1b-4a4793d05f9b_medium.jpg?v=1685495701','//modefootwear.com.au/cdn/shop/files/IMG_6943_2f9071e5-edc3-4457-bb1b-4a4793d05f9b_large.jpg?v=1685495701','collections/pikolinos/products/pikolinos-womens-w8j-8966-comfortable-leather-ankle-boots?variant=40637040394301','1','03/22/2023','7','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Womens W8J-8966 Comfortable Leather Ankle Boots - Tan','7039016566845','Pikolinos Womens W8J-8966 Comfortable Leather Ankle Boots','Womens','tan','s07.0 s08.0 s09.0 s10.0 ','pikolinos','199.95','319.95','p4p151-20','Boots','NONE','//modefootwear.com.au/cdn/shop/files/IMG_7010_c2e4e47b-e25b-4d33-b8c6-5a946fb41b37_medium.jpg?v=1685495699','//modefootwear.com.au/cdn/shop/files/IMG_7010_c2e4e47b-e25b-4d33-b8c6-5a946fb41b37_large.jpg?v=1685495699','collections/pikolinos/products/pikolinos-womens-w8j-8966-comfortable-leather-ankle-boots?variant=40637040427069','2','03/22/2023','7','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Womens Vitoria W0T-7559 Comfortable Leather Ankle Boots - Tan','7039016501309','Pikolinos Womens Vitoria W0T-7559 Comfortable Leather Ankle Boots','Womens','tan','s09.0 ','pikolinos','179.95','299.95','p4p151-20','Boots','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6973_73eadb38-7b3a-43fd-a217-3ea74b8da04f_medium.jpg?v=1685495680','//modefootwear.com.au/cdn/shop/files/IMG_6973_73eadb38-7b3a-43fd-a217-3ea74b8da04f_large.jpg?v=1685495680','collections/pikolinos/products/pikolinos-womens-vitoria-w0t-7559-comfortable-leather-ankle-boots?variant=40637039804477','1','03/22/2023','8','','','');

INSERT INTO `mode-60079308861_temp_table`(`id`, `pid`, `title`, `gender`, `colour`, `sizes`, `brand`, `price`, `pricesale`, `pricerange`, `type`, `boygirl`, `image`, `imagel`, `url`, `available`, `createdat`, `position`, `reviews`, `averages`, `sale`) VALUES ('Pikolinos Womens Daroca W1U-8505 Comfortable Leather Ankle Boots - Black','7039016665149','Pikolinos Womens Daroca W1U-8505 Comfortable Leather Ankle Boots','Womens','black','s09.0 ','pikolinos','232.47','299.95','p5p201-250','Boots','NONE','//modefootwear.com.au/cdn/shop/files/IMG_6823_915cb1d2-7ecf-49bc-b7d6-52aac61776c1_medium.jpg?v=1685495708','//modefootwear.com.au/cdn/shop/files/IMG_6823_915cb1d2-7ecf-49bc-b7d6-52aac61776c1_large.jpg?v=1685495708','collections/pikolinos/products/pikolinos-womens-daroca-w1u-8505-comfortable-leather-ankle-boots?variant=40637041311805','1','03/22/2023','9','','','');

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