Untitled query #27336

SQL

use dewiki_p;
SELECT rpage.page_title AS "Weiterleitung von", rd_title AS "Weiterleitung nach", cl_to AS "Mann/Frau/…"
  FROM page AS rpage, redirect, page AS zpage, categorylinks
 WHERE rpage.page_title LIKE "%(%)"
   AND rpage.page_namespace = 0
   AND rpage.page_is_redirect = 1
   AND rd_from = rpage.page_id
   AND rd_title LIKE "%(%)"
   AND zpage.page_title = rd_title
   AND zpage.page_namespace = rd_namespace
   AND zpage.page_id = cl_from
   AND cl_to in ("Mann", "Frau", "Divers", "Intersexueller", "Transgender-Person", "Geschlecht_unbekannt")
SQL

Checking query status...
