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.
#2245unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFB1D…901F
#2244unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8d70…2d05
#2243unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x622e…1d1A
#2242unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa510…1b97
#2241unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfEA3…db45
#2240unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8539…728B
#2239unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x806d…a229
#2238unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe1E9…Aa8E
#2237unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf44a…3329
#2236unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf38E…aD1c
#2235unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5cDa…97C2
#2234unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf0E0…1E51
#2233unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCB23…8eE4
#2232unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x966D…f9f4
#2231unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7af5…bD4E
#2230unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE126…0a43
#2229unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x14b7…1576
#2228unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE8b8…362c
#2227unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x96B2…f57F
#2226unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDbdd…4721
#2225unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe8f1…7Ce7
#2224unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5594…C172
#2223unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2927…3089
#2222unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa80F…5Dcf
#2221unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf63D…DdCe
#2220unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfbA9…AE25
#2219unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD318…D1Ca
#2218unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x838d…D17E
#2217unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5692…2D6f
#2216unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x05Fd…A9A5
#2215unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0aD2…2985
#2214unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x92Ba…a7A7
#2213unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xde5F…4737
#2212unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE5Ba…0c27
#2211unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7371…96a3
#2210unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeF09…060e
#2209unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf814…e664
#2208unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6CBe…9792
#2207unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x12bB…9704
#2206unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x699C…B4Ff
#2205unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF25C…5e6F
#2204unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x424a…38B9
#2203unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc63A…297c
#2202unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3Ad4…794D
#2201unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x007E…A71d
#2200unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x91a7…2695
#2199unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0D48…C3d9
#2198unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaf24…309F
#2197unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC5cb…E251
#2196unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB934…F267
#2195unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x43c9…81f1
#2194unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdD15…3A01
#2193unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDC5C…18Bb
#2192unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x60E8…13cE
#2191unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3EF2…cb76
#2190unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x97D7…01a0
#2189unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8A67…AD77
#2188unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3442…8a07
#2187unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5760…94d0
#2186unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x77aE…22ec
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