PDA

View Full Version : SQL question



devoured_elysium
05-07-2009, 10:12 PM
Hello. I'd like to know what is the query string for retrieving
vpip
pfr
ats
3bet
fold3bet
hand_sample

if possible. Thanks.

hulivili
05-12-2009, 12:42 PM
Good question, I am also trying to find the same.
Complete amount of hands in sample you get with this query:

SELECT cashhands FROM players
WHERE playername = 'player_you_are_interested'

For others I would be very interested too. It seems that they are somewhere, where player_id is not anymore the same. If you do a query you get the id of player what is used in other places of database. But it looks that there are also some other id_numbers assigned for any specific players.

SELECT player_id FROM players
WHERE playername = 'player_you_are_interested'