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 = 120 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
#WHERE term_text like "%"
GROUP BY eu_page_id HAVING missing_labels > 10
ORDER BY missing_labels DESC, pages.page_title, pages.page_namespace;

SQL

Checking query status...