日日操夜夜添-日日操影院-日日草夜夜操-日日干干-精品一区二区三区波多野结衣-精品一区二区三区高清免费不卡

[ecmsinfo]"select * from phome_4ecms_news where checked=1 order by diggtop desc,id desc limit 10",10,30,0,24,10,0[/ecmsinfo]

這個是頂的排行

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

這個是7天點擊的排行。

那怎么按照按欄目來顯示呢，以下方法就是

select * from phome_4ecms_news where newspath >SUBDATE(NOW(),INTERVAL 7 DAY) and classid=欄目id order by onclick desc limit 10