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.
#1583unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x08Fa…5ed8
#1582unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x33E2…510c
#1581unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xff66…19e1
#1580unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3b81…Feca
#1579unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x634a…55d7
#1578unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6f4e…997d
#1577unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x527A…a722
#1576unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x73Aa…855c
#1575unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x755b…e9e8
#1574unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa187…dAdc
#1573unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5865…6d0F
#1572unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEC15…3705
#1571unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x11Aa…663e
#1570unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5d8b…1866
#1569unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5f0b…099a
#1568unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xbFaa…f0b4
#1567unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB6a8…677f
#1566unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6886…cB95
#1565unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2729…7b89
#1564unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0984…e1Fb
#1563unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4609…4Dbd
#1562unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x573A…4597
#1561unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa161…7092
#1560unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x21eB…BE1E
#1559unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8f2b…1697
#1558unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x259e…9cAd
#1557unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5AE5…19AD
#1556unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc081…4d80
#1555unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2D72…4771
#1554unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3BD0…2E2A
#1553unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8E45…D611
#1552unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7BBB…f0f2
#1551unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x36f3…cF20
#1550unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x480E…c9df
#1549unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2F74…166e
#1548unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf241…2e55
#1547unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd003…9Fe6
#1546unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8215…9C5e
#1545unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3fD6…4cff
#1544unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x064c…Fdc4
#1543unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA794…4e98
#1542unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x434d…b6Bf
#1541unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2E29…26cc
#1540unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA8DA…28E7
#1539unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1a5c…7D97
#1538unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD424…abF7
#1537unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9FB1…223C
#1536unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9491…2325
#1535unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2953…033C
#1534unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x01F7…9DC6
#1533unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2F99…1643
#1532unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd726…fB36
#1531unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5c59…86af
#1530unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6593…BD7d
#1529unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3dF6…9682
#1528unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x90c1…3146
#1527unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x691e…d780
#1526unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xADb0…ddD7
#1525unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7f3c…e124
#1524unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5651…bB9C
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