SQL ERROR :
SELECT subcat.*,count(subcat.id) as total FROM tbl_subcategories as subcat LEFT JOIN tbl_products as p ON subcat.id=p.psubcat_type WHERE subcat.cat_id='21' AND subcat.status='1' AND p.status='1' GROUP BY p.psubcat_type ORDER BY subcat.name ASC
Rubber Planters
Sub Categories (1)
SQL ERROR :
SELECT * FROM tbl_categories WHERE status='1' ORDER BY cname ASC