Begriffsklärungsseiten mit 30 oder mehr verlinkten Personen

SQL

SELECT 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 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
 LIMIT 10

SQL

Checking query status...