Untitled query #49576

Klappt so nicht!

personen die einen Link zu einem Ort in den USA haben, aber nicht die US-Staatsbürgerschaft

SQL

use dewiki_p;
SELECT Person.page_title, Ort.page_title, 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_to
   AND Ort.page_namespace = pl_namespace
   AND cl_from = Ort.page_id
   /* AND cl_to IN (SELECT  */
LIMIT 10;

SQL

Checking query status...