SELECT row1 FROM ( SELECT @rownum:=@rownum+1 row1, t.id FROM g5_movie_program_episode t JOIN (select @rownum:=0) R WHERE t.prog_id = 247947 ORDER BY LENGTH(title) DESC, title DESC) a WHERE id =

1064 : 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 '' at line 1

error file : /tvwiki/program_view.php