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 (templatelinks, linktarget)
                                         ON tl_from = article.page_id
                                        AND tl_target_id = lt_id
                                        AND lt_title = navi.page_title
                                        AND lt_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 tl_from IS NULL
 GROUP BY article.page_title
 ORDER BY COUNT(*) DESC
SQL

Checking query status...
