{dede:sql sql="Select mid,userid,uname,face,scores,(select count(*) from t_archives where mid = m.mid and FROM_UNIXTIME( pubdate, '%Y%m%d' ) = DATE_FORMAT(now(),'%Y%m%d'))docnumber From t_member m order by docnumber desc limit 0,10"}
{dede:sql sql="Select mid,userid,uname,face,scores,(select count(*) from t_archives where mid = m.mid and FROM_UNIXTIME( pubdate, '%u' ) = DATE_FORMAT(now(),'%u'))docnumber From t_member m order by docnumber desc limit 0,10"}
{dede:sql sql="Select mid,userid,uname,face,scores,(select count(*) from t_archives where mid = m.mid and FROM_UNIXTIME( pubdate, '%y%m' ) = DATE_FORMAT(now(),'%y%m'))docnumber From t_member m order by docnumber desc limit 0,10"}