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.
#743unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x91FD…f58B
#742unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x28d4…9Cc1
#741unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4fa9…ce96
#740unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa7d3…22dE
#739unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC513…5517
#738unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xde73…8881
#737unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x464f…43C3
#736unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x98bb…791C
#735unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE39e…493e
#734unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfD77…6037
#733unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2Dea…233E
#732unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEF8C…2F7F
#731unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb649…9604
#730unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9628…68c2
#729unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc3B3…4a0c
#728unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x219B…4AD2
#727unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDf2F…a559
#726unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x22B4…9d9e
#725unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5796…d7f0
#724unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6578…fF5b
#723unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0403…Fa15
#722unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x43f7…6f85
#721unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf4EA…3cE5
#720unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x42d7…c9FD
#719unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd9c3…eb91
#718unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFe4B…95BB
#717unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA675…5059
#716unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd73b…3f02
#715unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2ba2…E2BD
#714unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6Ed6…Cd9c
#713unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0e95…8709
#712unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfA1e…24bb
#711unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2304…A6C4
#710unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc33D…954B
#709unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6594…8D14
#708unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb159…2be1
#707unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb62a…6722
#706unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x11F3…Eeae
#705unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF614…05E8
#704unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb079…2a75
#703unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9AB4…CC76
#702unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe604…B28b
#701unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaDFD…83BC
#700unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5Dbc…59CB
#699unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2B38…3b8a
#698unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x39fB…4bE2
#697unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9232…3fAf
#696unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4a65…7991
#695unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x62C3…873A
#694unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa9Bb…6825
#693unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7E26…05fd
#692unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4841…90a5
#691unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x121d…9C62
#690unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD23A…7fDA
#689unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0Eea…2D30
#688unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1a05…71e1
#687unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0464…9572
#686unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9D4b…510D
#685unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC19f…5A01
#684unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x07e8…1857
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