Seiten mit Klammerlemma und BKH

Liste für Seite https://de.wikipedia.org/wiki/Benutzer:KnightMove/Klammerlemmas_mit_BKH mit Ausnahmen aus https://de.wikipedia.org/wiki/Benutzer:KnightMove/Vielleicht_sinnvolle_BKHs_in_Klammerlemmas

Stand 3. September waren das 3195 Treffer

SQL

SELECT CONCAT('[[', REPLACE(P0.page_title, '_', ' '), ']]') AS Artikel,
       REPLACE(tl_title, '_', ' ') AS Vorlage,
       IF((SELECT 1
             FROM templatelinks
            WHERE tl_title = 'Personendaten'
              AND tl_namespace = 10
              AND P0.page_id = tl_from) = 1, "Person", "") AS Person
  FROM page as P0, templatelinks
 WHERE P0.page_namespace = 0
   AND P0.page_title like "%_(%)"
   AND P0.page_id = tl_from
   AND tl_namespace = 10
   AND tl_title IN ('Dieser_Artikel', 'Begriffsklärungshinweis')
   AND NOT EXISTS ( SELECT 1
                      FROM page AS P1, pagelinks
                     WHERE P1.page_title = 'KnightMove/Vielleicht_sinnvolle_BKHs_in_Klammerlemmas'
                       AND P1.page_namespace = 2
                       AND P1.page_id = pl_from
                       AND pl_title = P0.page_title
                       AND pl_namespace = 0
                  )
 ORDER BY Person DESC, P0.page_title

SQL

Checking query status...