SELECT page_to_correct.page_title as to_correct, lt_to_disamb.lt_title  as disambiguation_page, lt_to_correct_page.lt_title  as correct_page

FROM categorylinks as cl 

     JOIN page as disambpage ON cl.cl_from= disambpage.page_id

            AND disambpage.page_namespace =0

            AND disambpage.page_title not like '%Begriffsklärung%'

     JOIN pagelinks as from_disamb_page ON cl.cl_from = from_disamb_page.pl_from

            AND cl.cl_to = 'Begriffsklärung'

            AND from_disamb_page.pl_from_namespace = 0

     JOIN linktarget as lt_to_disamb ON lt_to_disamb.lt_title = disambpage.page_title

            AND lt_to_disamb.lt_namespace = 0

     JOIN pagelinks as to_disamb ON to_disamb.pl_target_id = lt_to_disamb.lt_id

            AND to_disamb.pl_from_namespace = 0

     JOIN pagelinks as to_correct_page ON from_disamb_page.pl_target_id = to_correct_page.pl_target_id

            AND to_correct_page.pl_from = to_disamb.pl_from

            AND to_correct_page.pl_from_namespace = 0

     JOIN page as page_to_correct ON page_to_correct.page_id = to_correct_page.pl_from 

     JOIN linktarget as lt_to_correct_page ON lt_to_correct_page.lt_id = to_correct_page.pl_target_id

            AND lt_to_correct_page.lt_namespace = 0

            AND lt_to_correct_page.lt_title not like '%Begriffsklärung%'

            AND lt_to_correct_page.lt_title like CONCAT(lt_to_disamb.lt_title, '_%')

ORDER BY disambpage.page_id DESC

Limit 1000;