select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('2CEE09AF-2237-4996-87E2-3A5B6B3DDA63', '5AD30AE8-3228-4C6B-A7A4-E992CE796FCF', '9950C96B-B913-4CF1-BA47-8B54B0DD889E')
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` =8where `categoryid` ='90C0F092-493B-4085-A77B-97371E143D35'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('2CEE09AF-2237-4996-87E2-3A5B6B3DDA63', '5AD30AE8-3228-4C6B-A7A4-E992CE796FCF', '9950C96B-B913-4CF1-BA47-8B54B0DD889E') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '90C0F092-493B-4085-A77B-97371E143D35', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '90C0F092-493B-4085-A77B-97371E143D35', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =8) and `isActive` =1and (`scope` isnullor `scope` =0)