Fehler beim lesen der Datenbank

Fehler #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 'AND ORDER BY f.header,f.subheader LIMIT 0,9' at line 1

Abfrage: SELECT f.id,f.header,f.subheader,f.text,f.duration,v.bild,(SELECT SUM(b.bewertung)/COUNT(*) FROM bewertungen AS b WHERE b.film=f.id) AS bewertung,fd.* FROM filme AS f JOIN videos AS v ON v.id=f.video LEFT OUTER JOIN filme_det AS fd ON fd.fid=f.id WHERE f.lft BETWEEN AND ORDER BY f.header,f.subheader LIMIT 0,9

Fatal error: Call to a member function get_query() on a non-object in /var/www/html/inc/design/bottom.php on line 8