SQL
AخA
SELECT
p1.page_title,
cl1.cl_to,
cl2.cl_to
FROM page p1 -- article
JOIN categorylinks cl1 -- daughter
ON p1.page_id = cl1.cl_from
JOIN categorylinks cl2 -- mother
ON p1.page_id = cl2.cl_from
JOIN page p2 -- daughter cat page
ON cl1.cl_to = p2.page_title
AND p2.page_namespace = 14
JOIN categorylinks cl3
ON p2.page_id = cl3.cl_from
and cl3.cl_to = cl2.cl_to
WHERE
p1.page_namespace = 0
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.