Categorized user pages (cswiki)

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

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q",term_entity_id), term_text
	FROM (SELECT * FROM pagelinks WHERE pl_title = "P210" and pl_namespace = 120 AND pl_from_namespace = 0) AS items
	JOIN wb_entity_per_page ON epp_page_id = pl_from
	LEFT JOIN (SELECT * FROM wb_terms WHERE term_language = "en" AND term_type = "label") AS labels
		ON term_entity_id = epp_entity_id;

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...