selectCASEWHEN price <500THEN "Less than 500"
WHEN price BETWEEN500AND5000THEN "500 - 5000"
WHEN price BETWEEN5000AND10000THEN "5000 - 10000"
WHEN price BETWEEN10000AND20000THEN "10000 - 20000"
ELSE "More than 20000"
ENDAS price_range,
COUNT(products.id) as products_count
from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(115, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1groupby `price_range`
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(115, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(323, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(333, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(330, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(332, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(331, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(100, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(111, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(113, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(346, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(320, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(349, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(107, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(321, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(369, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(371, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(316, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(319, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(317, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(363, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(368, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(318, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(103, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(340, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(347, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(353, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(350, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(338, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(345, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(132, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(357, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(324, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(356, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(101, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(339, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(336, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(334, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(361, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(337, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(328, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(358, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(335, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(122, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(125, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(115, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(126, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(102, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(364, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(372, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(367, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(378, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(375, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(377, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(133, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(366, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(322, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(112, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(109, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(365, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(379, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(360, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(106, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(343, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(329, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(120, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(116, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(129, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(373, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(370, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(376, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(123, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(127, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(108, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(114, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(131, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(128, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(104, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(110, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(348, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(351, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(327, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(326, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(374, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(119, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(352, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(105, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(130, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(distinct `products`.`id`) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(325, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1
selectcount(*) as aggregate from `products` whereexists (select*from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(115, categories_ids)) and `active` =1) and `products`.`name` !=''and `products`.`slug` !=''and `products`.`active` =1