Tutorial Show online players ONLY (for ip)

[Blaze]

If someone were interested in curiosity to understand how many unique players are connected to their server, here is the query.
If a player is logged in with 10 pg, it is only counted once.

select count(*) as aggregate from `player`.`player` where `last_play` >= (now() - INTERVAL 5 MINUTE) group by `ip`

 

[almobd3]

also you can use DISTINCT ip desc here