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.
#1704unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAFc0…d277
#1703unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA088…c465
#1702unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEF9E…be41
#1701unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x39Ce…d7e5
#1700unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE2Cf…57B7
#1699unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8D9b…8f04
#1698unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb0c2…A597
#1697unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb73B…DEDD
#1696unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBde9…0121
#1695unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0970…64Ae
#1694unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7CBa…B85D
#1693unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEba4…d857
#1692unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x580f…7BB7
#1691unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8C15…a130
#1690unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa67C…F5A2
#1689unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6511…44bC
#1688unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB7d6…9Afc
#1687unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x24E0…bc84
#1686unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe0d6…5d88
#1685unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x10BF…0C0d
#1684unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x488e…d1fA
#1683unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x93De…48f6
#1682unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFDBA…13f9
#1681unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc005…d9C6
#1680unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAc55…fa80
#1679unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB224…feAb
#1678unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDc46…4412
#1677unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA0f4…95ab
#1676unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x164F…73Ee
#1675unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE15E…95C0
#1674unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA3B1…84D4
#1673unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7C64…f40D
#1672unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x09e4…170E
#1671unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC9A8…aB31
#1670unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0116…230F
#1669unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x41Ca…78B7
#1668unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2dE1…B70A
#1667unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB31E…5Bf8
#1666unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB490…c38F
#1665unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBB62…B294
#1664unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4C2A…082A
#1663unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6D1a…338E
#1662unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x421C…bF3F
#1661unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8256…5830
#1660unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x45c1…3F12
#1659unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe5FC…802F
#1658unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe3bb…975e
#1657unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xae69…A7c8
#1656unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb132…7fF1
#1655unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0AED…8389
#1654unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB7aE…95c5
#1653unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1572…FE4a
#1652unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x551C…A82D
#1651unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfbaD…c3DC
#1650unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x12Cb…29A2
#1649unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2034…4e19
#1648unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6607…5D60
#1647unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcfA0…49e2
#1646unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb257…01Da
#1645unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9a77…3d5c
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