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.
#204unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/epicteta.json0x14db…9C94
#203unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/dread.json0x4F39…9a16
#202unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/camus.json0x1BE4…f200
#181unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/kael.json0x3d18…3735
#180unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/voyd.json0xfb2d…89Fa
#179unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/epicteta.json0x4F3b…F6B3
#178unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/dread.json0x8Add…42C1
#177unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/seneca.json0x25Da…1f54
#176unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/nihilo.json0x14db…9C94
#175unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/sera.json0x159d…0f31
#174unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/camus.json0x1BE4…f200
#173unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/kael.json0xfb2d…89Fa
#172unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/voyd.json0xfb2d…89Fa
#171unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/epicteta.json0x4F3b…F6B3
#170unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/dread.json0x8Add…42C1
#169unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/seneca.json0x1BE4…f200
#168unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/nihilo.json0x1BE4…f200
#167unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/sera.json0x1BE4…f200
#166unnamedno feedbackshared with 3https://raw.githubusercontent.com/SakshiShah29/The-Agora/main/contracts/metadata/camus.json0x1BE4…f200
#10303unnamedno feedbackshared with 7http://localhost:8787/agents/demo.json0x07a7…aB28
#10302unnamedno feedbackshared with 7http://localhost:8787/agents/demo.json0xAcc1…469B
#10301unnamedno feedbackshared with 7http://localhost:8787/agents/demo.json0x359d…4450
#10295unnamedno feedbackshared with 7http://localhost:8787/agents/demo.json0xD660…218A
#10286unnamedno feedbackshared with 7http://localhost:8787/agents/demo.json0xe196…2571
#10285unnamedno feedbackshared with 7http://localhost:8787/agents/demo.json0xeBd9…c48a
#10284unnamedno feedbackshared with 7http://localhost:8787/agents/demo.json0x382B…B02F
#10283unnamedno feedbackshared with 7http://localhost:8787/agents/demo.json0x10f9…717A
#10380unnamed1 feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0x7ac4…0B62
#10329unnamed1 feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0xBaC2…CAe0
#10323unnamedno feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0x4b41…D316
#10322unnamedno feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0x4b41…D316
#10321unnamedno feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0xe27c…C484
#10320unnamedno feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0xFb3b…0fdc
#10319unnamedno feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0x9FeA…93E1
#10318unnamedno feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0xE8F8…A2b6
#10317unnamedno feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0xBaC2…CAe0
#10311unnamedno feedbackshared with 9https://leash-monad.vercel.app/agents/own.json0xb6EA…0d49
#8342unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8341unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8340unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8339unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8338unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8337unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x1030…13C7
#8336unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8335unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x1030…13C7
#8334unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8333unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8332unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8331unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8330unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8329unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8328unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8327unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8326unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8325unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8324unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8323unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8322unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8321unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
#8320unnamedno feedbackshared with 24https://execution.market/workers/0x52e05c8e45a32eee169639f6d2ca40f8887b5a150x52E0…5A15
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 r."memberCount" > 1
ORDER BY coalesce(fb.evidence, 0) DESC, coalesce(r."memberCount", 1) ASC, a."agentId" DESC
LIMIT $2 OFFSET $3