SELECT COUNT(*) AS `count` FROM `profsh_pfshopro`.`products` AS `Product` LEFT JOIN `profsh_pfshopro`.`producers` AS `Producer` ON (`Product`.`producer_id` = `Producer`.`id`) LEFT JOIN `profsh_pfshopro`.`emag_categories` AS `EmagCategory` ON (`Product`.`emag_category_id` = `EmagCategory`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`professional` = '0' AND `Product`.`category_filters` LIKE '%{17}%'