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_terms, wb_entity_per_page

	LEFT JOIN ( SELECT pl_from FROM pagelinks WHERE pl_title = 'P735' AND pl_namespace = 120 ) As allitemswithP735
	ON epp_page_id = allitemswithP735.pl_from WHERE allitemswithP735.pl_from IS NULL
AND pl1.pl_title = 'P27' 
AND pl1.pl_namespace = 120 
AND pl1.pl_from = epp_page_id
AND epp_entity_type = 'item'
AND term_entity_id = epp_entity_id
AND term_type = 'label'
AND term_entity_type = 'item' 
AND term_language = 'it'
GROUP BY SUBSTRING_INDEX(CONCAT(term_text, ' '), ' ', 1)
HAVING COUNT(*)>50
SQL

Checking query status...
