{pc:get sql="select *,count(*) as count from hz_favorite where adddate>=DATE_SUB(CURDATE(),INTERVAL WEEKDAY(CURDATE()) DAY) group by title order by count(*) desc" return="data" num="4"}
{loop $data $key $val}
{$val[title]}
{/loop}
{/pc}
原文:http://www.cnblogs.com/linxutao/p/5315389.html