This query is marked as a draft This query has been published by FShbib.

SQL

AخA
 
USE arwiki_p;
SELECT pages.page_title, pages.page_namespace, COUNT(DISTINCT eu_entity_id) AS missing_labels
    FROM (SELECT * FROM wbc_entity_usage WHERE eu_aspect = "L.ar") AS eusage
    JOIN wikidatawiki_p.page AS items
        ON items.page_namespace = 0 AND items.page_title = eu_entity_id
    JOIN wikidatawiki_p.wb_entity_per_page
        ON epp_entity_type = "item" AND epp_page_id = items.page_id
    LEFT JOIN (SELECT * FROM wikidatawiki_p.wb_terms WHERE term_type = "label" AND term_language = "ar" AND term_entity_type = "item") AS labels
        ON term_entity_id = epp_entity_id
    JOIN page AS pages
        ON pages.page_id = eu_page_id
WHERE term_text IS NULL
GROUP BY eu_page_id HAVING missing_labels > 4
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.
All SQL code is licensed under CC0 License.

Checking query status...