Weiterleitungen auf Orte in Österreich

SQL

USE dewiki_p;
SELECT source.page_title, rd_title, cl_to
  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')

SQL

Checking query status...