Theory question: check-raised on the river

[SlantNGo]

Hand from two minutes ago:

Party Poker 2/4 Hold'em (6 handed) Hand History Converter Tool from FlopTurnRiver.com (Format: 2+2 Forums)

Preflop: Hero is CO with T[img]/images/graemlins/diamond.gif[/img], K[img]/images/graemlins/heart.gif[/img].
<font color="#666666">1 fold</font>, MP calls, <font color="#CC3333">Hero raises</font>, SB calls, <font color="#666666">1 fold</font>, MP calls.

Flop: (7 SB) 6[img]/images/graemlins/diamond.gif[/img], 5[img]/images/graemlins/club.gif[/img], K[img]/images/graemlins/spade.gif[/img] <font color="#0000FF">(4 players)</font>
SB checks, <font color="#CC3333">MP bets</font>, <font color="#CC3333">Hero raises</font>, SB folds, <font color="#CC3333">MP 3-bets</font>, Hero calls.

Turn: (6.50 BB) 8[img]/images/graemlins/club.gif[/img] <font color="#0000FF">(3 players)</font>
MP checks, <font color="#CC3333">Hero bets</font>, MP calls.

River: (8.50 BB) 9[img]/images/graemlins/spade.gif[/img] <font color="#0000FF">(3 players)</font>
MP checks, <font color="#CC3333">Hero bets</font>, <font color="#CC3333">MP raises</font>, Hero calls.

Final Pot: 12.50 BB

Results in white below: <font color="#FFFFFF">
MP has Jd 5h (one pair, fives).
Hero has Td Kh (one pair, kings).
Button doesn't show.
Outcome: Hero wins 12.50 BB. </font>

[jba]

^^^^
musta had some read

[sethypooh21]

[ QUOTE ]
^^^^
musta had some read

[/ QUOTE ]

Or

[X] was playing on party poker...

[SlantNGo]

[ QUOTE ]
^^^^
musta had some read

[/ QUOTE ]

He tried similar stuff earlier in the session so yeah. Otherwise I either c/c or b/f the river.

[HoneyBadger]

*Bump* [img]/images/graemlins/smile.gif[/img]

Some of my data for one-pair only: (won / lost / percentage / BB won vs folding)
$3/6 (FR only) : 2 / 30 / 6.25% / -16
$2/4 (6max + FR, 50/50) : 17 / 81 / 17.3% / +86.5
$1/2 (6max) : 4 / 22 / 15.3% / +14

Only $2/4 is a decent sample of 111k hands, actually.

[yourface]

will you please post the query you used?

[HoneyBadger]

Credit to Guy McSucker, who just pm-ed me the query. I guess it's ok if I post it here.

Select
gp.hand_rank_id as HandType,
SUM(CASE WHEN gp.total_won&gt;0 THEN gp.total_won ELSE 0 END) as Won,
SUM(CASE WHEN gp.total_won&gt;0 THEN 1 ELSE 0 END) as TimesWon,
SUM(CASE WHEN gp.total_won=0 THEN -10 ELSE 0 END) as Lost,
SUM(CASE WHEN gp.total_won=0 THEN -1 ELSE 0 END) as TimesLost,
SUM(g.pot) as Pot,
count(*) as Times
FROM game AS g INNER JOIN game_players AS gp ON gp.game_id = g.game_id
WHERE
gp.player_id = (select pref_value from prefs where pref_key = 'RP')
AND gp.rbet = 1
AND gp.went_to_showdown_n = 1
AND gp.rcall = 1
AND gp.river_bet = 20
AND (g.game_level_id = 1 OR g.game_level_id = 1)
GROUP BY gp.hand_rank_id;

Change the bold parts for the correct limit, this was $5/10, so a BB for the loss, 2 BB for the river, and appropriate game_id, or two in case of 6max + FR.