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` =4where `categoryid` ='A7CF97A7-D46E-44F9-B157-F805D8C7ECE4'and `PR_ProductCategories`.`deleted_at` isnull
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('EDF13941-2E43-40B5-8839-0B0C609D5C0B', '14BE5DE7-B810-42D0-A99F-D8D4A7E19A34', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('EDF13941-2E43-40B5-8839-0B0C609D5C0B', '14BE5DE7-B810-42D0-A99F-D8D4A7E19A34', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('D16A4B20-0EBE-4636-874D-A3A8AADD8F01', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'DFC7031B-350D-4256-BFD8-A01156482C16', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('D16A4B20-0EBE-4636-874D-A3A8AADD8F01', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'DFC7031B-350D-4256-BFD8-A01156482C16', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2F0F3BDA-33D8-40D4-B41D-5EE6350DAD1C', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2F0F3BDA-33D8-40D4-B41D-5EE6350DAD1C', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('DFC7031B-350D-4256-BFD8-A01156482C16', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('DFC7031B-350D-4256-BFD8-A01156482C16', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CFE8AF5E-8D96-4B45-9733-541C602AC29D', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC7031B-350D-4256-BFD8-A01156482C16', '5B008D2B-DA29-48B8-A12A-800B9E35CE05', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('DFC85A3C-534F-4217-8BE9-7A54FBBD6B52', 'FF832D2E-9B0B-4A76-A060-C26621F72D35', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC7031B-350D-4256-BFD8-A01156482C16', '5B008D2B-DA29-48B8-A12A-800B9E35CE05', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` =1and `PR_Categories`.`deleted_at` isnulland (`PR_Categories`.`lngId` isnullor `PR_Categories`.`lngId` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '90C0F092-493B-4085-A77B-97371E143D35', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '90C0F092-493B-4085-A77B-97371E143D35', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '12FE81B8-69C5-41AA-8CB0-5B4397661ECB', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '12FE81B8-69C5-41AA-8CB0-5B4397661ECB', 'DFC7031B-350D-4256-BFD8-A01156482C16', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)
selectcount(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '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` =4) and `isActive` =1and (`scope` isnullor `scope` =0)