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.
#803unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA585…4E63
#802unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2223…ec56
#801unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd3C3…ed31
#800unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4Dd8…0f1D
#799unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x43f3…5234
#798unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0102…17Ac
#797unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEA7C…A407
#796unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC95C…6e51
#795unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9007…BceD
#794unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfBD8…653c
#793unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8746…1ed4
#792unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x19Da…Fb5c
#791unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x07e6…7a22
#790unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBE81…7F6D
#789unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7C5F…073B
#788unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x316f…FC53
#787unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCB50…3eA4
#786unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7416…506C
#785unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF8E5…AE64
#784unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x40Ef…E27c
#783unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9d4c…d702
#782unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x24e3…8727
#781unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6Aa0…5467
#780unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3aEd…7319
#779unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaA40…5f7B
#778unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0D19…f0Fd
#777unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB2d0…5c15
#776unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6054…23a9
#775unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6e92…855F
#774unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x120F…07DC
#773unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x97C4…5a8C
#772unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF17b…4C80
#771unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x941c…CE66
#770unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA71B…9a24
#769unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE3F9…12C7
#768unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2C39…1f29
#767unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x083e…dd78
#766unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7E97…950E
#765unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0bfe…165f
#764unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA682…e222
#763unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE6bf…7073
#762unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEB0C…C00F
#761unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5399…908f
#760unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8167…86Eb
#759unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF710…0b80
#758unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2235…9208
#757unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCe5c…6f6d
#756unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB9Fe…043c
#755unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1641…b29E
#754unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe2a6…3E31
#753unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB6EF…c4b3
#752unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4E28…cE4D
#751unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaF41…0c69
#750unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA557…9bA2
#749unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF585…44e0
#748unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC8C4…00f0
#747unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x91d8…d186
#746unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x41BF…4Ea4
#745unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x38e5…6Fb1
#744unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8c38…08bd
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