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