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.

#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

#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

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 AND coalesce(r."memberCount", 1) = 1
ORDER BY coalesce(fb.evidence, 0) DESC, coalesce(r."memberCount", 1) ASC, a."agentId" DESC
LIMIT $2 OFFSET $3