SELECT * FROM (
            SELECT ip, (
                SELECT CONCAT(' ', stats.teama, ' ', stats.teamb, ' ', (
                    SELECT GROUP_CONCAT(name separator ' ')
                    FROM subnames
                    WHERE matchid = stats.id
                ))
                FROM stats
                WHERE server = ip
                ORDER BY time DESC
                LIMIT 1
            ) AS players
            FROM servers
            WHERE status = 1
        ) AS ips