Activity Table drops some transfer events

[NIXBNT]

When doing the ranking of stratinfo to join onto the transfer events, sometimes the transfer actions inherit a "deleteme" tag due to incorrect sorting.
To fix the issue an extra order by deleteme asc should be added to the RankedCompleteInfo table beginning here: https://github.com/bancorprotocol/carbon-backend/blob/main/src/activity/activity.service.ts#L924

Note that the ordering and filtering was also updated from date to block_number

The corrected table

RankedCompleteInfo AS (
  SELECT
    ci.*,
    ROW_NUMBER() OVER (
      PARTITION BY vm.id
      ORDER BY
        ci.block_number DESC, deleteme asc
    ) AS rn
  FROM
    voucher_minimal vm
    LEFT JOIN complete_renamed ci ON ci.id = vm.id
    AND ci.block_number <= vm.block_number
),

[NIXBNT]

This is solved in recent query updates