Query editor
WITH fnames AS (SELECTfid,ANY_VALUE(fname) AS fnameFROM dune.neynar.dataset_farcaster_fnamesWHERE deleted_at IS NULLGROUP BY fid),casts_unpacked AS (SELECTc.hash AS cast_hash,c.timestamp,t.mention_fidFROM dune.neynar.dataset_farcaster_casts AS cCROSS JOIN UNNEST(c.mentions) AS t(mention_fid)WHERE c.deleted_at IS NULLAND c.timestamp >= NOW() - INTERVAL '7' DAY -- 👈 для 14/30/60 меняешь здесь),ranked AS (SELECTu.mention_fid,f.fname,COUNT(DISTINCT u.cast_hash) AS unique_casts_with_mention,ROW_NUMBER() OVER (ORDER BY COUNT(DISTINCT u.cast_hash) DESC) AS rank_positionFROM casts_unpacked uLEFT JOIN fnames f ON f.fid = u.mention_fidGROUP BY 1, 2)SELECTrank_position AS rank,unique_casts_with_mention AS mentions,'7 days' AS periodFROM rankedWHERE LOWER(fname) IN ('rep', 'rep-hq')LIMIT 1;