[wildzer0]

I was just messing around with my PT database this morning and came up with this query to generate a buddy list automatically. Here it is if anyone wants to use it - works on postgres. You can change the values in the HAVING clause - the first line is number of hands, then, VP%IP, then WTSD

[ QUOTE ]

select players.screen_name as screenName
FROM (game INNER JOIN game_players ON game.game_id = game_players.game_id
INNER JOIN players ON game_players.real_player_id = players.player_id)
GROUP BY players.screen_name
HAVING (COUNT(game_players.game_id) > 100)
AND (AVG(game_players.vol_put_money_in_pot) > .5)
and (SUM (game_players.went_to_showdown_n) * 100 / SUM (game_players.saw_flop_n) > 33)
ORDER BY (AVG(game_players.vol_put_money_in_pot));



[/ QUOTE ]