SELECT
*
FROM
solana.core.ez_staking_lp_actions as ecf
JOIN solana.core.fact_stake_pool_actions as act ON act.block_id = ecf.block_id
and act.stake_pool_name = 'lido'
JOIN solana.core.fact_staking_lp_actions as act2 ON act2.block_id = ecf.block_id
WHERE
ecf.validator_name = 'validator: everstake'
AND ecf.stake_active = TRUE