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.
#1043unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x52B5…0727
#1042unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB27c…b1f9
#1041unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x233c…d33E
#1040unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7f2D…1021
#1039unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x990d…F6D6
#1038unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x496a…Fdb8
#1037unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x38E1…6930
#1036unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2C32…0Bd3
#1035unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7389…2077
#1034unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0FA7…0547
#1033unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB367…e051
#1032unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x01d2…6cc1
#1031unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7B57…BAb2
#1030unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE6B4…D69b
#1029unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7aB6…d5D5
#1028unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4c34…4631
#1027unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x42E5…BCc8
#1026unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd270…69cD
#1025unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc3E5…41EC
#1024unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0cEa…2008
#1023unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4c17…0643
#1022unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD3A2…eBcC
#1021unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1565…2ea4
#1020unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDB9b…3663
#1019unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x76CD…E659
#1018unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFDC4…E861
#1017unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEFe2…1035
#1016unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x711b…B3e7
#1015unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb9aD…c628
#1014unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd0a2…DF6B
#1013unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAF91…5ad3
#1012unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB058…531a
#1011unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3674…4bCD
#1010unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0106…a490
#1009unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7948…97f5
#1008unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf57f…9249
#1007unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0A7E…7223
#1006unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0C9E…c658
#1005unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0B63…55F6
#1004unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9CA0…9a43
#1003unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0A57…802a
#1002unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x910f…2f0B
#1001unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD870…C3B2
#1000unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB89e…E88d
#999unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x608A…8106
#998unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe5Ac…0855
#997unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x491F…F3b3
#996unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0391…3472
#995unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcC00…D376
#994unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x743b…529B
#993unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd226…f813
#992unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4dc5…BF69
#991unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1a16…78A9
#990unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5041…cd8F
#989unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC879…eBE5
#988unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7E30…02F2
#987unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa56B…a084
#986unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xadD0…7675
#985unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC50F…E758
#984unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdF6A…24F3
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