SQL
x
USE fawiki_p;
SELECT REPLACE(page_title,'_',' '), cl_to
FROM page JOIN categorylinks AS frst ON cl_from = page_id JOIN page_props ON pp_page = page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND pp_propname <> 'hiddencat'
AND page_id IN (
SELECT scnd.cl_from
FROM categorylinks AS scnd
WHERE scnd.cl_to IN (
SELECT pl_title
FROM pagelinks JOIN page ON pl_from = page_id
WHERE page_title = frst.cl_to
AND pl_from_namespace = 14
AND pl_namespace = 14
)
AND frst.cl_to <> scnd.cl_to
)
LIMIT 10;
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.