Articles by most wanted wikidata labels (arwiki)

مقالات عناصرها في ويكي بيانات بادعاءات بتسمية غير مترجمة. لو تُرجمت هذه التسميات إلى العربية لظهرت في ويكيبيديا العربية في المقالة..

SQL

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;

SQL

Checking query status...