Untitled query #35337

SQL

USE dewiki_p;
SELECT COUNT(*), cl_to
  FROM page, revision_userindex, categorylinks
 WHERE page_namespace = 0
   AND page_id = rev_page
   AND rev_parent_id = 0
   AND rev_user_text = 'Informationswiedergutmachung'
   AND page_id = cl_from
   AND cl_to IN ('Mann', 'Frau')
 GROUP BY cl_to;
SELECT page_title, cl_to
  FROM page, revision_userindex, categorylinks
 WHERE page_namespace = 0
   AND page_id = rev_page
   AND rev_parent_id = 0
   AND rev_user_text = 'Informationswiedergutmachung'
   AND page_id = cl_from
   AND cl_to IN ('Mann', 'Frau')
 ORDER BY cl_to, page_title
SQL

Checking query status...
