with c_tokens as (
SELECT *
FROM solana.core.dim_labels
where label LIKE '%solend%'
AND address_name LIKE '%solend %'
), tab1 as (
SELECT
DISTINCT tx_id
FROM solana.core.fact_transfers
LEFT OUTER JOIN c_tokens
ON address = mint
WHERE mint in (SELECT address FROM c_tokens)
)
SELECT *
FROM solana.core.fact_events
WHERE tx_id in (SELECT * from tab1)
LIMIT 100