by I want to make report showing my ev by positions against every opponent.
This need to be for spins. I want to have all players in report and my EV against every of them when I'm 3wBBvsSB, 3wSBvsBB, 3wBBvsBTN, 3wBTNvsBB, HUSB and HUBB.
Can anybody give me example of one statisctic from above? I'm trying long time without any success.
I made expression filter for every position but it's annoying and time consumming to check every player on every postion individually.
here is example of 3wBBvsSB
- Code: Select all
tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand
FROM tourney_hand_player_statistics thps
JOIN player p ON thps.id_player = p.id_player
WHERE (p.player_name = 'opponent' AND thps.position = 9)
AND EXISTS (
SELECT 1
FROM tourney_hand_player_statistics thps2
JOIN player p2 ON thps2.id_player = p2.id_player
WHERE thps2.id_hand = thps.id_hand
AND p2.player_name = 'hero'
AND thps2.position = 8
)
)
- Code: Select all
tourney_hand_summary.cnt_players = 3 and not tourney_hand_summary.str_actors_p LIKE '0%' and tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps where thps.flg_hero and thps.position = 8)
