|
登录后查才能浏览下载更多咨询,有问题联系QQ:3283999
您需要 登录 才可以下载或查看,没有账号?入住遨海湾
×
1、调用含有图片的日志 SELECT * FROM `uchome_blog` WHERE `picflag` =1;
; d$ Y3 v) u+ J- f2、调用最近更新的10条日志 SELECT * FROM uchome_blog FORCE INDEX(dateline) ORDER BY dateline DESC LIMIT 0,10; 6 l4 k" D9 {' P7 e. u F
3、调用最近更新的10个相册 SELECT * FROM uchome_album FORCE INDEX(updatetime) ORDER BY dateline DESC LIMIT 0,10; ' F( Q4 n4 l; {. Z. m/ {4 y C% Y( E' U2 R
说明:这是调用所有相册6 r, Q K+ S8 t x3 V9 C+ A6 R u
加个条件:调用隐私设计为全站可见的相册 SELECT * FROM uchome_album FORCE INDEX(updatetime) WHERE `friend` =0 ORDER BY dateline DESC
5 L% ^, v! C7 k: o说明:friend值: '0'全站用户可见,'1'为全好友可见,'2'为仅指定的好友可见,'3'为仅自己可见,'4'为凭密码查看1 u F- L7 [3 R0 _% O: }5 X
$ y" V: y0 ?3 H$ c+ Y4、调用最近的10条播客 SELECT * FROM uchome_doing FORCE INDEX(dateline) ORDER BY dateline DESC LIMIT 0,10;
$ v* \4 K' t. U9 O6 F: X5 a8 R% ~5、调用我的话题 SELECT * FROM uchome_thread ORDER BY dateline DESC LIMIT 0,10;
% m# g' t/ ^7 k- F5 @ u6、调用3天内回复数最多的日志 SELECT * FROM uchome_blog WHERE dateline>UNIX_TIMESTAMP()-86400*3 ORDER BY replynum DESC
$ A5 S: c5 X. s. q7、调用选吧一周内的热点话题 select * FROM uchome_thread where dateline>=UNIX_TIMESTAMP()-604800 ORDER BY viewnum DESC; / `4 A- z6 M- Z6 l
或者 SELECT * FROM uchome_ thread WHERE dateline>=UNIX_TIMESTAMP()-86400*7 ORDER BY viewnum DESC; $ [; `- `4 e3 G) q4 k
8、调用最近3天注册的人,且按照降序排列 SELECT * FROM uchome_space WHERE dateline>UNIX_TIMESTAMP()-86400*3 ORDER BY dateline DESC;
/ ~/ p. ? n O& j0 U) D6 r9、调用最后更新的10位会员 select * from uchome_space order by updatetime desc LIMIT 0,10; , s/ h1 |' K g* z" _& g
10、将用户栏目的内容列表出来,并以用户积分作为排列顺序 SELECT * FROM uchome_spacefield sf, uchome_space s WHERE s.uid=sf.uid order by s.credit desc
$ Y: W1 j7 H& J8 A7 k. N1 [说明:field_1为 uchome_spacefield 这个表要调用的用户栏目选择项,可以为field_1,field_2。。。
8 a! `: z0 M4 c11、调用个人空间性别为女的用户 select * from uchome_space s,uchome_spacefield sf where s.uid=sf.uid and sf.sex=2 7 W* p( @1 `2 E
12、调用个人空间性别为男的用户 select * from uchome_space s,uchome_spacefield sf where s.uid=sf.uid and sf.sex=1
7 m4 f. x! ?1 m13、调用积分高的前10个会员 select * from uchome_space order by credit desc LIMIT 0,10;
! Q" N1 u) ?5 S: ?4 C14、调用访问量最大的空间 select * from uchome_space order by viewnum desc LIMIT 0,10;
' ~5 u0 d( q L3 @15、调用指定用户的日志 SELECT * FROM `uchome_blog` WHERE uid =1 LIMIT 0 , 10
/ Z( F, A" e* g) B$ m7 [这是调用uid为1的10条记录+ f8 W* Q& n& z% ^2 c
16、调用有头像的10个会员 SELECT * FROM `uchome_space` WHERE `avatar` =1 LIMIT 0 , 10 ( z7 D1 \" p5 J U: i
17、调用某一主题回复的内容 SELECT * FROM `uchome_post` WHERE tid =1 AND isthread =0 LIMIT 0 , 30;
2 y4 f3 i0 n/ K$ T" n$ k. c上面的SQL语,可以调用主题id为1的30条回复( a/ O) B1 C X* E; v1 V8 R
18、调用群组 SELECT * FROM `uchome_mtag` LIMIT 0 , 10
5 O) R7 E3 {% P- m6 T' h19、调用一周热门会员 select * from uchome_space WHERE dateline>=UNIX_TIMESTAMP()3 y. X# ?) a: q" @6 I; v
' t6 M6 W1 \3 F* S: g) e5 A/ A
-3600*24*7 ORDER BY viewnum DESC LIMIT 0,18
$ V6 P* T0 {& u- l: ^! F5 u% Z( ]. T20、调用发过帖子且有头像的会员 SELECT * from uchome_blog s,uchome_space sf where s.uid=sf.uid and sf.avatar=1 |
|