select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'A3060E79-39FC-4057-968F-891A52BAA39A', 'B997854C-B0B2-4A72-87A1-C70A9439B595') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', 'A3060E79-39FC-4057-968F-891A52BAA39A', 'B997854C-B0B2-4A72-87A1-C70A9439B595') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('69778F03-78F1-4C9B-8936-94FFF47270D3', '9DABE1CD-8F52-43D7-8DCE-6BADF72EEE3F', 'D78F6505-9766-4732-A858-73785505B425') and `PR_SpecificationPropertyMasterData`.`deleted_at` isnullorderby `title` asc, `order` asc
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('F039A355-0BEA-4007-8B9D-27037EC800F5', 'FA21B327-A62C-41E6-BD54-0F8C1E2DE0DA', '3DABB7FB-FAF8-457F-B8E3-370033E408E5')
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` ='A881B577-87B7-4D55-81D7-C6CDAF12DB72'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('3DABB7FB-FAF8-457F-B8E3-370033E408E5', 'F039A355-0BEA-4007-8B9D-27037EC800F5', 'FA21B327-A62C-41E6-BD54-0F8C1E2DE0DA') 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 ('A881B577-87B7-4D55-81D7-C6CDAF12DB72', '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 ('A881B577-87B7-4D55-81D7-C6CDAF12DB72', '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 ('A881B577-87B7-4D55-81D7-C6CDAF12DB72', '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 ('A881B577-87B7-4D55-81D7-C6CDAF12DB72', '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 ('A881B577-87B7-4D55-81D7-C6CDAF12DB72', '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 ('A881B577-87B7-4D55-81D7-C6CDAF12DB72', '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)