关于通用文章列表
SQL语句是
select id,title,keywords,hits,intro,adddate,author,(select count(id) from ks_comment where channelid=1 and infoid=ks_article.id) as commenttotal from KS_Article where tid in({$CurrClassChildID}) and verific=1 order by id desc
我新建了文章模型之后,他的SQL语句是什么呢?
在线等待,thank you!!!