Query Error: SELECT temp.*,b.truename as author FROM (SELECT vid ,subject as title ,uid,@vt,views as clickcount,replys as comments,attachurl,-1 as whereis FROM bg_vid as a WHERE a.pass=1 and cid='457' limit 0,4 union all SELECT p.id as vid,p.title,p.uid,1,p.clickcount,p.comments,p.imagepath as attachurl,p.whereis FROM ceot_video.vod_page as p WHERE p.isshow=1 and p.v_type_id= '' and p.id<> order by comments desc ) as temp, bg_user as b where temp.uid=b.uid order by comments desc limit 0,4 The URL Is: http://blog.chinaceot.com/blog.php?do-showone-uid-1005100-type-vod-itemid-1711.html MySQL Server Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by comments desc ) as temp, bg_user as b where temp.uid=b.uid order by com' at line 1 ( 1064 ) You Can Get Help In: http://www.phpwind.net