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
        LEFT JOIN
    user_group_map AS ugm ON setter.user_id = ugm.user_id
WHERE
    YEAR(flag.modification_date) = 2016
        AND MONTH(flag.modification_date) > 2
        AND ft.grant_group_id IS NOT NULL
        AND ugm.group_id != gt.grant_group_id
        AND (flag.status = '+' || flag.status = '-')
ORDER BY setter.login_name
LIMIT 100000