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.
#1884unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6198…aA61
#1883unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE62A…4cA9
#1882unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF841…8d57
#1881unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfb16…f087
#1880unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC47C…9dD1
#1879unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa8D8…aEb0
#1878unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdd16…f222
#1877unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC4E5…4491
#1876unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8470…e1EF
#1875unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x20b3…d1D1
#1874unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAbC9…6d9c
#1873unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7046…E92d
#1872unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA8C8…19C3
#1871unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE15B…2055
#1870unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x392C…6C8D
#1869unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4ABB…8151
#1868unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8436…2d13
#1867unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFE46…489B
#1866unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa2e5…412B
#1865unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5D91…bDBA
#1864unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEE29…F8b8
#1863unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5d69…7a62
#1862unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x58b2…A404
#1861unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc150…900a
#1860unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1e75…49Ba
#1859unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaB31…7Be4
#1858unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe1c8…6e90
#1857unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF10C…4E92
#1856unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3101…8EFF
#1855unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc0FA…dfEA
#1854unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7AC7…E90b
#1853unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA16e…97BB
#1852unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x80F5…e3b7
#1851unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4a2b…879A
#1850unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2165…d7e9
#1849unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0061…56DE
#1848unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC7Ee…4478
#1847unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9a6e…83c8
#1846unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0d7f…c95E
#1845unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe4a9…4cA2
#1844unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4c47…133b
#1843unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2151…7cBe
#1842unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5A28…c6df
#1841unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6295…Cf6A
#1840unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x25C1…5085
#1839unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4920…a292
#1838unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaE28…54e6
#1837unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3B1E…9566
#1836unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7815…0C54
#1835unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaACd…f547
#1834unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x38a2…4947
#1833unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa109…93cf
#1832unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC573…7717
#1831unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x39D6…1d5B
#1830unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2d1F…BD02
#1829unnamed1 feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb420…9fC1
#1828unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1Ff7…7b2C
#1827unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3043…1a13
#1826unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x17B5…EB77
#1825unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF78F…c850
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