Ingatlan kereső

SELECT o.cim,o.url, i.terulet, i.telek, i.ar, i.fokep,i.rovid_leiras, i.k_kategoria, i.id, i.regisztracios FROM ingatlan AS i LEFT JOIN oldalak AS o ON o.id = i.id LEFT JOIN ingatlan_kategoria AS ik ON i.k_kategoria = ik.id LEFT JOIN varos AS v ON v.id = i.varos_id WHERE o.statusz = '1' AND ik.eladokiado = '1' ORDER BY i.letrehozva desc LIMIT 9999 OFFSET 0