select `specificationPropertyMasterDataId` from `PR_ProductSpecificationProperties` where `productId` in ('55746108-EAE5-40B6-8AD6-73E7DAC4AFD1', '82460854-CB0B-4710-9B34-39396BB483F5')
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` ='77FC6D7E-4F08-481C-A009-A7D276461DD0'and `PR_ProductCategories`.`deleted_at` isnull
select*from `PR_Products` where `PR_Products`.`productId` in ('55746108-EAE5-40B6-8AD6-73E7DAC4AFD1', '82460854-CB0B-4710-9B34-39396BB483F5') and `PR_Products`.`deleted_at` isnulland (`PR_Products`.`lngId` isnullor `PR_Products`.`lngId` =1) and `isActive` =1orderby `lngId` desc