Believe it or not - there's a field in the database for all-in and forced all in so I thought I was gold. Turns out it's not used
There's no way I can get the info out - it's not in there.
---------------
That's a post I started last night sometime. Since then I went back to see if there couldn't be some way to manage this.
So now for the bad news - the data isn't really in there the way I need to provide you exactly what you've asked for. I can't give you a neat and tidy answer on this one.
The good news is - I think I've come pretty close. What you can do is run a query that will return all games in which hero saw showdown, had pockets against pockets, and someone was all-in preflop (I just figured that part out now).
It returns 4 columns - game_id, who_won (player_id of winning player), villains hole cards, heros hole cards. With those columns it's pretty easy to tell whether someone sucked out or not, but yoiu have to do that on your own. I've organized it so the results list in order of who won so the winning hands for hero should all show up at the top (because hero's playerid is usually pretty low).
Of my 10000 hand sample (just one of my DB's) there are only 16 hands that qualify. Of those I won with suckouts:
99 v AA
QQ v KK
and lost to suckouts:
AA v QQ x2
The following hands held up for me:
AA v QQ x2
QQ v JJ x2
and I lost the following hands as I should have:
TT v AA x2
77 v AA
JJ v QQ
99 v TT
77 v QQ
55 v AA
KK v AA
well, that's depressing...
In order to run the query you will need your player_id, which you should know from the last exercise. And now the query:
everywhere it says player_id = 6 change it to your own player_id #.
Have fun.
