use commonswiki_p;

select * from templatelinks join page

on tl_from = page_id

where tl_title = "Wikidata_Infobox"

and tl_from_namespace = 14

and not exists

(select * from hewiki_p.iwlinks

 where iwl_title = concat('Category:', page_title))

limit 10;

#Netherlands, 88

use hewiki_p;

select * from iwlinks

where iwl_from = 25892

limit 100;

select hepp.pp_page, ccpp.pp_page 

from hewiki_p.page_props as hepp

left join commonswiki_p.page_props as ccpp

on hepp.pp_value=ccpp.pp_value and hepp.pp_propname=ccpp.pp_propname

where hepp.pp_page =25892 and hepp.pp_propname='wikibase_item';

​