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 '-photo.jpg, 9' at line 23
SELECT SQL_CALC_FOUND_ROWS o.*, p.url AS image, l.locality FROM offers AS o LEFT JOIN photos AS p ON o.offerId = p.offerId AND p.first = 'y' LEFT JOIN locality AS l ON o.localityId = l.localityId WHERE l.localityId = '' ORDER BY offerId DESC LIMIT 1-photo.jpg, 9