Mine

SELECT description.description_state, COUNT( product.product_id ) as description_count FROM description
				LEFT JOIN product ON description.product_id = product.product_id
				WHERE product.category_id = '$cat' GROUP BY description.description_state