常用筛选条件：
审核通过：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

以下信息块查询语句我们会陆续更新，敬请关注!

1. 调用审核过的最新20条信息
   select top 20 * from manage_info_view where audit = '通过' order by id desc
2. 调用核过的权重最高的20条信息
   select top 20 * from manage_info_view where audit = '通过' order by hot desc,id desc
3. 调用审核过的点击率最高的20条信息
   select top 20 * from manage_info_view where audit = '通过' order by click desc,id desc
4. 调用审核过的最新10条图文信息
   select top 10 * from manage_info_view where audit = '通过' and picurl <> '' order by id desc
5. 调用审核过的最新20条推荐信息
   select top 20 * from manage_info_view where audit = '通过' and rec = 1 order by id desc
6. 调用审核过的最新20条幻灯信息
   select top 20 * from manage_info_view where audit = '通过' and filtertf = 1 and picurl <> '' order by id desc
7. 调用审核过的最新3条头条信息
   select top 3 * from manage_info_view where audit = '通过' and head = 1 order by id desc
8. 调用审核过的最新20条普通文字信息
   select top 20 * from manage_info_view where audit = '通过' and url = '' and picurl <> '' order by id desc
9. 调用审核过的最新10条留言
   select top 20 * from manage_review_view where audit = '通过' order by id desc
10. 调用所有审核过的并允许在前台显示的栏目
    select top 20 * from manage_class_view where audit = '通过' and show = '显示' order by id desc