{dede:sql sql="Select mid,userid,uname,face,scores,(select count(1) from t_archives where mid = m.mid and FROM_UNIXTIME( pubdate, '%d' ) = date(curdate( )))docnumber From t_member m order by scores desc limit 0,10"}
{dede:sql sql="Select mid,userid,uname,face,scores,(select count(1) from t_archives where mid = m.mid and FROM_UNIXTIME( pubdate, '%w' ) = week(curdate( )))docnumber From t_member m order by scores desc limit 0,10"}
{dede:sql sql="Select mid,userid,uname,face,scores,(select count(1) from t_archives where mid = m.mid and FROM_UNIXTIME( pubdate, '%m' ) = month(curdate( )))docnumber From t_member m order by scores desc limit 0,10"}