Untitled query #30665

SQL

use dewiki_p;
SELECT COUNT(Anfangsbuchstabe), SUBSTRING(bio.page_title, 0, 21) as Anfangsbuchstabe
  FROM page AS bio
 WHERE bio.page_namespace = 0
   AND bio.page_title like "Liste_der_Biografien/%"
   AND bio.page_is_redirect = 0
   AND EXISTS (SELECT 1
                     FROM pagelinks, page as graphikus
                    WHERE graphikus.page_title = "APPERbot/LdB/List"
                      AND graphikus.page_namespace = 2
                      AND graphikus.page_id = pl_from
                      AND pl_from_namespace = 2
                      AND pl_title = bio.page_title
                      AND pl_namespace = 0
                  )
 GROUP by Anfangsbuchstabe
SQL

Checking query status...
