dede评论最多的文章排行版代码调用,并且调用第一条评论内容 {dede:sql sql="SELECT url,arctitle,msg, count( * ) AS count FROM 58pic_feedback GROUP BY arctitle ORDER BY count DESC LIMIT 0,10"} lia href="[field:url/]"[field:arctitle/]/a[field:msg […]
dede评论最多的文章排行版代码调用,并且调用第一条评论内容
{dede:sql sql="SELECT url,arctitle,msg, count( * ) AS count FROM 58pic_feedback
GROUP BY arctitle ORDER BY count DESC LIMIT 0,10"}
<li><a href="[field:url/]">[field:arctitle/]</a>[field:msg/]</li>
{/dede:sql}