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.
#1343unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7e0b…249D
#1342unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5cE7…27F1
#1341unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x575A…6967
#1340unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x617B…B95A
#1339unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdAF0…BE79
#1338unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x773A…E3fA
#1337unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x74Ee…D940
#1336unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3159…D0Fa
#1335unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x55D1…70A7
#1334unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeeC8…E13e
#1333unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x35f7…a045
#1332unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8fA3…E946
#1331unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8852…6fb7
#1330unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5c6E…87CC
#1329unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD5BF…eD8a
#1328unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x698c…EF64
#1327unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd384…3f20
#1326unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf5be…f1B1
#1325unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe78C…f20F
#1324unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x876e…8ef8
#1323unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x14aD…a4bA
#1322unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x11e8…a070
#1321unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x04B2…EbbE
#1320unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6648…6Af6
#1319unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8787…164F
#1318unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeA29…a3Bb
#1317unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC491…6d43
#1316unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe0ce…8Fd0
#1315unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcEd3…7f75
#1314unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9eD6…3344
#1313unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEA50…0Eff
#1312unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x23b8…5656
#1311unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd959…0e82
#1310unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfA9E…C149
#1309unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDaB1…4252
#1308unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdA25…E3B0
#1307unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8d5a…caA4
#1306unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x72eb…325C
#1305unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9864…48dF
#1304unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0f1e…24D1
#1303unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4c6D…210f
#1302unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6c38…9cF9
#1301unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x52Cf…D62d
#1300unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD66F…7692
#1299unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6827…b1Eb
#1298unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC675…5766
#1297unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1a75…7705
#1296unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC5E8…22C0
#1295unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7748…9F1a
#1294unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB5D8…3200
#1293unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4914…A0c9
#1292unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd4B1…73B2
#1291unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdb71…873A
#1290unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x707C…c9F0
#1289unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3537…Bf74
#1288unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4aB2…cC88
#1287unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA7ac…7559
#1286unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3D46…61B7
#1285unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD2e4…c420
#1284unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0aD3…bdD5
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