butthurtyuvi

SELECT user.user_id,user.user_touched,user.user_registration, user.user_editcount,user_properties.up_value,user_rights.ur_rights,MAX(revision.rev_timestamp) 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