SELECT e_id, emlak_turu, sub_type, title, spot, belde, fiyat, para_turu, satis_turu, create_date,
(SELECT resim FROM emlak_img WHERE e_id=emlak.e_id ORDER BY img_id LIMIT 0,1) AS emlak_img ,
(SELECT il FROM iller WHERE il_id=emlak.il_id) AS emlak_il ,
(SELECT ilce FROM ilceler WHERE ilce_id=emlak.ilce_id) AS emlak_ilce
FROM emlak WHERE lang='eng' AND status='1' AND emlak_turu='0'
Table 'besthomes.emlak_img' doesn't exist