Wikidata - search for labels or descriptions

Fork of Wikidata - search for labels or descriptions by Jura1

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

SQL

use wikidatawiki_p; 

SELECT term_text#, count(*)
from wb_terms 
WHERE term_entity_type = 'item' 
AND term_language = 'ar'
AND term_type = 'label'
AND term_text NOT LIKE 'قالب:%'
and exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = term_entity_id AND (wdpl.pl_title = 'Q11266439')
            AND wdpl.pl_namespace = 0)
and exists (select * from wikidatawiki_p.pagelinks wdp where wdp.pl_from = term_entity_id AND (wdp.pl_title = 'P31') 
             AND wdp.pl_namespace = 120)
GROUP BY term_text
#ORDER BY count(*) DESC
LIMIT 50

SQL

Checking query status...