注册
登录
| 关键词： uchome Select Where orDER dateline LIMIT DESC space sf spacefield |
1、调用含有图片的日志 Select * FROM `uchome_blog` Where `picflag` =1; 2、调用最近更新的10条日志 Select * FROM uchome_blog FORCE INDEX(dateline) orDER BY dateline DESC LIMIT 0,10; 3、调用最近更新的10个相册 Select * FROM uchome_album FORCE INDEX(updatetime) orDER BY dateline DESC LIMIT 0,10; 说明：这是调用所有相册 加个条件：调用隐私设计为全站可见的相册 Select * FROM uchome_album FORCE INDEX(updatetime) Where `friend` =0 orDER BY dateline DESC 说明：friend值： '0'全站用户可见,'1'为全好友可见,'2'为仅指定的好友可见,'3'为仅自己可见,'4'为凭密码查看 4、调用最近的10条迷你博客 Select * FROM uchome_doing FORCE INDEX(dateline) orDER BY dateline DESC LIMIT 0,10; 5、调用我的话题 Select * FROM uchome_thread orDER BY dateline DESC LIMIT 0,10; 6、调用3天内回复数最多的日志 Select * FROM uchome_blog Where dateline>UNIX_TIMESTAMP()-86400*3 orDER BY replynum DESC 7、调用选吧一周内的热点话题 select * FROM uchome_thread where dateline>=UNIX_TIMESTAMP()-604800 orDER BY viewnum DESC; 或者Select * FROM uchome_ thread Where dateline>=UNIX_TIMESTAMP()-86400*7 orDER BY viewnum DESC; 8、调用最近3天注册的人，且按照降序排列 Select * FROM uchome_space Where dateline>UNIX_TIMESTAMP()-86400*3 orDER BY dateline DESC; 9、调用最后更新的10位会员 select * from uchome_space order by updatetime desc LIMIT 0,10; 10、将用户栏目的内容列表出来，并以用户积分作为排列顺序 Select * FROM uchome_spacefield sf, uchome_space s Where s.uid=sf.uid order by s.credit desc 说明：field_1为 uchome_spacefield 这个表要调用的用户栏目选择项，可以为field_1，field_2。。。 11、调用个人空间性别为女的用户 select * from uchome_space s,uchome_spacefield sf where s.uid=sf.uid and sf.sex=2 12、调用个人空间性别为男的用户 select * from uchome_space s,uchome_spacefield sf where s.uid=sf.uid and sf.sex=1 13、调用积分高的前10个会员 select * from uchome_space order by credit desc LIMIT 0,10; 14、调用访问量最大的空间 select * from uchome_space order by viewnum desc LIMIT 0,10; 15、调用指定用户的日志 Select * FROM `uchome_blog` Where uid =1 LIMIT 0 , 10 这是调用uid为1的10条记录 16、调用有头像的10个会员 Select * FROM `uchome_space` Where `avatar` =1 LIMIT 0 , 10 17、调用某一主题回复的内容 Select * FROM `uchome_post` Where tid =1 AND isthread =0 LIMIT 0 , 30; 上面的SQL语，可以调用主题id为1的30条回复 18、调用群组 Select * FROM `uchome_mtag` LIMIT 0 , 10 19、调用一周热门会员 select * from uchome_space Where dateline>=UNIX_TIMESTAMP()-3600*24*7 orDER BY viewnum DESC LIMIT 0,18 20、调用发过帖子且有头像的会员 Select * from uchome_blog s,uchome_space sf where s.uid=sf.uid and sf.avatar=1 21、调用最热的群组 select * from uchome_post s,uchome_mtag sf where s.tagid=sf.tagid and orDER BY sf.membernum DESC LIMIT 0,10; 22、调用有图片的5个相册 Select * FROM `uchome_album` Where picflag =1 LIMIT 0 , 30 23、调用竞价排行 Select * FROM `uchome_show` orDER BY credit DESC LIMIT 0,10; 24、调用最新上传的10张图片 Select * FROM `uchome_pic`order by dateline desc LIMIT 0,10; 25、调用有话题的群组 select * from uchome_post s,uchome_mtag sf where s.tagid=sf.tagid LIMIT 0 , 10 26、调用最新的10个群组 Select * FROM `uchome_mtag`ORDER BY tagid DESC LIMIT 0,10; 27、调用群主id为1的有头像的10个会员 Select * from uchome_tagspace s,uchome_space sf where s.uid=sf.uid and sf.avatar=1 AND s.tagid=1 orDER BY sf.dateline DESC LIMIT 0,10; 28、调用单身的用户select * from uchome_space s,uchome_spacefield sf where s.uid=sf.uid and sf.marry=1 29、调用实名认证用户select * from uchome_space where `name`!='' 30、调用话题标题和所属群组名称select * from uchome_mtag s,uchome_thread sf where s.tagid=sf.tagid orDER BY sf.dateline DESC LIMIT 0,10; 31、随机调用用户的头像和用户名Select * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` Where `space`.`avatar`='1' orDER BY RAND() 32、调用指定群组的最新话题select s.*,sf.* from uchome_post s,uchome_mtag sf where s.tagid=sf.tagid and sf.tagid=1 orDER BY s.dateline LIMIT 0 , 10 上面的SQL指调用群组id为1的最新10个话题 |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
