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.

#10091unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5zl9vs339k18g2ot7ywn7e/registration.json0xB374…f209

#10090unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqi024ug0o80wqchmul287j8/registration.json0x3B1B…85e9

#10089unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5get4c0uiyuep1lie11ws1/registration.json0x63c3…38BA

#10088unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmra8tfklhx7ayguwg7u59c5f/registration.json0x1487…dd38

#10087unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqjwfpij0el0z8bkc0se8skz/registration.json0x00F7…D242

#10086unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqun3ka42rtdsjm8audrr82y/registration.json0xa494…d415

#10085unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/35160x0C78…18f7

#10084unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq6dfjrv0jhpi8odvna0rw08/registration.json0x16DC…F7f0

#10083unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5gcoem1jegavty5ms82rvp/registration.json0x0018…A42d

#10082unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqomxml1fcy6gtzz7zepgu06/registration.json0x1e5d…dB28

#10081unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqmen9pw4sbq14jbfpbxvjqs/registration.json0x32a1…2821

#10080unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqz1cfhy03scsb5qlpysb22i/registration.json0x5f45…e674

#10079unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr457lx20lgusc8qpna3h5g0/registration.json0x9b9a…a53f

#10078unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr3f8iu84zl2hdvhnfeqsa3g/registration.json0xb887…d537

#10077unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqorpcidffztw18sdt8aqqwn/registration.json0x4fE7…4CE8

#10076unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr3bbod44s9r13n8ga0b8r67/registration.json0x29d4…6B37

#10075unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr0k228b093d6oek0317m6xd/registration.json0xb23b…612c

#10074unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr0iqnu006x6vnpgbqgqxnis/registration.json0xcB79…560A

#10073unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr0hdbrb05jrtm6js8bofhe4/registration.json0x4Ad6…5f52

#10072unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr0ew1dw02urvnpgxc9v1x2y/registration.json0x4C9A…5ecb

#10071unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqwgbaol005x13e1kkst41hv/registration.json0xf0D5…7B7d

#10070unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqzlw9cd171ggv79rlcuwx30/registration.json0x555a…B0E7

#10069unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqv2shqu4afe12f8ni5ws6zs/registration.json0x7B95…3fe0

#10068unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr0n0bsf13znvnpg2rz1vk76/registration.json0x09ff…2277

#10067unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/48960x0C78…18f7

#10066unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/24750x0C78…18f7

#10065unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/21360x0C78…18f7

#10064unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/23940x0C78…18f7

#10063unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/23290x0C78…18f7

#10062unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/19690x0C78…18f7

#10061unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/45290x0C78…18f7

#10060unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/23360x0C78…18f7

#10059unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/20940x0C78…18f7

#10058unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/40450x0C78…18f7

#10057unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/45650x0C78…18f7

#10056unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/27250x0C78…18f7

#10055unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/47350x0C78…18f7

#10054unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/13080x0C78…18f7

#10053unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/13790x0C78…18f7

#10052unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/30620x0C78…18f7

#10051unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/48290x0C78…18f7

#10050unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/29810x0C78…18f7

#10049unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/27170x0C78…18f7

#10048unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/30610x0C78…18f7

#10047unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/31070x0C78…18f7

#10046unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/5370x0C78…18f7

#10045unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/27780x0C78…18f7

#10044unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/21020x0C78…18f7

#10043unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/41790x0C78…18f7

#10042unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/29700x0C78…18f7

#10041unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/44760x0C78…18f7

#10040unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/21480x0C78…18f7

#10039unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/31970x0C78…18f7

#10038unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/30680x0C78…18f7

#10037unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/18990x0C78…18f7

#10036unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/5590x0C78…18f7

#10035unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/32280x0C78…18f7

#10034unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/43520x0C78…18f7

#10033unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/42930x0C78…18f7

#10032unnamedno feedbackrecord is its ownhttps://api.monadmogs.xyz/api/agents/metadata/33170x0C78…18f7

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