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.
#8317unnamed78 feedbacksrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-trading-gen-2-1771581285931.json0x656d…4a10
#8316unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-trading-genesis-1-1771576466076.json0x656d…4a10
#8315unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-trading-genesis-1771572163232.json0x656d…4a10
#1585unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/aaa-1771241579124.json0x656d…4a10
#342unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-genenis-3-1771221679228.json0x656d…4a10
#244unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-genesis-1771215246117.json0x656d…4a10
#235unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-genesis-1771213264876.json0x656d…4a10
#225unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-genesis-1771211566739.json0x656d…4a10
#224unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-genesis-1771210427094.json0x656d…4a10
#201unnamedno feedbackrecord is its ownhttps://metadata.anoa.app/agents/143/0x656df648b057c809d03d18b73b0b14f3e5a34a10/anoa-genesis-1771189332402.json0x656d…4a10
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 (lower(coalesce(a.name,'')) LIKE $2 OR lower(a.owner) LIKE $3 OR lower(coalesce(a."agentWallet",'')) LIKE $4 OR lower(coalesce(a."tokenUri",'')) LIKE $5 OR a."agentId"::text = $6)
ORDER BY coalesce(fb.evidence, 0) DESC, coalesce(r."memberCount", 1) ASC, a."agentId" DESC
LIMIT $7 OFFSET $8