Əmlak axtarışı
Faydalı Məlumatlar
Əmlak Kodu
Satılır / Zavod
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select count(*) as count_row from t_advert where Visible='1' and EstateStatus='1' and EstateType='16'
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repairedSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID as advert_id, t1.advert_title, 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 from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Azərbaycan dili' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Azərbaycan dili' and t3.PageType='EstateType' left join t_properties t8 on t1.RoomType=t8.ItemID and t8.PageLang='Azərbaycan dili' 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='Azərbaycan dili' and t7.PageType='RoomType' where t1.Visible='1' and EstateStatus='1' and EstateType='16' order by ADate desc limit 0,0
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repaired
SQL_ERROR_CODE 0
SQL_QUERY select count(*) as count_row from t_advert where Visible='1' and EstateStatus='1' and EstateType='16'
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repairedSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID as advert_id, t1.advert_title, 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 from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Azərbaycan dili' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Azərbaycan dili' and t3.PageType='EstateType' left join t_properties t8 on t1.RoomType=t8.ItemID and t8.PageLang='Azərbaycan dili' 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='Azərbaycan dili' and t7.PageType='RoomType' where t1.Visible='1' and EstateStatus='1' and EstateType='16' order by ADate desc limit 0,0
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repaired
Axtardığınız meyarlara uyğun qeyd tapıla bilməmişdir...