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.
#1463unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6DB3…78f5
#1462unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x48E8…0E9b
#1461unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8A5B…5cb0
#1460unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x097f…F9F5
#1459unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x454a…8bB7
#1458unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x312c…E276
#1457unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0722…8786
#1456unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcE9B…543e
#1455unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc5b9…Ddd9
#1454unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x86eE…5D79
#1453unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5094…62dF
#1452unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x979f…01Db
#1451unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAC97…f1b4
#1450unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe908…Ed6c
#1449unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7b4F…6949
#1448unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8A6F…A30c
#1447unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc169…4b41
#1446unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6EC1…1974
#1445unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2cf7…5127
#1444unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4A81…1461
#1443unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB0C1…5c26
#1442unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x81d3…e026
#1441unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2707…f9CC
#1440unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA876…8720
#1439unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2559…5f58
#1438unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x07ac…5674
#1437unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1F3a…aABf
#1436unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf3cB…0e36
#1435unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc45C…ae7B
#1434unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE5Fb…0cEE
#1433unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9FE4…ff1e
#1432unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x64e8…A860
#1431unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd6C2…7e54
#1430unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD049…c453
#1429unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1646…D70B
#1428unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe8f8…1F92
#1427unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3d7d…f2fc
#1426unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6f13…9529
#1425unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4F3F…fa87
#1424unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x78D4…0520
#1423unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x74Ca…8CD2
#1422unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBAc8…1ac5
#1421unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA9C5…A68B
#1420unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8b81…E0bB
#1419unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4016…0F5A
#1418unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb32e…c823
#1417unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDAAB…A8d0
#1416unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x359b…6f34
#1415unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF7e4…48e3
#1414unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEBDc…E576
#1413unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x586F…47e7
#1412unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDaFb…3799
#1411unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x581c…AE05
#1410unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x32bF…A3a9
#1409unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaF00…3c7e
#1408unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb230…b26a
#1407unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x25eb…e0bb
#1406unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAe32…4597
#1405unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc16E…04e4
#1404unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3F5D…7A1A
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