Wikilinks mit fehlendem Pipe-Zeichen

Fork of Wikilinks mit fehlendem Pipe-Zeichen by Wurgl

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

gesucht werden Rotlinks nach dem Schema "Blubb (Klammerteil)Blah" wobei "Blubb (Klammerteil)" als Blaulink existiert

SQL

USE ndswiki_p;
SELECT Artikel.page_title AS "Artikel",
       pl_title AS "eventuell kaputten Link",
       CONCAT(SUBSTRING_INDEX(pl_title, ')', 1), ')|', SUBSTRING_INDEX(pl_title, ')', -1)) AS "Vörslag"
  from pagelinks, page AS Artikel, page AS Blaulink
 WHERE Artikel.page_id = pl_from
   AND pl_namespace = 0
   AND pl_from_namespace = 0
   AND pl_title regexp '\\)[^_/]'
   AND Blaulink.page_namespace = pl_namespace
   AND Blaulink.page_title = CONCAT(SUBSTRING_INDEX(pl_title, ')', 1), ')')
   AND NOT EXISTS (SELECT 1
                    FROM page
                   WHERE page_title = pl_title
                     AND page_namespace = pl_namespace
                  )

SQL

Checking query status...