|
|
|
 |
|
|
|
En Uygun Satýlýklar |
|
|
|
|
|
En Uygun Kiralýklar |
|
|
|
|
|
Döviz Bilgileri |
|
|
| T.C.M.B |
Alýþ |
Satýþ |
| TL |
0 |
0 |
| EUR |
2.1394 |
2.1497 |
| USD |
1.5282 |
1.5356 |
| GBP |
2.4991 |
2.5122 |
|
|
|
|
|
|
|
|
|
Vitrin Ýlanlarý |
|
|
select
t1.*,
t2.Name as estate_type,
t3.Name as estate_status,
t4.Name as estate_township,
t6.Currency as estate_rent_currency,
t7.Images as estate_images,
t8.Name as estate_city
from t_advert t1
inner join t_properties t2 on t2.PageType='EstateType'
inner join t_properties t3 on t3.PageType='EstateStatus'
inner join t_properties t4 on t4.PageType='TownShip'
inner join t_exchange t6 on t6.Currency=t1.RentCurrency
inner join t_advert_images t7 on t7.ParentID=t1.ID
inner join t_properties t8 on t8.PageType='City'
where
t2.ItemID = t1.EstateType and t2.PageLang='Türkçe' and
t3.ItemID = t1.EstateStatus and t3.PageLang='Türkçe' and
t4.ID = t1.TownShipID and
t6.Currency = t1.RentCurrency and
t7.ParentID = t1.ID and t7.Seq = (select min(Seq) from t_advert_images where Visible='1' and ParentID=t1.ID group by Seq LIMIT 0,1) and
t8.ID = t1.CityID and
t1.Visible='1' and t1.DisplayAdvert='1' order by RentPrice limit 0,22
|
|
|
