a guest Jan 21st, 2020 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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
RAW Paste Data