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.
#1283unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfe9c…aa95
#1282unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xACc8…2D96
#1281unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA01e…4e45
#1280unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFc00…45c9
#1279unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x45B2…9628
#1278unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC8c0…13CD
#1277unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa27c…44f8
#1276unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1c18…3c18
#1275unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc47B…1b20
#1274unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x47a7…57F7
#1273unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6435…458f
#1272unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xbf00…2dae
#1271unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8292…F6e5
#1270unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6F0c…5aEE
#1269unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x803B…f518
#1268unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x72C0…4ac0
#1267unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe9f6…BA5e
#1266unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x427e…74b6
#1265unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3C96…e715
#1264unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa45D…E8b7
#1263unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBf70…C615
#1262unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0f81…0f8C
#1261unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x86B1…F0F9
#1260unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcE48…a72c
#1259unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x919A…2484
#1258unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9F3A…dD8F
#1257unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE9A6…9512
#1256unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC705…1017
#1255unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAe32…4597
#1254unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1Fe9…F056
#1253unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x881D…f086
#1252unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x581c…AE05
#1251unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc112…BA04
#1250unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x82D8…A3Ba
#1249unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5017…0A76
#1248unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb230…b26a
#1247unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7B18…1Fac
#1246unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5AbA…6214
#1245unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6EEf…Fc60
#1244unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA13a…24A6
#1243unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x59A5…91c0
#1242unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc5e8…DCF4
#1241unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0afA…f075
#1240unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc0F4…8a8b
#1239unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd7FC…4295
#1238unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3F5D…7A1A
#1237unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xded4…096f
#1236unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcC61…87C0
#1235unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaF00…3c7e
#1234unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBB83…401c
#1233unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2251…eaa5
#1232unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x25eb…e0bb
#1231unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEBDc…E576
#1230unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA559…BD06
#1229unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcA3D…a3F3
#1228unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDaB1…4252
#1227unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdA25…E3B0
#1226unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x32bF…A3a9
#1225unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc16E…04e4
#1224unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8d78…CadF
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