$author = $db->author[$id]
SELECT id, name, web
FROM author
WHERE (id = '113')
foreach ($author->application()->order("title") as $application)
SELECT id, author_id, title, maintainer_id
FROM application
WHERE (application.author_id IN (113))
ORDER BY application.author_id, title
foreach ($author->application()->via("maintainer_id")->order("title") as $application)
SELECT id, maintainer_id, title
FROM application
WHERE (application.maintainer_id IN (113))
ORDER BY application.maintainer_id, title