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.

#10182unnamed78 feedbacksrecord is its ownhttps://execution.market/workers/0x350ef06f11e87731476d567b3e5e5d865dcd66570x350E…6657

#10181unnamed37 feedbacksrecord is its ownhttps://execution.market/workers/0xaf95b213f44f0177e3a82e2d959524dd1e2a11740xaF95…1174

#10180unnamed13 feedbacksrecord is its ownhttps://execution.market/workers/0x76e9be89a3be6c1bf581a1f4519cb82dca9c57b30x76e9…57B3

#10261unnamed12 feedbacksrecord is its ownhttps://execution.market/workers/0xa3279f744438f83bc75ce9f8a8282c448f97cc8a0xa327…cc8A

#10220unnamed5 feedbacksrecord is its ownhttps://execution.market/workers/0x46bdfd8256ceeb3325725cb3b81701c3e2e32ebd0x46Bd…2eBD

#10184unnamed5 feedbacksrecord is its ownhttps://execution.market/workers/0x3aebb73a33377f0d6fc2195f83559635adee84080x3aeb…8408

#10169unnamed5 feedbacksrecord is its ownhttps://execution.market/workers/0x5975442e9608f71cea6e9b1f3841b5a045e0500d0x5975…500d

#10168unnamed4 feedbacksrecord is its ownhttps://execution.market/workers/0x64dbe996e626260f21f5c4fad3c9ba209978c3680x64db…c368

#10221unnamed3 feedbacksrecord is its ownhttps://execution.market/workers/0x9688385469cd5d216fd5a89eb03ec7fd0e0bd92d0x9688…d92D

#10189unnamed2 feedbacksrecord is its ownhttps://execution.market/workers/0xc059b9cd5b7421a28f9259adb4511418fd548b5e0xc059…8b5E

#10262unnamed1 feedbackrecord is its ownhttps://execution.market/workers/0x04eaeddba3b03b9a5abbd2ecb024458c7b1dcefa0x04Ea…CEFA

#10223unnamed1 feedbackrecord is its ownhttps://execution.market/workers/0xedc637d4b1bb9069753cc9335942be932083d2d00xEDc6…d2D0

#10219unnamed1 feedbackrecord is its ownhttps://execution.market/workers/0x8e503212c3c0806adecd2cc24f74379a3dedcbbc0x8E50…cBBC

#10190unnamed1 feedbackrecord is its ownhttps://execution.market/workers/0x7fd9f9e51c9a94b3bca2082c8332cbf708b0b5290x7Fd9…B529

#10188unnamed1 feedbackrecord is its ownhttps://execution.market/workers/0x6e5306c83602b204acaa65ceb05ec178120ea2650x6e53…a265

#10183unnamed1 feedbackrecord is its ownhttps://execution.market/workers/0xfa1c6ff4ede5a8290b292f40bb7ad0fbcb1c65d10xFa1c…65d1

#10167unnamed1 feedbackrecord is its ownhttps://execution.market/workers/0x945659f0eb9c34487b0c0f61ed7e9d279ace8f090x9456…8f09

#10153unnamed1 feedbackrecord is its ownhttps://execution.market/workers/0xfa349fa115142cb1029648ae1fe61436ef9e31640xfA34…3164

#10420unnamed1 feedbackrecord is its ownhttps://scavenger-osan-flapjax.surge.sh/erc8004-agent.json0xeBa1…99Bc

#10413unnamed1 feedbackrecord is its ownhttps://assay-207908449630.us-central1.run.app/.well-known/agent-card.json0xEC52…5573

#10235unnamedno feedbackrecord is its ownhttps://execution.market/workers/0x914c38fc1aec27912b90609ca82383630d64b5e40x914c…B5e4

#10234unnamedno feedbackrecord is its ownhttps://execution.market/workers/0x09c32b8fc0a94a1eed424499a42180e29667beee0x09C3…bEeE

#10222unnamedno feedbackrecord is its ownhttps://execution.market/workers/0x3a3f992d926da3272e681dc59d23ad63fa77f3a70x3a3f…F3A7

#10216unnamedno feedbackrecord is its ownhttps://execution.market/workers/0x172b60cb44d020ae8370b1370a11d615ce413aa50x172B…3aA5

#10215unnamedno feedbackrecord is its ownhttps://execution.market/workers/0x5de4d9ac31e0d1bc672619047b0b4894fd9064e60x5De4…64E6

#10187unnamedno feedbackrecord is its ownhttps://execution.market/workers/0xfefa20c2f64327f79ce0c0263106bd2b53b500610xFeFa…0061

#10154unnamedno feedbackrecord is its ownhttps://execution.market/workers/0x01f90369170c917a2c0e9d26d54c6a3a400984d30x01F9…84D3

#10152unnamedno feedbackrecord is its ownhttps://execution.market/workers/0xd5791860ca10a6f39749fb499931c79c7c35071a0xD579…071A

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 AND (lower(coalesce(a.name,'')) LIKE $2 ESCAPE '\' OR lower(a.owner) LIKE $3 ESCAPE '\' OR lower(coalesce(a."agentWallet",'')) LIKE $4 ESCAPE '\' OR lower(coalesce(a."tokenUri",'')) LIKE $5 ESCAPE '\' OR a."agentId"::text = $6)
ORDER BY coalesce(fb.evidence, 0) DESC, coalesce(r."memberCount", 1) ASC, a."agentId" DESC
LIMIT $7 OFFSET $8