dennisa
01-29-2009, 03:50 PM
Hello Holdem Manager Support,
I just wrote the following query in PGadmin for a custom report I am trying to create. I would like add the stat of attempted to steal, but did not see it in the tables. Would you help me derrive which fields I need to gather to render that stat. The SQL below is what I am using to start my custom report.
Thanks
select p.playername, cr.totalplayedhands, cr.compiledplayerresults_id, cr.playedonmonth, cm.totalhands, cm.vpiphands, cm.pfrhands,
g.gametypedescription
from players p, compiledresults_month cr, compiledplayerresults_month cm, gametypes g
where p.player_id = cr.player_id and cr.compiledplayerresults_id = cm.compiledplayerresults_id and cr.gametype_id = g.gametype_id and
cr.playedonmonth >= '200812' and p.cashhands > 500 and g.istourney = false
order by playername
I just wrote the following query in PGadmin for a custom report I am trying to create. I would like add the stat of attempted to steal, but did not see it in the tables. Would you help me derrive which fields I need to gather to render that stat. The SQL below is what I am using to start my custom report.
Thanks
select p.playername, cr.totalplayedhands, cr.compiledplayerresults_id, cr.playedonmonth, cm.totalhands, cm.vpiphands, cm.pfrhands,
g.gametypedescription
from players p, compiledresults_month cr, compiledplayerresults_month cm, gametypes g
where p.player_id = cr.player_id and cr.compiledplayerresults_id = cm.compiledplayerresults_id and cr.gametype_id = g.gametype_id and
cr.playedonmonth >= '200812' and p.cashhands > 500 and g.istourney = false
order by playername