gistfile1.sql

mysql -u research -h db67.pmtpa.wmnet -p enwiki -e "SELECT
user.user_id,
MAX(revision.rev_timestamp),
user.user_touched,
user.user_registration,
user.user_editcount,
user_properties.up_value,
user_rights.ur_rights FROM
(((user_properties LEFT JOIN user ON user.user_id = user_properties.up_user) LEFT JOIN user_rights ON user.user_id = user_rights.ur_user) INNER JOIN revision ON user.user_id = revision.rev_user) WHERE user_properties.up_property = 'gender' AND user_properties.up_value IS NOT NULL" > gendergap.tsv