USE enwiki_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 hewiki_p.page he ON REPLACE(ips_site_page, ' ', '_') = he.page_title AND he.page_namespace = 0

WHERE ips_site_id = 'hewiki'

AND he.page_title="בנימין") 

AND ips_site_id = 'enwiki'