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.

#10151unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrpyuo7w28qyr0u1oyp7dzmo/registration.json0xd3af…4dB4

#10150unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrl6ewc59c03u9i3epw4mh15/registration.json0x85B2…Ea84

#10149unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrdmes8u0015fcqb092ntwot/registration.json0xAD0E…F5Bb

#10148unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmquppnn52wdyfwxwi9a412jk/registration.json0xF53c…E398

#10147unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr9e0ycif8sqouib9sjhic73/registration.json0x99DF…53d6

#10146unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr908rok3mjw9jilcmw6c2yq/registration.json0x62b0…54D9

#10145unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr8zjetodoftouibpq9mn4hf/registration.json0x1d06…4918

#10144unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrkgbant62o5u9i3oownha6f/registration.json0xb9E4…C86b

#10143unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrkfl4lq60z6u9i335g16k6j/registration.json0x9f45…3FcA

#10142unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrk353j95534dqn0e4d6myx5/registration.json0xCbAC…D255

#10141unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrjtria74hpxwa5dbo5e691w/registration.json0xA176…BD40

#10140unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrj0tgtk2788wa5dnadjpx3f/registration.json0x2DE7…A1eD

#10139unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrl5rta97cuhdqn0nidk7bw7/registration.json0xA59e…6E9C

#10138unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmridwm9u0fy8dqn0y9ijyd7u/registration.json0x2442…394e

#10137unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrjguzd53hi1wa5dnr9g3knr/registration.json0x5110…d967

#10136unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrjgwxgf3fuh3drrizg2jayk/registration.json0xE426…895f

#10135unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrd6bjki1sq06d18n4xd88g2/registration.json0xFa6d…FdC8

#10134unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrjgsge23habwa5daawjtbwg/registration.json0x9E26…bCB8

#10133unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmripwxaf1a40u9i36ea3thon/registration.json0x0a8C…B9Ad

#10132unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrhtkce041jyfnr52y74g59v/registration.json0x9b9c…F8FF

#10131unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrhqczu43r6gccyacmeqx6p9/registration.json0x2Ce6…3219

#10130unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr945xac3rm6s4vwaw7ltliq/registration.json0xA9B2…624D

#10129unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr945saoe6zqouib9ztud939/registration.json0x201A…D5C0

#10128unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr945onwe5voyguwjodwzs9g/registration.json0x5E89…a464

#10127unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr8zku6d3bw9ohwei9yaa664/registration.json0xc47D…38C2

#10126unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr65k61f3dtl2pz5wz0uwshs/registration.json0x2b0C…59B1

#10125unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrizej0c22gowa5db72rhzif/registration.json0xCe41…5623

#10124unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrizv3iu22iu3drre57br4mv/registration.json0xD2c8…d187

#10123unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrj2kc9q2b60wa5d643dyk07/registration.json0xeD0B…E3C5

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

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

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

#10119unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrepcnsq23gu2dkyvqkoie88/registration.json0x6cF0…db11

#10118unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrby8kjmkm2oyguwyd22h5n1/registration.json0xc19f…9511

#10117unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrby8wt0a9yrs4vw3yv3zo8f/registration.json0xab98…7b08

#10116unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrby96weab6uohwede5ymyq4/registration.json0x52a7…c136

#10115unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrby92zrajfq9jilu43w3vq7/registration.json0x6977…D74C

#10114unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrby8qbfab6johwej1wh6xk6/registration.json0xdCe5…1d58

#10113unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr4adckn0v7jsc8q35vgulnz/registration.json0x5dFF…9847

#10112unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr9cf8k1f2utouib3244vsp1/registration.json0x62F8…3e4B

#10111unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr5ugff729nd2pz5glenw5x0/registration.json0x2121…6698

#10110unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr5sh2sy23gzycahp9g4nz6c/registration.json0x7C0c…58c8

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

#10108unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr5ugepw290youibodtfco26/registration.json0x6C0c…e7E8

#10107unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr891j9z0zp29jil3j5f1a80/registration.json0xE918…9222

#10106unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr5ugg4l2a3qycahk708q03b/registration.json0x6200…a8c7

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

#10104unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr7amu6f7txnycahgx3nrp7u/registration.json0xCbB9…0D28

#10103unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr7amt7o7rgqouibhpdok0y5/registration.json0x99Ee…D4ad

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

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

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

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

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

#10097unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr7aidx67qxxouibydv3oxii/registration.json0xBe4f…bf1a

#10096unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrauqmdp8xbk9jilfqv9acpa/registration.json0x1Dc8…1318

#10095unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmr86v7oi0r519jildhtubf58/registration.json0x0e6D…460A

#10094unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmrebb9bb0zfm2reyzf2zk110/registration.json0x6e2F…a0aE

#10093unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmqoumr7hfupbnq1qqcl630cd/registration.json0x657D…F03D

#10092unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq64xpu341ngavtycvbdphrr/registration.json0xbf08…c3c3

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