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.

#8648unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq410i1zhh1tlao6bkkaki8a/registration.json0xBB3e…D1Ac

#8647unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqalfve24j7nbpnit3w3utgl/registration.json0xe9a3…D90D

#8646unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqal9x7g2ib4aweflu8atizs/registration.json0x2Ab3…Ef24

#8645unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmnfuicy3005hcz0vk9wxeivk/registration.json0x8e1f…c0d4

#8644unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpx1vndh1a7qeoe2yd2d23bu/registration.json0x48F3…1593

#8643unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq2jhqgc34jj13qk5ssa8fa3/registration.json0xd5A0…D9d4

#8642unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq54cr4k05gr18g2azbj0rmt/registration.json0x5C2B…BF30

#8641unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5at9tj00htqcv20s22go6c/registration.json0x4f72…f43c

#8640unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5atcgj0ekzpd22lyeclj10/registration.json0x362e…04c1

#8639unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5atdj70el0pd228w5czu4o/registration.json0x3E75…27a8

#8638unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5cwxgs0cyiqcv2m46ja0rt/registration.json0x9034…45d9

#8637unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq0hnj3j1xb4k9a5n7lpdmjf/registration.json0xbA27…5ee3

#8636unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5cwyj20saj18g2s2puecsr/registration.json0x4400…69ff

#8635unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpwxdsca11y6dm6np399igrm/registration.json0x07f1…CB38

#8634unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpvznkoo0vl3uzu3nd9pfvwv/registration.json0x5054…c613

#8633unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq90e2ah0bagbpnivr56hpe9/registration.json0x3a4b…Aa2c

#8632unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9p6e1p1yzzaml1qw8dxqo8/registration.json0xb869…EEeE

#8631unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9oxzih1e0y12oytg1th9sk/registration.json0x7095…8c4D

#8630unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpyfnpo7043s13huzyr5g83s/registration.json0x6964…01B5

#8629unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmmtas3u600967r8cmqoiq5n4/registration.json0x4E6f…e0c7

#8628unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpzaohhj1glpgp5rvvty539e/registration.json0x515e…7b7C

#8627unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpvdk9qe03sgby1mzt85tvck/registration.json0x15c2…C727

#8626unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq8axj8b5kpoycoa0njhdrcy/registration.json0x8165…Ca6a

#8625unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq8axclk1t3pnwniatn4jczv/registration.json0xf965…0e6C

#8624unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5atasa0ekmpd226be65gtx/registration.json0x4481…3083

#8623unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq0hniut1xb3k9a5vc3oq2qm/registration.json0x797e…75fF

#8622unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq8ax79q1t3inwnim4kzxoqb/registration.json0x7e18…3e5D

#8621unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq8awz635i2xjdc9egxvqenq/registration.json0x0264…4286

#8620unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpyga69d0cqf13hu03u5ns4d/registration.json0xa8AB…475A

#8619unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq0nk1rrvpaejqa42bqgmg6s/registration.json0x0b51…86Db

#8618unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9fsz7y0pym12oyspxm0yif/registration.json0x5527…3D58

#8617unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmngtyqov00aud3l3gqdtpoat/registration.json0xcaA3…e014

#8616unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmnhasacw007i12dwir58ps8b/registration.json0xcb07…7f19

#8615unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9cdq1y126s5iqvtnj7ahvj/registration.json0x6120…3C66

#8614unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpuwghvi2mkaww7py2ucgh89/registration.json0x514e…a8A1

#8613unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpyche3000ai11q6cla9rbnb/registration.json0xa88B…Db34

#8612unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq918sm10e1zdjcr9w8enfry/registration.json0x215d…AF29

#8611unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmosljjqe0004gnllxfdd1j9x/registration.json0xBd5E…81f7

#8610unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq4kxpc5j2dpfahhlq7vqre7/registration.json0x413A…bfaE

#8609unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpuc1fyq1qla10mqrude8pe2/registration.json0xa5b1…ed2c

#8608unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq0ao4kthossd8x9w7zv718j/registration.json0xBf2b…0E53

#8607unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpxcfo0l276n2xse5t307y6x/registration.json0x4254…F1B3

#8606unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpwwvo0811io12l4ijoqdiuh/registration.json0xbd25…0Aa7

#8605unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq0tlxqamf21jqa4pcht63rw/registration.json0x9c97…aa5F

#8604unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmnod4z43005h8y4mpt59ni67/registration.json0x3Fc6…02d1

#8603unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq180s8i2nhtleinggh2xf1w/registration.json0x6a5f…0b63

#8602unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5vhfl72hnmpd22ivdpl8r4/registration.json0xaEe0…B111

#8601unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmptireo40jer5kajfdulqofe/registration.json0x5E89…722c

#8600unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpysvedh9mr013huf9wdfqka/registration.json0xc2BF…E768

#8599unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpxnawnh0bga1sim0lca13su/registration.json0xaFcf…58d5

#8598unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpylxb3x3fot13huyt3kc414/registration.json0x9c13…8d1D

#8597unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpzgdwfsa9o93b3k0ips24j5/registration.json0x345e…A55e

#8596unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpxhjgb500305875fw98e9bc/registration.json0x754f…695a

#8595unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5cd9ta0hf4uep11nyosh22/registration.json0x3964…EDCa

#8594unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq85rsmv1hrnnwni121rjz8e/registration.json0x3e80…9905

#8593unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq84pqhc57o1tapljettba8t/registration.json0x91f6…26e0

#8592unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq83y55i561gtapl6ev3usqi/registration.json0x2779…b4D7

#8591unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq08t0pl6d8e73o0enbs80ga/registration.json0x6d9B…2587

#8590unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq3gusv1mz7qw9u2qanz8w3y/registration.json0x4891…814B

#8589unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq3f9o7q50abvm8noiz5foul/registration.json0x3796…1922

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