select

case

when {{n_days}} != 0 then dateadd(day, -{{n_days}}, current_date())

else to_timestamp('{{start_date}}')

end start_date,

case

when {{n_days}} != 0 then current_date()

else to_timestamp('{{end_date}}')

end end_date

,block_proposals as(

select

rf.block_timestamp,

rf.block_id,

rf.pubkey

from solana.gov.fact_rewards_fee rf

join date_filter

on rf.block_timestamp between start_date and end_date

where

rf.pubkey = '{{validator_pubkey}}'

select * from block_proposals

order by block_timestamp desc