SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` ORDER BY `space`.`updatetime` DESC, `space`.`lastlogin` DESC, `space`.`viewnum` DESC
最热会员
查询SQL语句
SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`avatar`='1' ORDER BY `space`.`credit` DESC
数据显示HTML代码
<ul>
<!--{loop $_SBLOCK['block8'] $value}-->
<li>