Wikidata - given names - count of ar-descriptions

Fork of Wikidata - given names - count of en-descriptions by Jura1

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

SQL

# count of en-descriptions of given name items
use wikidatawiki_p; 

SELECT term_text As description, COUNT(page_title) AS items 
#CONCAT('#[[Special:Search/', term_text, '|', term_text, ']]') AS simplelist_for_copy_and_paste

FROM pagelinks, page, wb_entity_per_page, wb_terms
WHERE pl_from = 21293912
AND pl_namespace = 0
AND pl_title = page_title
AND page_id = epp_page_id
AND epp_entity_id = term_entity_id
AND term_entity_type = 'item'  # 'item' not 'property'
AND term_type = 'description'       # 'label', 'description', 'alias'
AND term_language = 'ar'
GROUP BY term_text

SQL

Checking query status...