viewtopic.php?f=15&t=3770&st=0&sk=t&sd=a
Could not see how to attach the PokerTracker.log, so here is the content of it:
- Code: Select all
2008/05/01 18:09:34.771: [- Main -][System] PokerTracker v3.00 beta 9
2008/05/01 18:09:34.972: [- Main -][System] Attempting to to: http://www.ptrackupdate.com/check.php
2008/05/01 18:09:35.012: [00003684][ConnectorThread] Connecting...
2008/05/01 18:09:35.192: [00003684][ConnectorThread] Sending request...
2008/05/01 18:09:35.533: [00003684][ConnectorThread] Reading response...
2008/05/01 18:09:35.573: [00003684][ConnectorThread] Read complete.
2008/05/01 18:09:35.613: [00003684][ConnectorThread] Returning.
2008/05/01 18:09:35.643: [- Main -][System] Data read.
2008/05/01 18:09:35.683: [00003944][QueryManager] Loading stats
2008/05/01 18:09:38.917: [00003944][QueryManager] Stats loaded.
2008/05/01 18:09:39.018: [00003944][QueryManager] Loading queries
2008/05/01 18:09:39.058: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Aliases.xml.pte
2008/05/01 18:09:39.098: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2008/05/01 18:09:39.188: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2008/05/01 18:09:39.248: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Notes.xml.pte
2008/05/01 18:09:39.298: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Players.xml.pte
2008/05/01 18:09:39.378: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2008/05/01 18:09:39.448: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2008/05/01 18:09:39.548: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2008/05/01 18:09:39.659: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2008/05/01 18:09:39.729: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2008/05/01 18:09:39.829: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2008/05/01 18:09:40.350: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2008/05/01 18:09:40.670: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2008/05/01 18:09:40.720: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2008/05/01 18:09:40.770: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2008/05/01 18:09:40.850: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2008/05/01 18:09:40.920: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2008/05/01 18:09:41.000: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2008/05/01 18:09:41.491: [00003944][Query] Loading query file: C:\Programmer\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2008/05/01 18:09:41.651: [00003944][QueryManager] Queries loaded.
2008/05/01 18:09:41.942: [00003944][StatManager] Stats and reports loaded.
2008/05/01 18:09:41.972: [00003944][FilterManager] Loading filters...
2008/05/01 18:09:42.242: [00003944][FilterManager] Filters loaded.
2008/05/01 18:09:42.282: [00003944][LayoutManager] Loading layouts...
2008/05/01 18:09:42.332: [00003944][LayoutManager] Layouts loaded.
2008/05/01 18:09:42.623: [00003944][StatManager] Stats and reports loaded.
2008/05/01 18:09:42.653: [00003944][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/05/01 18:09:42.753: [00003944][PostgresConnection] Successfully connected to: PT3 Beta DB1 [26738296]
2008/05/01 18:09:43.144: [00003944][ConnectionManager] Database Version: 300025
2008/05/01 18:09:43.214: [00003944][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/05/01 18:09:43.324: [00003944][PostgresConnection] Successfully connected to: PT3 Beta DB1 [28164088]
2008/05/01 18:09:43.374: [00003944][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/05/01 18:09:43.464: [00003944][PostgresConnection] Successfully connected to: PT3 Beta DB1 [18500592]
2008/05/01 18:09:43.494: [00003944][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/05/01 18:09:43.584: [00003944][PostgresConnection] Successfully connected to: PT3 Beta DB1 [28192528]
2008/05/01 18:09:44.045: [00003756][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/05/01 18:09:44.385: [00003756][Query] Query execution time: 286.03858870 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/05/01 18:09:45.737: [00003876][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc
2008/05/01 18:09:47.460: [00002088][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/05/01 18:09:47.510: [00002088][Query] Query execution time: 5.72782295 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/05/01 18:09:47.540: [00003876][Query] Query execution time: 1741.68392910 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc
2008/05/01 18:09:47.630: [00001020][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc
2008/05/01 18:09:47.860: [00001020][Query] Query execution time: 203.49346076 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc
2008/05/01 18:09:47.910: [00002884][QueryReportCtrl] Query load time: 40 ms
2008/05/01 18:09:49.342: [00001592][QueryReportCtrl] Query load time: 1312 ms
2008/05/01 18:11:14.405: [- Main -][AutoImporter] Starting auto-import. Ply: PokerTracker 3 Beta Database 1, Obs: PokerTracker 3 Beta Database 1
2008/05/01 18:11:14.445: [- Main -][ImportAuto] Adding message: PokerStars: Starting auto-import.
2008/05/01 18:11:14.505: [- Main -][AutoImporter] Starting auto-import. Ply: PokerTracker 3 Beta Database 1, Obs: PokerTracker 3 Beta Database 1
2008/05/01 18:11:14.555: [- Main -][ImportAuto] Adding message: PartyGaming: Starting auto-import.
2008/05/01 18:11:14.585: [00000492][ImportAuto] Adding message: PokerStars: Found 0 files to monitor.
2008/05/01 18:11:14.645: [00002416][WindowManager] Entering thread
2008/05/01 18:11:14.755: [00000492][ImportAuto] Adding message: PartyGaming: Found 0 files to monitor.
2008/05/01 18:11:14.966: [- Main -][StatManager] Stats and reports loaded.
2008/05/01 18:11:15.016: [- Main -][LayoutManager] Loading layouts...
2008/05/01 18:11:15.056: [- Main -][LayoutManager] Layouts loaded.
2008/05/01 18:11:15.366: [- Main -][StatManager] Stats and reports loaded.
2008/05/01 18:21:03.051: [00000492][ImportAuto] Adding message: PokerStars: Loading hand history file: C:\Programmer\PokerStars\HandHistory\Handstand2\HH20080501 T86784253 No Limit Hold'em $0,10 + $0.txt
2008/05/01 18:21:03.101: [00000492][HandHistoryDatabaseImport::DatabaseVariables] Getting connections
2008/05/01 18:21:03.822: [00003492][HandHistoryDatabaseImport::DatabaseVariables::Entry] Beginning thread.
2008/05/01 18:21:05.284: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124614139)
2008/05/01 18:21:36.039: [00003372][TableManager] Could not locate window for table: '86784253 26'
2008/05/01 18:21:37.781: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124636938)
2008/05/01 18:22:08.145: [00003372][TableManager] Could not locate window for table: '86784253 26'
2008/05/01 18:22:29.996: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124646385)
2008/05/01 18:22:56.074: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124662277)
2008/05/01 18:23:01.071: [00003372][TableManager] Could not locate window for table: '86784253 26'
2008/05/01 18:23:19.027: [00003036][Query] Executing SQL: SELECT id_note, date_note, notes FROM notes WHERE id_x = 105 AND enum_type = 'P' ORDER BY date_note asc
2008/05/01 18:23:19.067: [00001952][Query] Executing SQL: SELECT id_player, player_name, id_site FROM player WHERE id_player_alias = 105 ORDER BY player_name_search ASC;
2008/05/01 18:23:19.147: [00001564][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/05/01 18:23:19.237: [00001952][Query] Query execution time: 12.48845873 ms : SELECT id_player, player_name, id_site FROM player WHERE id_player_alias = 105 ORDER BY player_name_search ASC;
2008/05/01 18:23:19.317: [00003036][Query] Query execution time: 128.01934324 ms : SELECT id_note, date_note, notes FROM notes WHERE id_x = 105 AND enum_type = 'P' ORDER BY date_note asc
2008/05/01 18:23:19.357: [00001564][PostgresConnection] Successfully connected to: PT3 Beta DB1 [28634704]
2008/05/01 18:23:19.407: [00001564][Query] Executing SQL: SELECT (holdem_table_session_summary.id_limit), (sum(holdem_table_session_summary.cnt_hands)), (sum(holdem_table_session_summary.cnt_hands_won)), (count(holdem_table_session_summary.id_session)), (sum((case when( holdem_table_session_summary.amt_won > 0) then 1 else 0 end))), (holdem_table_session_summary.id_player), (sum( holdem_table_session_summary.amt_won )), (sum(holdem_table_session_summary.amt_won * 1.0 / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult))), (sum( holdem_table_session_summary.amt_rake )), (sum( holdem_table_session_summary.amt_mgr )) FROM holdem_table_session_summary, holdem_limit WHERE (holdem_limit.id_limit = holdem_table_session_summary.id_limit) AND (holdem_table_session_summary.id_player = 105) GROUP BY (holdem_table_session_summary.id_limit), (holdem_table_session_summary.id_player)
2008/05/01 18:23:19.457: [00003796][ConnectionManager] Waiting for connection. (id: 41 Holdem Cash Player Statistics/General-Player-Statistics)
2008/05/01 18:23:19.507: [00001604][QueryReportCtrl] Query load time: 0 ms
2008/05/01 18:23:19.588: [00003052][QueryReportCtrl] Query load time: 0 ms
2008/05/01 18:23:19.628: [00003796][ConnectionManager] Connection obtained. (id: 41 Holdem Cash Player Statistics/General-Player-Statistics)
2008/05/01 18:23:19.678: [00001564][Query] Query execution time: 145.82551693 ms : SELECT (holdem_table_session_summary.id_limit), (sum(holdem_table_session_summary.cnt_hands)), (sum(holdem_table_session_summary.cnt_hands_won)), (count(holdem_table_session_summary.id_session)), (sum((case when( holdem_table_session_summary.amt_won > 0) then 1 else 0 end))), (holdem_table_session_summary.id_player), (sum( holdem_table_session_summary.amt_won )), (sum(holdem_table_session_summary.amt_won * 1.0 / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult))), (sum( holdem_table_session_summary.amt_rake )), (sum( holdem_table_session_summary.amt_mgr )) FROM holdem_table_session_summary, holdem_limit WHERE (holdem_limit.id_limit = holdem_table_session_summary.id_limit) AND (holdem_table_session_summary.id_player = 105) GROUP BY (holdem_table_session_summary.id_limit), (holdem_table_session_summary.id_player)
2008/05/01 18:23:19.718: [00003796][Query] Executing SQL: SELECT (holdem_hand_player_statistics.id_limit), (count(holdem_hand_player_statistics.id_hand)), (sum(holdem_hand_player_statistics.amt_won)), (sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_f_raise)), (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_t_raise)), (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_r_raise)), (sum(holdem_hand_player_statistics.cnt_f_call)), (sum(holdem_hand_player_statistics.cnt_t_call)), (sum(holdem_hand_player_statistics.cnt_r_call)), (sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_bb_steal_fold) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_sb_steal_fold) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) FROM holdem_hand_player_statistics WHERE (holdem_hand_player_statistics.id_player = 105) GROUP BY (holdem_hand_player_statistics.id_limit)
2008/05/01 18:23:19.858: [00003912][Query] Executing SQL: SELECT date_start, date_end FROM holdem_table_session_summary WHERE id_player = 105 AND id_limit = 3 ORDER BY date_end DESC;
2008/05/01 18:23:19.988: [00003912][Query] Executing SQL: SELECT date_start, date_end FROM holdem_table_session_summary WHERE id_player = 105 ORDER BY date_end DESC;
2008/05/01 18:23:20.098: [00003912][QueryReportCtrl] Query load time: 261 ms
2008/05/01 18:23:20.178: [00003796][Query] Query execution time: 400.74003819 ms : SELECT (holdem_hand_player_statistics.id_limit), (count(holdem_hand_player_statistics.id_hand)), (sum(holdem_hand_player_statistics.amt_won)), (sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_showdown AND holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_f_raise)), (sum((case when(holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_t_raise)), (sum((case when(holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))), (sum(holdem_hand_player_statistics.cnt_r_raise)), (sum(holdem_hand_player_statistics.cnt_f_call)), (sum(holdem_hand_player_statistics.cnt_t_call)), (sum(holdem_hand_player_statistics.cnt_r_call)), (sum((case when(holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_bb_steal_fold) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))), (sum((case when(holdem_hand_player_statistics.flg_sb_steal_fold) then 1 else 0 end))), (sum( (case when(holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) FROM holdem_hand_player_statistics WHERE (holdem_hand_player_statistics.id_player = 105) GROUP BY (holdem_hand_player_statistics.id_limit)
2008/05/01 18:23:20.429: [00001488][QueryReportCtrl] Query load time: 30 ms
2008/05/01 18:23:20.659: [00000988][Query] Executing SQL: SELECT id_note, date_note, notes FROM notes WHERE id_x = 105 AND enum_type = 'P' ORDER BY date_note asc
2008/05/01 18:23:20.689: [00001536][Query] Executing SQL: SELECT id_player, player_name, id_site FROM player WHERE id_player_alias = 105 ORDER BY player_name_search ASC;
2008/05/01 18:23:20.739: [00003280][Query] Executing SQL: SELECT (tourney_holdem_summary.amt_buyin), (tourney_holdem_summary.id_table_type), (tourney_holdem_summary.id_tourney_type), (count(tourney_holdem_summary.id_tourney)), (sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)), (sum(tourney_holdem_results.amt_won)), (((sum((case when(tourney_holdem_results.amt_won > 0) then 1 else 0 end))) * 1.0 / (count(tourney_holdem_summary.id_tourney))) * 100), (sum((case when(tourney_holdem_results.amt_won > 0) then 1 else 0 end))), (sum(tourney_holdem_summary.cnt_players)), (avg(tourney_holdem_results.val_finish)), (sum((case when(tourney_holdem_results.val_finish=1) then 1 else 0 end))), (sum((case when(tourney_holdem_results.val_finish=2) then 1 else 0 end))), (sum((case when(tourney_holdem_results.val_finish=3) then 1 else 0 end))) FROM tourney_holdem_summary, tourney_holdem_results WHERE (tourney_holdem_results.id_tourney = tourney_holdem_summary.id_tourney) AND (tourney_holdem_results.id_player = 105) GROUP BY (tourney_holdem_summary.amt_buyin), (tourney_holdem_summary.id_table_type), (tourney_holdem_summary.id_tourney_type)
2008/05/01 18:23:20.779: [00000988][Query] Query execution time: 1.58400020 ms : SELECT id_note, date_note, notes FROM notes WHERE id_x = 105 AND enum_type = 'P' ORDER BY date_note asc
2008/05/01 18:23:20.829: [00002952][ConnectionManager] Waiting for connection. (id: 41 Holdem Tournament Player Statistics/Player-Statistics-Main)
2008/05/01 18:23:20.879: [00001536][Query] Query execution time: 5.93818488 ms : SELECT id_player, player_name, id_site FROM player WHERE id_player_alias = 105 ORDER BY player_name_search ASC;
2008/05/01 18:23:20.919: [00002096][QueryReportCtrl] Query load time: 0 ms
2008/05/01 18:23:20.959: [00003280][Query] Query execution time: 100.74576517 ms : SELECT (tourney_holdem_summary.amt_buyin), (tourney_holdem_summary.id_table_type), (tourney_holdem_summary.id_tourney_type), (count(tourney_holdem_summary.id_tourney)), (sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)), (sum(tourney_holdem_results.amt_won)), (((sum((case when(tourney_holdem_results.amt_won > 0) then 1 else 0 end))) * 1.0 / (count(tourney_holdem_summary.id_tourney))) * 100), (sum((case when(tourney_holdem_results.amt_won > 0) then 1 else 0 end))), (sum(tourney_holdem_summary.cnt_players)), (avg(tourney_holdem_results.val_finish)), (sum((case when(tourney_holdem_results.val_finish=1) then 1 else 0 end))), (sum((case when(tourney_holdem_results.val_finish=2) then 1 else 0 end))), (sum((case when(tourney_holdem_results.val_finish=3) then 1 else 0 end))) FROM tourney_holdem_summary, tourney_holdem_results WHERE (tourney_holdem_results.id_tourney = tourney_holdem_summary.id_tourney) AND (tourney_holdem_results.id_player = 105) GROUP BY (tourney_holdem_summary.amt_buyin), (tourney_holdem_summary.id_table_type), (tourney_holdem_summary.id_tourney_type)
2008/05/01 18:23:21.000: [00002952][ConnectionManager] Connection obtained. (id: 41 Holdem Tournament Player Statistics/Player-Statistics-Main)
2008/05/01 18:23:21.040: [00002952][Query] Executing SQL: SELECT (tourney_holdem_hand_player_statistics.id_blinds), (count(tourney_holdem_hand_player_statistics.id_hand)), (sum(tourney_holdem_hand_player_statistics.amt_won)), (sum((case when(tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_f_raise)), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_t_raise)), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_r_raise)), (sum(tourney_holdem_hand_player_statistics.cnt_f_call)), (sum(tourney_holdem_hand_player_statistics.cnt_t_call)), (sum(tourney_holdem_hand_player_statistics.cnt_r_call)), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_bb_steal_fold) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_sb_steal_fold) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) FROM tourney_holdem_hand_player_statistics WHERE (tourney_holdem_hand_player_statistics.id_player = 105) GROUP BY (tourney_holdem_hand_player_statistics.id_blinds)
2008/05/01 18:23:21.090: [00003692][QueryReportCtrl] Query load time: 0 ms
2008/05/01 18:23:21.150: [00002756][QueryReportCtrl] Query load time: 20 ms
2008/05/01 18:23:21.250: [00002952][Query] Query execution time: 157.77424226 ms : SELECT (tourney_holdem_hand_player_statistics.id_blinds), (count(tourney_holdem_hand_player_statistics.id_hand)), (sum(tourney_holdem_hand_player_statistics.amt_won)), (sum((case when(tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_bet) then 1 else 0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_f_raise)), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_bet) then 1 else 0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_t_raise)), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_bet) then 1 else 0 end))), (sum(tourney_holdem_hand_player_statistics.cnt_r_raise)), (sum(tourney_holdem_hand_player_statistics.cnt_f_call)), (sum(tourney_holdem_hand_player_statistics.cnt_t_call)), (sum(tourney_holdem_hand_player_statistics.cnt_r_call)), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_fold) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_fold) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_fold) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_p_3bet_action='F') then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_f_3bet_action='F') then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_t_3bet_action='F') then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.enum_r_3bet_action='F') then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_3bet_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_3bet_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_t_3bet_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_r_3bet_def_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_att) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_steal_opp) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_bb_steal_fold) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_b) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_sb_steal_fold) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_def_opp AND tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))) FROM tourney_holdem_hand_player_statistics WHERE (tourney_holdem_hand_player_statistics.id_player = 105) GROUP BY (tourney_holdem_hand_player_statistics.id_blinds)
2008/05/01 18:23:21.630: [00004052][QueryReportCtrl] Query load time: 150 ms
2008/05/01 18:23:33.618: [00003368][Query] Executing SQL: SELECT (tourney_holdem_hand_player_statistics.id_holecard), (count(tourney_holdem_hand_player_statistics.id_hand)), (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum(tourney_holdem_hand_player_statistics.amt_won)), (sum(tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_first_raise) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_p_limp = false AND tourney_holdem_hand_player_statistics.flg_p_ccall = false) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) FROM tourney_holdem_hand_player_statistics, tourney_holdem_blinds WHERE (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND ((tourney_holdem_hand_player_statistics.id_holecard) > 0) GROUP BY (tourney_holdem_hand_player_statistics.id_holecard)
2008/05/01 18:23:33.868: [00003368][Query] Query execution time: 223.71027603 ms : SELECT (tourney_holdem_hand_player_statistics.id_holecard), (count(tourney_holdem_hand_player_statistics.id_hand)), (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))), (sum(tourney_holdem_hand_player_statistics.amt_won)), (sum(tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb *tourney_holdem_blinds.val_nlpl_mult))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_p_ccall) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_won_hand AND tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_f_saw) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.cnt_p_raise > 0) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_first_raise) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.flg_p_limp) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_p_open = false AND tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_statistics.flg_p_limp = false AND tourney_holdem_hand_player_statistics.flg_p_ccall = false) then 1 else 0 end))), (sum((case when(tourney_holdem_hand_player_statistics.flg_showdown) then 1 else 0 end))), (sum( (case when(tourney_holdem_hand_player_statistics.flg_showdown AND tourney_holdem_hand_player_statistics.flg_won_hand) then 1 else 0 end))) FROM tourney_holdem_hand_player_statistics, tourney_holdem_blinds WHERE (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND ((tourney_holdem_hand_player_statistics.id_holecard) > 0) GROUP BY (tourney_holdem_hand_player_statistics.id_holecard)
2008/05/01 18:23:34.148: [00002088][QueryReportCtrl] Query load time: 150 ms
2008/05/01 18:23:34.349: [00003876][Query] Executing SQL: SELECT (tourney_holdem_hand_summary.id_hand), (tourney_holdem_hand_summary.id_site), (tourney_holdem_hand_summary.hand_no), (tourney_holdem_hand_summary.flg_note), (tourney_holdem_hand_player_statistics.id_holecard), (tourney_holdem_hand_summary.id_blinds), (tourney_holdem_hand_summary.date_played), (tourney_holdem_hand_player_statistics.flg_blind_s), (tourney_holdem_hand_player_statistics.flg_blind_b), (tourney_holdem_hand_player_statistics.flg_p_ccall), (tourney_holdem_hand_player_statistics.amt_won), (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)), (tourney_holdem_hand_player_detail.holecard_1), (tourney_holdem_hand_player_detail.holecard_2), (tourney_holdem_hand_player_statistics.flg_f_saw), (tourney_holdem_hand_summary.card_1), (tourney_holdem_hand_summary.card_2), (tourney_holdem_hand_summary.card_3), (tourney_holdem_hand_summary.card_4), (tourney_holdem_hand_summary.card_5), (tourney_holdem_hand_player_statistics.id_final_hand), (tourney_holdem_hand_player_statistics.flg_showed), (tourney_holdem_hand_player_statistics.enum_folded), (player_winner.player_name), (tourney_holdem_hand_summary.id_win_hand) FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_blinds, tourney_holdem_hand_player_detail, player player_winner WHERE (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND ((tourney_holdem_hand_player_statistics.id_holecard) = 1)
2008/05/01 18:23:35.210: [00003876][Query] Query execution time: 817.24884029 ms : SELECT (tourney_holdem_hand_summary.id_hand), (tourney_holdem_hand_summary.id_site), (tourney_holdem_hand_summary.hand_no), (tourney_holdem_hand_summary.flg_note), (tourney_holdem_hand_player_statistics.id_holecard), (tourney_holdem_hand_summary.id_blinds), (tourney_holdem_hand_summary.date_played), (tourney_holdem_hand_player_statistics.flg_blind_s), (tourney_holdem_hand_player_statistics.flg_blind_b), (tourney_holdem_hand_player_statistics.flg_p_ccall), (tourney_holdem_hand_player_statistics.amt_won), (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)), (tourney_holdem_hand_player_detail.holecard_1), (tourney_holdem_hand_player_detail.holecard_2), (tourney_holdem_hand_player_statistics.flg_f_saw), (tourney_holdem_hand_summary.card_1), (tourney_holdem_hand_summary.card_2), (tourney_holdem_hand_summary.card_3), (tourney_holdem_hand_summary.card_4), (tourney_holdem_hand_summary.card_5), (tourney_holdem_hand_player_statistics.id_final_hand), (tourney_holdem_hand_player_statistics.flg_showed), (tourney_holdem_hand_player_statistics.enum_folded), (player_winner.player_name), (tourney_holdem_hand_summary.id_win_hand) FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_blinds, tourney_holdem_hand_player_detail, player player_winner WHERE (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND ((tourney_holdem_hand_player_statistics.id_holecard) = 1)
2008/05/01 18:23:35.530: [00003988][QueryReportCtrl] Query load time: 180 ms
2008/05/01 18:24:05.834: [00002680][Query] Executing SQL: SELECT (tourney_holdem_summary.id_tourney), (tourney_holdem_summary.flg_note), (tourney_holdem_summary.date_start), (tourney_holdem_summary.date_end), (tourney_holdem_summary.id_site), (tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon), (tourney_holdem_results.val_finish), (tourney_holdem_results.amt_won) FROM tourney_holdem_summary, tourney_holdem_results WHERE (tourney_holdem_results.id_tourney = tourney_holdem_summary.id_tourney) AND (tourney_holdem_results.id_player = 105)
2008/05/01 18:24:05.884: [00002680][Query] Query execution time: 19.43598977 ms : SELECT (tourney_holdem_summary.id_tourney), (tourney_holdem_summary.flg_note), (tourney_holdem_summary.date_start), (tourney_holdem_summary.date_end), (tourney_holdem_summary.id_site), (tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon), (tourney_holdem_results.val_finish), (tourney_holdem_results.amt_won) FROM tourney_holdem_summary, tourney_holdem_results WHERE (tourney_holdem_results.id_tourney = tourney_holdem_summary.id_tourney) AND (tourney_holdem_results.id_player = 105)
2008/05/01 18:24:06.325: [00003792][QueryReportCtrl] Query load time: 290 ms
2008/05/01 18:24:06.515: [00004068][Query] Executing SQL: SELECT (tourney_holdem_hand_summary.id_hand), (tourney_holdem_hand_summary.id_site), (tourney_holdem_hand_summary.hand_no), (tourney_holdem_hand_summary.flg_note), (tourney_holdem_hand_player_statistics.id_holecard), (tourney_holdem_hand_summary.date_played), (tourney_holdem_hand_player_statistics.flg_blind_s), (tourney_holdem_hand_player_statistics.flg_blind_b), (tourney_holdem_hand_player_statistics.flg_p_ccall), (tourney_holdem_hand_player_statistics.amt_won), (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)), (tourney_holdem_hand_player_detail.holecard_1), (tourney_holdem_hand_player_detail.holecard_2), (tourney_holdem_hand_player_statistics.flg_f_saw), (tourney_holdem_hand_summary.card_1), (tourney_holdem_hand_summary.card_2), (tourney_holdem_hand_summary.card_3), (tourney_holdem_hand_summary.card_4), (tourney_holdem_hand_summary.card_5), (tourney_holdem_hand_player_statistics.id_final_hand), (tourney_holdem_hand_player_statistics.flg_showed), (tourney_holdem_hand_player_statistics.enum_folded), (player_winner.player_name), (tourney_holdem_hand_summary.id_win_hand), (tourney_holdem_hand_summary.id_tourney) FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_blinds, tourney_holdem_hand_player_detail, player player_winner WHERE (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND (tourney_holdem_hand_summary.id_tourney) in (293)
2008/05/01 18:24:06.575: [00004068][Query] Query execution time: 16.24759571 ms : SELECT (tourney_holdem_hand_summary.id_hand), (tourney_holdem_hand_summary.id_site), (tourney_holdem_hand_summary.hand_no), (tourney_holdem_hand_summary.flg_note), (tourney_holdem_hand_player_statistics.id_holecard), (tourney_holdem_hand_summary.date_played), (tourney_holdem_hand_player_statistics.flg_blind_s), (tourney_holdem_hand_player_statistics.flg_blind_b), (tourney_holdem_hand_player_statistics.flg_p_ccall), (tourney_holdem_hand_player_statistics.amt_won), (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)), (tourney_holdem_hand_player_detail.holecard_1), (tourney_holdem_hand_player_detail.holecard_2), (tourney_holdem_hand_player_statistics.flg_f_saw), (tourney_holdem_hand_summary.card_1), (tourney_holdem_hand_summary.card_2), (tourney_holdem_hand_summary.card_3), (tourney_holdem_hand_summary.card_4), (tourney_holdem_hand_summary.card_5), (tourney_holdem_hand_player_statistics.id_final_hand), (tourney_holdem_hand_player_statistics.flg_showed), (tourney_holdem_hand_player_statistics.enum_folded), (player_winner.player_name), (tourney_holdem_hand_summary.id_win_hand), (tourney_holdem_hand_summary.id_tourney) FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_blinds, tourney_holdem_hand_player_detail, player player_winner WHERE (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND (tourney_holdem_hand_summary.id_tourney) in (293)
2008/05/01 18:24:06.725: [00003816][QueryReportCtrl] Query load time: 10 ms
2008/05/01 18:24:12.504: [00003820][Query] Executing SQL: SELECT (tourney_holdem_hand_summary.id_hand), (tourney_holdem_hand_summary.id_site), (tourney_holdem_hand_summary.hand_no), (tourney_holdem_hand_summary.flg_note), (tourney_holdem_hand_player_statistics.id_holecard), (tourney_holdem_hand_summary.date_played), (tourney_holdem_hand_player_statistics.flg_blind_s), (tourney_holdem_hand_player_statistics.flg_blind_b), (tourney_holdem_hand_player_statistics.flg_p_ccall), (tourney_holdem_hand_player_statistics.amt_won), (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)), (tourney_holdem_hand_player_detail.holecard_1), (tourney_holdem_hand_player_detail.holecard_2), (tourney_holdem_hand_player_statistics.flg_f_saw), (tourney_holdem_hand_summary.card_1), (tourney_holdem_hand_summary.card_2), (tourney_holdem_hand_summary.card_3), (tourney_holdem_hand_summary.card_4), (tourney_holdem_hand_summary.card_5), (tourney_holdem_hand_player_statistics.id_final_hand), (tourney_holdem_hand_player_statistics.flg_showed), (tourney_holdem_hand_player_statistics.enum_folded), (player_winner.player_name), (tourney_holdem_hand_summary.id_win_hand), (tourney_holdem_hand_summary.id_tourney) FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_blinds, tourney_holdem_hand_player_detail, player player_winner WHERE (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND (tourney_holdem_hand_summary.id_tourney) in (292)
2008/05/01 18:24:12.654: [00003820][Query] Query execution time: 100.29878099 ms : SELECT (tourney_holdem_hand_summary.id_hand), (tourney_holdem_hand_summary.id_site), (tourney_holdem_hand_summary.hand_no), (tourney_holdem_hand_summary.flg_note), (tourney_holdem_hand_player_statistics.id_holecard), (tourney_holdem_hand_summary.date_played), (tourney_holdem_hand_player_statistics.flg_blind_s), (tourney_holdem_hand_player_statistics.flg_blind_b), (tourney_holdem_hand_player_statistics.flg_p_ccall), (tourney_holdem_hand_player_statistics.amt_won), (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)), (tourney_holdem_hand_player_detail.holecard_1), (tourney_holdem_hand_player_detail.holecard_2), (tourney_holdem_hand_player_statistics.flg_f_saw), (tourney_holdem_hand_summary.card_1), (tourney_holdem_hand_summary.card_2), (tourney_holdem_hand_summary.card_3), (tourney_holdem_hand_summary.card_4), (tourney_holdem_hand_summary.card_5), (tourney_holdem_hand_player_statistics.id_final_hand), (tourney_holdem_hand_player_statistics.flg_showed), (tourney_holdem_hand_player_statistics.enum_folded), (player_winner.player_name), (tourney_holdem_hand_summary.id_win_hand), (tourney_holdem_hand_summary.id_tourney) FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_blinds, tourney_holdem_hand_player_detail, player player_winner WHERE (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND (tourney_holdem_hand_summary.id_tourney) in (292)
2008/05/01 18:24:12.884: [00003300][QueryReportCtrl] Query load time: 181 ms
2008/05/01 18:24:13.405: [00003112][Query] Executing SQL: SELECT (tourney_holdem_hand_summary.id_hand), (tourney_holdem_hand_summary.id_site), (tourney_holdem_hand_summary.hand_no), (tourney_holdem_hand_summary.flg_note), (tourney_holdem_hand_player_statistics.id_holecard), (tourney_holdem_hand_summary.date_played), (tourney_holdem_hand_player_statistics.flg_blind_s), (tourney_holdem_hand_player_statistics.flg_blind_b), (tourney_holdem_hand_player_statistics.flg_p_ccall), (tourney_holdem_hand_player_statistics.amt_won), (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)), (tourney_holdem_hand_player_detail.holecard_1), (tourney_holdem_hand_player_detail.holecard_2), (tourney_holdem_hand_player_statistics.flg_f_saw), (tourney_holdem_hand_summary.card_1), (tourney_holdem_hand_summary.card_2), (tourney_holdem_hand_summary.card_3), (tourney_holdem_hand_summary.card_4), (tourney_holdem_hand_summary.card_5), (tourney_holdem_hand_player_statistics.id_final_hand), (tourney_holdem_hand_player_statistics.flg_showed), (tourney_holdem_hand_player_statistics.enum_folded), (player_winner.player_name), (tourney_holdem_hand_summary.id_win_hand), (tourney_holdem_hand_summary.id_tourney) FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_blinds, tourney_holdem_hand_player_detail, player player_winner WHERE (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND (tourney_holdem_hand_summary.id_tourney) in (293)
2008/05/01 18:24:13.495: [00003112][Query] Query execution time: 31.59535639 ms : SELECT (tourney_holdem_hand_summary.id_hand), (tourney_holdem_hand_summary.id_site), (tourney_holdem_hand_summary.hand_no), (tourney_holdem_hand_summary.flg_note), (tourney_holdem_hand_player_statistics.id_holecard), (tourney_holdem_hand_summary.date_played), (tourney_holdem_hand_player_statistics.flg_blind_s), (tourney_holdem_hand_player_statistics.flg_blind_b), (tourney_holdem_hand_player_statistics.flg_p_ccall), (tourney_holdem_hand_player_statistics.amt_won), (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)), (tourney_holdem_hand_player_detail.holecard_1), (tourney_holdem_hand_player_detail.holecard_2), (tourney_holdem_hand_player_statistics.flg_f_saw), (tourney_holdem_hand_summary.card_1), (tourney_holdem_hand_summary.card_2), (tourney_holdem_hand_summary.card_3), (tourney_holdem_hand_summary.card_4), (tourney_holdem_hand_summary.card_5), (tourney_holdem_hand_player_statistics.id_final_hand), (tourney_holdem_hand_player_statistics.flg_showed), (tourney_holdem_hand_player_statistics.enum_folded), (player_winner.player_name), (tourney_holdem_hand_summary.id_win_hand), (tourney_holdem_hand_summary.id_tourney) FROM tourney_holdem_hand_summary, tourney_holdem_hand_player_statistics, tourney_holdem_blinds, tourney_holdem_hand_player_detail, player player_winner WHERE (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_player_statistics.id_player = 105) AND (tourney_holdem_hand_summary.id_tourney) in (293)
2008/05/01 18:24:13.645: [00002404][QueryReportCtrl] Query load time: 40 ms
2008/05/01 18:24:20.725: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124670212)
2008/05/01 18:24:51.159: [00003372][TableManager] Could not locate window for table: '86784253 26'
2008/05/01 18:25:12.380: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124695538)
2008/05/01 18:25:43.124: [00003372][TableManager] Could not locate window for table: '86784253 26'
2008/05/01 18:26:25.745: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124713236)
2008/05/01 18:26:56.069: [00003372][TableManager] Could not locate window for table: '86784253 26'
2008/05/01 18:27:02.839: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124732300)
2008/05/01 18:27:33.162: [00003372][TableManager] Could not locate window for table: '86784253 26'
2008/05/01 18:27:49.776: [00000492][ImportAuto] Adding message: PokerStars: Hand Imported (#17124742867)
2008/05/01 18:28:00.091: [00003492][DatabaseVariables::Entry] 0 queries remain.
2008/05/01 18:28:00.131: [00003372][TableManager] Thread exiting.
2008/05/01 18:28:00.171: [00000492][ImportAuto] Adding message: PokerStars: Stopping auto-import.
2008/05/01 18:28:00.201: [00000492][ImportAuto] Adding message: PartyGaming: Stopping auto-import.
2008/05/01 18:28:00.251: [00000492][HandHistoryFeederText] Moving file 'C:\Programmer\PokerStars\HandHistory\Handstand2\HH20080501 T86784253 No Limit Hold'em $0,10 + $0.txt' to 'C:\Programmer\PokerTracker 3\Processed\HH20080501 T86784253 No Limit Hold'em $0,10 + $0.txt'
2008/05/01 18:28:00.301: [00002416][WindowManager] Thread exiting.
2008/05/01 18:28:00.792: [- Main -][App] Shutting down subsystems...
2008/05/01 18:28:00.842: [- Main -][PostgresConnection] Disconnecting from database: PT3 Beta DB1
2008/05/01 18:28:00.872: [- Main -][PostgresConnection] Disconnecting from database: PT3 Beta DB1
2008/05/01 18:28:00.912: [- Main -][PostgresConnection] Disconnecting from database: PT3 Beta DB1
2008/05/01 18:28:00.952: [- Main -][PostgresConnection] Disconnecting from database: PT3 Beta DB1
2008/05/01 18:28:01.002: [- Main -][PostgresConnection] Disconnecting from database: PT3 Beta DB1
2008/05/01 18:28:01.092: [- Main -][App] Flushing profiler info...
2008/05/01 18:28:01.192: [- Main -][System] Application exiting
