verlinkte Weiterleitungen mit Anzahl Verlinkungen

SQL

SELECT CONCAT('[{{fullurl:', REPLACE(WL.page_title, '_', ' '), '&redirect=no}} ', REPLACE(WL.page_title, '_', ' '), ']') AS Weiterleitung,
       CONCAT('[[', REPLACE(NACH.pl_title, '_', ' '), ']]') AS Ziel,
       COUNT(VONPAGE.page_id) AS "Anzahl Links auf Weiterleitung",
       CONCAT('[[', GROUP_CONCAT(DISTINCT REPLACE(VONPAGE.page_title, '_', ' ') SEPARATOR ']], [[' LIMIT 5), ']]') AS "maximal 5 Links"
  FROM page AS WL, pagelinks AS VON, pagelinks AS NACH, page AS VONPAGE
 WHERE WL.page_namespace = 0
   AND WL.page_is_redirect = 1
   AND VON.pl_title = WL.page_title
   AND VON.pl_namespace = WL.page_namespace
   AND VON.pl_from_namespace = 0
   AND NACH.pl_from = WL.page_id
   AND NACH.pl_namespace = 0
   AND VONPAGE.page_id = VON.pl_from
 GROUP BY WL.page_id
HAVING COUNT(DISTINCT VONPAGE.page_id) > 1
 LIMIT 10
SQL

Checking query status...
