select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '65EBFA01-7744-4861-803E-BA026DFC9BA0') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '65EBFA01-7744-4861-803E-BA026DFC9BA0') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('BDB99B83-7053-4913-94AA-4A53DBDE5668', 'D78F6505-9766-4732-A858-73785505B425') and `PR_SpecificationPropertyMasterData`.`deleted_at` isnullorderby `title` asc, `order` asc
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', '143A7C4F-815D-4B17-B08E-BEAD3B7537D2')
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` =3where `categoryid` ='04D55C1B-233E-4330-91DC-3EA91D0BF2B4'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('143A7C4F-815D-4B17-B08E-BEAD3B7537D2', '9B0DC8C0-55C0-4EDB-B211-2557FEEDE6B7', 'B4C8A4CC-CFBF-4BD2-9536-79DB16CEF214') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =3) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '04D55C1B-233E-4330-91DC-3EA91D0BF2B4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =3) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '04D55C1B-233E-4330-91DC-3EA91D0BF2B4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =3) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('5473E506-0419-4ACD-B240-9486A2AB8B20', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '04D55C1B-233E-4330-91DC-3EA91D0BF2B4', '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` =3) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('5473E506-0419-4ACD-B240-9486A2AB8B20', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '04D55C1B-233E-4330-91DC-3EA91D0BF2B4', '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` =3) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('5473E506-0419-4ACD-B240-9486A2AB8B20', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '04D55C1B-233E-4330-91DC-3EA91D0BF2B4', '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` =3) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('5473E506-0419-4ACD-B240-9486A2AB8B20', 'DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', '04D55C1B-233E-4330-91DC-3EA91D0BF2B4', '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` =3) and `isActive` =1and (`scope` isnullor `scope` =0)