SELECT
pm.*,
p.ID
from pbk9wlov_postmeta as pm
INNER JOIN pbk9wlov_posts as p
on p.ID = pm.post_id
where p.ID = (
SELECT pm.post_id
FROM pbk9wlov_postmeta pm
WHERE pm.meta_key = 'leadpages_slug'
AND pm.meta_value = 'arcadia-real-estate-desirable-for-families/reasons-why-arcadia-real-estate-is-so-desirable-for-families-10850991'
ORDER BY pm.meta_id ASC
LIMIT 1
)