XF 1.2 Ignored members

[Blue]

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

 

[Amaury]

A resource would be required for this.

 

[Liam W]

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.

 

[Blue]

Worked great, thanks!