SELECT metadataID,tag, count(*) AS count, s1.storyIDlook AS storyID, m.homeIDlook, m.homeType FROM metadata m INNER JOIN storyxmetadata s1 ON m.metadataID=s1.metadataIDlook INNER JOIN story s ON s.storyID=s1.storyIDlook WHERE  m.private = 'n' AND s.deprecated LIKE 'n' AND browse LIKE 'y' AND category LIKE 'n' AND s.allowbrowse LIKE 'y' GROUP BY m.metadataID, tag, m.homeIDlook, m.homeType, s1.storyIDlook ORDER BY tag