| 1 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1192 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 2 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1192 LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1193 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 4 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1193 LIMIT 1 | | 1 | 1 | 0 |
| 5 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1193 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 6 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1193 LIMIT 1 | | 1 | 1 | 0 |
| 7 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1194 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 8 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1194 LIMIT 1 | | 1 | 1 | 0 |
| 9 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1194 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 10 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1194 LIMIT 1 | | 1 | 1 | 0 |
| 11 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1195 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 12 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1195 LIMIT 1 | | 1 | 1 | 0 |
| 13 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1195 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 14 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1195 LIMIT 1 | | 1 | 1 | 0 |
| 15 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1196 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 16 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1196 LIMIT 1 | | 1 | 1 | 0 |
| 17 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1196 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 18 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1196 LIMIT 1 | | 1 | 1 | 0 |
| 19 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1197 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 20 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1197 LIMIT 1 | | 1 | 1 | 0 |
| 21 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1197 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 22 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1197 LIMIT 1 | | 1 | 1 | 0 |
| 23 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1198 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 24 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1198 LIMIT 1 | | 1 | 1 | 0 |
| 25 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1198 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 26 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1198 LIMIT 1 | | 1 | 1 | 0 |
| 27 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1199 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 28 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1199 LIMIT 1 | | 1 | 1 | 0 |
| 29 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1199 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 30 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1199 LIMIT 1 | | 1 | 1 | 0 |
| 31 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1200 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 32 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1200 LIMIT 1 | | 1 | 1 | 0 |
| 33 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1200 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 34 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1200 LIMIT 1 | | 1 | 1 | 0 |
| 35 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1201 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 36 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1201 LIMIT 1 | | 1 | 1 | 0 |
| 37 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1201 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 38 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1201 LIMIT 1 | | 1 | 1 | 0 |
| 39 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1202 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 40 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1202 LIMIT 1 | | 1 | 1 | 0 |
| 41 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1202 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 42 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1202 LIMIT 1 | | 1 | 1 | 0 |
| 43 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1203 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 44 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1203 LIMIT 1 | | 1 | 1 | 0 |
| 45 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1203 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 46 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1203 LIMIT 1 | | 1 | 1 | 0 |
| 47 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1204 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 48 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1204 LIMIT 1 | | 1 | 1 | 0 |
| 49 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1204 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 50 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1204 LIMIT 1 | | 1 | 1 | 0 |
| 51 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1205 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 52 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1205 LIMIT 1 | | 1 | 1 | 0 |
| 53 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1205 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 54 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1205 LIMIT 1 | | 1 | 1 | 0 |
| 55 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1206 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 56 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1206 LIMIT 1 | | 1 | 1 | 0 |
| 57 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1206 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 58 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1206 LIMIT 1 | | 1 | 1 | 0 |
| 59 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 972 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 60 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 972 LIMIT 1 | | 1 | 1 | 0 |
| 61 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 972 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 62 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 972 LIMIT 1 | | 1 | 1 | 1 |
| 63 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1006 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 64 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1006 LIMIT 1 | | 1 | 1 | 0 |
| 65 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1006 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 66 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1006 LIMIT 1 | | 1 | 1 | 1 |
| 67 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 940 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 68 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 940 LIMIT 1 | | 1 | 1 | 0 |
| 69 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 940 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 70 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 940 LIMIT 1 | | 1 | 1 | 1 |
| 71 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 997 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 72 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 997 LIMIT 1 | | 1 | 1 | 0 |
| 73 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 997 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 74 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 997 LIMIT 1 | | 1 | 1 | 1 |
| 75 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`image` FROM `showroom_migrate`.`products` AS `Product` LEFT JOIN `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` ON (`ProductQtyPrice`.`product_id` = `Product`.`id`) LEFT JOIN `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` ON (`ProductSpecialOffer`.`product_id` = `Product`.`id` AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04') LEFT JOIN `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` ON (`ProductCategoryAssoc`.`product_id` = `Product`.`id` AND `ProductCategoryAssoc`.`category_id` != 3) WHERE `Product`.`id` IN (477, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 645, 640, 644, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 568, 665, 864, 866, 867, 863, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 941, 942, 943, 945, 944, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 972, 1006, 940, 997) AND `Product`.`status` = 1 AND `Product`.`type` = 1 GROUP BY `Product`.`id` ORDER BY `ProductQtyPrice`.`price` ASC LIMIT 24 | | 24 | 24 | 231 |
| 76 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1088 LIMIT 1 | | 1 | 1 | 0 |
| 77 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 913 LIMIT 1 | | 1 | 1 | 0 |
| 78 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1040 LIMIT 1 | | 1 | 1 | 0 |
| 79 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1135 LIMIT 1 | | 1 | 1 | 0 |
| 80 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 961 LIMIT 1 | | 1 | 1 | 0 |
| 81 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1056 LIMIT 1 | | 1 | 1 | 0 |
| 82 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1183 LIMIT 1 | | 1 | 1 | 0 |
| 83 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1008 LIMIT 1 | | 1 | 1 | 0 |
| 84 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1104 LIMIT 1 | | 1 | 1 | 0 |
| 85 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 929 LIMIT 1 | | 1 | 1 | 0 |
| 86 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1151 LIMIT 1 | | 1 | 1 | 0 |
| 87 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 976 LIMIT 1 | | 1 | 1 | 0 |
| 88 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1072 LIMIT 1 | | 1 | 1 | 0 |
| 89 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 897 LIMIT 1 | | 1 | 1 | 0 |
| 90 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1199 LIMIT 1 | | 1 | 1 | 0 |
| 91 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1024 LIMIT 1 | | 1 | 1 | 0 |
| 92 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1120 LIMIT 1 | | 1 | 1 | 0 |
| 93 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 945 LIMIT 1 | | 1 | 1 | 0 |
| 94 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1167 LIMIT 1 | | 1 | 1 | 0 |
| 95 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 992 LIMIT 1 | | 1 | 1 | 0 |
| 96 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 993 LIMIT 1 | | 1 | 1 | 0 |
| 97 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1089 LIMIT 1 | | 1 | 1 | 0 |
| 98 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 914 LIMIT 1 | | 1 | 1 | 0 |
| 99 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1041 LIMIT 1 | | 1 | 1 | 0 |
| 100 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1088 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 101 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 913 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 102 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1040 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 103 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1135 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 104 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 961 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 105 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1056 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 106 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1183 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 107 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1008 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 108 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1104 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 109 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 929 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 110 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1151 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 111 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 976 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 112 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1072 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 113 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 897 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 114 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1199 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 115 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1024 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 116 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1120 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 117 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 945 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 118 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1167 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 119 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 992 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 120 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 993 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 121 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1089 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 122 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 914 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 123 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 1041 AND `ProductSpecialOffer`.`form_date` <= '2020-07-04' AND `ProductSpecialOffer`.`to_date` >= '2020-07-04' LIMIT 1 | | 0 | 0 | 0 |
| 124 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1088 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 125 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 126 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1088 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 127 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 913 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 128 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 129 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 913 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 130 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1040 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 131 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 132 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1040 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 133 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1135 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 134 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 135 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1135 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 136 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 961 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 137 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 138 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 961 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 139 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1056 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 140 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 141 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1056 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 142 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1183 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 143 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 144 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1183 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 145 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1008 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 146 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 147 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1008 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 148 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1104 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 149 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 150 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1104 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 151 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 929 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 152 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 153 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 929 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 154 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1151 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 155 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 156 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1151 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 157 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 976 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 158 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 159 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 976 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 160 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1072 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 161 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 162 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1072 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 163 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 897 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 164 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 165 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 897 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 166 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1199 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 167 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 168 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1199 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 169 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1024 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 170 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 171 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1024 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 172 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1120 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 173 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 174 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1120 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 175 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 945 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 176 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 177 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 945 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 178 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1167 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 179 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 180 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1167 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 181 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 992 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 182 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 183 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 992 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 184 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 993 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 185 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 186 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 993 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 187 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1089 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 188 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 189 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1089 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 190 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 914 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 191 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 192 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 914 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 193 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 1041 AND `ProductCategoryAssoc`.`category_id` != 3 LIMIT 1 | | 1 | 1 | 0 |
| 194 | SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`parent_id` FROM `showroom_migrate`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 | | 1 | 1 | 0 |
| 195 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1041 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 196 | SELECT COUNT(*) AS `count` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` IN (477, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 645, 640, 644, 646, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 568, 665, 864, 866, 867, 863, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 941, 942, 943, 945, 944, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994, 995, 996, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 972, 1006, 940, 997) AND `Product`.`status` = 1 AND `Product`.`type` = 1 GROUP BY `Product`.`id` | | 323 | 323 | 3 |
| 197 | SELECT `ProductCustomField`.`id`, `ProductCustomField`.`name`, `ProductCustomField`.`sort_order`, `ProductCustomField`.`status`, `ProductCustomField`.`created`, `ProductCustomField`.`modified` FROM `showroom_migrate`.`product_custom_fields` AS `ProductCustomField` WHERE `ProductCustomField`.`status` = 1 ORDER BY `ProductCustomField`.`sort_order` ASC | | 2 | 2 | 0 |
| 198 | SELECT `ProductCustomFieldValue`.`id`, `ProductCustomFieldValue`.`value`, `ProductCustomFieldValue`.`custom_field_id`, `ProductCustomFieldValue`.`image`, `ProductCustomFieldValue`.`created`, `ProductCustomFieldValue`.`modified` FROM `showroom_migrate`.`product_custom_field_values` AS `ProductCustomFieldValue` WHERE `ProductCustomFieldValue`.`custom_field_id` IN (2, 1) | | 14 | 14 | 0 |
| 199 | SELECT `Deal`.`id`, `Deal`.`name`, `Deal`.`banner`, `Deal`.`validity_from`, `Deal`.`validity_to`, `Deal`.`status`, `Deal`.`created`, `Deal`.`modified`, `DealOffer`.`id`, `DealOffer`.`deal_id`, `DealOffer`.`apply_qty`, `DealOffer`.`apply_category`, `DealOffer`.`type`, `DealOffer`.`value`, `DealOffer`.`free_category`, `DealOffer`.`created`, `DealOffer`.`modified` FROM `showroom_migrate`.`deals` AS `Deal` LEFT JOIN `showroom_migrate`.`deal_offers` AS `DealOffer` ON (`DealOffer`.`deal_id` = `Deal`.`id`) WHERE ((`Deal`.`validity_from` <= '2020-07-04') AND (`Deal`.`validity_to` >= '2020-07-04') AND (`Deal`.`status` = 1)) ORDER BY `validity_to` DESC | | 0 | 0 | 0 |
| 200 | SELECT `Country`.`id`, `Country`.`name` FROM `showroom_migrate`.`countries` AS `Country` WHERE 1 = 1 | | 240 | 240 | 1 |
