Solution frmo JonA
public text v1 · immutableNew:
SELECT tag.name, v1.number
FROM (SELECT tag_id
, COUNT(tag_id) AS number
FROM tag_webobject
GROUP BY tag_id
) v1
LEFT JOIN tag
ON v1.tag_id=tag.id
;
Old:
SELECT tag.name, COUNT(tag_webobject.tag_id) AS number
FROM tag_webobject
GROUP BY tag_webobject.tag_id
LEFT JOIN tag
ON tag_webobject.tag_id=tag.id;