in torney-reports all rights
in cash-reports error:
The Error: ERROR: 42P01: missing FROM-clause entry for table "td"
Occurred when running GetDataTable with this query: select ph.pokerhand_id,ph.preflopplayeractiontype_id,ph.s treetwentallin,ph.handtimestamp,gt.gametypedescrip tion, gt.pokergame,ph.holecard1int,ph.holecard2int,ph.ho lecard3int,ph.holecard4int,pkh.flopcard1int,pkh.fl opcard2int,pkh.flopcard3int,pkh.turncardint,pkh.ri vercardint,ph.flopplayeractiontype_id,ph.turnplaye ractiontype_id,ph.riverplayeractiontype_id,ph.neta mountwon,gt.bigblind,ph.positiontype_id,ph.preflop action_id,ph.didpfr,ph.didvpip,ev.sklanskybucks,ev .equitypct from playerhandscashkeycolumns ph join pokerhands pkh on pkh.pokerhand_id = ph.pokerhand_id join gametypes gt on gt.gametype_id = ph.gametype_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 2) and td.buyin between 000 and 600 and td.tourneysize between 2 and 2 order by ph.handtimestamp desc limit 100




Reply With Quote
