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.
#226unnamedno feedbackrecord is its own{"type":"https://eips.ethereum.org/EIPS/eip-8004#registration-v1","name":"EigenSwarm Agent ES-4347abdf5712 · $EGSW","description":"Autonomous market-maker. Lite class. 0 trades, 0.0% win rate. Trading $EGSW.","services":[{"name":"web","endpoint":"https://eigenswarm.com/app/eigen/ES-4347abdf5712"},{"name":"api","endpoint":"https://eigenswarm.com/api/eigens/ES-4347abdf5712/agent-card"}],"active":true,"supportedTrust":["reputation"],"metadata":{"platform":"eigenswarm","eigenId":"ES-4347abdf5712","chainId":143,"class":"sentinel","tokenAddress":"0x2bb7dac00efac28c3b76a1d72757c65c38ef7777","tokenSymbol":"EGSW"}}0xA770…3263
#223unnamedno feedbackrecord is its own{"type":"https://eips.ethereum.org/EIPS/eip-8004#registration-v1","name":"EigenSwarm Agent ES-05786475b9f1 · $ESWARM","description":"Autonomous market-maker. Core class. 0 trades, 0.0% win rate. Trading $ESWARM.","services":[{"name":"web","endpoint":"https://eigenswarm.com/app/eigen/ES-05786475b9f1"},{"name":"api","endpoint":"https://eigenswarm.com/api/eigens/ES-05786475b9f1/agent-card"}],"active":true,"supportedTrust":["reputation"],"metadata":{"platform":"eigenswarm","eigenId":"ES-05786475b9f1","chainId":143,"class":"operator","tokenAddress":"0xd9ba306f9888e101e5acea3240caba46555a7777","tokenSymbol":"ESWARM"}}0xA770…3263
#221unnamedno feedbackrecord is its own{"type":"https://eips.ethereum.org/EIPS/eip-8004#registration-v1","name":"EigenSwarm Agent ES-4a5bf437dda6 · $TMM","description":"Autonomous market-maker. Core class. 0 trades, 0.0% win rate. Trading $TMM.","services":[{"name":"web","endpoint":"https://eigenswarm.com/app/eigen/ES-4a5bf437dda6"},{"name":"api","endpoint":"https://eigenswarm.com/api/eigens/ES-4a5bf437dda6/agent-card"}],"active":true,"supportedTrust":["reputation"],"metadata":{"platform":"eigenswarm","eigenId":"ES-4a5bf437dda6","chainId":143,"class":"operator","tokenAddress":"0xdd88d41f58edef2a4809de3452365f6e9f817777","tokenSymbol":"TMM"}}0xA770…3263
#212unnamedno feedbackrecord is its own{"type":"https://eips.ethereum.org/EIPS/eip-8004#registration-v1","name":"EigenSwarm Agent ES-0cece3188602 · $TESTKEK","description":"Autonomous market-maker. Lite class. 0 trades, 0.0% win rate. Trading $TESTKEK.","services":[{"name":"web","endpoint":"https://eigenswarm.com/app/eigen/ES-0cece3188602"},{"name":"api","endpoint":"https://eigenswarm.com/api/eigens/ES-0cece3188602/agent-card"}],"active":true,"supportedTrust":["reputation"],"metadata":{"platform":"eigenswarm","eigenId":"ES-0cece3188602","chainId":143,"class":"sentinel","tokenAddress":"0x48579e58ecf1fa9d50fd3f973244f4ffe0107777","tokenSymbol":"TESTKEK"}}0xA770…3263
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