select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '33C27305-6859-4DF9-9CC5-FB5E0806602D') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '33C27305-6859-4DF9-9CC5-FB5E0806602D') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyId` in ('1404128B-8306-4A41-926F-05ACF8F3B461', '6EC81350-90AD-44AC-93DD-C4259723C2F5', '7FF6FD81-194A-4575-8110-DA21E2657100') and `PR_SpecificationPropertyMasterData`.`deleted_at` isnullorderby `title` asc, `order` asc
select*from `PR_Products` where `PR_Products`.`productId` in ('003379CB-8A6C-479F-B8C7-34F193129999', '2426E1D7-A8A2-4BD5-8777-98DE2663FC9B') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
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` =8where `categoryid` ='05E803A7-793A-4E6A-A1AA-C1B163BDDF5A'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('2426E1D7-A8A2-4BD5-8777-98DE2663FC9B') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =8) and `isActive` =1orderby `lngId` desc
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('05E803A7-793A-4E6A-A1AA-C1B163BDDF5A', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '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` =8) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('05E803A7-793A-4E6A-A1AA-C1B163BDDF5A', 'B2CDA476-C8A3-4130-B00A-2DF9161E4632', '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` =8) and `isActive` =1and (`scope` isnullor `scope` =0)