A Database Error Occurred

Error Number: 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 pets_text.lang_id = 2 ORDER BY pets_text.pos' at line 8

SELECT pets.link FROM pets LEFT JOIN pets_text ON pets.pet_id = pets_text.pet_id WHERE pets_text.position < AND pets_text.lang_id = 2 ORDER BY pets_text.position DESC LIMIT 1