playedyearandmonth >= 202009 and playedyearandmonth <= 202012 and P.cashhands > 0
group by P.player_id, P.PlayerName,P.pokersite_ID
HAVING sum(C.totalhands) >= 50
order by TotalHands desc
23:12:30.354 [Worker 19:19 - PostgresqlDatabase.ExecuteCancellableQuery] [[General] ] queryGroup=PlayerDetails
23:12:30.488 [Worker 19:19 - PostgresqlDatabase.ExecuteCancellableQuery] [[General] ] TIMER: 00:00.134 [19 - PostgresqlDatabase.ExecuteCancellableQuery]
23:12:30.682 [Main:1 - CaddyNotes.InitializeWithPlayer] [[General] ] Notecaddy Initializing : B178EE04
23:12:30.683 [Main:1 - CaddyNotes.InitializeWithPlayer] [[General] ] Notecaddy Finished for : B178EE04 with 0 notes
23:12:30.694 [Main:1 - CaddyNotes.InitializeWithPlayer] [[General] ] Notecaddy Initializing : B178EE04
23:12:30.695 [Main:1 - CaddyNotes.InitializeWithPlayer] [[General] ] Notecaddy Finished for : B178EE04 with 0 notes
23:12:30.819 [Main:1 - Shell.SelectTab] [[General] ] *** Ribbon tab selected: notecaddytab ***
23:12:32.330 [Main:1 - MainView.ShowNoteCaddy] [[General] ] trying to open notecaddy. Authorization: True
23:13:24.657 [Worker 21:21 - PokerManager.GarbageCollectionTimerTick] [[General] ] Before GC.Collect: GarbageCollectionGeneration=0, TotalMemory=107
23:13:24.657 [Worker 21:21 - PokerManager.GarbageCollectionTimerTick] [[General] ] After GC.Collect: GarbageCollectionGeneration=0, TotalMemory=107
23:13:24.657 [Worker 21:21 - PokerManager.GarbageCollectionTimerTick] [[General] ] CollectionCount=142,18,7
23:15:28.664 [Main:1 - App.App_DispatcherUnhandledException] [[HighPriority] ]
System.OverflowException: Value was either too large or too small for an Int32.
at System.Runtime.CompilerServices.AsyncServices.<>c. <ThrowAsync>b__1_0(Object state)
at System.Windows.Threading.ExceptionWrapper.Internal RealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatch When(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
23:15:28.664 [Main:1 - App.App_DispatcherUnhandledException] [[HighPriority] ] Holdem Manager 2 encountered an unrecoverable error:
Details copied to clipboard
Value was either too large or too small for an Int32.
Stack Trace at System.Runtime.CompilerServices.AsyncServices.<>c. <ThrowAsync>b__1_0(Object state)
at System.Windows.Threading.ExceptionWrapper.Internal RealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatch When(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)