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.

#8768unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqjnluj54yieofjjq5e6b7zh/registration.json0x89F6…3877

#8767unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqno6t0w92stw18sli2lct0h/registration.json0x8B0b…E889

#8766unnamedno feedbackno documentno tokenURI0x1477…be63

#8765unnamedno feedbackno documentno tokenURI0xe0f3…d3BA

#8764unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqcpreuz9y22aml1q5d46lx7/registration.json0xae7D…15B9

#8763unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqkqz8we2fy8cxnewwtsd5vx/registration.json0x3E1C…C6b6

#8762unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqdjfaje056mbvixx5j4l8og/registration.json0x3bC5…5E37

#8761unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqa1n8vz2d1r12oy731tjw3d/registration.json0xf8bf…E676

#8760unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq8ov86w6j18taplc72n65h8/registration.json0x228e…2990

#8759unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqi9mdh51b05ofjjg7wbuh1o/registration.json0x060A…d918

#8758unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqgpr8av4f7yy7gjy5qdxiug/registration.json0xEeD1…5F74

#8757unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq64xelp3bn8uep1u3or4uu6/registration.json0xe740…eE15

#8756unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqk0ua400qnez8bkdpc5fj3x/registration.json0xB622…37A3

#8755unnamedno feedbackno documentno tokenURI0x3D22…69e5

#8754unnamedno feedbackno documentno tokenURI0xd25E…82f9

#8753unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqjlnfgy4sxmofjjh1ybif3a/registration.json0xDc57…7A46

#8752unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq61fcy63131pd22q3vfg3cd/registration.json0x8Ac6…5071

#8751unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5zlivc2n1wqcv2p4tgminm/registration.json0x3801…151A

#8750unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5zky7a2n0pqcv2aahgg525/registration.json0x5983…14B4

#8749unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq61fiy0313qpd225kugs6zj/registration.json0xa3d6…7F11

#8748unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5zlfgo2t8wuep10ejyokit/registration.json0xA261…3E67

#8747unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqixfy4e2yc31jnrzm896ybf/registration.json0x1487…E9af

#8746unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5zlkpd3iruavtydgb2hwwc/registration.json0x95aB…5049

#8745unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqjf7rg44b0pwqch91rdsnx1/registration.json0x9e4A…5d76

#8744unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqjgwts14fg4v23x1jksmikm/registration.json0x2300…acAC

#8743unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqjfdf494bhawqchp5pvsxfk/registration.json0x8F70…FF90

#8742unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqip9v322diywqchal8v5sv8/registration.json0xcbd2…3940

#8741unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqixiizd2ygm1jnrp9m43mh8/registration.json0xbD7A…3538

#8740unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqiz487g310bv23x7asmpiou/registration.json0x9fa8…eDd7

#8739unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqixhn2s2vngofjj163mkfja/registration.json0x0318…2570

#8738unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5x55y82li6uep16kootxty/registration.json0x20E7…0293

#8737unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5sys0c28b3pd22mjkyr2xo/registration.json0x029a…7BdE

#8736unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqa5p9pp17enawefkmowv9ly/registration.json0x0b50…5432

#8735unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9lux0j1qpwaml1a2d5wmls/registration.json0x0EfC…F111

#8734unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9lt7gg1ow6bpni5an8olxe/registration.json0xD52E…4666

#8733unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9ltlhz1qmraml1ceenzadn/registration.json0x6149…B501

#8732unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9lrmzq1pzc5iqv1cp42l9v/registration.json0x16a9…1a6F

#8731unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9lr2y91qi4aml18u6zpsha/registration.json0x3A64…40D3

#8730unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqh6fs331e9klwzlbvwxfym9/registration.json0xa96e…1d5d

#8729unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqhzp1my0nmp1jnrzy5wjcbu/registration.json0xfF20…a089

#8728unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqa5otl117dfawefqg3dc31n/registration.json0x3401…75c4

#8727unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9lr5f91os6bpni6fq427c7/registration.json0x1960…ce23

#8726unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9lw8fe1qc15iqvxroz90v4/registration.json0x66B6…7Ace

#8725unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq6smwjd11lv10yihjjh3wj9/registration.json0x724F…BeD5

#8724unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqgy67zq0gz0lwzlz83bmhqw/registration.json0x98D6…29bD

#8723unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq0w4ymj3s3e6t1cmcob01gi/registration.json0xAb00…3b9E

#8722unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq4d4i7n1g1sfahhe3gl5j3c/registration.json0xB8cf…d488

#8721unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpyrkggw7vjj1hxgk9vl0xu4/registration.json0xa171…38ab

#8720unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqhi897p2jjdjdl2rouj3zih/registration.json0xc702…C37E

#8719unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqhgx3hd2e7ljfg5s73qsg6p/registration.json0x9532…3934

#8718unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqhg8czu2c7kjuwrp5or4vby/registration.json0x6744…2D4D

#8717unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqhg2j8g2cl5lwzlbeehc5kb/registration.json0xFd60…b0D6

#8716unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq9qy5hz23pmdjcrscaut0cq/registration.json0xa49E…Cf9b

#8715unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5jetlc17gppd22nq939s1f/registration.json0xDb77…64f1

#8714unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpprqmht001d96wnepu2ow43/registration.json0x7943…007e

#8713unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqcpq7d8379hs4z7piqcgvjz/registration.json0xbE98…EfcE

#8712unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpy25hj60cc59cbvgc3pn68e/registration.json0xCBA3…0Aac

#8711unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqgcmne33hiuy7gjy1wf3d6h/registration.json0x0AE3…c1d6

#8710unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqgyfcjy0i6vjfg5ztivls22/registration.json0xBB4D…995F

#8709unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqgyfblg0himjuwr6ouqofzd/registration.json0x7feC…4138

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