SELECT
              offer_id,
              sub2,
              sub3,
              sub4,
              count(*) filter (where sub5 != 'csm') as real_clicks,
              count(*) filter (where sub5 = 'csm') as fake_clicks,
              CURRENT_DATE date
            FROM affise.offer_getloyal
             WHERE created_at = :createdAt :: DATE
            GROUP BY offer_id, sub2, sub3, sub4;