Fork of
subcat arts with cats and Qs
by Jheald
This query is marked as a draft
This query has been published
by Jheald.
SQL
AخA
use enwiki_p;
#SELECT c_up.cl_to #, GROUP_CONCAT(p1.page_title SEPARATOR ' / ') AS pages , COUNT(p1.page_id)
SELECT *
FROM categorylinks AS c1
JOIN page AS p1 ON c1.cl_from=p1.page_id AND p1.page_is_redirect=0
JOIN categorylinks AS c_up ON c_up.cl_from=p1.page_id
WHERE c1.cl_to='MC existing maps group 01 (GB counties)'
#GROUP BY c_up.cl_to;
LIMIT 50;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.