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.
#1764unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdEC2…29a5
#1763unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xADBE…10c3
#1762unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x266A…2701
#1761unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaaD1…4e04
#1760unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2925…372F
#1759unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC41C…81eC
#1758unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x459F…1db5
#1757unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE5e1…2ede
#1756unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc0C7…570e
#1755unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x59a5…78d4
#1754unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3B4f…9029
#1753unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE360…4288
#1752unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb44e…6b6F
#1751unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd086…C55b
#1750unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2617…A756
#1749unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA1c6…7797
#1748unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD99f…8FeA
#1747unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x16d2…2B3a
#1746unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcEB4…4f78
#1745unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5de6…07B5
#1744unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1944…3bfc
#1743unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3546…f655
#1742unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0590…2e12
#1741unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD439…D53B
#1740unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5a30…3A95
#1739unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x44E7…77A8
#1738unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xecf1…E624
#1737unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb618…0899
#1736unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD3D8…0CC5
#1735unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0eF8…937e
#1734unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7518…6409
#1733unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2d3b…Df54
#1732unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x95AA…11aC
#1731unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1436…b50d
#1730unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB6a6…4d39
#1729unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x322f…e73D
#1728unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd8af…9428
#1727unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8BF0…DEdC
#1726unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x87d3…6785
#1725unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6120…132e
#1724unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6c70…D989
#1723unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD0C9…1929
#1722unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5a88…5A5c
#1721unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8312…d5CE
#1720unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x61A9…5275
#1719unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC06f…1361
#1718unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xffF4…3D31
#1717unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x206b…4002
#1716unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF98c…88eE
#1715unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x90D1…A3FF
#1714unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x61B4…b84a
#1713unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8D3f…aF80
#1712unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7704…3fC4
#1711unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd1D1…b148
#1710unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0639…FB71
#1709unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6dDF…26e4
#1708unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4a91…F099
#1707unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7Af4…D958
#1706unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0969…1075
#1705unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8F0e…02Be
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