The Heavy Duty Quick Mount RLT600 roof rack system is fixed to your roof using a specialised track. However the legs and bars can be easily removed wh...
The Heavy Duty Quick Mount RLT600 roof rack system is fixed to your roof using a specialised track. However the legs and bars can be easily removed wh...
The Heavy Duty Quick Mount RLT600 roof rack system is fixed to your roof using a specialised track. However the legs and bars can be easily removed wh...
The Heavy Duty Quick Mount RLT600 roof rack system is fixed to your roof using a specialised track. However the legs and bars can be easily removed wh...
The Heavy Duty RCH Trackmount roof rack system is fixed to your canopy using a specialised track. However, the legs and bars can be removed when not r...
The Heavy Duty RCH Trackmount roof rack system is fixed to your canopy using a specialised track. However, the legs and bars can be removed when not r...
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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('34B3AC20-1470-4163-9002-4A2DEF58B895', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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', '22ADDDD8-F9BB-444C-8325-7022C158858C', '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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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', '22ADDDD8-F9BB-444C-8325-7022C158858C') 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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('22ADDDD8-F9BB-444C-8325-7022C158858C', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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', '577C39A6-D608-4705-99FA-5E316D717E92', '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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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', '2CBD78E5-6F12-40AE-87A8-682042E21BF6', '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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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', '7236FB29-2012-4348-8E33-1B06CAB423B6', '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 ('7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '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', '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', '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', '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', '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', '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', '577C39A6-D608-4705-99FA-5E316D717E92') 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 ('577C39A6-D608-4705-99FA-5E316D717E92', '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 ('577C39A6-D608-4705-99FA-5E316D717E92', '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 ('577C39A6-D608-4705-99FA-5E316D717E92', '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*from `PR_Products` where `PR_Products`.`productId` in ('131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '2CBD78E5-6F12-40AE-87A8-682042E21BF6') 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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '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*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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('376B70F1-C925-4540-A2E7-DEEC55F2830D', '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 ('7236FB29-2012-4348-8E33-1B06CAB423B6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '7CD87081-4C6C-469C-B2FB-E05ED64E7814', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('577C39A6-D608-4705-99FA-5E316D717E92', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('2CBD78E5-6F12-40AE-87A8-682042E21BF6', '131B1314-78F7-4F05-AFC2-1A170FAF0692', '21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F') 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 ('CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', 'D2750AC9-265D-4816-8311-019B0AC34727', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', 'D2750AC9-265D-4816-8311-019B0AC34727', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', 'D2750AC9-265D-4816-8311-019B0AC34727', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('CC10C398-FA6F-4D53-A06D-66B723A76B0A', '1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', 'F4002455-238B-4D8A-A05D-A91AF642DC79', 'EDB3EE9C-F789-438A-AEE2-23EF9E55341B', '05F86187-482A-48FE-ACAC-42454854124F', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', '9F51A563-DC0C-4204-804A-A95E5758578C', '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 ('131B1314-78F7-4F05-AFC2-1A170FAF0692', 'D2750AC9-265D-4816-8311-019B0AC34727', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', 'D2750AC9-265D-4816-8311-019B0AC34727', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', 'D2750AC9-265D-4816-8311-019B0AC34727', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', '9F51A563-DC0C-4204-804A-A95E5758578C', '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', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('1EE3B390-38D4-42FB-8E1E-0FACC26C3C3C', 'CC10C398-FA6F-4D53-A06D-66B723A76B0A', '863D439D-B6F2-48F1-BA51-9EEA6A2228E3', '4CA5F18E-7591-4B57-AC5F-D23F950CF945', '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', '9F51A563-DC0C-4204-804A-A95E5758578C') 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 ('C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', 'D872661D-7FD5-4986-BC31-1BB4C789005C', 'DDB88D55-C385-43E4-AE6A-CC4C556D7310') 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 ('DDB88D55-C385-43E4-AE6A-CC4C556D7310', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', 'D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('DDB88D55-C385-43E4-AE6A-CC4C556D7310', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', 'D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('DDB88D55-C385-43E4-AE6A-CC4C556D7310', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', 'D872661D-7FD5-4986-BC31-1BB4C789005C') 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 ('C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('DDB88D55-C385-43E4-AE6A-CC4C556D7310', '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 ('DDB88D55-C385-43E4-AE6A-CC4C556D7310', '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 ('C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('DDB88D55-C385-43E4-AE6A-CC4C556D7310', '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 ('C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('DDB88D55-C385-43E4-AE6A-CC4C556D7310', 'F4002455-238B-4D8A-A05D-A91AF642DC79') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =7) and `isActive` =1orderby `lngId` desc