select*from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('136357FD-0870-490C-9773-B2BC409CD78C', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2629C939-C55C-4CF6-8FED-3D41EF235CFF', 'CE49416F-033B-4F79-A495-86DFDF9F4655') and `PR_Specifications`.`deleted_at` isnullorderby `order` asc
select*from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationId` in ('136357FD-0870-490C-9773-B2BC409CD78C', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2629C939-C55C-4CF6-8FED-3D41EF235CFF', 'CE49416F-033B-4F79-A495-86DFDF9F4655') and `PR_SpecificationProperties`.`deleted_at` isnullorderby `order` asc
select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('225BFD2C-F813-4E5D-9A43-8EB88C8B30F9', '86FF7D54-A9A4-47C4-8A80-D7F204F287BD', 'F6845B4B-9982-4B0D-853B-B556FCBFE496', '9950C96B-B913-4CF1-BA47-8B54B0DD889E')
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` ='15C302E4-2F9B-4FC3-98C3-3B843089FBAE'and `PR_ProductCategories`.`deleted_at` isnull
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('15C302E4-2F9B-4FC3-98C3-3B843089FBAE', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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 ('15C302E4-2F9B-4FC3-98C3-3B843089FBAE', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '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 ('15C302E4-2F9B-4FC3-98C3-3B843089FBAE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'D2463931-314A-492F-B7D7-C5FC39E5FCC9') 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 ('15C302E4-2F9B-4FC3-98C3-3B843089FBAE', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'D2463931-314A-492F-B7D7-C5FC39E5FCC9') 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)