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.
#863unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4736…d009
#862unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x30B6…0504
#861unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6dbb…b978
#860unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9700…50D4
#859unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAB35…9159
#858unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x011D…9db5
#857unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3205…1E01
#856unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2a0C…52eB
#855unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC30A…569e
#854unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8DB7…eAaA
#853unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2305…d9d9
#852unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1A26…C0E7
#851unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd14b…7961
#850unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1756…6C27
#849unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBA63…152E
#848unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x62e7…fe5b
#847unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc9Bb…b056
#846unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x92c4…56fb
#845unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1ba3…30E8
#844unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9778…566f
#843unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf64A…DBDc
#842unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2EA8…d1F3
#841unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1afE…1325
#840unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb013…096f
#839unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x21F9…a268
#838unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0ED1…E0F9
#837unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCb31…9918
#836unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf88c…471e
#835unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB000…8132
#834unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB79F…633e
#833unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC9c5…ceF7
#832unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2D7f…1769
#831unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x52B2…8571
#830unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7780…4ac8
#829unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaEB4…fb06
#828unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x67D3…eA98
#827unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x23a4…097C
#826unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2f06…2240
#825unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5093…0DA4
#824unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7fCF…7870
#823unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3B35…DA3c
#822unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x51C0…5b52
#821unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x40A4…4702
#820unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xbA3c…40C8
#819unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb04D…2399
#818unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3aF2…5feB
#817unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x936f…6Aa4
#816unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6A91…EDD2
#815unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5489…5276
#814unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6f26…0cd9
#813unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7db5…e192
#812unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x04db…4FfB
#811unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3509…F03E
#810unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x01d0…5D09
#809unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x144C…FA36
#808unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6Fce…d272
#807unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7Ee1…2F7A
#806unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC6c6…8891
#805unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x702a…42E2
#804unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF0B1…2309
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