Old Links from meisterschaft to Disambiguation pages , de

SQL

SELECT pl_from, pl_title, cl1.cl_to
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, cl1.cl_to
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;
SQL

Checking query status...
