SQL_QUERY select t1.*, t1.id as advert_id, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_warming_system, t5.Name as estate_ground, t6.Name as estate_room_type, t7.Name as estate_flat_item, t8.Name as estate_current_flat, t9.Name as estate_city, t10.Name as estate_township, t15.Name as estate_area, t11.Name as estate_land_registry_status, t12.Name as estate_development_status, t13.Name as estate_precedents, t14.Name as estate_floor_permission, t16.Name as estate_wet_ground, t17.Name as estate_front, (select t_advert_images.Images from t_advert, t_advert_images where t_advert.ID=t_advert_images.ParentID and t_advert.ID='101198' 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.PageType='EstateStatus' and t2.PageLang='English' left join t_properties t3 on t1.EstateType = t3.ItemID and t3.PageType='EstateType' and t3.PageLang='English' left join t_properties t4 on t1.WarmingSystem = t4.ItemID and t4.PageType='WarmingSystem' and t4.PageLang='English' left join t_properties t5 on t1.Ground = t5.ItemID and t5.PageType='Ground' and t5.PageLang='English' left join t_properties t6 on t1.RoomType = t6.ItemID and t6.PageType='RoomType' and t6.PageLang='English' left join t_properties t7 on t1.FlatItem = t7.ItemID and t7.PageType='FlatItem' and t7.PageLang='English' left join t_properties t8 on t1.CurrentFlat = t8.ItemID and t8.PageType='CurrentFlat' and t8.PageLang='English' left join t_city t9 on t1.City = t9.ID left join t_township t10 on t1.TownShip = t10.ID left join t_area t15 on t1.Area = t15.ID left join t_properties t11 on t1.LandRegistryStatus = t11.ItemID and t11.PageType='LandRegistryStatus' and t11.PageLang='English' left join t_properties t12 on t1.DevelopmentStatus = t12.ItemID and t12.PageType='DevelopmentStatus' and t12.PageLang='English' left join t_properties t13 on t1.Precedents = t13.ItemID and t13.PageType='Precedents' and t13.PageLang='English' left join t_properties t14 on t1.FloorPermission = t14.ItemID and t14.PageType='FloorPermission' and t14.PageLang='English' left join t_properties t16 on t1.WetGround = t16.ItemID and t16.PageType='WetGround' and t16.PageLang='English' left join t_properties t17 on t1.Front = t17.ItemID and t17.PageType='Front' and t17.PageLang='English' where t1.ID='101198'
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repaired Untitled Document
  • Doorman
  • Cable TV
  • Jacuzzi
  • With Furniture
  • With White Goods
  • Parking Garage
  • PVC Framed Windows
  • Balcony
  • Second Bathroom
  • Cabinet For Shower
  • Air Conditioner
  • High Ceiling
Further Information