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.
#1644unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x96D0…6C2e
#1643unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3049…A342
#1642unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB696…7B70
#1641unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe1a7…bCD7
#1640unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeAb0…bB84
#1639unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD9B9…3bd0
#1638unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5C12…Ad0f
#1637unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf687…CB8A
#1636unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7DD7…9A2a
#1635unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x55C2…A86e
#1634unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdd37…589d
#1633unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x859c…0D51
#1632unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4C7c…BfB5
#1631unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x72d6…3e2b
#1630unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6D08…8AeF
#1629unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE82A…e39D
#1628unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6975…cB04
#1627unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x03BF…E53f
#1626unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x941E…18d6
#1625unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x15f1…2Dc7
#1624unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd253…c3DC
#1623unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA880…8124
#1622unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC0A3…2275
#1621unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x38d9…C3e7
#1620unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1fE3…3934
#1619unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3DA9…21F8
#1618unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFAcC…e88f
#1617unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1Cbc…1D19
#1616unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcfE6…d8ac
#1615unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAdFC…e6d4
#1614unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDACB…d2E3
#1613unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x26Ef…63B8
#1612unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9ee2…fF69
#1611unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBA45…b893
#1610unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x411c…Ec2A
#1609unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5702…364b
#1608unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6dcD…19e8
#1607unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5cD6…6471
#1606unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd800…7343
#1605unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x30fC…D040
#1604unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3914…3a1b
#1603unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x809A…165B
#1602unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaC25…4262
#1601unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x23c2…6D0f
#1600unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x99F9…541C
#1599unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf1B9…4955
#1598unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc83D…66B1
#1597unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9935…F1B1
#1596unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x20E9…E1bb
#1595unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x599e…BfF7
#1594unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8F1d…5114
#1593unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB302…3805
#1592unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcd6E…6025
#1591unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4cef…ea7F
#1590unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFfd5…Ff34
#1589unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3595…6Cdf
#1588unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5F0A…c7af
#1587unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb8BC…08EF
#1586unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9A55…bDAB
#1584unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc6a4…7d88
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