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...
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...
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 ('DE815B4E-FB6A-44D9-A7DD-E31557E8F8CE', '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', '56D6DB6B-E9CB-4207-9DBF-545852296C3D', 'E156B3E6-8FC0-405C-97CE-7D4E85163C52') 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', '56D6DB6B-E9CB-4207-9DBF-545852296C3D', 'E156B3E6-8FC0-405C-97CE-7D4E85163C52') 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 ('DE815B4E-FB6A-44D9-A7DD-E31557E8F8CE', '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', 'E156B3E6-8FC0-405C-97CE-7D4E85163C52') 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 ('DE815B4E-FB6A-44D9-A7DD-E31557E8F8CE', '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', 'E156B3E6-8FC0-405C-97CE-7D4E85163C52') 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
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 ('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 ('D2750AC9-265D-4816-8311-019B0AC34727', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', 'DDB88D55-C385-43E4-AE6A-CC4C556D7310') 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 ('D2750AC9-265D-4816-8311-019B0AC34727', 'DDB88D55-C385-43E4-AE6A-CC4C556D7310') 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 ('D2750AC9-265D-4816-8311-019B0AC34727', 'DDB88D55-C385-43E4-AE6A-CC4C556D7310') 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', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('BC94303A-44AC-4F15-A532-380C3D428F15', '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 ('BC94303A-44AC-4F15-A532-380C3D428F15', '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', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('BC94303A-44AC-4F15-A532-380C3D428F15', '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', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('BC94303A-44AC-4F15-A532-380C3D428F15', '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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '9A614125-30A9-4863-BFCF-C0E51BA20780', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('9A614125-30A9-4863-BFCF-C0E51BA20780', 'F4002455-238B-4D8A-A05D-A91AF642DC79', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '9A614125-30A9-4863-BFCF-C0E51BA20780') 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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '9A614125-30A9-4863-BFCF-C0E51BA20780') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '9A614125-30A9-4863-BFCF-C0E51BA20780') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('21948AA5-0A8D-4CE6-AC7E-2722FBB92A15', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '9A614125-30A9-4863-BFCF-C0E51BA20780') 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 ('7D840EEB-355A-4179-8613-A043CBBB8DA6', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', 'E5F13203-8F73-45E4-B020-1A01A9CA1C8F') 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 ('D2750AC9-265D-4816-8311-019B0AC34727', 'E5F13203-8F73-45E4-B020-1A01A9CA1C8F') 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 ('7D840EEB-355A-4179-8613-A043CBBB8DA6', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', 'E5F13203-8F73-45E4-B020-1A01A9CA1C8F') 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 ('7D840EEB-355A-4179-8613-A043CBBB8DA6', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', 'E5F13203-8F73-45E4-B020-1A01A9CA1C8F') 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 ('8030E215-2BB2-457B-A510-84B98AC52BF9', '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 ('5D6C330B-19F4-4D89-BF7C-55B14A28879F', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', '5D6C330B-19F4-4D89-BF7C-55B14A28879F') 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 ('8030E215-2BB2-457B-A510-84B98AC52BF9', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', '5D6C330B-19F4-4D89-BF7C-55B14A28879F') 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 ('8030E215-2BB2-457B-A510-84B98AC52BF9', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', '5D6C330B-19F4-4D89-BF7C-55B14A28879F') 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 ('7D840EEB-355A-4179-8613-A043CBBB8DA6', '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 ('E5F13203-8F73-45E4-B020-1A01A9CA1C8F', '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 ('F4002455-238B-4D8A-A05D-A91AF642DC79', 'E5F13203-8F73-45E4-B020-1A01A9CA1C8F') 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 ('7D840EEB-355A-4179-8613-A043CBBB8DA6', '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 ('F4002455-238B-4D8A-A05D-A91AF642DC79', 'E5F13203-8F73-45E4-B020-1A01A9CA1C8F') 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 ('7D840EEB-355A-4179-8613-A043CBBB8DA6', '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 ('F4002455-238B-4D8A-A05D-A91AF642DC79', 'E5F13203-8F73-45E4-B020-1A01A9CA1C8F') 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', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('BC94303A-44AC-4F15-A532-380C3D428F15', '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 ('BC94303A-44AC-4F15-A532-380C3D428F15', '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', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('BC94303A-44AC-4F15-A532-380C3D428F15', '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', 'C4F4361F-391E-4A44-A2DB-A8A94CAFCEB7', '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 ('BC94303A-44AC-4F15-A532-380C3D428F15', '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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '9A614125-30A9-4863-BFCF-C0E51BA20780', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '9A614125-30A9-4863-BFCF-C0E51BA20780') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '9A614125-30A9-4863-BFCF-C0E51BA20780') 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', 'AB7D65CA-31FA-4586-8475-182A089287A2', '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 ('D2750AC9-265D-4816-8311-019B0AC34727', '14DD0175-CED9-42B8-9DBA-9BC14A45EC00', '9A614125-30A9-4863-BFCF-C0E51BA20780') 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', '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
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', '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', '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*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', '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 `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 ('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 ('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