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.
#623unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5709…9EC6
#622unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x44c4…D60a
#621unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x68d0…B4Bb
#620unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6E84…0633
#619unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3f50…2172
#618unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4F85…233B
#617unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb845…17CA
#616unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdD75…5821
#615unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6704…01cd
#614unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x922D…8033
#613unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x380f…50f8
#612unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaAbe…26D1
#611unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7dBF…3F9F
#610unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaf3B…4DD6
#609unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFa7a…39ae
#608unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA574…70cf
#607unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE482…1Ba6
#606unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCC36…c5EB
#605unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa72a…8Ad9
#604unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBB9C…3A01
#603unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD2D9…07b8
#602unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD332…Bd04
#601unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xebE4…7D7d
#600unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x53b8…53eD
#599unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCEA7…fFF9
#598unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6a79…e826
#597unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7658…477F
#596unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x27D3…eCDF
#595unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3C82…bff3
#594unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCdEd…0E9a
#593unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xabc7…fFb3
#592unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2180…cdAD
#591unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x598D…6Ac7
#590unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2575…28de
#589unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x94Ad…7e59
#588unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4694…781C
#587unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9f6d…f2dA
#586unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdb5b…D901
#585unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2B58…452E
#584unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x208c…0Ce4
#583unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf72F…EF5e
#582unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x278C…a33E
#581unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7423…4f4d
#580unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x64F6…C972
#579unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x69c4…c71b
#578unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAF1D…8E2E
#577unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x349a…4F2C
#576unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x58dF…e4C2
#575unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc595…a5bF
#574unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9F8B…6Edd
#573unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE444…CbdC
#572unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x90F0…4889
#571unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x514b…9013
#570unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8eDf…2c29
#569unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x79CB…d558
#568unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0f86…d355
#567unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1e7f…2038
#566unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8636…f427
#565unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdc66…DCD3
#564unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA2bb…2822
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