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.
#1403unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd7FC…4295
#1402unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x82D8…A3Ba
#1401unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1Fe9…F056
#1400unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc0F4…8a8b
#1399unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE9A6…9512
#1398unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA13a…24A6
#1397unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xded4…096f
#1396unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x919A…2484
#1395unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0afA…f075
#1394unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2049…918a
#1393unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcA3D…a3F3
#1392unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC705…1017
#1391unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcC61…87C0
#1390unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2251…eaa5
#1389unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc112…BA04
#1388unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDb61…8f30
#1387unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBB83…401c
#1386unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd8EA…4065
#1385unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x25F5…A42b
#1384unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFB66…a77c
#1383unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6EEf…Fc60
#1382unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcD57…6f01
#1381unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5017…0A76
#1380unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5D2B…d0E6
#1379unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x59A5…91c0
#1378unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7B18…1Fac
#1377unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc5e8…DCF4
#1376unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9F3A…dD8F
#1375unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB78c…df92
#1374unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4200…96B2
#1373unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x881D…f086
#1372unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0Ac4…8e4D
#1371unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA559…BD06
#1370unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4cdB…eBFc
#1369unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6387…beA4
#1368unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1FeB…280b
#1367unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa5B8…B5A4
#1366unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF805…7E59
#1365unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6E87…12e8
#1364unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe89e…03a4
#1363unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6697…C068
#1362unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9386…4C80
#1361unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD863…AC3b
#1360unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x068E…eA47
#1359unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCf13…D7F4
#1358unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7fb4…A7b9
#1357unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD523…3e74
#1356unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x424f…b082
#1355unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3F5d…Cd99
#1354unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfa4f…60A5
#1353unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x88eA…C45C
#1352unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x375f…7BCD
#1351unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3F4A…Cffd
#1350unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5D8F…fc30
#1349unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3ebb…5983
#1348unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8d78…CadF
#1347unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBa4B…6fe5
#1346unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc68a…c467
#1345unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6792…3b52
#1344unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x76C9…945d
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