select * from [!db.pre!]ecms_news where classid in (select classid from [!db.pre!]enewsclass where bclassid in (7,8,9)) order by onclick DESC limit 8 dedecms..

   通过用灵动标签的SQL语句查询来调用栏目导航。（当然栏目导航一般我们用现成的showclasstemp或listshowclass栏目导航标签调用）例一：灵动标签显示栏目导航<table width="200" bo..

    问题：　　我用sql调用48小时内最热门的信息。只找到： 以下为引用的内容：
[ecmsinfo]"select * from phome_ecms_news where newstime>SUBDATE(NOW(),INTERVAL 2 DAY) or..