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.
#1824unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x206A…4Fd1
#1823unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9f82…8A84
#1822unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf493…68c0
#1821unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4b96…9285
#1820unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5004…2e70
#1819unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x42b8…F44b
#1818unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaaf7…4212
#1817unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD80D…C572
#1816unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6Aa7…678f
#1815unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9fE3…1ce3
#1814unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x06b8…46bB
#1813unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6de5…c1ca
#1812unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb4bf…23Db
#1811unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2D48…E03a
#1810unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6C4f…9527
#1809unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4CcB…48b4
#1808unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE7d9…469e
#1807unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1961…00bC
#1806unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x933b…2429
#1805unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x50A1…9949
#1804unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc6C3…789e
#1803unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB5fF…C6C3
#1802unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3905…7e59
#1801unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5E96…d58f
#1800unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xacE6…85f1
#1799unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc4A5…f11D
#1798unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9030…8b5B
#1797unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfcfB…d199
#1796unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9F30…49d8
#1795unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3E5d…9767
#1794unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBdCB…8Da5
#1793unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdC12…ec19
#1792unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7C7a…8C6d
#1791unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x11d5…970d
#1790unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5BFc…47d4
#1789unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCa6d…ae1c
#1788unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd73E…CD08
#1787unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdBA5…a824
#1786unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3098…7DdF
#1785unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2275…B339
#1784unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE558…d470
#1783unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA951…3311
#1782unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA955…30C6
#1781unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x866f…1bDc
#1780unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6f66…06d3
#1779unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9ccd…51CE
#1778unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x08CB…f258
#1777unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xca08…8B83
#1776unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5BfB…cF72
#1775unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD709…c5D1
#1774unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x261e…CF27
#1773unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc917…2433
#1772unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9889…F62B
#1771unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9410…500F
#1770unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x018A…4843
#1769unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2Ab7…5295
#1768unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAa76…4BCE
#1767unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaE8C…10f0
#1766unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xbABd…4E0d
#1765unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x42CE…00a9
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