current_owner_check.sql

EXPLAIN ANALYZE
SELECT
  projects.slug,
  token_index,
  current_owner
FROM (
  SELECT
    token_id,
    to_address AS current_owner
  FROM (
    SELECT
      token_id,
      rank() OVER (PARTITION BY token_id ORDER BY block_number DESC, log_index DESC) AS rank,
      to_address
    FROM erc_721_transfers
    -- Change this part to "WHERE token_id IN (SELECT ...)" for a
    -- project-specific query, or drop the "WHERE" clause to check all tokens.
    WHERE token_id = (
      SELECT token_id FROM tokens JOIN projects USING (project_id)
      WHERE slug = 'ringers' AND token_index = 851
    )
  ) AS ranked_transfers
  WHERE rank = 1
) AS token_owners
JOIN tokens USING (token_id)
JOIN projects USING (project_id)
;