Anyone study the files of example site album-o-rama? I got lost in the file album-o-rama\apps\frontend\controllers\IndexController.php. Don't know when did the author defined the"al","ar","ap".
$phql = 'SELECT
al.id,
al.name,
ar.uri,
ar.id as artist_id,
ar.name as artist,
ap.url
FROM AlbumOrama\Models\Albums al
JOIN AlbumOrama\Models\Artists ar
JOIN AlbumOrama\Models\AlbumsPhotos ap
WHERE
al.id >= '.($offset * 30).' AND
ap.type = "large"
ORDER BY al.playcount DESC
LIMIT 30';
$albums = $this->modelsManager->executeQuery($phql);
$this->view->setVar('albums', $albums);