use commonswiki_p;

select * from templatelinks join page

on tl_from = page_id

where tl_title = "Wikidata_Infobox"

and tl_from_namespace = 14

and 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_prefix = 'commons'

and iwl_title like 'Category:Neth%'

limit 100;

​

​