Sortieren über 2 Tabellen

[xabbuh]

Abwärts sortiert sollte es doch auch gehen:

PHP-Code:

<?php
    $sql = "SELECT
                p.id,
                p.topic_id,
                p.user_id,
                p.created AS datum,
                p.title,
                p.text,
                t.id,
                t.forum_id,
                t.closed,
                t.pinned
            FROM
                post p
            LEFT JOIN
                topic t
            ON
                t.id = p.topic_id
            GROUP BY
                p.topic_id
            ORDER BY
                YEAR(p.created) DESC,
                MONTH(p.created) DESC,
                DAYOFMONTH(p.created) DESC";
?>