uchome 的几个数据调用的SQL语句

踏浪行歌

1、调用含有图片的日志 SELECT * FROM `uchome_blog` WHERE `picflag` =1; 3 _2 Q8 T: a" D2、调用最近更新的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; 说明：这是调用所有相册 5 k3 y& f$ V* U/ f1 S. k加个条件：调用隐私设计为全站可见的相册 SELECT * FROM uchome_album FORCE INDEX(updatetime) WHERE `friend` =0 ORDER BY dateline DESC , T! d+ S& U) r. K" E5 \0 ^5 r说明：friend值： '0'全站用户可见,'1'为全好友可见,'2'为仅指定的好友可见,'3'为仅自己可见,'4'为凭密码查看 : {8 x8 J1 w3 k, p 4、调用最近的10条播客 SELECT * FROM uchome_doing FORCE INDEX(dateline) ORDER BY dateline DESC LIMIT 0,10; ) o! q; u# \2 t2 X0 k5、调用我的话题 SELECT * FROM uchome_thread ORDER BY dateline DESC LIMIT 0,10; % C9 V3 Q( O! d% u6、调用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; $ r5 I' P& f! O9 h5 _4 O6 v6 m6 Z或者 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; 6 o3 ~5 v, F" B. d" e( h% I/ Z9 W10、将用户栏目的内容列表出来，并以用户积分作为排列顺序 SELECT * FROM uchome_spacefield sf, uchome_space s WHERE s.uid=sf.uid order by s.credit desc ' c6 q6 V! r# E: C% }说明：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 ' L% ]8 i8 q9 Y12、调用个人空间性别为男的用户 select * from uchome_space s,uchome_spacefield sf where s.uid=sf.uid and sf.sex=1 - t1 q; a5 I9 y) T6 F13、调用积分高的前10个会员 select * from uchome_space order by credit desc LIMIT 0,10; 14、调用访问量最大的空间 select * from uchome_space order by viewnum desc LIMIT 0,10; / E4 }' A1 j7 X5 M6 T15、调用指定用户的日志 SELECT * FROM `uchome_blog` WHERE uid =1 LIMIT 0 , 10 3 G/ F" N2 d. G% c% W这是调用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; ) r$ R0 L! r" X) }上面的SQL语，可以调用主题id为1的30条回复 7 ?- @3 O. g1 X18、调用群组 SELECT * FROM `uchome_mtag` LIMIT 0 , 10 5 Z; n L' Q- F) A) s19、调用一周热门会员 select * from uchome_space WHERE dateline>=UNIX_TIMESTAMP() ) B1 T! z- V) w- V1 ?! B -3600*24*7 ORDER BY viewnum DESC LIMIT 0,18 + g4 u0 x! S7 {. T7 [) N. T20、调用发过帖子且有头像的会员 SELECT * from uchome_blog s,uchome_space sf where s.uid=sf.uid and sf.avatar=1