SELECT user.username, INET_NTOA(ip.ip)
FROM xf_ip AS ip
LEFT JOIN xf_user AS user ON (user.user_id = ip.user_id)
WHERE user.username = 'admin'
GROUP BY ip.ip
SELECT user.username, INET_NTOA(ip.ip)
FROM xf_ip AS ip
LEFT JOIN xf_user AS user ON (user.user_id = ip.user_id)
WHERE user.username = 'admin'
GROUP BY ip.ip