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.

#8unnamedno feedbackrecord is its owndata:application/json;enc=gzip;level=6;base64,H4sIAHXNhWkAA61XT2/bNhS/91MI3jW2lDhJ7d6KYAN2GFaguw2D8Ew9yZwpUiMpJ+rQ794fJceWFcWJ0/ggWY/v/3/+/yGKJr6pePIpmqy9r9ynOGZZuRn7NVuuy5mxRfzr71++BvB0kSTXv1gupPOWvDR6ur2cXAQmmsqWyWdrjY7uZlEHztgJK6uAGk4j0qSabxxl5OkiKmnDF4BlET+wqD1HudSkhSQVZSykA5m7iDJpWXjVRFJ7tiS81EV0L/06WikjNmJNUkcsjGuc59J1kmVJxZFZwF3NggFOkJ5RVcXXnNB8wZwsP94k2SKfXybJIv94STe3SXYpcr5lQbdzEvNVkiyTq2V+nc9v5vPlckE5Lxezf6uiE+bYbqVgB3l/4zuKgmPDb++XPz9//a3FbaGss8rAmr5+BQyqVzNhypgK7UUTG3J5fCDasg0OCTTbZLaYJYcjt5FKHaS3MJivfWqsWPNjtGJrFKfknCx0idM9g4AeIuOlIJV23OKSkAN4tDDL5IyG41twem9sllbWrNSjw9/C5in4TawKNiV727yJuKotp61NpkJyBTe9YJAwGQh7X5x6k2ZGwM04OJ/aoD5K+a2Vfb5oLitFHrl3BqXnBx+UDhzOlHj4epO7ATSWy5A720G8V+S4o+5DQ6dIWRdSMwf3xi3gv5qU9E3IZXZumMvjNEIxDXMs462pXFoqPGOpc0sIYi18SIpWxVBxA5rCoBJDm2L4D86X4W9cGSVFg0yqqlfhW+k2UCkUYw4fDWNf1srLtDQZqZjqTJqgDjqMa524C5+rmMW6T6YJqsPhinRRowP0qXoxOsRjDPhTDHP05xQGj1p1Nrddi0mdUcN0OcUL06tltB8Y6H0rSQi09LI4Sy0khbEhj42GXqhw3oYkbzQy2UnX2Yt47MS8F9sXzt9LzEabe8UZiN6dtWPC7JnsmP2zn1WZKTGvB8OKs7rLlnj/r69H7zhFFdthlo6QQxeP4tBGmeJoMrBmWzRx93r2AIWsYfCws+xwKnPPNsWA3U2MERSL9z0hedGInkraSqxJgXlwmZAcOoJQ2Fk8ItF9v0xwDO0a0LlUJerMm9AkX0EpRpw5huhq5xFjWsnQpPv43X6HHURn6apGHiGZ4hXpzUCBUbwd8LV4R8AXiaTeYk8KhqT7be4lGqQ9yaNptWZSfi3Iclxy1vag8Sxc10gw1I0ztYWoeG3BumuAR3KHeGHam4YZIEz94bIyxA7zhrXrirRVHcmYS3+SaPB9ChV7ua1l67VTaGiOMpRsqwJGLmPcDmmkzpA1Fqt/KL06tNW6nd1Ue3SMYZU9i46BYYZORLtBGzua0mPFrbjAtA0zQylcOLBihH6HrfA4hzu09vkMOJjedb+n54cB9NgZ2/f3DvPJveGPuy+nrw0ULly4ZmG3CZe20evCVXJ1M01up5eLTuhzwu7gUlOelpeb3Aia9cXiMrCBsBkiG+8E4Nl2/En/stj2/A7s6qoy1nP2l4XMwzAAflX7frQnwjaVN1M0H21KKR7BnnlKHnvvDnsvMczhbTAHixy3kIfr5GoncAf+8P0HKc0IPvoOAAA=0x6446…d161

#1unnamed1 feedbackno documentno tokenURI0x6446…d161

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