Missende vrouwen

SQL

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 wbnl
WHERE epp_entity_id=wbnl.ips_item_id
AND ips_site_id='nlwiki')
GROUP by witem.page_title
ORDER BY COUNT(witem.page_title) DESC
LIMIT 200;
SQL

Checking query status...
