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.
#1223unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x773A…E3fA
#1222unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x25F5…A42b
#1221unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6792…3b52
#1220unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe0ce…8Fd0
#1219unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB78c…df92
#1218unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4200…96B2
#1217unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6387…beA4
#1216unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x424f…b082
#1215unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd384…3f20
#1214unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x586F…47e7
#1213unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4cdB…eBFc
#1212unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe25D…E9c3
#1211unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1FeB…280b
#1210unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe89e…03a4
#1209unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCf13…D7F4
#1208unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2049…918a
#1207unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD863…AC3b
#1206unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9386…4C80
#1205unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEA50…0Eff
#1204unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd8EA…4065
#1203unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6E87…12e8
#1202unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD523…3e74
#1201unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3F5d…Cd99
#1200unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x068E…eA47
#1199unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x375f…7BCD
#1198unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6697…C068
#1197unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x14aD…a4bA
#1196unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x74Ca…8CD2
#1195unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdAF0…BE79
#1194unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB5D8…3200
#1193unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3ebb…5983
#1192unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBAc8…1ac5
#1191unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x88eA…C45C
#1190unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBa4B…6fe5
#1189unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF805…7E59
#1188unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeeC8…E13e
#1187unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5D8F…fc30
#1186unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcD57…6f01
#1185unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc68a…c467
#1184unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x04B2…EbbE
#1183unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x575A…6967
#1182unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x76C9…945d
#1181unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x617B…B95A
#1180unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5cE7…27F1
#1179unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x35f7…a045
#1178unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1a75…7705
#1177unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3159…D0Fa
#1176unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8fA3…E946
#1175unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x698c…EF64
#1174unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa5B8…B5A4
#1173unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8852…6fb7
#1172unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeA29…a3Bb
#1171unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfa4f…60A5
#1170unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5c6E…87CC
#1169unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD5BF…eD8a
#1168unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5D2B…d0E6
#1167unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFB66…a77c
#1166unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x876e…8ef8
#1165unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3F4A…Cffd
#1164unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf5be…f1B1
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