Tags

foreach ($db->tag()->order("name") as $tag)

SELECT id, name
FROM tag
ORDER BY name

a("./?tag=$tag[id]", $tag->application_tag()->count("*"))

SELECT COUNT(*), tag_id
FROM application_tag
WHERE (application_tag.tag_id IN (208, 207, 209, 204, 203, 202, 210, 201, 206, 205))
GROUP BY tag_id