$tag = $db->tag[$_GET["tag"]]
SELECT id, name
FROM tag
WHERE (id = '202')
$count = $applications->count("*")
SELECT COUNT(*)
FROM application
LEFT JOIN application_tag ON application.id = application_tag.application_id
WHERE (application_tag.tag_id = '202')
foreach ($applications->order($order, "application.id")->limit($perPage, $offset) as $application)
SELECT application.id, application.title, application.slogan, application.author_id
FROM application
LEFT JOIN application_tag ON application.id = application_tag.application_id
WHERE (application_tag.tag_id = '202')
ORDER BY title, application.id
LIMIT 10
a("author.php?id=$application[author_id]", $application->author["name"])
SELECT id, name
FROM author
WHERE (author.id IN (101, 102, 109))
foreach ($application->application_tag() as $application_tag)
SELECT application_id, tag_id
FROM application_tag
WHERE (application_tag.application_id IN (301, 304, 323, 322))
h($application_tag->tag["name"])
SELECT id, name
FROM tag
WHERE (tag.id IN (201, 202, 207))