gistfile1.txt

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