Re: Your Edge
Hi Dave,
I am running this query on a FullTilt PostgreSQL database and I am betting the following error:
row number -1 is out of range 0..-1
Total query runtime: 10 ms.
0 rows retrieved.
The only figures I have changed are my screen name and the limit. Can you tell me what the problem is?
Also, can you give me the correct notation for FTP games?
I am curious what I should be putting in the:
AND game_level.game_level_desc = 'NL $50'
line if I want to look at higher limits on Full Tilt or PokerStars. I am guessing that the notation is different on the different sites.
Thanks
[ QUOTE ]
------------------------- code ----------------
SELECT
screen_name, COUNT(game_players.game_id) AS HANDS,
SUM(total_bet) AS BET, SUM(total_won) AS WON,
((SUM(total_won)/SUM(total_bet))-1)*100 as EDGE,
SUM(total_won)-SUM(total_bet) as PROFIT
FROM players, game_players, game, game_level
WHERE players.player_id = game_players.player_id
AND game_players.game_id = game.game_id
AND game.game_level_id = game_level.game_level_id
AND game_level.game_level_desc = '<font color="red">NL $50</font>'
AND screen_name='<font color="blue">your_screenname_here</font>'
GROUP BY screen_name;
--------------------------------------------------
[/ QUOTE ]
|