MTT Starting Stack

[bleedingthrough]

I'm trying to create a starting stack value to use. I've grabbed the below from other posts, but I'm getting an error for the ignition data. When report is filtered to only include data from WPN it works great. When allowing Ignition data from ignition card catcher or ignition hand converter I get the error at the bottom. What should I change to correct this error?

select distinct first_value(thps.amt_before) over (partition by thps.id_tourney order by thps.date_played)
from tourney_hand_player_statistics as thps
inner join tourney_summary as ts on ts.id_tourney = thps.id_tourney
where thps.flg_hero
and ts.tourney_no = tourney_summary.tourney_no

"Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: more than one row returned by a subquery used as an expression)

[Flag_Hippo]

We do not officially support hands from those sources you mentioned but it looks like that's caused by bad data e.g. having multiple tournaments that are merged to a single tournament.