The Heavy Duty RCH Trackmount roof rack system is fixed to your roof using a specialised track. However, the legs and bars can be removed when not req...
The Heavy Duty RCH Trackmount roof rack system is fixed to your roof using a specialised track. However, the legs and bars can be removed when not req...
The Heavy Duty RCL Trackmount roof rack system is fixed to your roof using a specialised track. However, the legs and bars can be removed when not req...
selectMAX(`productPrice`) as max_price, MIN(`productPrice`) as min_price, count(*) as product_count from `PR_ProductCategories` innerjoin `PR_Products` on `PR_Products`.`productId` = `PR_ProductCategories`.`productId` and `PR_Products`.`isActive` =1and `isObsolete` isnulland `PR_Products`.`deleted_at` isnulland `PR_Products`.`lngId` =7where `categoryid` ='863D439D-B6F2-48F1-BA51-9EEA6A2228E3'andnotexists (select1from `PR_VehicleProducts` where PR_VehicleProducts.productid = PR_ProductCategories.productid and
PR_VehicleProducts.deleted_at isnulland
PR_VehicleProducts.lngId =7) and `PR_ProductCategories`.`deleted_at` isnull
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('9C70F1D2-72B2-4B5F-9A5B-D1463D86CC82', 'E46F848F-3241-4A22-A86B-2C7996988B42') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('E46F848F-3241-4A22-A86B-2C7996988B42', '9C70F1D2-72B2-4B5F-9A5B-D1463D86CC82') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E46F848F-3241-4A22-A86B-2C7996988B42', '9C70F1D2-72B2-4B5F-9A5B-D1463D86CC82') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E46F848F-3241-4A22-A86B-2C7996988B42', '9C70F1D2-72B2-4B5F-9A5B-D1463D86CC82') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('F4002455-238B-4D8A-A05D-A91AF642DC79', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '6960CA14-58B6-4361-892B-53573BDFE1DC', '1759B7B8-824F-451D-9CAF-BD72E4F58BB6') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('F4002455-238B-4D8A-A05D-A91AF642DC79', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '6960CA14-58B6-4361-892B-53573BDFE1DC', '1759B7B8-824F-451D-9CAF-BD72E4F58BB6') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('F4002455-238B-4D8A-A05D-A91AF642DC79', 'DAB1706C-1C57-4B3F-BD24-923BFB275F35', '6960CA14-58B6-4361-892B-53573BDFE1DC', '1759B7B8-824F-451D-9CAF-BD72E4F58BB6') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', '7F833B2C-4A6E-41E2-BFAF-E55D5C5982CA', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('7F833B2C-4A6E-41E2-BFAF-E55D5C5982CA', 'D2750AC9-265D-4816-8311-019B0AC34727', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('7F833B2C-4A6E-41E2-BFAF-E55D5C5982CA', 'D2750AC9-265D-4816-8311-019B0AC34727', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('7F833B2C-4A6E-41E2-BFAF-E55D5C5982CA', 'D2750AC9-265D-4816-8311-019B0AC34727', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('44E7E807-BC74-48DB-BF04-B8F828867E4B', '632E3885-AB6B-46DD-95A3-6C4CFAC37D29') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('44E7E807-BC74-48DB-BF04-B8F828867E4B', '632E3885-AB6B-46DD-95A3-6C4CFAC37D29') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('44E7E807-BC74-48DB-BF04-B8F828867E4B', '632E3885-AB6B-46DD-95A3-6C4CFAC37D29') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('44E7E807-BC74-48DB-BF04-B8F828867E4B', '632E3885-AB6B-46DD-95A3-6C4CFAC37D29') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('2B935821-F73C-47C4-B9AB-D90F5D7FDA99', '33E87C45-2168-40FD-BD60-3675536673DE', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('2B935821-F73C-47C4-B9AB-D90F5D7FDA99', '33E87C45-2168-40FD-BD60-3675536673DE', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('2B935821-F73C-47C4-B9AB-D90F5D7FDA99', '33E87C45-2168-40FD-BD60-3675536673DE', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('2B935821-F73C-47C4-B9AB-D90F5D7FDA99', '33E87C45-2168-40FD-BD60-3675536673DE', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('744CC095-1B38-4C5C-9EAE-593CD924E9D7', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('744CC095-1B38-4C5C-9EAE-593CD924E9D7', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('744CC095-1B38-4C5C-9EAE-593CD924E9D7', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('744CC095-1B38-4C5C-9EAE-593CD924E9D7', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', 'A1AABF72-431E-470B-8312-44C9F1DAE9E9', 'F4002455-238B-4D8A-A05D-A91AF642DC79') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'A1AABF72-431E-470B-8312-44C9F1DAE9E9') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'A1AABF72-431E-470B-8312-44C9F1DAE9E9') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'A1AABF72-431E-470B-8312-44C9F1DAE9E9') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '6960CA14-58B6-4361-892B-53573BDFE1DC', 'F4002455-238B-4D8A-A05D-A91AF642DC79') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '6960CA14-58B6-4361-892B-53573BDFE1DC') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '6960CA14-58B6-4361-892B-53573BDFE1DC') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '99AE33D6-3212-4C77-8A8A-F97CF1039C15', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '6960CA14-58B6-4361-892B-53573BDFE1DC') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'BABBF8DB-76B0-4727-9A3B-87FA220C1342', 'DBD705FB-4244-424D-97FF-76B7638BB459') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('DBD705FB-4244-424D-97FF-76B7638BB459', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'BABBF8DB-76B0-4727-9A3B-87FA220C1342') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DBD705FB-4244-424D-97FF-76B7638BB459', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'BABBF8DB-76B0-4727-9A3B-87FA220C1342') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('DBD705FB-4244-424D-97FF-76B7638BB459', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'BABBF8DB-76B0-4727-9A3B-87FA220C1342') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', 'AB06F641-F245-407E-8DD9-D2995902C55D', 'F4002455-238B-4D8A-A05D-A91AF642DC79') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'AB06F641-F245-407E-8DD9-D2995902C55D') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'AB06F641-F245-407E-8DD9-D2995902C55D') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'AB06F641-F245-407E-8DD9-D2995902C55D') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('33E87C45-2168-40FD-BD60-3675536673DE', 'E46F848F-3241-4A22-A86B-2C7996988B42', 'EAD0A3BF-4A01-410C-A3F5-2EB3B4574CEE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('33E87C45-2168-40FD-BD60-3675536673DE', 'E46F848F-3241-4A22-A86B-2C7996988B42', 'EAD0A3BF-4A01-410C-A3F5-2EB3B4574CEE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('33E87C45-2168-40FD-BD60-3675536673DE', 'E46F848F-3241-4A22-A86B-2C7996988B42', 'EAD0A3BF-4A01-410C-A3F5-2EB3B4574CEE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('33E87C45-2168-40FD-BD60-3675536673DE', 'E46F848F-3241-4A22-A86B-2C7996988B42', 'EAD0A3BF-4A01-410C-A3F5-2EB3B4574CEE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('44E7E807-BC74-48DB-BF04-B8F828867E4B', '632E3885-AB6B-46DD-95A3-6C4CFAC37D29') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('44E7E807-BC74-48DB-BF04-B8F828867E4B', '632E3885-AB6B-46DD-95A3-6C4CFAC37D29') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('44E7E807-BC74-48DB-BF04-B8F828867E4B', '632E3885-AB6B-46DD-95A3-6C4CFAC37D29') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('44E7E807-BC74-48DB-BF04-B8F828867E4B', '632E3885-AB6B-46DD-95A3-6C4CFAC37D29') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('E6349AC2-6C40-4C97-9FA6-F45AB937C9D9', 'F4002455-238B-4D8A-A05D-A91AF642DC79') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('E6349AC2-6C40-4C97-9FA6-F45AB937C9D9', 'F4002455-238B-4D8A-A05D-A91AF642DC79') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E6349AC2-6C40-4C97-9FA6-F45AB937C9D9', 'F4002455-238B-4D8A-A05D-A91AF642DC79') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('E6349AC2-6C40-4C97-9FA6-F45AB937C9D9', 'F4002455-238B-4D8A-A05D-A91AF642DC79') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '452123C7-B8CD-4BE7-BC4D-6D05078D9D8E', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', '452123C7-B8CD-4BE7-BC4D-6D05078D9D8E') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', '452123C7-B8CD-4BE7-BC4D-6D05078D9D8E') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '7B63CFF4-F78F-44F7-9E95-9F9F90505B82', '452123C7-B8CD-4BE7-BC4D-6D05078D9D8E') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '56D6DB6B-E9CB-4207-9DBF-545852296C3D', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '6F37AB64-8B25-4B2F-9DB7-55718A98D8DE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '56D6DB6B-E9CB-4207-9DBF-545852296C3D', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '6F37AB64-8B25-4B2F-9DB7-55718A98D8DE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '56D6DB6B-E9CB-4207-9DBF-545852296C3D', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '6F37AB64-8B25-4B2F-9DB7-55718A98D8DE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', '52426EAC-B690-4D60-95D8-E85DB0CBBFDB', 'E46F848F-3241-4A22-A86B-2C7996988B42') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('52426EAC-B690-4D60-95D8-E85DB0CBBFDB', 'E46F848F-3241-4A22-A86B-2C7996988B42', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('52426EAC-B690-4D60-95D8-E85DB0CBBFDB', 'E46F848F-3241-4A22-A86B-2C7996988B42', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('52426EAC-B690-4D60-95D8-E85DB0CBBFDB', 'E46F848F-3241-4A22-A86B-2C7996988B42', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('3BED1A02-4549-4D95-A821-3FA3410516D0', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', '7CD87081-4C6C-469C-B2FB-E05ED64E7814') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', '3BED1A02-4549-4D95-A821-3FA3410516D0') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', '3BED1A02-4549-4D95-A821-3FA3410516D0') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', '3BED1A02-4549-4D95-A821-3FA3410516D0') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '56D6DB6B-E9CB-4207-9DBF-545852296C3D', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', 'CBD51CA4-0777-4119-A5FE-AFCDD56C9C24') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '56D6DB6B-E9CB-4207-9DBF-545852296C3D', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', 'CBD51CA4-0777-4119-A5FE-AFCDD56C9C24') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '56D6DB6B-E9CB-4207-9DBF-545852296C3D', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', 'CBD51CA4-0777-4119-A5FE-AFCDD56C9C24') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF', '6763D37B-9EAC-4A04-8A96-7994C1175F84', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('6763D37B-9EAC-4A04-8A96-7994C1175F84', 'D2750AC9-265D-4816-8311-019B0AC34727', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('6763D37B-9EAC-4A04-8A96-7994C1175F84', 'D2750AC9-265D-4816-8311-019B0AC34727', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('6763D37B-9EAC-4A04-8A96-7994C1175F84', 'D2750AC9-265D-4816-8311-019B0AC34727', '3E30A3C6-BC12-4A0E-A558-CBAA6371E3AF') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('33E87C45-2168-40FD-BD60-3675536673DE', 'A08676E9-9477-4E55-A7E1-FFF6D48F199E', 'EAD0A3BF-4A01-410C-A3F5-2EB3B4574CEE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('33E87C45-2168-40FD-BD60-3675536673DE', 'A08676E9-9477-4E55-A7E1-FFF6D48F199E', 'EAD0A3BF-4A01-410C-A3F5-2EB3B4574CEE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('33E87C45-2168-40FD-BD60-3675536673DE', 'A08676E9-9477-4E55-A7E1-FFF6D48F199E', 'EAD0A3BF-4A01-410C-A3F5-2EB3B4574CEE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('33E87C45-2168-40FD-BD60-3675536673DE', 'A08676E9-9477-4E55-A7E1-FFF6D48F199E', 'EAD0A3BF-4A01-410C-A3F5-2EB3B4574CEE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '7236FB29-2012-4348-8E33-1B06CAB423B6') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F', 'DA26C1E7-BFFC-4307-BA92-24001D1429E2') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F', 'DA26C1E7-BFFC-4307-BA92-24001D1429E2') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '9A915692-6FDF-40C0-AA16-720A3917FCAC', '05F86187-482A-48FE-ACAC-42454854124F', 'DA26C1E7-BFFC-4307-BA92-24001D1429E2') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('452123C7-B8CD-4BE7-BC4D-6D05078D9D8E', 'AC4152F4-219E-467C-B486-FEFD50BE7C7D', 'BDBB2B78-D8E6-4E3B-9B08-8FBA709BCCBE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('452123C7-B8CD-4BE7-BC4D-6D05078D9D8E', 'BDBB2B78-D8E6-4E3B-9B08-8FBA709BCCBE', 'AC4152F4-219E-467C-B486-FEFD50BE7C7D') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('452123C7-B8CD-4BE7-BC4D-6D05078D9D8E', 'BDBB2B78-D8E6-4E3B-9B08-8FBA709BCCBE', 'AC4152F4-219E-467C-B486-FEFD50BE7C7D') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('452123C7-B8CD-4BE7-BC4D-6D05078D9D8E', 'BDBB2B78-D8E6-4E3B-9B08-8FBA709BCCBE', 'AC4152F4-219E-467C-B486-FEFD50BE7C7D') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select*from `PR_Products` where `PR_Products`.`productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '4D21C51A-A239-44A1-A690-B406AD84464C', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
select `netSuiteId` from `PR_Products` where `productId` in ('4D21C51A-A239-44A1-A690-B406AD84464C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('4D21C51A-A239-44A1-A690-B406AD84464C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '376B70F1-C925-4540-A2E7-DEEC55F2830D', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =7) and `isActive` =1and (`scope` isnullor `scope` =0)
select `netSuiteId` from `PR_Products` where `productId` in ('4D21C51A-A239-44A1-A690-B406AD84464C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc