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.
#1103unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA2eD…40bB
#1102unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x263a…6D2B
#1101unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2338…90e9
#1100unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcd9a…B7B9
#1099unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2225…01f2
#1098unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4545…ce5a
#1097unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3416…A9e4
#1096unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x291F…764e
#1095unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x67cE…f66B
#1094unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x40D8…e067
#1093unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFE51…feBA
#1092unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0687…5bA2
#1091unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA208…634d
#1090unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8c9e…C2D5
#1089unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa5D0…5798
#1088unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x069d…AD08
#1087unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6005…c4d1
#1086unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2473…2847
#1085unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc253…C65F
#1084unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1911…AaEb
#1083unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD035…FB99
#1082unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x625B…3A8D
#1081unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe78A…5237
#1080unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9AF1…f0ad
#1079unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf42D…048A
#1078unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8b02…1f3d
#1077unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB076…b1a8
#1076unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x78d1…65c8
#1075unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4DFf…0901
#1074unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3579…DE9e
#1073unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4B5a…3176
#1072unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA343…369c
#1071unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2A38…9730
#1070unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x629B…11b3
#1069unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x50dA…5a0e
#1068unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCfbe…2e3B
#1067unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7bB8…a1a9
#1066unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0814…5295
#1065unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3365…78A8
#1064unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x53f1…d6F9
#1063unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8f88…d2a0
#1062unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7407…272F
#1061unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd3EB…190d
#1060unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD4Ce…FD92
#1059unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5E23…3143
#1058unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7A3f…3937
#1057unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf5e5…1101
#1056unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa9E3…85a9
#1055unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb2df…ffFC
#1054unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3a63…d71e
#1053unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7a6a…b1Eb
#1052unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9c3C…CD6a
#1051unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2eA7…849C
#1050unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1c10…1e11
#1049unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb9F4…79c2
#1048unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9562…2887
#1047unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD7F0…9092
#1046unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x82F7…aF33
#1045unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9EA8…6233
#1044unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd886…aAA1
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