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'
Capture - SuperTstore
