verlinkte Weiterleitungen mit Anzahl Verlinkungen

SQL

SELECT CONCAT('[{{fullurl:', REPLACE(page_title, '_', ' '), '&redirect=no}} ', REPLACE(page_title, '_', ' '), '] => [[', REPLACE(NACH.pl_title, '_', ' '), ']]'),
       COUNT(VON.pl_title),
       CONCAT('[[', GROUP_CONCAT(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(VON.pl_title) > 1
 LIMIT 10

SQL

Checking query status...