BillGatesIII wrote:There is a known bug in the PT4 Filter Expression parser which messes things up if there is a Group By in the subquery and some other filter is used, I guess therefore your report will not work.
And I finally got it why using val_finish doesn't work, my bad, sorry for that. It will of course return all hands of the tourneys you finished in the top 9 and not only the final table hands
The good thing is I got a SQL statement that will give you the final table hands of any tourney that starts with 1500 chips.
- Code: Select all
tourney_hand_player_statistics.id_hand in (
select id_hand
from (
select distinct
thps.id_tourney
,thps.id_hand
,sum(thps.amt_before) over (partition by thps.id_hand) = (ts.cnt_players * 1500) as ft
from tourney_hand_player_statistics as thps
join tourney_summary as ts on ts.id_tourney = thps.id_tourney) as mtt
where mtt.ft)
The irritating thing is that I created a much more beautiful piece of SQL that should work for any starting stack but the parser doesn't like it
Your SQL code works fine, that's exactly what I needed, I'm perfectly fine with the fixed value of starting stack. Thank you for your help and your time, I much appreciate it.
