SELECT SQL_SMALL_RESULT

            user.clan_tag,

            user.username,

            c2.*,

            UNIX_TIMESTAMP(c1.date) AS  date,

            count(c1.id)            AS  replies

--

FROM        comments                AS  c2

--

LEFT JOIN

comments    AS  c1 ON



            c1.id                   =   c2.thread_id

AND         c1.board                =   c2.board

--

LEFT JOIN

user ON



            c2.user_id              =   user.id

--

GROUP BY    c1.thread_id

--

ORDER BY    lastpost DESC

--

LIMIT 0,23;