GROUP BY and then COUNT without a subquery?
Is it possible to group by and then get a total count of all the rows without a subquery? I think the answer is no, but thought it was worth asking.
This is my query at the moment, which does what I want, but has a subquery:
SELECT COUNT(*) AS count
LEFT JOIN categories AS node ON node.id = img_categories.categories_id,
categories AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND parent.id = 16
GROUP BY img_categories.img_id
) AS tbl