伊人国际自留地

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;
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;