[cjd]

For anyone wanting to query their own PT database, here's the query I used. It should grab hands that were all-in preflop (preFlopBet=totalBet AND we saw a river card AND we never folded)

Just change the last two lines in the where clause, from "120" and "200" to the range of BB you want to look at.

---------------
SELECT
hole_cards,
game_level.game_level_big_bet,
SUM(total_won-total_bet) AS Net,
COUNT(*) AS Times,
SUM(IIf(total_won>0,1,0)) AS TimesWon,
ROUND(100*SUM(IIf(total_won>0,1,0))/COUNT(*)+0.000001,1) AS PercentWon,
ROUND(AVG((total_won-total_bet)/game_level.game_level_big_bet)+0.000001,2) AS BBPerHand
FROM
game,
game_players,
game_level
WHERE
game.game_id=game_players.game_id
And game.game_level_id=game_level.game_level_id
And pre_flop_bet=total_bet
And hole_cards<>""
And game.river<>""
And isnull(game_players.when_folded)
And (game_level.game_level_big_bet between 0.49 and 0.51)
And hole_cards in("AA","KK","QQ","JJ","TT","AKo","AQo","AKs","AQs ")
And pre_flop_bet>=game_level.game_level_big_bet*120
And pre_flop_bet<game_level.game_level_big_bet*200
GROUP BY
hole_cards,
game_level.game_level_big_bet
ORDER BY
game_level.game_level_big_bet DESC,
COUNT(*) DESC
;
---------------