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.
#983unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x92f0…3783
#982unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd8C5…58Ca
#981unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9B7A…C95b
#980unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7e21…F0B8
#979unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDf0E…3efC
#978unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA7A0…205e
#977unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa9F0…7E8d
#976unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3C7a…cfC8
#975unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7Ea8…8655
#974unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc428…a054
#973unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x98e2…3365
#972unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1C14…fFC6
#971unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2719…A4dC
#970unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4272…81BB
#969unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfE03…66FE
#968unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xD1d7…043f
#967unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb8Cb…7cCC
#966unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x77d8…b2D8
#965unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEd6A…7C45
#964unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdf72…3edb
#963unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9017…F161
#962unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x54Ca…3fab
#961unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6b1A…C55c
#960unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x76A4…3D5b
#959unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe698…0b0a
#958unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8227…371f
#957unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf35e…98a0
#956unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4D9b…8A81
#955unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x156C…07c9
#954unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9f45…F2B8
#953unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5006…eB5f
#952unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9cf1…Aa5C
#951unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2b0D…1AaA
#950unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x69d7…0742
#949unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc55D…2A04
#948unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x767e…c66F
#947unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa747…e9Fc
#946unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x675F…c955
#945unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x023C…c13F
#944unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5245…548E
#943unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7947…F192
#942unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x279b…0A4d
#941unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6049…A695
#940unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0493…dA59
#939unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xf24A…d73f
#938unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xCB7c…4447
#937unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3bBf…6f2F
#936unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9232…9C77
#935unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0D14…164E
#934unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7a62…CF27
#933unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x736f…915d
#932unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x180A…8a50
#931unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x78F7…516A
#930unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA352…320b
#929unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xeBB0…d975
#928unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2968…3e15
#927unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc63d…c946
#926unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1B6B…5c58
#925unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x889B…3140
#924unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA0ce…04C2
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