自己已解决:MYSQL要大于4.0 用SQL刷新 [ecmsinfo]'select * from (select classid,newspath,filename,title,newstime from xcpetecms_news union select classid,newspath,filename,title,newstime from xcpetecms_download union select classid,newspath,filename,title,newstime from xcpetecms_flash union select classid,newspath,filename,title,newstime from xcpetecms_article) a order by newstime desc limit 10',0,52,0,24,7,0[/ecmsinfo]
|