select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('B7B99D2D-EA76-45C9-BF3E-95E8378FD5A0', '2717B09B-C21F-46C4-9039-2D8EC7C84BC0', '44114B5C-5025-4150-9566-EC4FD8DAB693', 'EFAE71DD-41E5-4925-91AC-2B8DE5C5DE1C', 'AC8B46AA-4BE6-4D26-BAFC-8F814251E716')
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` =4where `categoryid` ='482017D8-B0AD-41BF-97A5-5B7540931F4F'and `PR_ProductCategories`.`deleted_at` isnull
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('56CC127A-B3F9-41E6-B365-2FC71CBCBB82', '482017D8-B0AD-41BF-97A5-5B7540931F4F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('56CC127A-B3F9-41E6-B365-2FC71CBCBB82', '482017D8-B0AD-41BF-97A5-5B7540931F4F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('56CC127A-B3F9-41E6-B365-2FC71CBCBB82', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '482017D8-B0AD-41BF-97A5-5B7540931F4F', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('56CC127A-B3F9-41E6-B365-2FC71CBCBB82', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '482017D8-B0AD-41BF-97A5-5B7540931F4F', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('482017D8-B0AD-41BF-97A5-5B7540931F4F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '26140DB8-D45A-45A6-96FC-897FEC2BA49A', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('482017D8-B0AD-41BF-97A5-5B7540931F4F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '26140DB8-D45A-45A6-96FC-897FEC2BA49A', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '482017D8-B0AD-41BF-97A5-5B7540931F4F', 'F3109825-C704-42C0-874F-249F1011A1BB', '26140DB8-D45A-45A6-96FC-897FEC2BA49A', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '482017D8-B0AD-41BF-97A5-5B7540931F4F', 'F3109825-C704-42C0-874F-249F1011A1BB', '26140DB8-D45A-45A6-96FC-897FEC2BA49A', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('482017D8-B0AD-41BF-97A5-5B7540931F4F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '26140DB8-D45A-45A6-96FC-897FEC2BA49A', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('482017D8-B0AD-41BF-97A5-5B7540931F4F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '26140DB8-D45A-45A6-96FC-897FEC2BA49A', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)