USE hewiki_p;

SELECT *

FROM wikidatawiki_p.wb_items_per_site

LEFT JOIN page ON REPLACE(ips_site_page, ' ', '_') = page_title AND page_namespace = 0

where ips_item_id in (SELECT ips_item_id

FROM wikidatawiki_p.wb_items_per_site

LEFT JOIN enwiki_p.page en ON REPLACE(ips_site_page, ' ', '_') = en.page_title AND en.page_namespace = 0

WHERE ips_site_id = 'enwiki'

AND en.page_title is not null            

AND en.page_title = 'P')