Meistkommentierte Beiträge der letzten Zeit 21.07.2011, 10:18

Meistkommentierteste Beiträge der letzten 40 Tage

{exp:query sql="SELECT c.entry_id, c.comment_date, COUNT(c.entry_id) AS comment_count, t.url_title AS url_titel, t.title FROM exp_comments c, exp_channel_titles t WHERE c.entry_id = t.entry_id AND UNIX_TIMESTAMP() - c.comment_date <= (40*24*60*60) GROUP BY c.entry_id ORDER BY comment_count DESC, c.comment_date DESC LIMIT 10"}
• {title} - {comment_count} Kommentar{if comment_count != 1}e{/if}
{/exp:query}