Rotlinks die nur in einem oder zwei Artikeln vorkommen

This query is marked as a draft This query has been published by Wurgl.

Das sind eventuell Tippfehler
Sind erstmal 3.993.565 Records, daher Einschränkung "Muss Kleinbuchstaben enthalten"

SQL

SELECT lt_title AS "Rotlink", COUNT(*) AS "Anzahl", GROUP_CONCAT(CONCAT('[[', REPLACE(article.page_title, '_', ' '), ']]') SEPARATOR ' ') AS "Artikel"
  FROM page AS article, pagelinks, linktarget
       LEFT JOIN page AS redlink
         ON lt_title = redlink.page_title
        AND lt_namespace = redlink.page_namespace
 WHERE lt_namespace = 0
   AND lt_id = pl_target_id
   AND redlink.page_id IS NULL
   AND article.page_id = pl_from
   AND article.page_namespace = 0
 GROUP BY pl_title
HAVING COUNT(*) <= 2;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...