gistfile1.txt

SELECT DISTINCT
    setter.login_name, ft.name, flags.status, grant_group.name
FROM
    flag_state_activity AS flags
        JOIN
    profiles AS setter ON flags.setter_id = setter.userid
        JOIN
    flagtypes AS ft ON ft.id = flags.type_id
        JOIN
    groups AS grant_group ON grant_group.id = ft.grant_group_id
WHERE
    YEAR(flags.flag_when) = 2016
        AND MONTH(flags.flag_when) > 2
        AND ft.grant_group_id IS NOT NULL
        AND flags.status = '+'
ORDER BY setter.login_name
LIMIT 100000