XF 1.2 Ignored members


Well-known member
Anyone know how to see the top ignored members? Like a query that would list them by the most ignored to the least?

Liam W

Well-known member
Off hand, this SQL should do the trick:

SELECT      `ignored_user_id`,
            COUNT(`ignored_user_id`) AS `value_occurrence`
    FROM    `xf_user_ignored`
    GROUP BY `ignored_user_id`
    ORDER BY `value_occurrence` DESC
    LIMIT    1;
just run it in phpmyadmin, or somewhere else, and it'll give you the ignored_user_id and how many times it's there.