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 AS ips1 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
WHERE page_namespace = 0
AND pl_namespace = 0 AND pl_title = 'Q4167836'
AND CONCAT('Q', ips_item_id) <> term_full_entity_id
AND NOT EXISTS (
  SELECT 1 FROM wb_items_per_site AS ips2
  WHERE ips2.ips_item_id = REPLACE(term_full_entity_id, 'Q', '')
  AND ips1.ips_site_id = ips2.ips_site_id
)
LIMIT 100;
SQL

Checking query status...
