Query editor
WITH rep_casts AS (SELECTc.id,c.created_at,c.timestamp,c.fid AS author_fid,c.hash AS cast_hash,c.textFROM dune.neynar.dataset_farcaster_casts AS cCROSS JOIN UNNEST(c.mentions) AS m(fid) -- π§ ΡΠ°Π·Π²ΠΎΡΠ°ΡΠΈΠ²Π°Π΅ΠΌ ΠΌΠ°ΡΡΠΈΠ² mentionsWHERE(LOWER(c.text) LIKE '%@rep-hq%' OR m.fid = 1328810)),reaction_counts AS (SELECTr.target_hash,COUNT(*) AS total_reactions,COUNT_IF(r.reaction_type = 1) AS likes,COUNT_IF(r.reaction_type = 2) AS recastsFROM dune.neynar.dataset_farcaster_reactions AS rGROUP BY r.target_hash),fnames AS (SELECTfid,fnameFROM (SELECTfid,fname,created_at,deleted_at,ROW_NUMBER() OVER (PARTITION BY fidORDER BYCASE WHEN deleted_at IS NULL THEN 0 ELSE 1 END,created_at DESC) AS rnFROM dune.neynar.dataset_farcaster_fnames)WHERE rn = 1AND deleted_at IS NULL),followers AS (SELECTtarget_fid AS fid,COUNT(DISTINCT fid) AS followers_countFROM dune.neynar.dataset_farcaster_linksWHERE deleted_at IS NULLAND type = 'follow'GROUP BY target_fid)SELECTrc.cast_hash,rc.author_fid,fn.fname,COALESCE(f.followers_count, 0) AS followers,rc.text,