Weiterleitungen auf Orte in Österreich

SQL

USE dewiki_p;
SELECT DISTINCT source.page_title AS "WL-Seite", rd_title AS "WL-Ziel"
  FROM page as source, redirect, page as target, categorylinks
 WHERE source.page_is_redirect = 1
   AND source.page_namespace = 0
   AND rd_from = source.page_id
   AND target.page_title = rd_title
   AND target.page_namespace = rd_namespace
   AND target.page_id = categorylinks.cl_from
   AND cl_to in ('Gemeinde_im_Burgenland', 'Gemeinde_in_Niederösterreich', 'Gemeinde_in_Oberösterreich',
                 'Gemeinde_im_Land_Salzburg', 'Gemeinde_in_der_Steiermark', 'Gemeinde_in_Tirol',
                 'Gemeinde_in_Kärnten', 'Gemeinde_in_Vorarlberg', 'Stadt_in_Österreich')
SQL

Checking query status...
