| MuOnline |
SELECT m.memb___id , m.ConnectTM, m.ServerName, m.IP, a.GameIDC, a.Id , r.resets, g.grand_resets, c.Class, c.cLevel, c.Name FROM [MuOnline].dbo.[MEMB_STAT] as m INNER JOIN AccountCharacter AS a ON (m.memb___id Collate Database_Default = a.Id Collate Database_Default) INNER JOIN Character AS c ON (a.GameIDC Collate Database_Default = c.Name Collate Database_Default) INNER JOIN Character AS r ON (a.GameIDC Collate Database_Default = r.Name Collate Database_Default) INNER JOIN Character AS g ON (a.GameIDC Collate Database_Default = g.Name Collate Database_Default) WHERE ConnectStat = 1 AND ServerName = 'Regular' ORDER by m.ConnectTM DESC
|