All pastes #225073 Raw Edit

Solution frmo JonA

public text v1 · immutable
#225073 ·published 2006-10-27 19:01 UTC
rendered paste body
New:
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;