#1
|
|||
|
|||
pokertracker question
inspired by pokerbobs 12 bet fold to 13 bet posts etc. [img]/images/graemlins/smile.gif[/img]
Is there anyway to serch for hands where I 3-bet and then folded to a cap? Or I guess even hands where I 3bet, and then i can look for the cap fold myself. any ideas? |
#2
|
|||
|
|||
Re: pokertracker question
Do you know how to run SQL queries against your database? Here's what I came up with.
SELECT game_number FROM game_players AS gp INNER JOIN game AS g ON gp.game_id = g.game_id WHERE gp.player_id = (select player_id from players where screen_name = '<font color="red">Me</font>') AND blind_amt=<font color="orange">3</font> AND (gp.<font color="blue">turn</font>_bet = <font color="green">18</font> AND gp.<font color="blue">t</font>call = 0 AND gp.<font color="blue">t</font>fold > 0) Replace <font color="red">Me</font> with your screenname. Replace <font color="orange">3</font> with the size of a small bet in the limit you're looking for. Replace <font color="green">18</font> with the real-money raise size you're looking for. Replace <font color="blue">turn</font> with river or flop and <font color="blue">t</font> with r or f as you like. |
#3
|
|||
|
|||
Re: pokertracker question
i will do this, if you explain to me how, to run sql queries against my database.
|
#4
|
|||
|
|||
Re: pokertracker question
If yours is an Access database, open ptrack.mdb, select Queries, make a new one, switch from Design View to SQL View, and paste and execute my query.
If yours is a PostgreSQL database, run pgAdmin, double-click your database on the left pane, enter the admin password, click the HOLDEM database, find the SQL button up top, and paste and execute my query. Should work. |
|
|