select ((h.nisan/7)*7*rate.rate) as sqlfiyat,yatak_odasi,id,url,title,baslik,resim,indirim,ribbon,kisa_icerik,oda_sayisi,kisi,kur,doviz,nisan,mayis,haziran,temmuz,agustos,eylul,ekim,kasim,diger,(select avg(puan) from defter where onay=1 and islm_id=h.id) as ortalamapuan from homes as h INNER JOIN rate ON rate.CurrencyName=h.doviz where h.aktif=1 and h.emlak_bolgesi IN(select id from destinations where id IN(select id from destinations where id IN(select id from destinations where id=38 or cat=38) or cat IN(select id from destinations where id=38 or cat=38)) or cat IN(select id from destinations where id IN(select id from destinations where id=38 or cat=38) or cat IN(select id from destinations where id=38 or cat=38))) and h.sadece_bizde=1
Sonuçları Sırala:

Sonuç Bulunamadı..!