select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '19ECC647-D200-4FA2-B9A2-1C3469EB3DE2', '9058F3AB-365F-4892-85F2-7034C0BC8E74', 'B878FCF2-996F-4EFD-BD59-5C4F213DB582', 'DC910DF6-288C-4A41-AA46-811FC12100C5') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '19ECC647-D200-4FA2-B9A2-1C3469EB3DE2', '9058F3AB-365F-4892-85F2-7034C0BC8E74', 'B878FCF2-996F-4EFD-BD59-5C4F213DB582', 'DC910DF6-288C-4A41-AA46-811FC12100C5') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('0849DCE1-13F4-43F1-AD0D-57DD2B28C265', '3E3DCB67-BC56-472B-805B-2D8BB52FBDA5', '6038C9E1-E3AF-4610-BD1F-4D258779A6CE')
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` ='EDF13941-2E43-40B5-8839-0B0C609D5C0B'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('0849DCE1-13F4-43F1-AD0D-57DD2B28C265', '3E3DCB67-BC56-472B-805B-2D8BB52FBDA5', '6038C9E1-E3AF-4610-BD1F-4D258779A6CE') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =4) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('EDF13941-2E43-40B5-8839-0B0C609D5C0B', '14BE5DE7-B810-42D0-A99F-D8D4A7E19A34', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('EDF13941-2E43-40B5-8839-0B0C609D5C0B', '14BE5DE7-B810-42D0-A99F-D8D4A7E19A34', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('26140DB8-D45A-45A6-96FC-897FEC2BA49A', 'EDF13941-2E43-40B5-8839-0B0C609D5C0B', '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 ('26140DB8-D45A-45A6-96FC-897FEC2BA49A', 'EDF13941-2E43-40B5-8839-0B0C609D5C0B', '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 ('EDF13941-2E43-40B5-8839-0B0C609D5C0B', '14BE5DE7-B810-42D0-A99F-D8D4A7E19A34', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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 ('EDF13941-2E43-40B5-8839-0B0C609D5C0B', '14BE5DE7-B810-42D0-A99F-D8D4A7E19A34', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '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)