event_from

FROM gold.near_events

WHERE event_from_label_type IS NULL

AND event_from NOT IN(SELECT address FROM redshift.udm_address_tags WHERE blockchain = 'near')

AND event_to_label_type = 'distributor'

AND metric_date >= getdate() - interval '6 months'

AND event_from IS NOT NULL

AND event_to IS NOT NULL

AND event_from != 'failed'

AND event_to != 'failed'

AND (tx_type != 'failed' OR tx_type IS NULL)