| 1 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 148 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 2 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 148 LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 148 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' LIMIT 1 | | 0 | 0 | 0 |
| 4 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 148 LIMIT 1 | | 1 | 1 | 1 |
| 5 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 148 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 6 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 148 LIMIT 1 | | 1 | 1 | 0 |
| 7 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 148 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' LIMIT 1 | | 0 | 0 | 0 |
| 8 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 148 LIMIT 1 | | 1 | 1 | 1 |
| 9 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 164 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 10 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 164 LIMIT 1 | | 1 | 1 | 0 |
| 11 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 164 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' LIMIT 1 | | 0 | 0 | 0 |
| 12 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 164 LIMIT 1 | | 1 | 1 | 1 |
| 13 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 164 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 14 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 164 LIMIT 1 | | 1 | 1 | 0 |
| 15 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 164 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' LIMIT 1 | | 0 | 0 | 0 |
| 16 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 164 LIMIT 1 | | 1 | 1 | 1 |
| 17 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 116 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 18 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 116 LIMIT 1 | | 1 | 1 | 0 |
| 19 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 116 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' LIMIT 1 | | 0 | 0 | 0 |
| 20 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 116 LIMIT 1 | | 1 | 1 | 1 |
| 21 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 116 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 22 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 116 LIMIT 1 | | 1 | 1 | 0 |
| 23 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 116 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' LIMIT 1 | | 0 | 0 | 0 |
| 24 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 116 LIMIT 1 | | 1 | 1 | 1 |
| 25 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 431 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 26 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 431 LIMIT 1 | | 1 | 1 | 0 |
| 27 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 431 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' LIMIT 1 | | 0 | 0 | 0 |
| 28 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 431 LIMIT 1 | | 1 | 1 | 1 |
| 29 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 431 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 30 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 431 LIMIT 1 | | 1 | 1 | 0 |
| 31 | SELECT `ProductSpecialOffer`.`product_id`, `ProductSpecialOffer`.`discount_type`, `ProductSpecialOffer`.`value` FROM `showroom_migrate`.`product_special_offers` AS `ProductSpecialOffer` WHERE `ProductSpecialOffer`.`product_id` = 431 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' LIMIT 1 | | 0 | 0 | 0 |
| 32 | SELECT `ProductCategoryAssoc`.`product_id`, `ProductCategoryAssoc`.`category_id` FROM `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` WHERE `ProductCategoryAssoc`.`product_id` = 431 LIMIT 1 | | 1 | 1 | 1 |
| 33 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 859 AND `Product`.`type` = 1 | | 0 | 0 | 0 |
| 34 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 859 AND `Product`.`type` = 1 | | 0 | 0 | 0 |
| 35 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 53 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` = 53 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` = 53 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 53 LIMIT 1 | | 1 | 1 | 1 |
| 39 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 53 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` = 53 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` = 53 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 53 LIMIT 1 | | 1 | 1 | 1 |
| 43 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 972 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` = 972 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` = 972 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 972 LIMIT 1 | | 1 | 1 | 1 |
| 47 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 972 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` = 972 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` = 972 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 972 LIMIT 1 | | 1 | 1 | 1 |
| 51 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1006 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` = 1006 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` = 1006 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1006 LIMIT 1 | | 1 | 1 | 1 |
| 55 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 1006 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` = 1006 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` = 1006 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1006 LIMIT 1 | | 1 | 1 | 1 |
| 59 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 940 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` = 940 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` = 940 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 940 LIMIT 1 | | 1 | 1 | 1 |
| 63 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 940 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` = 940 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` = 940 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 940 LIMIT 1 | | 1 | 1 | 1 |
| 67 | SELECT `Product`.`id`, `Product`.`name` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` = 997 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` = 997 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` = 997 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 997 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` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07') LEFT JOIN `showroom_migrate`.`product_category_assoc` AS `ProductCategoryAssoc` ON (`ProductCategoryAssoc`.`product_id` = `Product`.`id` AND `ProductCategoryAssoc`.`category_id` != 3) WHERE `Product`.`id` IN (26, 25, 27, 79, 128, 150, 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, 868, 873, 872, 871, 870, 869, 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, 41, 204, 283, 277, 259, 271, 290, 286, 266, 322, 261, 309, 280, 248, 293, 274, 267, 323, 262, 310, 281, 275, 268, 324, 288, 263, 311, 282, 258, 270, 295, 276, 245, 325, 289, 264, 246, 312, 326, 284, 265, 308, 278, 260, 292, 273, 294, 285, 247, 296, 327, 50, 239, 346, 462, 200, 303, 152, 419, 66, 255, 362, 15, 479, 430, 168, 82, 120, 378, 34, 495, 223, 330, 446, 319, 435, 30, 169, 383, 500, 174, 397, 505, 126, 99, 233, 340, 456, 51, 190, 297, 413, 142, 249, 356, 472, 49, 67, 16, 206, 313, 158, 372, 489, 110, 83, 217, 440, 35, 40, 179, 402, 131, 104, 238, 345, 461, 56, 224, 331, 447, 181, 46, 404, 133, 240, 347, 463, 197, 304, 62, 420, 149, 256, 11, 363, 480, 485, 213, 320, 334, 450, 45, 185, 291, 407, 136, 243, 350, 466, 61, 10, 307, 423, 366, 483, 77, 318, 434, 29, 382, 499, 173, 396, 504, 125, 98, 232, 339, 455, 189, 143, 412, 141, 355, 471, 205, 468, 73, 425, 22, 368, 89, 436, 218, 441, 194, 146, 398, 506, 234, 341, 457, 210, 162, 298, 414, 114, 250, 357, 473, 78, 178, 314, 130, 373, 490, 106, 144, 58, 380, 497, 225, 7, 332, 448, 208, 160, 74, 405, 112, 241, 23, 348, 464, 175, 176, 305, 90, 421, 503, 124, 97, 231, 338, 454, 188, 411, 140, 354, 470, 65, 14, 427, 156, 370, 487, 108, 81, 215, 438, 33, 172, 279, 177, 400, 129, 102, 236, 343, 459, 54, 3, 193, 300, 416, 145, 252, 359, 475, 70, 19, 209, 161, 375, 492, 113, 86, 220, 443, 38, 43, 182, 134, 107, 109, 20, 87, 39, 103, 60, 9, 76, 403, 28, 92, 44, 32, 171, 399, 507, 101, 235, 342, 458, 2, 192, 299, 415, 251, 358, 474, 69, 18, 315, 374, 491, 85, 219, 442, 37, 42, 59, 377, 494, 8, 186, 409, 138, 352, 63, 12, 202, 154, 31, 170, 393, 127, 100, 52, 1, 191, 68, 17, 207, 159, 48, 371, 488, 216, 203, 439, 155, 269, 376, 493, 94, 121, 228, 335, 451, 408, 137, 244, 351, 467, 201, 424, 153, 367, 484, 212, 5, 195, 302, 418, 227, 184, 428, 157, 221, 88, 328, 444, 401, 237, 344, 460, 301, 417, 253, 360, 476, 72, 21, 167, 381, 55, 4, 71, 226, 333, 449, 183, 406, 135, 242, 349, 465, 199, 306, 422, 151, 365, 482, 317, 433, 498, 119, 395, 198, 257, 364, 481, 75, 316, 432, 24, 166, 118, 91, 394, 502, 123, 96, 501, 122, 229, 111, 93, 230, 337, 453, 187, 410, 139, 353, 469, 426, 369, 486, 214, 165, 272, 379, 496, 117, 336, 452, 95, 47, 254, 361, 478, 222, 329, 445, 429, 105, 147, 84, 211, 36, 163, 115, 57, 6, 287, 80, 13, 64, 321, 437, 180, 132, 196, 148, 164, 116, 431, 53, 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 | 640 |
| 76 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 913 LIMIT 1 | | 1 | 1 | 0 |
| 77 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1040 LIMIT 1 | | 1 | 1 | 0 |
| 78 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1166 LIMIT 1 | | 1 | 1 | 0 |
| 79 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 961 LIMIT 1 | | 1 | 1 | 0 |
| 80 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1087 LIMIT 1 | | 1 | 1 | 0 |
| 81 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1008 LIMIT 1 | | 1 | 1 | 0 |
| 82 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1134 LIMIT 1 | | 1 | 1 | 0 |
| 83 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 929 LIMIT 1 | | 1 | 1 | 0 |
| 84 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1055 LIMIT 1 | | 1 | 1 | 0 |
| 85 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1182 LIMIT 1 | | 1 | 1 | 0 |
| 86 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 976 LIMIT 1 | | 1 | 1 | 0 |
| 87 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1103 LIMIT 1 | | 1 | 1 | 0 |
| 88 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 897 LIMIT 1 | | 1 | 1 | 0 |
| 89 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1024 LIMIT 1 | | 1 | 1 | 0 |
| 90 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1150 LIMIT 1 | | 1 | 1 | 0 |
| 91 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 945 LIMIT 1 | | 1 | 1 | 0 |
| 92 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1071 LIMIT 1 | | 1 | 1 | 0 |
| 93 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1198 LIMIT 1 | | 1 | 1 | 0 |
| 94 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 992 LIMIT 1 | | 1 | 1 | 0 |
| 95 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1119 LIMIT 1 | | 1 | 1 | 0 |
| 96 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1120 LIMIT 1 | | 1 | 1 | 0 |
| 97 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 914 LIMIT 1 | | 1 | 1 | 0 |
| 98 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1041 LIMIT 1 | | 1 | 1 | 0 |
| 99 | SELECT `ProductQtyPrice`.`price`, `ProductQtyPrice`.`product_id` FROM `showroom_migrate`.`product_qty_prices` AS `ProductQtyPrice` WHERE `ProductQtyPrice`.`product_id` = 1167 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` = 913 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1040 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1166 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 961 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1087 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1008 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1134 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 929 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1055 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1182 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 976 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1103 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 897 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1024 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1150 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 945 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1071 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1198 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 992 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1119 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1120 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 914 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1041 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 1167 AND `ProductSpecialOffer`.`form_date` <= '2019-12-07' AND `ProductSpecialOffer`.`to_date` >= '2019-12-07' 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` = 913 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` = 913 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` = 1040 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` = 1040 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` = 1166 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` = 1166 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` = 961 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` = 961 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` = 1087 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` = 1087 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` = 1008 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` = 1008 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` = 1134 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` = 1134 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` = 929 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` = 929 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` = 1055 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` = 1055 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` = 1182 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` = 1182 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` = 976 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` = 976 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` = 1103 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` = 1103 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` = 897 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` = 897 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` = 1024 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` = 1024 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` = 1150 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` = 1150 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` = 945 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` = 945 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` = 1071 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` = 1071 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` = 1198 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` = 1198 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` = 992 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` = 992 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` = 1119 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` = 1119 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` = 1120 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` = 1120 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` = 914 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` = 914 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` = 1041 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` = 1041 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` = 1167 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` = 1167 AND `Product`.`type` = 1 | | 1 | 1 | 0 |
| 196 | SELECT COUNT(*) AS `count` FROM `showroom_migrate`.`products` AS `Product` WHERE `Product`.`id` IN (26, 25, 27, 79, 128, 150, 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, 868, 873, 872, 871, 870, 869, 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, 41, 204, 283, 277, 259, 271, 290, 286, 266, 322, 261, 309, 280, 248, 293, 274, 267, 323, 262, 310, 281, 275, 268, 324, 288, 263, 311, 282, 258, 270, 295, 276, 245, 325, 289, 264, 246, 312, 326, 284, 265, 308, 278, 260, 292, 273, 294, 285, 247, 296, 327, 50, 239, 346, 462, 200, 303, 152, 419, 66, 255, 362, 15, 479, 430, 168, 82, 120, 378, 34, 495, 223, 330, 446, 319, 435, 30, 169, 383, 500, 174, 397, 505, 126, 99, 233, 340, 456, 51, 190, 297, 413, 142, 249, 356, 472, 49, 67, 16, 206, 313, 158, 372, 489, 110, 83, 217, 440, 35, 40, 179, 402, 131, 104, 238, 345, 461, 56, 224, 331, 447, 181, 46, 404, 133, 240, 347, 463, 197, 304, 62, 420, 149, 256, 11, 363, 480, 485, 213, 320, 334, 450, 45, 185, 291, 407, 136, 243, 350, 466, 61, 10, 307, 423, 366, 483, 77, 318, 434, 29, 382, 499, 173, 396, 504, 125, 98, 232, 339, 455, 189, 143, 412, 141, 355, 471, 205, 468, 73, 425, 22, 368, 89, 436, 218, 441, 194, 146, 398, 506, 234, 341, 457, 210, 162, 298, 414, 114, 250, 357, 473, 78, 178, 314, 130, 373, 490, 106, 144, 58, 380, 497, 225, 7, 332, 448, 208, 160, 74, 405, 112, 241, 23, 348, 464, 175, 176, 305, 90, 421, 503, 124, 97, 231, 338, 454, 188, 411, 140, 354, 470, 65, 14, 427, 156, 370, 487, 108, 81, 215, 438, 33, 172, 279, 177, 400, 129, 102, 236, 343, 459, 54, 3, 193, 300, 416, 145, 252, 359, 475, 70, 19, 209, 161, 375, 492, 113, 86, 220, 443, 38, 43, 182, 134, 107, 109, 20, 87, 39, 103, 60, 9, 76, 403, 28, 92, 44, 32, 171, 399, 507, 101, 235, 342, 458, 2, 192, 299, 415, 251, 358, 474, 69, 18, 315, 374, 491, 85, 219, 442, 37, 42, 59, 377, 494, 8, 186, 409, 138, 352, 63, 12, 202, 154, 31, 170, 393, 127, 100, 52, 1, 191, 68, 17, 207, 159, 48, 371, 488, 216, 203, 439, 155, 269, 376, 493, 94, 121, 228, 335, 451, 408, 137, 244, 351, 467, 201, 424, 153, 367, 484, 212, 5, 195, 302, 418, 227, 184, 428, 157, 221, 88, 328, 444, 401, 237, 344, 460, 301, 417, 253, 360, 476, 72, 21, 167, 381, 55, 4, 71, 226, 333, 449, 183, 406, 135, 242, 349, 465, 199, 306, 422, 151, 365, 482, 317, 433, 498, 119, 395, 198, 257, 364, 481, 75, 316, 432, 24, 166, 118, 91, 394, 502, 123, 96, 501, 122, 229, 111, 93, 230, 337, 453, 187, 410, 139, 353, 469, 426, 369, 486, 214, 165, 272, 379, 496, 117, 336, 452, 95, 47, 254, 361, 478, 222, 329, 445, 429, 105, 147, 84, 211, 36, 163, 115, 57, 6, 287, 80, 13, 64, 321, 437, 180, 132, 196, 148, 164, 116, 431, 53, 972, 1006, 940, 997) AND `Product`.`status` = 1 AND `Product`.`type` = 1 GROUP BY `Product`.`id` | | 817 | 817 | 4 |
| 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` <= '2019-12-07') AND (`Deal`.`validity_to` >= '2019-12-07') 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 |
