SQL
x
SELECT pl_from, pl_title
FROM page , categorylinks as cl1, categorylinks as cl2, pagelinks
Where cl2.cl_to = 'Begriffsklärung'
AND cl2.cl_from= page_id
AND pl_title=page_title
AND pl_from_namespace = 0
AND pl_namespace = 0
AND cl1.cl_to like '%meisterschaft%'
AND pl_title not like '%Begriffsklärung%'
AND cl1.cl_from= pl_from
UNION
SELECT pl_from, pl_title
FROM page as page, page as redirectpage, redirect, categorylinks as cl1, categorylinks as cl2, pagelinks
Where cl2.cl_to = 'Begriffsklärung'
AND cl2.cl_from= page.page_id
AND pl_title=redirectpage.page_title
AND pl_namespace = 0
AND rd_from=redirectpage.page_id
AND rd_namespace = 0
AND rd_title=page.page_title
AND cl1.cl_to like '%meisterschaft%'
AND pl_title not like '%Begriffsklärung%'
AND cl1.cl_from= pl_from
ORDER BY pl_from DESC
Limit 3000;
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.