帝国CMS用SQL语句按时间和按栏目调用文章

帝国cms用SQL语句按时间和按栏目调用文章

用sql调用48小时内最热门的信息：

[ecmsinfo]"select * from phome_ecms_news where newstime>SUBDATE(NOW(),INTERVAL 2 DAY) order by onclick desc limit 10",10,30,0,24,7,0[/ecmsinfo]

这样只能调用全站的信息，我想调用某一栏目48小时内点击最热门的信息怎么写？

[ecmsinfo]"select * from phome_ecms_news where newstime>SUBDATE(NOW(),INTERVAL 2 DAY) and classid in (栏目ID,栏目ID) order by onclick desc limit 10",10,30,0,24,7,0[/ecmsinfo]