SQL
x
WITH MathTitle AS (
SELECT page_title
FROM page
JOIN categorylinks ON cl_from = page_id
WHERE cl_to = 'High-priority_mathematics_articles' limit 200
)
SELECT *
FROM page p1
JOIN linktarget ON lt_id = p1.page_id
WHERE page_namespace = 0
AND EXISTS (
SELECT 1
FROM MathTitle
WHERE p1.page_title = page_title
)
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.