AqiooPlat.Web存储过程对应的sql

1.db_article_GetTopByistop

SELECT top 6 a_id, username, a_topic, a_author, a_comto, a_pic, a_summary, a_counter, classid,sp_poll_agree,sp_poll_oppose,sp_integral,a_arrtim
FROM db_article where (a_istop=1 or 1=0) and (classid=0 or classid in (SELECT classid FROM db_sys_class where nsort='article' and a_hidden=1 and (c_class=0 or 0=0))) order by a_arrtim desc

 

2. db_article_GetArticleByFilter

 blockcomponent(ArticleRepeat2ViewComponent with  "num=9" "filter=classid in (SELECT classid FROM db_sys_class where nsort='article' and a_hidden=1 and c_class=24) and (sp_keyes like '%财运%' or sp_keyes like '%财富%') " "sortField=a_arrtim desc")