SELECT TOP 10 d.memb___id, SUM(d.TotalTime) AS TotalTime , m.IP FROM DmN_OnlineCheck AS d  INNER JOIN [MuOnline].dbo.[MEMB_STAT] AS m ON(d.memb___id COLLATE Database_Default = m.memb___id COLLATE Database_Default) WHERE d.ServerName = 'Regular'  GROUP BY d.memb___id , m.IP  ORDER BY SUM(TotalTime) DESC