Untitled query #28276

This query is marked as a draft This query has been published by Matěj Suchánek.

SQL

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

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...