Some interesting non-PokerTracker stats

[illunious]

My .5/1 Flop Actions: BB/hand, Count
(1=true, 0=false), VPIP 14 and Total AF (not including PF) 2.3.

I used the PT DB to get them while working on an unrelated project and thought they were VERY interesting stats.

Check out the dismal value of the "no bet/raise call" (this includes call, call/call, check/call and coldcalling a raise) .

fbet=1 AND fraise=1: 3.5 (BB/hand), 218 (hands)
fbet=0 AND fraise=1: 2.9, 670
fbet=1 AND fraise=0: 1.6, 3356
fraise=1 AND fcall=1: 1.1, 230
fbet=1 AND fcall=1: 0.7, 463
fbet=0 AND fraise=0 AND fcall=1: .096, 1215
fbet=0 AND fraise=0 AND ffold=1: -0.7, 5079
fcall=1 AND ffold=1: -1.6, 14
(fbet=1 OR fraise=1) AND ffold=1: -2.1, 99

Un-accounted-for (rare and +EV to call stats) bad data (I think): calling capped flops counts as calling.

Comments welcome, I will do a turn and river breakdown soon.

[illunious]

B-R-C-K-F
02-1-0-0-0-0
03-1-1-0-0-0
04-1-0-1-0-0
05-1-0-0-0-1
06-1-1-1-0-0
07-1-1-0-0-1
09-1-0-1-0-1
10-1-1-1-0-1
11-0-1-0-0-0
12-0-1-1-0-0
13-0-1-0-1-0
14-0-1-0-0-1
15-0-1-1-1-0
16-0-1-1-0-1
17-0-1-0-1-1
18-0-1-1-1-1
19-0-0-1-0-0
20-0-0-1-1-0
21-0-0-1-0-1
22-0-0-1-1-1
23-0-0-0-1-1
24-0-0-0-0-1


Here's the full breakdown.

r-11/$8.32/101 means 101 times I raised the river as my only action and net 8.32 BB per hand.
t-4/$0.44/248 means 248 times I bet and called the turn and net .44 BB per hand.

f-2/$1.95/2882
f-3/$4.33/133
f-4/$0.47/377
f-5/($1.90)/92
f-6/$2.34/85
f-7/0
f-9/($4.00)/1
f-10/0
f-11/$3.45/480
f-12/$0.77/136
f-13/$7.79/36
f-14/($6.08)/6
f-15/($3.39)/9
f-16/0
f-17/0
f-18/0
f-19/$0.29/733
f-20/($0.16)/469
f-21/($1.50)/12
f-22/($1.50)/1
f-23/($0.67)/2993
f-24/($0.74)/2073



t-2/$3.03/2455
t-3/$7.94/53
t-4/$0.44/248
t-5/($2.52)/106
t-6/$7.71/39
t-7/0
t-9/0
t-10/0
t-11/$6.13/149
t-12/$2.06/36
t-13/$5.86/32
t-14/($2.83)/3
t-15/($2.08)/3
t-16/0
t-17/0
t-18/0
t-19/$0.73/706
t-20/($0.01)/459
t-21/($3.36)/18
t-22/($3.50)/2
t-23/($0.94)/1030
t-24/($1.06)/945



r-2/$5.15/1537
r-3/$10.10/39
r-4/($0.45)/153
r-5/($3.46)/29
r-6/$6.12/65
r-7/0
r-9/0
r-10/0
r-11/$8.32/101
r-12/$0.90/28
r-13/$5.84/9
r-14/($9.25)/2
r-15/($7.50)/1
r-16/0
r-17/0
r-18/0
r-19/$0.00/564
r-20/($0.85)/392
r-21/($4.69)/13
r-22/0
r-23/($1.66)/512
r-24/($1.76)/486

[melange]

Do you have the SQL queries used for these or are they quite easy? It would be good to be able to compare your stats with ours to find some trends.

[illunious]

SELECT * FROM game_players WHERE player_id=#playerid#
AND #curturn#bet=0
AND #curturn#raise=0
AND #curturn#call=0
AND #curturn#check=0
AND #curturn#fold=0

Change 0 to 1 depending on what data you want and add up the total_won and total_bet fields.