select fact_swaps.TX_ID, MAX(FROM_AMOUNT_USD) AS USD_VALUE, MIN(fact_swaps.BLOCK_TIMESTAMP) AS TIMESTAMP, MIN(fact_swaps.FROM_ASSET) AS FROM_ASSET, MIN(fact_swaps.TO_ASSET) AS TO_ASSET, MIN(fact_swaps_events.MEMO) AS MEMO
FROM thorchain.core.fact_swaps
INNER JOIN thorchain.core.fact_swaps_events ON fact_swaps.TX_ID=fact_swaps_events.TX_ID
WHERE AFFILIATE_ADDRESS = 'ej' AND MEMO LIKE '%:%:%:%:%:%:%'
group by fact_swaps.TX_ID
ORDER BY TIMESTAMP DESC