Links from a page to Disambiguation pages (incl. redirections) , de

SQL

set @id = 	8475702;

SELECT pl_from, pl_title, cl_to
FROM  page , categorylinks, pagelinks
Where pl_from= @id
	AND cl_to = 'Begriffsklärung'
	AND cl_from= page_id
    AND pl_title=page_title
    AND pl_from_namespace = 0
    AND pl_namespace = 0
    
    UNION
    
SELECT pl_from, pl_title, cl_to
FROM  page as page, redirect, page as redirectpage, categorylinks, pagelinks
Where pl_from= @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 cl_from= page.page_id
	AND cl_to = 'Begriffsklärung'
    
ORDER BY pl_from DESC
Limit 300;

SQL

Checking query status...