How do you run in small pots? (Sexy SQL statement inside!)

[johnnycakes]

Hi guys.

I was looking over some PT data for leaks. I was looking at my big pots won and lost, but then I started wondering how I ran in small pots.

So, I wrote a SQL query to see what my PTBB/100 is in all pots where I win/lose (that's NET profit or loss) between -25 and 25 Big Blinds.
So, for 2/4 it's all hands where I lost up to 100 or won up to 100.

My results for this yr so far ~230K hands was disturbing to me, so I'll hold off on posting for now. But I'm not a good player.

If anyone doesn't mind, please run this SQL statement against your PT database.

This will look at all your PL/NL hands and return your PTBB/100 and the number of hands. This query will work in Access or postgreSQL.

Just plug in your main screen name in the query where it says SCREENNAME. Put in your main PT SN and it will also find all the hands played by your other aliases.

If anyone needs to know how to run it, just ask.

Hopefully this will be interesting.

SELECT (((sum((game_players.total_won-game_players.total_bet)/(game_level.game_level_big_bet*2)))/count(*))*100) as running,count(*) as total_hands
FROM game_level INNER JOIN (game INNER JOIN (players INNER JOIN game_players ON players.player_id = game_players.player_id) ON game.game_id = game_players.game_id) ON game_level.game_level_id = game.game_level_id
where players.screen_name='SCREENNAME'
and ((game_players.total_won-game_players.total_bet)/game_level.game_level_big_bet between -25 and 25)
and game_level.pl_nl=1;



*Don't worry; this can't hurt your data. It is a SELECT statement. All it can do is grab and display data. DELETE and UPDATE statements can change/delete your info.

[Pog0]

I'd expect to be down overall in small pots.

As good players, we're minimizing our losses and maximizing our wins. So we manage to keep the pots in which we are beat small and make the pots we win big.

[soah]

You should look at pot size instead of net profit or loss per hand. Many small pots are multiway. There are many hands where after the action is complete you will either lose 20bb or win 30bb once you see who has the winner. what you are doing will count those losses against you and ignore the ones that you win.

[johnnycakes]

I expect to be down too, but how much?

I think I could be losing too much in my small pots, and I'd like to see how loss rates vary among MSNL posters.

[johnnycakes]

[ QUOTE ]
There are many hands where after the action is complete you will either lose 20bb or win 30bb once you see who has the winner. what you are doing will count those losses against you and ignore the ones that you win.

[/ QUOTE ]

Not sure what you mean. The query looks at how much money you put in the pot and looks at how much money you made in the hand. So if you put money in the pot and lost that counts. If you put money in and won...that counts too.

[johnnycakes]

[ QUOTE ]
You should look at pot size instead of net profit or loss per hand.

[/ QUOTE ]

But anyway, is there other things I should look at for evidence of how I'm playing in small pots?

[tagtastic]

Where do I paste this statement to run it in PT?

[Big_Jim]

[ QUOTE ]
If anyone needs to know how to run it, just ask.

[/ QUOTE ]
Dude, like 90% of people are going to have to ask, why not just tell them?

[johnnycakes]

[ QUOTE ]
[ QUOTE ]
If anyone needs to know how to run it, just ask.

[/ QUOTE ]
Dude, like 90% of people are going to have to ask, why not just tell them?

[/ QUOTE ]

Sorry, didn't realize.

Here is how to run it in Access


In PostgreSQL, go Start -> Programs -> PostgreSQL 8.0 -> pgAdmin III.
The pgAdmin will launch.
Double click your server in the left hand column. Mine is called "PostgreSQL Database Server 8.0"

Now you'll see a list of your databases. Double click the one you want to run the query against.

Now click the SQL button in the toolbar. It's the one that looks like a pencil and says SQL.

Copy and paste the SQL query into the top part of the window.

Click the first green arrow in the toolbar. (Or select Query->Execute)

[soah]

[ QUOTE ]
[ QUOTE ]
There are many hands where after the action is complete you will either lose 20bb or win 30bb once you see who has the winner. what you are doing will count those losses against you and ignore the ones that you win.

[/ QUOTE ]

Not sure what you mean. The query looks at how much money you put in the pot and looks at how much money you made in the hand. So if you put money in the pot and lost that counts. If you put money in and won...that counts too.

[/ QUOTE ]

so? the money you put into the pot is not equal to how much money all 5 of your opponents collectively put in the pot