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.
#1163unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDaFb…3799
#1162unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8b81…E0bB
#1161unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6648…6Af6
#1160unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x55D1…70A7
#1159unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9864…48dF
#1158unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8787…164F
#1157unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3057…327A
#1156unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x359b…6f34
#1155unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC5E8…22C0
#1154unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7e0b…249D
#1153unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4016…0F5A
#1152unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x72eb…325C
#1151unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF7e4…48e3
#1150unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC491…6d43
#1149unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4F3F…fa87
#1148unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb32e…c823
#1147unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe78C…f20F
#1146unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDb61…8f30
#1145unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9eD6…3344
#1144unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8d5a…caA4
#1143unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0Ac4…8e4D
#1142unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0f1e…24D1
#1141unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x52Cf…D62d
#1140unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7748…9F1a
#1139unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDAAB…A8d0
#1138unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x11e8…a070
#1137unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfA9E…C149
#1136unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd959…0e82
#1135unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4c6D…210f
#1134unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC675…5766
#1133unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcEd3…7f75
#1132unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA9C5…A68B
#1131unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD66F…7692
#1130unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7fb4…A7b9
#1129unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6827…b1Eb
#1128unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x23b8…5656
#1127unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6c38…9cF9
#1126unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4BE2…aa8e
#1125unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x80f2…C121
#1124unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2A5D…7851
#1123unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x17c7…A418
#1122unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc96a…08E7
#1121unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x17Be…aade
#1120unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1eff…72d5
#1119unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x456a…345e
#1118unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6E06…224c
#1117unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8A2d…b6E1
#1116unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4c8b…3b07
#1115unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb15C…6dCc
#1114unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4742…D9B7
#1113unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x60F1…8E38
#1112unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD8e9…c61d
#1111unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA3C4…Bc4D
#1110unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x878D…c235
#1109unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x19E6…9f31
#1108unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0Ef2…Cd02
#1107unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA70E…7556
#1106unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF147…eCBd
#1105unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf065…53e0
#1104unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD0df…B09e
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