MySQL Query : select * from v9_course_link_video as a left join v9_course_video as b on (a.videoid = b.videoid) where b.videoid!='' and b.status=0 and a.courseid = order by b.sort_order desc LIMIT 100 MySQL 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 b.sort_order desc LIMIT 100' at line 1 MySQL Errno : 1064 Message : 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 b.sort_order desc LIMIT 100' at line 1 Need Help?