kanmanimonad mainnet · 143

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.

#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

#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

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