Wikilinks mit Klammer und zwei Zeichen danach

Fork of Wikilinks mit Klammer und einzelnem Zeichen danach by Wurgl

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

SQL

USE dewiki_p;
select CONCAT('[[', CONCAT(IF(page_namespace = 10, 'Vorlage:', ''), REPLACE(RL.page_title, '_', ' ')), ']]') AS "Artikel",
       REPLACE(pl_title, '_', ' ') AS "Verlinkt nach"
  FROM pagelinks STRAIGHT_JOIN page AS RL
 WHERE RL.page_id = pl_from
   AND pl_from_namespace IN (0, 10)
   AND pl_namespace = 0
   AND pl_title LIKE "%\_(%)____"
   AND pl_title NOT LIKE "%))"
   AND NOT EXISTS (SELECT 1
                     FROM page AS Tst
                    WHERE Tst.page_title = pl_title
                      AND Tst.page_namespace = pl_namespace
                  )
 ORDER BY pl_title, RL.page_namespace DESC, RL.page_title;

SQL

Checking query status...