select e.*, r.File, il.isim, ilce.ilce as ilcesi from emlak as e 
		left join resim as r on e.id = r.EmlakId
		left join il on e.il = il.plaka 
		left join ilce on e.ilce = ilce.id
		where e.id = '".$_REQUEST['IlanId']."' 
		group by e.id, r.Id
		order by r.MainFile DESC, r.Id ASC