to find the level you want try this
select * from game_level
that will give you all the levels you have in the DB and their game_level_id
then use
select x.game_id from game_players x join game_players y on x.game_id = y.game_id and y.fbet = 1 and y.praise != 1 and y.ffold = 1 join game z on x.game_id = z.game_id and z.game_level_id = game_level_id here where x.raised_first_pf = 1 and x.fraise = 1 and x.fcheck != 1 and x.real_player_id = player_id here
to those who actually appreciate my work - you're very welcome. This is such a fascinating topic. There's a lot of good stuff in there.
Here's a question:
how often is a limp - re-raise AA?
To be fair I'm not talking about pure limps, but people that call the current bet, get raised at some point behind them, and then re-reraise pre-flop.
Any guesses?
|