gzp74 wrote:I would like to ask about what is the different between these? ....SIMILAR TO '8%' or ...... LIKE '8%'
You will get the same results using either of those expressions.
gzp74 wrote:Is the a list or link where I can find the description about all field of tourney_hand_player_statistics database table?
We have not published the schema like we did for PokerTracker 3 however you can find the files used to create the database in your PokerTracker4 installation folder:
C:\Program Files (x86)\PokerTracker 4\Data\Schemas
The meaning of database fields with the same names haven't changed in any significant way from PokerTracker 3 and you can find that
here. Also forum member 'Bininu' made their own document available in
this thread.
gzp74 wrote:another one, where : BvB, BB def.(not folding) against SB non-alin (max 33.33% of eff.stack) open raise.
All your stats look good however with this one
amt_p_raise_facing is the last raise faced and not necessarily the first. If you always want the size of the 2bet faced you should use
tourney_hand_player_statistics.amt_p_2bet_facing instead and since the BB has already invested 1BB you need to add that to the raise faced so it calculates correctly for the effective stack e.g.
- Code: Select all
sum(if[tourney_hand_player_statistics.position = 8 AND tourney_hand_summary.str_aggressors_p LIKE '89%' AND tourney_hand_summary.str_actors_p LIKE '9%' AND tourney_hand_player_statistics.amt_p_2bet_facing > 0 AND (((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_hand_player_statistics.amt_p_effective_stack) < 0.3333) AND NOT(lookup_actions_p.action='F'), 1, 0])