调用最新会员
SELECT * from uc_home_space order by updatetime desc
调用积分高的前10个会员
SELECT * from uchome_space order by credit desc
调用访问量最大的空间
SELECT * from uchome_space order by viewnum desc
调用有头像的会员
SELECT * FROM `uchome_space` WHERE `avatar` =1 by updatetime desc
调用一周热门会员
SELECT * from uchome_blog s,uchome_space sf where s.uid=sf.uid and sf.avatar=1
调用单身的用户
SELECT * from uchome_space s,uchome_spacefield sf where s.uid=sf.uid and sf.marry=1
调用实名认证用户
SELECT * from uchome_space where `name`!=''
随机调用用户的头像和用户名
SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`avatar`='1' ORDER BY RAND()
群组热帖>>
调用话题标题和所属群组名称
SELECT * from uchome_mtag s,uchome_thread sf where s.tagid=sf.tagid ORDER BY sf.dateline DESC
调用指定群组的最新话题
SELECT s.*,sf.* from uchome_post s,uchome_mtag sf where s.tagid=sf.tagid and sf.tagid=1 ORDER BY s.dateline