
常用筛选条件:
审核通过:audit = '通过'
图文信息:picurl <> ''
文字信息:url = '' and picurl <> ''
外部信息:url <> ''
推荐信息:rec = 1
头条信息:head = 1
幻灯信息:filtertf = 1 and picurl <> ''
常用排序:
按添加时间先后排序(新添加的在前):order by id desc 或 order by addtime desc
按最后修改时间排序(新修改的在前):order by modtime desc
按权重排序(权重越高越前,权重相同则新添加的在前):order by hot desc,id desc
以下信息块查询语句我们会陆续更新,敬请关注!
- 调用审核过的最新20条信息
select top 20 * from manage_info_view where audit = '通过' order by id desc
- 调用核过的权重最高的20条信息
select top 20 * from manage_info_view where audit = '通过' order by hot desc,id desc
- 调用审核过的点击率最高的20条信息
select top 20 * from manage_info_view where audit = '通过' order by click desc,id desc
- 调用审核过的最新10条图文信息
select top 10 * from manage_info_view where audit = '通过' and picurl <> '' order by id desc
- 调用审核过的最新20条推荐信息
select top 20 * from manage_info_view where audit = '通过' and rec = 1 order by id desc
- 调用审核过的最新20条幻灯信息
select top 20 * from manage_info_view where audit = '通过' and filtertf = 1 and picurl <> '' order by id desc
- 调用审核过的最新3条头条信息
select top 3 * from manage_info_view where audit = '通过' and head = 1 order by id desc
- 调用审核过的最新20条普通文字信息
select top 20 * from manage_info_view where audit = '通过' and url = '' and picurl <> '' order by id desc
- 调用审核过的最新10条留言
select top 20 * from manage_review_view where audit = '通过' order by id desc
- 调用所有审核过的并允许在前台显示的栏目
select top 20 * from manage_class_view where audit = '通过' and show = '显示' order by id desc