Untitled query #49576

SQL

use dewiki_p;
SELECT Person.page_title as Person, Ort.page_title as Ort, cl_to
  FROM page AS Person, templatelinks, categorylinks, pagelinks, page AS Ort
 WHERE Person.page_namespace = 0
   AND tl_from = Person.page_id
   AND tl_from_namespace = Person.page_namespace
   AND tl_namespace = 10
   AND tl_title = 'Personendaten'
   AND pl_from = Person.page_id
   AND pl_from_namespace = Person.page_namespace
   AND pl_namespace = 0
   AND Ort.page_title = pl_title
   AND Ort.page_namespace = pl_namespace
   AND cl_from = Ort.page_id
   AND cl_to IN (SELECT Cat.page_title
                   FROM page AS Cat, categorylinks
                  WHERE page_namespace = 14
                    AND cl_from = page_id
                    AND cl_to IN ('Ort_in_den_Vereinigten_Staaten', 'Hauptstadt_in_den_Vereinigten_Staaten', 'City_in_New_York', 'City_in_Wisconsin')
                )
   AND NOT EXISTS (SELECT 1
                     FROM categorylinks
                    WHERE cl_from = Person.page_id
                      AND cl_to = 'Kategorie:US-Amerikaner'
                  )
LIMIT 100;
SQL

Checking query status...
