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.
#383unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8B22…7C7D
#382unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5017…8962
#381unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x19ec…77Be
#380unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4f94…B0C1
#379unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xADef…4ba6
#378unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf7B0…1f99
#377unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE162…1B33
#376unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x71FC…99E0
#375unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfF2A…3Dd2
#374unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9B8E…B959
#373unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1D39…4A3B
#372unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x41bB…8005
#371unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa73d…f955
#370unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9b13…04c7
#369unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb2FB…A4E7
#368unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x47A2…07a6
#367unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFb9d…ad64
#366unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7e5c…A3D2
#365unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeB58…2b56
#364unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5992…2a41
#363unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0Df8…F92E
#362unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x60ef…a8E6
#361unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6cbf…1541
#360unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x23AA…2bfB
#359unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa50A…6507
#358unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x69f3…6B06
#357unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa034…1F42
#356unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC158…6c86
#355unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3D84…45EE
#354unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdf51…313e
#353unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x579E…aB50
#352unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5060…745f
#351unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe13d…f5a8
#350unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xec63…6049
#349unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6812…fF52
#348unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA4a5…d732
#347unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x62F0…2d3c
#346unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x548B…Bc10
#345unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7d7E…b91e
#344unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1F8d…4484
#343unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2155…B649
#341unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x634D…2c80
#340unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa6aB…DF7E
#339unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8e67…3e6B
#338unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCc84…1D44
#337unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9326…203E
#336unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5ed3…9b49
#335unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1B83…f376
#334unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x61A8…3bEF
#333unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6735…aaAF
#332unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2B82…3775
#331unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9a97…2aE2
#330unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x45EF…C8f3
#329unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdd98…4908
#328unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3dBC…287A
#327unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x62e5…6acB
#326unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x666e…26B7
#325unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7Bee…BCF1
#324unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5113…BE1D
#323unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1DF5…d955
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