every registered agent, filterable by what shares its record

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.

10,426 matching agents · page 157 of 174

#1283unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xfe9c…aa95
#1282unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xACc8…2D96
#1281unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA01e…4e45
#1280unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xFc00…45c9
#1279unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x45B2…9628
#1278unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC8c0…13CD
#1277unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa27c…44f8
#1276unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1c18…3c18
#1275unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc47B…1b20
#1274unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x47a7…57F7
#1273unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6435…458f
#1272unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xbf00…2dae
#1271unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8292…F6e5
#1270unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6F0c…5aEE
#1269unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x803B…f518
#1268unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x72C0…4ac0
#1267unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xe9f6…BA5e
#1266unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x427e…74b6
#1265unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3C96…e715
#1264unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xa45D…E8b7
#1263unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBf70…C615
#1262unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0f81…0f8C
#1261unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x86B1…F0F9
#1260unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcE48…a72c
#1259unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x919A…2484
#1258unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9F3A…dD8F
#1257unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE9A6…9512
#1256unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC705…1017
#1255unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAe32…4597
#1254unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1Fe9…F056
#1253unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x881D…f086
#1252unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x581c…AE05
#1251unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc112…BA04
#1250unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x82D8…A3Ba
#1249unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5017…0A76
#1248unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xb230…b26a
#1247unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7B18…1Fac
#1246unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5AbA…6214
#1245unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6EEf…Fc60
#1244unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA13a…24A6
#1243unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x59A5…91c0
#1242unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc5e8…DCF4
#1241unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0afA…f075
#1240unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc0F4…8a8b
#1239unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd7FC…4295
#1238unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3F5D…7A1A
#1237unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xded4…096f
#1236unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcC61…87C0
#1235unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xaF00…3c7e
#1234unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xBB83…401c
#1233unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2251…eaa5
#1232unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x25eb…e0bb
#1231unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xEBDc…E576
#1230unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA559…BD06
#1229unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xcA3D…a3F3
#1228unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDaB1…4252
#1227unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdA25…E3B0
#1226unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x32bF…A3a9
#1225unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xc16E…04e4
#1224unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8d78…CadF
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