dede评论最多的文章排行版代码调用,并且调用第一条评论内容

{dede:sql sql="SELECT url,arctitle,msg, count( * ) AS count FROM dede_feedback

 GROUP BY arctitle ORDER BY count DESC LIMIT 0,10"} 
<li><a href="[field:url/]">[field:arctitle/]</a>[field:msg/]</li> 
{/dede:sql}