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.
#2125unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA588…02Da
#2124unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7aC6…3236
#2123unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfDf9…d4a6
#2122unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x188E…aED1
#2121unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1594…33c4
#2120unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC946…93fC
#2119unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD376…BEA2
#2118unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe108…0215
#2117unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaF12…15d1
#2116unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4575…61d9
#2115unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC5b4…b3C4
#2114unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9D15…11d3
#2113unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7706…0183
#2112unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4F85…2859
#2111unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x05f7…fC52
#2110unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe90C…90aB
#2109unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeC59…264f
#2108unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1857…18a5
#2107unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x924b…8BD0
#2105unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd69d…090b
#2104unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3502…Bf1D
#2103unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7162…43b9
#2102unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6E55…ED88
#2101unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa937…6FA2
#2100unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6f54…7c76
#2099unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7cb3…DD3a
#2098unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8b56…1819
#2097unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3a35…8C31
#2096unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x15a1…4398
#2095unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa021…9dcF
#2094unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2ab3…63a9
#2093unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4847…b3BA
#2092unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5d09…6583
#2091unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2861…B797
#2090unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe297…7c7b
#2089unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2154…69D8
#2088unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3a0c…B7bF
#2087unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5059…e119
#2086unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0DdD…CC41
#2085unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7D73…0CD9
#2084unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3cC1…d127
#2083unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4B14…8762
#2082unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8C75…E337
#2081unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6909…A32A
#2080unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4bc2…370b
#2079unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDa1c…5f38
#2078unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA28D…8044
#2077unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2259…44a7
#2076unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE78C…57d9
#2075unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa0b5…7860
#2074unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBf51…90B7
#2073unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xbbeD…c36B
#2072unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xec51…2791
#2071unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf662…D09a
#2070unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4079…c553
#2069unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x07da…1a37
#2068unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4881…B872
#2067unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb9a1…6240
#2066unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x32b6…8d91
#2065unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x51C0…E02A
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