Wikidata description maintenance

SQL

USE wikidatawiki_p;
SELECT D.term_full_entity_id AS id1, L.term_full_entity_id AS id2, D.term_text
FROM wb_terms AS D
JOIN wb_terms AS L ON L.term_text = D.term_text
JOIN page ON page_title = L.term_full_entity_id AND page_namespace = 0
LEFT JOIN pagelinks ON pl_from = page_id AND pl_title = 'P279' AND pl_namespace = 120
WHERE D.term_language = 'cs' AND D.term_type = 'description'
AND L.term_language = D.term_language AND L.term_type = 'label'
AND pl_title IS NULL
AND D.term_text NOT IN ('jazyk', 'zámek', 'válka', 'doména', 'zvláštní obvod Tokia', 'povídka', 'rok', 'chemická skupina')
LIMIT 1000;
SQL

Checking query status...
