This is what you want: (string_agg((case when tourney_hand_player_statistics.cnt_p_raise > 0 AND NOT tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.position=9 then lookup_hole_cards.hole_cards else NULL end), ', ')) If you use this column you don't need any formatting. ...

What I want to do is practically the same but using different break down of stack sizes. If PT4 excluded only the live table columns instead of the hole stat then everything would be fine.

For exemple: There is a stat which gives information about the preflop 3bet frequency of the player and the stat filters the information by stack size. For example: if stack size is bigger than 15 BB then the stat will be calculated like (cnt_p_3bet_15_100_bb / cnt_p_3bet_opp_15_100_bb) * 100, and i...

If a stat reads from live database table then the HUD will read only from the active database regardless how many databases is chosen to read.

Ticket is opened: #159165

The problem was described clearly, I think developers could create a test stat easily.
However I created a test HUD and opened a ticket: #159164

If you have a stat in your HUD which needs information from live database tables then there will be a join in the WHERE clause of the query sent to postgres: WHERE (live_tourney_player.id_player = tourney_hand_player_statistics.id_player_real) Well, I believe this clause is incorrect because hands p...

Done, Ticket #159099

I think you could find the same problem easily in your database, too (at least I've checked some other players' database who play some other game format and saw the same problem) but okay, I'll open a ticket soon.

I have checked dozens of hands and I don't see any reasons why the amt_expected_won_icm_pct is empty. Here is one example hand of the 94thousands: PokerStars Hand #101622891348: Tournament #762909800, $196.66+$3.34 USD Hold'em No Limit - Match Round I, Level II (15/30) - 2013/07/20 0:33:50 CET [2013...

I might be wrong but for me it seems that most of the time this column isn't calculated even it should be. I created a query and run against my HU SNG database: select id_hand from tourney_hand_player_statistics where id_holecard > 0 and cnt_players = 2 and flg_showdown and NOT enum_allin = 'N' and ...