current_owners_for_project.sql

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
    WHERE token_id IN (
      SELECT token_id FROM tokens JOIN projects USING (project_id)
      WHERE slug = 'ringers'
    )
  ) AS ranked_transfers
  WHERE rank = 1
) AS token_owners
JOIN tokens USING (token_id)
JOIN projects USING (project_id)
ORDER BY token_index
;