![]() |
|
#2
|
||||
|
||||
![]()
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? |
#3
|
||||
|
||||
![]()
Stats are fun.
This is a tricky one though, especially with the broad definition (maybe this should be a new thread - but I guess there's not too much to discuss with this one). I think the number is pretty high... how about 42%? |
#4
|
||||
|
||||
![]()
I'm doing a decent amount of SQL at work right now and would love to help out with this but I don't have the time right now. So I appreciate it de-coder. And work also blocks this site
![]()
__________________
I need 'em for my footsies. |
#5
|
||||
|
||||
![]()
Keep in mind I'm not actually a sql guy - I'm just kindof flying by the seat of my pants and reading a lot of sql docs (I also asked a guy at work to point me in the right direction). If you have any suggestions as to how to do things better, or if you see any problems with it let me know.
There's more stuff in there too if we have any ideas for things we'd like to see (see above for 1 fun stat...). |
#7
|
||||
|
||||
![]()
Finally getting around to reading this after my Cali trip... thanks TP and de-coder, this is very interesting stuff.
And BL, you really, really need to learn how to deal with people w/o being a complete ass... trust me, it will help you later in life when you eventually crawl out from the bowels of your parent's basement. ![]()
__________________
GO GREEN!!! GO WHITE!!! |
#8
|
||||
|
||||
![]()
No other guesses on this?
TP guessed 42% - anyone else? |
#10
|
|||
|
|||
![]()
Good thread, thanks for the work.
I don't have any data, but I'm sure my 5% guess was strongly influenced by the way I was running at the time, and not truly representative of the general trend. Thanks to this thread, I've been experimenting a lot more with raising the donk bettor. On a drawy board, I'm starting to find more success - not with the initial fold, at $100NL anyway - but if the turn blanks and I fire again, I'm winning the pot consistently. |
#11
|
||||
|
||||
![]()
Exactly.
Nice to know that not everyone finds this thread useless. ![]() |
![]() |
Thread Tools | |
Display Modes | |
|
|