Untitled query #7157

This query is marked as a draft This query has been published by Matěj Suchánek.

SQL

SELECT pages.page_title, pages.page_namespace, COUNT(eu_sk.eu_entity_id) AS missing_labels
FROM wbc_entity_usage AS eu_sk
#JOIN wbc_entity_usage AS eu_cs USING (eu_page_id, eu_entity_id)
JOIN page AS pages ON pages.page_id = eu_sk.eu_page_id
WHERE eu_sk.eu_aspect = 'L.sk'
#AND eu_cs.eu_aspect = 'L.cs'
#AND term_text IS NULL
GROUP BY eu_sk.eu_page_id HAVING missing_labels > 10
ORDER BY missing_labels DESC#, pages.page_title, pages.page_namespace;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...