select count(DISTINCT p.product_id) as totale from gn_product p LEFT JOIN gn_product_to_category pc on (p.product_id=pc.product_id) LEFT JOIN gn_category_description cd on (pc.category_id=cd.category_id) LEFT JOIN gn_category c on (pc.category_id=c.category_id) LEFT JOIN gn_product_description pd on (p.product_id=pd.product_id) WHERE pc.category_id = '105' AND p.price >= 0 AND p.price <= 20000 AND pd.language_id = '1' AND cd.language_id = '1' AND p.status = '1' AND c.status = '1' ORDER BY p.stock_status_id ASC, p.product_id DESC