Untitled query #1276

SQL

#
use wikidatawiki_p; 
SELECT CONCAT('Q', term_entity_id) AS item, term_text AS label, 'space', GROUP_CONCAT( term_language ) AS  languages
#SELECT CONCAT('Q', term_entity_id) AS item, GROUP_CONCAT(term_text) AS labels, 'space', GROUP_CONCAT( term_language ) AS  languages
FROM pagelinks As pl1, wb_entity_per_page, wb_terms, pagelinks AS pl2
WHERE pl1.pl_title = 'Q39'
AND pl2.pl_title = 'Q5'
and pl1.pl_namespace = 0
and pl2.pl_namespace = 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_entity_type = 'item' 
and term_type = 'label'
and term_language In ('en', 'fr', 'it', 'de', 'rm')

GROUP BY term_entity_id, term_text
SQL

Checking query status...
