SELECT count(distinct p.id_product) as count FROM (`sc_product` p) LEFT JOIN `sc_category_product` cp ON `p`.`id_product` = `cp`.`id_product` LEFT JOIN `sc_specific_price` sp ON `p`.`id_product` = `sp`.`id_product` && sp.id_product_attribute=0 WHERE `p`.`active` = '1' AND `p`.`permit` = '1' AND `cp`.`id_category` = '363' AND `p`.`deleted` != '1'