use wikidatawiki_p;

SELECT CONCAT('* [[:d:', witem.page_title, '|', term_text,']] - ', COUNT(witem.page_title)) FROM page AS witem

JOIN pagelinks ON witem.page_id=pl_from AND pl_namespace=0 AND pl_title='Q6581072' 

JOIN wb_entity_per_page ON witem.page_id=epp_page_id

JOIN wb_items_per_site ON epp_entity_id=ips_item_id

JOIN wb_terms ON epp_entity_id=term_entity_id AND term_entity_type='item' AND term_language='en' AND term_type='label'

AND NOT EXISTS(

SELECT * FROM  wb_items_per_site AS wbet

WHERE epp_entity_id=wbet.ips_item_id

AND ips_site_id='etwiki')

GROUP by witem.page_title

ORDER BY COUNT(witem.page_title) DESC

LIMIT 200;