Starting blind for tournament

[Samirino]

Hello,

I want a formula stat to figure out starting blind for tournament, can anyone help me please thanks?

[Samirino]

I have thought about a query like this for starting blind:

Code: Select all

select distinct first_value(tnb.amt_bb) over (order by thps.date_played)
            from tourney_hand_player_statistics as thps, tourney_summary as tns, tourney_blinds as tnb
            where thps.flg_hero
            and thps.id_tourney = tns.id_tourney
            and thps.id_blinds = tnb.id_blinds


Am I correct? If I'm wrong please correct me.

[Samirino]

Sorry I want to post rest of my example query for VPIP I want to use with starting blind but it always indicates me that it is detected like a spam and I can't deal with...

[Flag_Hippo]

Unfortunately I am not familiar with these types of queries but if a more advanced PostgreSQL user sees this then they might be able to offer you some advice.