verlinkte Weiterleitungen mit Anzahl Verlinkungen

SQL

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

Checking query status...
