Gender of editors to specific pages (aggregate, timestamp range)

SQL

SELECT (CASE
        WHEN actor_user IS NULL then 'ip'
        WHEN up_value IS NULL then 'unspecified'
        ELSE up_value
        END) AS gender_or_ip,
       COUNT(*)
FROM (SELECT DISTINCT actor_user, actor_name, up_value
      FROM revision
      JOIN actor ON actor_id = rev_actor
      LEFT JOIN user_properties ON up_user = actor_user AND up_property = 'gender'
      WHERE rev_page = (SELECT page_id
                        FROM page
                        WHERE page_namespace = 4 AND page_title = 'Articles_for_deletion/Clarice_Phelps')
         OR (rev_page = (SELECT page_id
                         FROM page
                         WHERE page_namespace = 4 AND page_title = 'Articles_for_deletion/Clarice_Phelps')
          )) q1
GROUP BY gender_or_ip;

SQL

Checking query status...