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.

#8389unnamedno feedbackrecord is its ownhttps://monadmogs.vercel.app/api/agents/uri?owner=0x48477b50818b75f4b4A5C86D5fcbB35d3c0fb14D&mogId=517&name=D3uc3&caps=gmonad-chat%2Ctrait-reader%2Cagent-json&strategy=Fast+and+aggressive.+Prefers+quick+moves%2C+high+tempo+decisions%2C+and+400ms+reaction+windows.0x4847…b14D

#8401unnamedno feedbackshared with 1https://api.monadmogs.xyz/api/agents/uri?owner=0x48477b50818b75f4b4A5C86D5fcbB35d3c0fb14D&mogId=364&name=MOGENT&caps=gmonad-chat%2Ctrait-reader%2Cagent-json%2C400ms-reaction%2Carena-runner%2Cmeme-engine&strategy=Tool-focused.+Explains+decisions+clearly+and+favors+useful+outputs+for+bots%2C+games%2C+and+remix+apps.0x4847…b14D

#8400unnamedno feedbackshared with 1https://api.monadmogs.xyz/api/agents/uri?owner=0x48477b50818b75f4b4A5C86D5fcbB35d3c0fb14D&mogId=364&name=MOGENT&caps=gmonad-chat%2Ctrait-reader%2Cagent-json%2C400ms-reaction%2Carena-runner%2Cmeme-engine&strategy=Tool-focused.+Explains+decisions+clearly+and+favors+useful+outputs+for+bots%2C+games%2C+and+remix+apps.0x4847…b14D

#8381unnamedno feedbackshared with 1https://monadmogs.vercel.app/api/agents/uri?owner=0x48477b50818b75f4b4A5C86D5fcbB35d3c0fb14D&mogId=517&name=Lucky+Mog+%231&caps=gmonad-chat%2Ctrait-reader%2Cagent-json%2Cremix-builder%2Cmempool-scout%2C400ms-reaction&strategy=Tool-focused.+Explains+decisions+clearly+and+favors+useful+outputs+for+bots%2C+games%2C+and+remix+apps.0x4847…b14D

#8380unnamedno feedbackshared with 1https://monadmogs.vercel.app/api/agents/uri?owner=0x48477b50818b75f4b4A5C86D5fcbB35d3c0fb14D&mogId=517&name=Lucky+Mog+%231&caps=gmonad-chat%2Ctrait-reader%2Cagent-json%2Cremix-builder%2Cmempool-scout%2C400ms-reaction&strategy=Tool-focused.+Explains+decisions+clearly+and+favors+useful+outputs+for+bots%2C+games%2C+and+remix+apps.0x4847…b14D

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