SELECT ban_id, ban_ip, user_email, user_id,
MATCH (ban_ip, user_email) AGAINST ('"46.39.228.87"' IN BOOLEAN MODE) AS rev_0
FROM users RIGHT JOIN banlist ON ban_userid = user_id
WHERE MATCH (ban_ip, user_email) AGAINST ('"46.39.228.87"' IN BOOLEAN MODE)
ORDER BY rev_0 DESC LIMIT 10

ban_id|ban_ip        |user_email|user_id|rev_0
91    |5555555       |NULL      |NULL   |-2
452   |412.35.348.42 |NULL      |NULL   |-2
90    |223.42.254.4  |NULL      |NULL   |-2
96    |24.175.253.143|NULL      |NULL   |-2
92    |88.112.234.132|NULL      |NULL   |-2