Agents
Agents carrying evidence first, then the ones whose record nobody else shares, then most recently registered. Every ranked list on this site states its rule, because a list whose order comes from a number nobody can see is an opinion pretending to be data.
#2064unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0217…4Db7
#2063unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC729…C9EA
#2062unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0646…F122
#2061unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2138…1773
#2060unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb3B4…1de8
#2059unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc6ba…700F
#2058unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x87d1…B130
#2057unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x646f…8DB8
#2056unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x75B2…05ee
#2055unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf165…1291
#2054unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC14e…A7FD
#2053unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9de8…892C
#2052unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc6eA…20E1
#2051unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF7a1…08D5
#2050unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9E76…Daa6
#2049unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8561…A7f6
#2048unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc4A2…Da75
#2047unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd873…d9a8
#2046unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2FcA…68bD
#2045unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf27D…f430
#2044unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9B76…84bA
#2043unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0Baa…623D
#2042unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x22Af…434E
#2041unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x972a…21DF
#2040unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x059f…5639
#2039unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x96AA…88b5
#2038unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x15E6…6Fbb
#2037unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x77Ff…1d9a
#2036unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x07f8…Db50
#2035unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6B29…91FC
#2034unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6B7E…aC53
#2033unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc26D…A6dB
#2032unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB3Bb…FF4E
#2031unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB46A…54b8
#2030unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCf9F…d281
#2029unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9AdB…A524
#2028unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA9A8…66dc
#2027unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x16F3…7669
#2026unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xed67…1CB2
#2025unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9438…cAF1
#2024unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x571a…Bd6F
#2023unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb4CF…be09
#2022unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfFA7…4176
#2021unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x56fe…6838
#2020unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb4E4…615d
#2019unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6bDE…Ec9B
#2018unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC0D6…b05d
#2017unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDBF9…0871
#2016unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2Ebc…7f01
#2015unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x76ef…8ce3
#2014unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB793…6229
#2013unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2734…3727
#2012unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2e38…FEa2
#2011unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5cE4…Cbdd
#2010unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1f7B…39b9
#2009unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2468…0639
#2008unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdcDD…CbC9
#2007unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7257…bD57
#2006unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB1A5…8096
#2005unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x66F2…9638
re-derive this
SELECT a.id, a."agentId", a.owner, a."agentWallet", a."tokenUri", a."uriHash", a.name,
a.endpoints, a."declaresX402", a."registeredAtBlock", a.rung,
a."transferCount", a."metadataUpdateCount",
r."memberCount" AS record_members, r.resolves AS record_resolves,
coalesce(fb.total, 0) AS feedback_count
FROM "Agent" a
LEFT JOIN "AgentRecord" r ON r.id = a."uriHash" AND r."chainId" = a."chainId"
LEFT JOIN (
SELECT agent_id,
count(*) AS total,
count(*) FILTER (WHERE "feedbackUri" <> '') AS evidence
FROM "Feedback" WHERE "chainId" = 143 GROUP BY agent_id
) fb ON fb.agent_id = a.id
WHERE a."chainId" = $1
ORDER BY coalesce(fb.evidence, 0) DESC, coalesce(r."memberCount", 1) ASC, a."agentId" DESC
LIMIT $2 OFFSET $3