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 ('670B29B1-B55A-4853-B5FB-3859B86B5455', '235FB1ED-0508-4B19-9FAE-45AF77E8DD89')
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` =1where `categoryid` ='EDF13941-2E43-40B5-8839-0B0C609D5C0B'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('235FB1ED-0508-4B19-9FAE-45AF77E8DD89', '670B29B1-B55A-4853-B5FB-3859B86B5455') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =1) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('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` =1) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('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` =1) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('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` =1) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('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` =1) and `isActive` =1and (`scope` isnullor `scope` =0)