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}
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}