Begriffsklärungsseiten mit 30 oder mehr verlinkten Personen

Fork of Begriffsklärungsseiten mit 30 oder mehr verlinkten Personen by Wurgl

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

SQL

SELECT CONCAT('[[', REPLACE(BKL.page_title, '_', ' '), ']]'),
       count(Person.page_title) AS AnzahlPersonenLinks
  FROM page AS BKL, templatelinks AS BTL, pagelinks, page AS Person, templatelinks as PTL
 WHERE BKL.page_namespace = 0
   AND BKL.page_title NOT LIKE '%_(Familienname)'
   AND BTL.tl_from = BKL.page_id
   AND BTL.tl_title = 'Begriffsklärung'
   AND BTL.tl_namespace = 10
   AND pl_from = BKL.page_id
   AND pl_namespace = 0
   AND Person.page_title = pl_title
   AND Person.page_namespace = 0
   AND PTL.tl_from = Person.page_id
   AND PTL.tl_title = 'Personendaten'
   AND PTL.tl_namespace = 10
 GROUP BY BKL.page_title
 HAVING AnzahlPersonenLinks >= 30

SQL

Checking query status...