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.

#8468unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpxexl6t2fcu78sf8ajrzj1w/registration.json0x8951…94D1

#8467unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpy4eec700c6ohc7g5cw05y6/registration.json0x7BCd…A773

#8466unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq6ju5pd0itxp2dyxvxpicdd/registration.json0x8740…A9A3

#8465unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpwx2mdi11rl12l4hr6nr88q/registration.json0xdacF…9F15

#8464unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpx4132m1gja12l47y5dno0v/registration.json0x6c7f…c672

#8463unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpt6ldts06tyu2if87g4sol6/registration.json0xB3EF…0f05

#8462unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpy18wai04vzngbvq4amzjz2/registration.json0x00b0…610e

#8461unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmptw73jl13f9utmpjuvfsgc6/registration.json0x95c9…0a71

#8460unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpxrqbks0lbhk1zs0gvez88n/registration.json0x27fA…03b6

#8459unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpxgdt4y005u5slj4z6ffotq/registration.json0x2312…92E4

#8458unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpt8qyji091aww7peyiocpf7/registration.json0xe6be…C4b0

#8457unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpzpi1zd2ferbj7o1z6fny5x/registration.json0x641B…12D9

#8456unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpy96gt000tcyxh7dtnahsa0/registration.json0xFa8A…494f

#8455unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmnfvthye006iwts2b997rhpf/registration.json0x87c4…211a

#8454unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq2hq4un11ixw9u2lavfpspa/registration.json0x308a…0b03

#8453unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq0b6y0qg1cidglrypqzco5h/registration.json0x4b38…710D

#8452unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq1j5btj1haqqr6wadsojq3h/registration.json0x3Da8…07A1

#8451unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpwsmsbl0rlheoe2ofthfts6/registration.json0xD332…8Beb

#8450unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpv9v80c00e1uu1dguo149c9/registration.json0xb8D3…2d13

#8449unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5f22p50ydz18g2p7ed310f/registration.json0xA083…4dEA

#8448unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpxot2mt0efq5ft2ec6clkf2/registration.json0x21D5…B9F8

#8447unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpz7ybxl0djqdfirzvedc2ea/registration.json0xfA87…F430

#8446unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq00cdk6puzmc7za3fp1umf6/registration.json0xCBCD…0714

#8445unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpvpqune0ge8uzu3llrhcfuf/registration.json0x47B0…a771

#8444unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpw9at1g01ezo5rkpl6dv4ej/registration.json0x3F07…293e

#8443unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpv505f52yw8utmpdfu9n22r/registration.json0xCc19…5Fb5

#8442unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpr6d1i804h0708ul3syw5sl/registration.json0x7E93…3A5a

#8441unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq5g39rm12rj18g21252gbve/registration.json0xC80A…4e41

#8440unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmno07tzt000413bmgx0s2bi9/registration.json0x539F…9939

#8439unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpv6iz942z3au2ifkso27agk/registration.json0xD1Fd…9Bb7

#8438unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpv32vgd2w2jutmpd87e7eai/registration.json0xc9f6…E870

#8437unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq0iducv4co238q2pbuoeozf/registration.json0x3C8A…1e19

#8436unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmq1expo605ewwog1v1vk9kcg/registration.json0xC6ef…1F4f

#8435unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmprvimyj079a12cn5utxce0h/registration.json0x32A8…C753

#8434unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmprmui0w01ek12cnkib3yzs5/registration.json0x0a89…9AB3

#8433unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpy4lcyi001y11vnekn1zlo3/registration.json0x7d2a…0bEF

#8432unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpzcz8uo02tpcu1mju3in3lf/registration.json0x9cc2…0D13

#8431unnamedno feedbackrecord is its ownhttps://dashboard.dev.fun/api/arena/agent/cmpwqvymm0onw12l4rfa9ib7c/registration.json0x5fe9…96f5

#8430unnamedno feedbackno documentno tokenURI0xF963…381C

#8429unnamedno feedbackno documentno tokenURI0x7d66…1769

#8428unnamedno feedbackrecord is its ownhttps://b-dashboard.dev.fun/api/arena/agent/cmq63xzno00178rlcucfn0vwz/registration.json0x1355…6ae0

#8427unnamedno feedbackrecord is its ownhttps://b-dashboard.dev.fun/api/arena/agent/cmq63ugnr000p8rlc4p84ent0/registration.json0x218E…7e96

#8426unnamedno feedbackno documentno tokenURI0xf47b…4A6c

#8425unnamedno feedbackno documentno tokenURI0xa97F…A1A8

#8424unnamedno feedbackno documentno tokenURI0x15fb…3485

#8423unnamedno feedbackno documentno tokenURI0x1138…0482

#8422unnamedno feedbackno documentno tokenURI0xA7d2…61B7

#8421unnamedno feedbackno documentno tokenURI0x15fb…3485

#8420unnamedno feedbackno documentno tokenURI0xa2c4…40B5

#8419unnamedno feedbackno documentno tokenURI0x5140…AE6E

#8418unnamedno feedbackno documentno tokenURI0x3515…d715

#8417unnamedno feedbackno documentno tokenURI0x44FE…f4EC

#8416unnamedno feedbackno documentno tokenURI0x115b…D2aA

#8415unnamedno feedbackno documentno tokenURI0x94B9…56D3

#8414unnamedno feedbackno documentno tokenURI0x9249…0055

#8413unnamedno feedbackno documentno tokenURI0x943b…7D69

#8412unnamedno feedbackrecord is its ownhttps://b-dashboard.dev.fun/api/arena/agent/cmq4mz8rt0mzwwezmoe54edoq/registration.json0x9CA6…0cC9

#8411unnamedno feedbackrecord is its ownhttps://b-dashboard.dev.fun/api/arena/agent/cmq4mlyjj0dsywezmz6ne3815/registration.json0x7835…1805

#8410unnamedno feedbackrecord is its ownhttps://b-dashboard.dev.fun/api/arena/agent/cmq4m2bcm06w7wezmd3rb4ah5/registration.json0x3858…b716

#8409unnamedno feedbackno documentno tokenURI0x3648…e940

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