SELECT p.ID, pm.* FROM wp_posts as p
JOIN wp_postmeta pm ON pm.post_id = p.id
JOIN _countries _c ON _c.country_id = pm.meta_value AND pm.meta_key = 'REAL_HOMES_country'
WHERE p.ID = 912
GROUP BY p.ID