cash_hand_player_statistics.position= 1 This position doesn't exist on a 6max table. UTG on a 6max table is seat number 3 - see this guide . cash_hand_summary.str_aggressors_p LIKE '80%' With this you are saying that the BTN was the first preflop raiser (2bettor) and not the 3bettor - see this post...
You need to go to 'Configure -> Themes -> Replayer', select the custom theme and then click the 'Make Active' button'. If you don't see it there then please attach your downloaded theme to a Support Ticket.
Please turn on 'Enable Logging' in PokerTracker 4 via 'Configure -> Options' and then restart PokerTracker 4. Next reproduce this issue by playing on a table for a few minutes and then attach your support bundle to a Support Ticket . The support bundle is created via the 'File -> Create Support Bund...
That is a subquery used for 'vs Hero' custom statistics . These types of query are used if you want information about a player different from the one the stat is written for however using these types of queries means that the database cache cannot be used . For more on how SELECT works see here and ...
Is there a chance to filter for multiple positions? e.g. We are PFA IP and play vs SB tourney_hand_player_statistics.position < 9 and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_f_has_position and tourney_hand_player_statistics.flg_f_saw and tourney_hand_...
WPN only began providing more detailed tournament information in 2020 so it's not unusual to see WPN tournaments with no buyins/prizes if they were played before they introduced the newer format of tournament files. You also opened a support ticket (#426076) in 2019 querying why these WPN results we...