Untitled query #28276

SQL

USE wikidatawiki_p;
SELECT page_title, term_text, term_language, ips_site_id, CONCAT('Q', ips_item_id)
FROM pagelinks
JOIN page ON page_id = pl_from
JOIN wb_terms ON term_full_entity_id = page_title AND term_type = 'label'
JOIN wb_items_per_site ON ips_site_id IN (
  CONCAT(term_language, 'wiki'),
  CONCAT(term_language, 'wikiquote'),
  CONCAT(term_language, 'wikisource'),
  CONCAT(term_language, 'wikivoyage')
) AND ips_site_page = term_text
#JOIN wb_items_per_site ON ips_site_id = CONCAT(term_language, 'wiki') AND ips_site_page = term_text
WHERE page_namespace = 0
AND pl_namespace = 0 AND pl_title = 'Q4167836'
AND ips_item_id <> REPLACE(term_full_entity_id, 'Q', '')
LIMIT 1;
SQL

Checking query status...
