Untitled query #1276

SQL

# See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg
#
use wikidatawiki_p; 
SELECT SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1) AS label, COUNT(*)
FROM pagelinks As pl1, wb_entity_per_page, wb_terms, pagelinks AS pl2
WHERE pl1.pl_title = 'Q5' 
AND pl2.pl_title = 'P569'   #Q5 = humans
AND pl1.pl_namespace = 0 
AND pl2.pl_namespace = 120  #property = 120, items = 0
AND epp_entity_type = 'item'
AND pl1.pl_from = epp_page_id
AND pl2.pl_from = epp_page_id
AND term_entity_id = epp_entity_id
AND term_type = 'label'
AND term_entity_type = 'item' 
AND term_language = 'en'
GROUP BY SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1)
HAVING COUNT(*)>50
SQL

Checking query status...
