posiciones que ven flop

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

posiciones que ven flop

Postby plukhead » Tue Feb 28, 2023 10:08 am

hola necesito ayuda para escribir una expresión que indique que posiciones llegan al flop en un spin and go o expreso.....lo intente con cadenas de actores sin exito......por ejemplo quiero ver todas las manos en las que en 3handed ,llegan al flop solo SB y BB ,.....
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: posiciones que ven flop

Postby Flag_Hippo » Tue Feb 28, 2023 12:07 pm

If you are using the aggressors/actors strings for that you would have to cover every possible scenario which would not be straightforward but you could instead test for the button not seeing the flop using a subquery.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: posiciones que ven flop

Postby plukhead » Tue Feb 28, 2023 3:20 pm

Claro, cubrir todos los escenarios es mucho trabajo, y no se como hacer una subconsulta, podrías ayudarme?
plukhead
 
Posts: 116
Joined: Mon Sep 16, 2019 11:16 pm

Re: posiciones que ven flop

Postby Flag_Hippo » Wed Mar 01, 2023 5:50 am

This subquery tests for the button not seeing the flop:

Code: Select all
tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps where thps.position = 0 and NOT thps.flg_f_saw)

For more on how SELECT works see here.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 24 guests

cron