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` ='4CA5F18E-7591-4B57-AC5F-D23F950CF945'and `PR_ProductCategories`.`deleted_at` isnull
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('863D439D-B6F2-48F1-BA51-9EEA6A2228E3', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', '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 ('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
select `netSuiteId` from `PR_Products` where `productId` in ('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', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', '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 ('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', 'D6164D33-DF96-43AE-80EA-0BEEECEB0393', '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 ('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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '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 ('3B393703-FAA0-4701-A5B4-DFA329A3DC9B', '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 ('D872661D-7FD5-4986-BC31-1BB4C789005C', '8D7D7313-DB13-4970-8ABC-F1A4DD7E68EB', '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*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 ('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', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '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', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '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', '50D6789D-8616-41FF-9F4C-2E003AD2B49A', '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