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.
#923unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6049…A695
#922unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0B9F…69D5
#921unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB54F…2694
#920unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd94D…23E3
#919unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa026…4Cf6
#918unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd695…94ce
#917unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x13Bf…5C1a
#916unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x213D…59bB
#915unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1A51…6A25
#914unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x209F…2808
#913unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6E91…63CE
#912unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd421…4d76
#911unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB1E7…ad5F
#910unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x673d…3c79
#909unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x281e…5C13
#908unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb472…d628
#907unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc5FA…85b3
#906unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF93e…D7AA
#905unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFa05…70BF
#904unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4cdB…36F1
#903unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x84F5…D8Ad
#902unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3Bb8…BA40
#901unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x107C…ED2C
#900unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb93c…6B59
#899unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF3b3…ccbC
#898unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf9A3…8B0B
#897unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4906…CA30
#896unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD410…0CAF
#895unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9d8b…6C35
#894unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBDcB…Fb80
#893unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA29d…3F9C
#892unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1677…A07E
#891unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF00F…163a
#890unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x143e…c9bC
#889unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf533…aEAA
#888unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x317c…8dC5
#887unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9232…F19E
#886unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x57Dc…054f
#885unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xbbA1…CA91
#884unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x494e…1f10
#883unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDE4B…394a
#882unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x47B8…90e1
#881unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC146…89FF
#880unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE473…bC0C
#879unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1908…Bc76
#878unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1ae8…ec4f
#877unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xedfF…9024
#876unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1F0c…2e38
#875unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8Ff3…Ce4e
#874unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x587F…Ea8a
#873unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd6a6…D23A
#872unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEBf3…aa16
#871unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6CbA…240C
#870unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf888…aCFB
#869unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7b84…6e77
#868unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0b8a…190d
#867unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9066…0AD3
#866unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x77A2…9B49
#865unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9Db1…258d
#864unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2C50…0Bf9
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