All pastes #225095 Raw Edit

Solution 2 from JonA

public text v1 · immutable
#225095 ·published 2006-10-27 19:13 UTC
rendered paste body
New 2:
SELECT tag.name
     , COUNT(t1.tag_id) AS number
  FROM tag_webobject t1
  LEFT JOIN tag
    ON t1.tag_id=tag.id
 GROUP BY tag.id
        , tag.name
;

New 1:
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
;