SELECTcount(hole_card_1) AS zomg_sets,sum(CASE WHEN villains_hand ~ '(\\w)[hcsd] \\1'AND the_flop LIKE ('%' || substring(villains_hand FROM 1 FOR 1) || '%')AND the_flop LIKE ('%' || substring(hole_card_1 FROM 1 FOR 1) || '%')THEN 1 END) AS set_over_set,sum(CASE WHEN villains_hand ~ '(\\w)[hcsd] \\1'AND turn || river LIKE ('%' || substring(villains_hand FROM 1 FOR 1) || '%')AND the_flop || turn LIKE ('%' || substring(hole_card_1 FROM 1 FOR 1) || '%')THEN 1 END) AS two_outer,sum(CASE WHEN hand_history ~ 'HOLE CARDS.*?raise.*?raise.*?FLOP' THEN 1 END)AS treybet_pot,round(avg(total_won::numeric - total_bet::numeric),2) AS avg_BBFROM (SELECT CASE WHEN gp.went_to_showdown_n = 1 THEN substring( regexp_replace(h.hand_history, '(?n)MYSCREENNAME.*?showed \\[.*?\\]', ''), 'SUMMARY.*?showed \\[(.*?)\\]' ) END as villains_hand, g.flop_1 || g.flop_2 || g.flop_3 AS the_flop, * FROM game_players gp JOIN game g ON gp.game_id = g.game_id AND g.date_played > (current_date - interval '1 month') JOIN hand_histories h ON g.game_number = h.game_number WHERE gp.player_id = (SELECT player_id FROM players WHERE screen_name = 'MYSCREENNAME') AND gp.pair_hand = 1 AND gp.saw_flop_n = 1 -- i hit all the sets, i hit all the sets AND (g.flop_1 || g.flop_2 || g.flop_3 || g.turn || g.river) LIKE ('%' || substring(gp.hole_card_1 FROM 1 FOR 1) || '%') --LIMIT 10 --OFFSET 18) AS sets;