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.
#1523unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE26D…22ca
#1522unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1ffD…7f2d
#1521unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaEeB…Ba1f
#1520unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x41F3…44eA
#1519unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2115…1072
#1518unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8cEF…89Cf
#1517unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6cFA…403f
#1516unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5c60…CD54
#1515unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5939…B042
#1514unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8219…5cb0
#1513unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9649…80cD
#1512unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDC3a…c083
#1511unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE089…9572
#1510unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8009…57bF
#1509unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9D36…268D
#1508unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDBad…02A6
#1507unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x77af…DA4d
#1506unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4CB6…f746
#1505unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf756…E2F4
#1504unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd723…310C
#1503unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6b53…b230
#1502unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdc71…1b47
#1501unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x198E…7566
#1500unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3da2…83B2
#1499unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDFC3…c1a0
#1498unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcEB9…e2c6
#1497unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x915B…5E33
#1496unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x504A…4774
#1495unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x57F2…446d
#1494unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD3ac…56D2
#1493unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf99A…24BC
#1492unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x98c7…1492
#1491unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd264…AfC6
#1490unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xecb2…49Ed
#1489unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x945E…f234
#1488unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x30c7…ac86
#1487unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe850…7B7F
#1486unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC3dE…7D6F
#1485unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x61c5…aC21
#1484unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x452D…e5ff
#1483unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7b38…3d45
#1482unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD750…5bA2
#1481unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5C53…98a2
#1480unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1400…D03F
#1479unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD455…6492
#1478unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfa6e…3564
#1477unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3BfF…DeFc
#1476unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1274…b4c4
#1475unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7D66…91a5
#1474unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd7f9…Fc78
#1473unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4D79…05FC
#1472unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1cC2…7EC5
#1471unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2A24…10a2
#1470unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2224…23b6
#1469unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB843…7b25
#1468unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4820…0B64
#1467unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4603…da32
#1466unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4119…511e
#1465unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAc0e…0F71
#1464unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3f42…6242
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