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 1370-212488546_554028905602274_5352900869426874980_n.jpg, 9