• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 Ignored members

Blue

Well-known member
#1
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
#3
Off hand, this SQL should do the trick:

Code:
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.