plukhead wrote:AND tourney_hand_summary.str_actors_p = '0'
With this you are saying only the BTN VPIP'd and they made one action. If the BTN limped, SB folds, BB raises and BTN calls then the actors string would be '080'. See this post
for more information on how the actors and aggressors strings work.
plukhead wrote:AND lookup_actions_p.action = 'LC'
'L' isn't a valid action. The BTN actions preflop will be 'CC'.