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