<?php

function factory() {
        return array(
            "select"    => array(
                "artists"         => "GROUP_CONCAT(ym_tracks.artist)",
                "label_permalink" => "ym_labels.permalink",
                "label_name"      => "ym_labels.name",
                "type_name"       => "ym_types.name",
                "ym_releases.*"
            ),
            "from"      => array("ym_releases"),
            "join"      => array(
                array("inner", "ym_tracks", "ym_releases.catalog",  "ym_tracks.catalog"),
                array("inner", "ym_labels", "ym_releases.label",    "ym_labels.id"),
                array("inner", "ym_types",  "ym_releases.type",     "ym_types.type")
            ),
            "where"     => array(
                array("ym_releases.type", "!=", "podcast"),
                array("ym_releases.enabled", "=", "1")
            ),
            "group"     => array("ym_tracks.catalog"),
            "order"     => array(array("ym_releases.date", "-"))
        );
    }