Hizmetlerimiz
Referans Kodu
E-Posta Listesi
Yeniliklerden haberdar olmak için E-Posta listemize kayıt olabilirsiniz.
Anket
Emlak Arama
Satılık / Arsa
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID as advert_id, t1.RefNo, t1.SquareMeter, t1.RentPrice, t1.RentCurrency, t1.AdvertType, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_city, t5.Name as estate_township, t6.Name as estate_area, t7.Name as estate_room, (select Images from t_advert_images where Visible='1' and ParentID=t1.ID order by Seq asc LIMIT 0,1) as estate_images, (select PageTitle from t_advert_seo where AdvertID=t1.ID and PageLang='Türkçe') as advert_title from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Türkçe' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Türkçe' and t3.PageType='EstateType' left join t_properties t8 on t1.RoomType=t8.ItemID and t8.PageLang='Türkçe' and t8.PageType='RoomType' left join t_city t4 on t1.City=t4.ID left join t_township t5 on t1.Township=t5.ID left join t_area t6 on t1.Area=t6.ID left join t_properties t7 on t1.RoomType=t7.ItemID and t7.PageLang='Türkçe' and t7.PageType='RoomType' where t1.Visible='1' and EstateStatus='1' and EstateType='10' order by ADate desc limit 0,18
SQL_ERROR Subquery returns more than 1 row
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID as advert_id, t1.RefNo, t1.SquareMeter, t1.RentPrice, t1.RentCurrency, t1.AdvertType, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_city, t5.Name as estate_township, t6.Name as estate_area, t7.Name as estate_room, (select Images from t_advert_images where Visible='1' and ParentID=t1.ID order by Seq asc LIMIT 0,1) as estate_images, (select PageTitle from t_advert_seo where AdvertID=t1.ID and PageLang='Türkçe') as advert_title from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Türkçe' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Türkçe' and t3.PageType='EstateType' left join t_properties t8 on t1.RoomType=t8.ItemID and t8.PageLang='Türkçe' and t8.PageType='RoomType' left join t_city t4 on t1.City=t4.ID left join t_township t5 on t1.Township=t5.ID left join t_area t6 on t1.Area=t6.ID left join t_properties t7 on t1.RoomType=t7.ItemID and t7.PageLang='Türkçe' and t7.PageType='RoomType' where t1.Visible='1' and EstateStatus='1' and EstateType='10' order by ADate desc limit 0,18
SQL_ERROR Subquery returns more than 1 row
- Toplam Kayıt 13 • Sayfa 1/1
- 1
