Puuduvad mehed

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='Q6581097' 
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;
SQL

Checking query status...
