Your Edge

[beach_bum]

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 ]