Validators that missed proposals recently

query.sql

WITH validator_data AS (
    SELECT t.validator_id, t.name
    FROM public.validator_data_substates t
    WHERE name IS NOT NULL
      AND down_state_version IS NULL
    ORDER BY t.validator_id
)

(SELECT k.epoch, '<- Current Epoch' as validator, Null as proposals_missed, Null as proposals_completed
FROM validator_proposal_records k
ORDER BY k.last_updated_state_version DESC
LIMIT 1)
UNION ALL
(SELECT k.epoch,
       v.name,
       proposals_missed,
       proposals_completed
FROM validator_proposal_records k
         JOIN validator_data v ON (k.validator_id = v.validator_id)
WHERE proposals_missed > 0
  -- And name = '🍼 Mleekko Staking'
  AND last_updated_state_version > (SELECT top_of_ledger_state_version - 10000000 FROM ledger_status)
ORDER BY k.last_updated_state_version DESC, proposals_missed + proposals_completed)