Navigationsleisten Fußball ergänzen

SQL

SELECT article.page_title AS "Artikel",
       GROUP_CONCAT(navi.page_title SEPARATOR ', ') AS "Navigationsleiste(n)",
       COUNT(*) AS "Anzahl Navileisten"
  FROM categorylinks,
       pagelinks AS navipl,
       (page AS navi, page AS article) LEFT JOIN pagelinks AS articlepl
                                         ON articlepl.pl_from = article.page_id
                                        AND articlepl.pl_title = navi.page_title
                                        AND articlepl.pl_namespace = navi.page_namespace
 WHERE cl_to = 'Vorlage:Navigationsleiste_Fußball_(Europa)'
   AND navi.page_id = cl_from
   AND navi.page_namespace = 10
   AND navipl.pl_from = navi.page_id
   AND navipl.pl_title = article.page_title
   AND navipl.pl_namespace = article.page_namespace
   AND article.page_namespace = 0
   AND articlepl.pl_from IS NULL
 GROUP BY article.page_title
SQL

Checking query status...
