SELECT p.ID, pm.*, _ci.title_en, _c.title_en FROM wp_posts as p
JOIN wp_postmeta pm ON pm.post_id = p.id
JOIN _cities _ci ON _ci.city_id = pm.meta_value AND pm.meta_key = 'REAL_HOMES_city'
JOIN _countries _c ON _c.country_id = _ci.country_id
WHERE p.ID = 912