XF 1.2 Ignored members

Blue

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?
 
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.
 
Top Bottom