Hands against players without tag

[javitxu6]

Hello, I've seen that using this formula I can view hands against a specific player tag: tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, notes n WHERE thps.id_player = n.id_x AND (n.id_color = 2)).

How can I view hands against players who don't have a tag?

[javitxu6]

I would also like to know how to review hands involving two players with a specific tag. For example, if I want to see hands where two green-tagged players (tag 2) are at the table, how do I do it?

[Flag_Hippo]

Hello, I've seen that using this formula I can view hands against a specific player tag: tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, notes n WHERE thps.id_player = n.id_x AND (n.id_color = 2)).

How can I view hands against players who don't have a tag?

I am not sure exactly what you want but if you want to review hands played against players who don't have any tag then unfortunately I don't know of a method to achieve that.

I would also like to know how to review hands involving two players with a specific tag. For example, if I want to see hands where two green-tagged players (tag 2) are at the table, how do I do it?

I don't have a filter for a specific number of green tagged players but you can query specific positions like this:

Code: Select all

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, notes n WHERE thps.id_player = n.id_x AND thps.position = 8 AND (n.id_color = 2)) and tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, notes n WHERE thps.id_player = n.id_x AND thps.position = 9 AND (n.id_color = 2))

This will return hands where the SB and BB have a green tag although this filter would only be feasible to change and edit for other positions if you are playing 3-handed spin & goes for example. If you used that filter for full ring hands then it wouldn't exclude players in other positions having a green tag.

[javitxu6]

Thanks a lot!