string SQL = "SELECT u.UserId,u.Username,u.Password,u.Status FROM Users AS u";
SQL += "OUTER APPLY (SELECT b.BanId FROM Bans AS b WHERE @P0 >= b.Start AND @P0 <= b.Finish AND b.UserId = u.UserId AND b.GalaxyId = @P1) AS banCheck ";
SQL += "OUTER APPLY (SELECT gu.GalaxyId, gu.DisplayName, g.Name FROM GalaxyUsers AS gu INNER JOIN Galaxies AS g ON gu.GalaxyId = g.GalaxyId WHERE gu.GalaxyId = @P1 AND gu.UserId = u.UserId) AS galCheck ";
SQL+="WHERE u.Status = 0 AND u.Username = @P2 AND u.Password = @P3";

DataTable res = DB.RunSQL(dx,SQL,DateTimeOffset.UtcNow,GalaxyId,Username,PasswordHash);