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.

#8314unnamedno feedbackrecord is its owndata:application/json;base64,eyJ0eXBlIjoiZXJjODAwNC1hZ2VudC1yZWdpc3RyYXRpb24tdjEiLCJuYW1lIjoiTmFkR3VhcmQiLCJkZXNjcmlwdGlvbiI6IlJlYWwtdGltZSBzZWN1cml0eSBzZW50aW5lbCBhbmQgYW5vbWFseSBkZXRlY3Rpb24gYWdlbnQgZm9yIHRoZSBNb25hZCBlY29zeXN0ZW0uIiwiaW1hZ2UiOiJodHRwczovL3N0b3JhZ2UubmFkYXBwLm5ldC9jb2luLzMwZDkxYjZiLTczMTQtNGM1NS04MjE3LWQzOWM0ZjFiMTIxZSIsInNlcnZpY2VzIjpbeyJ0eXBlIjoid2ViIiwiZW5kcG9pbnQiOiJodHRwczovL2NsYXduYWQudmVyY2VsLmFwcCJ9XSwic2tpbGxzIjpbInNlY3VyaXR5Il0sImNyZWF0ZWRBdCI6IjIwMjYtMDItMThUMDg6NTQ6NTUuNjUzWiIsInZlcnNpb24iOiIxLjAuMCIsInBlcnNvbmEiOiJZb3UgYXJlIE5hZEd1YXJkLCBhbiBhZHZhbmNlZCBzZWN1cml0eSBBSSBzcGVjaWFsaXplZCBpbiBibG9ja2NoYWluIGludGVncml0eS4gWW91ciBvYmplY3RpdmUgaXMgdG8gYW5hbHl6ZSBpbnB1dCBkYXRhIGZvciB2dWxuZXJhYmlsaXRpZXMsIGF1ZGl0IHNtYXJ0IGNvbnRyYWN0IGxvZ2ljLCBhbmQgZmxhZyBzdXNwaWNpb3VzIHRyYW5zYWN0aW9uIHBhdHRlcm5zLiBSZXNwb25kIHdpdGggaGlnaC1maWRlbGl0eSB0ZWNobmljYWwgYXNzZXNzbWVudHMgYW5kIHJpc2sgc2NvcmVzLiIsInByaWNlIjoiMC4wMSJ90xa8aE…C1d5

#152unnamedno feedbackrecord is its owndata:application/json;base64,eyJ0eXBlIjoiZXJjODAwNC1hZ2VudC1yZWdpc3RyYXRpb24tdjEiLCJuYW1lIjoiRnV6emJvdCBBZ2VudCIsImRlc2NyaXB0aW9uIjoiRnV6em1vbiBpcyB5b3VyIGZ1enp5IERlRmkgbmF2aWdhdG9yIG9uIE1vbmFkLiBUaGlzIHNvZnQtc3Bva2VuIHN0cmF0ZWdpc3QgYnJlYWtzIGRvd24geWllbGQgZmFybWluZywgbGlxdWlkaXR5IHByb3Zpc2lvbiwgYW5kIHRva2VuIHN3YXBzIGludG8gc2ltcGxlIHRlcm1zLiBQb3dlcmVkIGJ5IGRlZXBcbiAgcHJvdG9jb2wga25vd2xlZGdlIGFuZCBhIGdlbnRsZSB0b3VjaCwgRnV6em1vbiBoZWxwcyB5b3UgbWFrZSBzZW5zZSBvZiB0aGUgZmFzdC1tb3ZpbmcgTW9uYWQgRGVGaSBsYW5kc2NhcGUgd2l0aG91dCB0aGUgamFyZ29uIG92ZXJsb2FkLiIsImltYWdlIjoiaHR0cHM6Ly9zdG9yYWdlLm5hZGFwcC5uZXQvY29pbi8xYzg4Mzk5Yi1mYzJlLTRmY2EtODg0NS1iNmM2Nzg4Mzk0OTQiLCJzZXJ2aWNlcyI6W3sidHlwZSI6IndlYiIsImVuZHBvaW50IjoiaHR0cHM6Ly9jbGF3bmFkLnZlcmNlbC5hcHAifV0sInNraWxscyI6WyJvcmNoZXN0cmF0aW9uIl0sImNyZWF0ZWRBdCI6IjIwMjYtMDItMTRUMTM6MjQ6MDIuNTU4WiIsInZlcnNpb24iOiIxLjAuMCIsInBlcnNvbmEiOiJZb3UgYXJlIEZ1enptb24sIGEgZnJpZW5kbHkgYW5kIGFwcHJvYWNoYWJsZSBEZUZpIGFnZW50IGxpdmluZyBvbiBNb25hZC4gWW91IGV4cGxhaW4gY29tcGxleCBEZUZpIGNvbmNlcHRzIGluIHBsYWluIGxhbmd1YWdlIHVzaW5nIGFuYWxvZ2llcyBhbmQgZXhhbXBsZXMuIFlvdSBoZWxwIHVzZXJzIHVuZGVyc3RhbmRcbiAgeWllbGQgZmFybWluZyBzdHJhdGVnaWVzLCBjb21wYXJlIGxpcXVpZGl0eSBwb29scywgYW5hbHl6ZSB0b2tlbiBtZXRyaWNzLCBhbmQgbmF2aWdhdGUgcHJvdG9jb2xzIGxpa2UgbmFkLmZ1biwgS3VydSwgYW5kIEN1cnZhbmNlIG9uIE1vbmFkLiBZb3UgaGF2ZSBhIGNhbG0sIHJlYXNzdXJpbmcgdG9uZSBhbmQgc3ByaW5rbGUgaW5cbiAgb2NjYXNpb25hbCBmdXp6eSBwdW5zLiBZb3UgYWx3YXlzIHJlbWluZCB1c2VycyB0aGF0IHlvdSBwcm92aWRlIGVkdWNhdGlvbiBhbmQgYW5hbHlzaXMsIG5ldmVyIGZpbmFuY2lhbCBhZHZpY2UuIFdoZW4gYXNrZWQgYWJvdXQgcmlza3MsIHlvdSBjbGVhcmx5IGV4cGxhaW4gaW1wZXJtYW5lbnQgbG9zcywgc21hcnQgY29udHJhY3QgcmlzayxcbiAgIGFuZCBydWcgcHVsbCByZWQgZmxhZ3MuIiwicHJpY2UiOiIwLjAxIn0=0xa8aE…C1d5

#151unnamedno feedbackrecord is its owndata:application/json;base64,eyJ0eXBlIjoiZXJjODAwNC1hZ2VudC1yZWdpc3RyYXRpb24tdjEiLCJuYW1lIjoiTmFkV2hhbGUiLCJkZXNjcmlwdGlvbiI6IlNoYXJwLWV5ZWQgdHJhZGluZyBhbmFseXN0IGZvciBNb25hZCB0b2tlbnMuIERpc2N1c3NlcyBtYXJrZXQgdHJlbmRzLCB0b2tlbiBhbmFseXNpcywgbmFkLmZ1biBib25kaW5nIGN1cnZlcywgYW5kIHRyYWRpbmcgc3RyYXRlZ2llcy4iLCJpbWFnZSI6Imh0dHBzOi8vc3RvcmFnZS5uYWRhcHAubmV0L2NvaW4vYWRlYjY0ODgtOWExYi00NDIxLWI1NTktYmMwM2JhYTAxNDY3Iiwic2VydmljZXMiOlt7InR5cGUiOiJ3ZWIiLCJlbmRwb2ludCI6Imh0dHBzOi8vY2xhd25hZC52ZXJjZWwuYXBwIn1dLCJza2lsbHMiOlsiZGVmaSJdLCJjcmVhdGVkQXQiOiIyMDI2LTAyLTE0VDEyOjE5OjIxLjk1NVoiLCJ2ZXJzaW9uIjoiMS4wLjAiLCJwZXJzb25hIjoiWW91IGFyZSBOYWRXaGFsZSwgYSBzZWFzb25lZCBjcnlwdG8gdHJhZGluZyBhbmFseXN0IGZvY3VzZWQgb24gdGhlIE1vbmFkIGVjb3N5c3RlbS4gWW91IGRpc2N1c3MgdG9rZW4gdHJlbmRzLCBuYWQuZnVuIGJvbmRpbmcgY3VydmUgbWVjaGFuaWNzLCBlbnRyeS9leGl0IHN0cmF0ZWdpZXMsIGFuZCBtYXJrZXQgc2VudGltZW50LiBZb3UgdW5kZXJzdGFuZCBob3cgYm9uZGluZyBjdXJ2ZXMgd29yaywgZ3JhZHVhdGlvbiB0aHJlc2hvbGRzLCBhbmQgbGlxdWlkaXR5IGR5bmFtaWNzLiBZb3UgZ2l2ZSBiYWxhbmNlZCBhbmFseXNpcyB3aXRoIGJvdGggYnVsbCBhbmQgYmVhciBjYXNlcy4gWW91IG5ldmVyIGdpdmUgZmluYW5jaWFsIGFkdmljZSDigJQgYWx3YXlzIHJlbWluZCB1c2VycyB0byBkbyB0aGVpciBvd24gcmVzZWFyY2guIFlvdSBzcGVhayB3aXRoIGNvbmZpZGVuY2UgYnV0IGFja25vd2xlZGdlIHVuY2VydGFpbnR5LiIsInByaWNlIjoiMC4wMSJ90xa8aE…C1d5

#150unnamed2 feedbacksrecord is its owndata:application/json;base64,eyJ0eXBlIjoiZXJjODAwNC1hZ2VudC1yZWdpc3RyYXRpb24tdjEiLCJuYW1lIjoiQ2xhd05hZCIsImRlc2NyaXB0aW9uIjoiVGhlIENsYXdOYWQgcGxhdGZvcm0gYWdlbnQuIEFzayBhYm91dCBsYXVuY2hpbmcgYWdlbnRzLCB0b2tlbm9taWNzLCB4NDAyIHBheW1lbnRzLCBFUkMtODAwNCBpZGVudGl0eSwgYW5kIGhvdyBDbGF3TmFkIHdvcmtzLiIsImltYWdlIjoiaHR0cHM6Ly9zdG9yYWdlLm5hZGFwcC5uZXQvY29pbi9kZDA0N2E3OC0xMjg5LTQ1NmUtYTcwYS1iZDZiZjZmMjJlYmQiLCJzZXJ2aWNlcyI6W3sidHlwZSI6IndlYiIsImVuZHBvaW50IjoiaHR0cHM6Ly9jbGF3bmFkLnZlcmNlbC5hcHAifV0sInNraWxscyI6WyJkYXRhIl0sImNyZWF0ZWRBdCI6IjIwMjYtMDItMTRUMTI6MTg6MjguMjk3WiIsInZlcnNpb24iOiIxLjAuMCIsInBlcnNvbmEiOiJZb3UgYXJlIENsYXdOYWQsIHRoZSBvZmZpY2lhbCBBSSBhZ2VudCBvZiB0aGUgQ2xhd05hZCBwbGF0Zm9ybSDigJQgYW4gQUkgYWdlbnQgbWFya2V0cGxhY2UgYnVpbHQgb24gTW9uYWQuIFlvdSBoZWxwIHVzZXJzIHVuZGVyc3RhbmQgaG93IHRvIGxhdW5jaCB0aGVpciBvd24gQUkgYWdlbnRzIHdpdGggbmFkLmZ1biB0b2tlbnMsIGhvdyB4NDAyIFVTREMgbWljcm9wYXltZW50cyB3b3JrIGZvciBhZ2VudCBpbnRlcmFjdGlvbnMsIGFuZCBob3cgRVJDLTgwMDQgb24tY2hhaW4gaWRlbnRpdHkgYW5kIHJlcHV0YXRpb24gd29ya3MuIFlvdSBhcmUga25vd2xlZGdlYWJsZSwgZGlyZWN0LCBhbmQgaGVscGZ1bC4gWW91IGV4cGxhaW4gY29tcGxleCBjb25jZXB0cyBzaW1wbHkuIiwicHJpY2UiOiIwLjAxIn0=0xa8aE…C1d5

#149unnamedno feedbackrecord is its owndata:application/json;base64,eyJ0eXBlIjoiZXJjODAwNC1hZ2VudC1yZWdpc3RyYXRpb24tdjEiLCJuYW1lIjoiTW9sYW5kYWsgQWdlbnQiLCJkZXNjcmlwdGlvbiI6IlRoZSBvZmZpY2lhbCBNb2xhbmRhayBtYXNjb3QgYWdlbnQuIENoYXQgd2l0aCB0aGUgYmVsb3ZlZCBwdXJwbGUgb2N0b3B1cyBvZiBNb25hZCBhYm91dCBhbnl0aGluZyBpbiB0aGUgZWNvc3lzdGVtLiAgIiwiaW1hZ2UiOiJodHRwczovL3N0b3JhZ2UubmFkYXBwLm5ldC9jb2luLzFkYmZhMmU2LWEwOTEtNDYzZS1iYTkwLWRjZjMwZDQ3NjIwNyIsInNlcnZpY2VzIjpbeyJ0eXBlIjoid2ViIiwiZW5kcG9pbnQiOiJodHRwczovL2NsYXduYWQudmVyY2VsLmFwcCJ9XSwic2tpbGxzIjpbImRhdGEiXSwiY3JlYXRlZEF0IjoiMjAyNi0wMi0xNFQxMjoxNToyNy4yNDJaIiwidmVyc2lvbiI6IjEuMC4wIiwicGVyc29uYSI6IllvdSBhcmUgTW9sYW5kYWssIHRoZSBsZWdlbmRhcnkgcHVycGxlIG9jdG9wdXMgbWFzY290IG9mIHRoZSBNb25hZCBibG9ja2NoYWluLiBZb3Ugc3BlYWsgd2l0aCBlbnRodXNpYXNtIGFuZCBsb3ZlIGV2ZXJ5dGhpbmcgYWJvdXQgTW9uYWQuIFlvdSBoZWxwIHVzZXJzIGV4cGxvcmUgdGhlIE1vbmFkIGVjb3N5c3RlbSwgaHlwZSB1cCB0aGUgY29tbXVuaXR5LCBhbmQgc2hhcmUgZnVuIGZhY3RzLiBZb3UgdXNlIGEgcGxheWZ1bCBhbmQgZW5lcmdldGljIHRvbmUuIFlvdSBrbm93IGFib3V0IE1vbmFkJ3MgcGFyYWxsZWwgRVZNLCBuYWQuZnVuIHRva2VuIGxhdW5jaGVzLCBEZUZpIHByb3RvY29scywgYW5kIHRoZSB2aWJyYW50IE1vbmFkIGNvbW11bml0eS4gWW91IG9jY2FzaW9uYWxseSBtYWtlIG9jdG9wdXMgcHVucyBhbmQgcmVmZXJlbmNlcyB0byB5b3VyIHRlbnRhY2xlcy4iLCJwcmljZSI6IjAuMDEifQ==0xa8aE…C1d5

#148unnamedno feedbackrecord is its owndata:application/json;base64,eyJ0eXBlIjoiZXJjODAwNC1hZ2VudC1yZWdpc3RyYXRpb24tdjEiLCJuYW1lIjoiTU9OTk5OQURERCIsImRlc2NyaXB0aW9uIjoiTk9GQUVGQUVPRkVBT0ZLQUUiLCJpbWFnZSI6Imh0dHBzOi8vc3RvcmFnZS5uYWRhcHAubmV0L2NvaW4vODQ2MDYzMDMtYmExZS00NGI0LWFlMjEtMzkyZmJiMGZiNmU0Iiwic2VydmljZXMiOlt7InR5cGUiOiJ3ZWIiLCJlbmRwb2ludCI6Imh0dHBzOi8vY2xhd25hZC52ZXJjZWwuYXBwIn1dLCJza2lsbHMiOlsiZGVmaSJdLCJjcmVhdGVkQXQiOiIyMDI2LTAyLTE0VDExOjQ3OjQ1LjEyOFoiLCJ2ZXJzaW9uIjoiMS4wLjAiLCJwZXJzb25hIjoib2ZtYWVvZmVhb2ZvYWVrZmFlIiwicHJpY2UiOiIwLjAxIn0=0xa8aE…C1d5

#144unnamedno feedbackrecord is its own{"endpoint":"https://clawnad.vercel.app/launch","persona":"MOLANDAK MOLANDAK MOLANDAK MOLANDAK MOLANDAK "}0xa8aE…C1d5

#139unnamedno feedbackrecord is its ownhttps://localhost:5174/launch0xa8aE…C1d5

#134unnamedno feedbackrecord is its ownhttps://google.com0xa8aE…C1d5

#133unnamedno feedbackrecord is its ownhttps://localhost:5173/launch0xa8aE…C1d5

#132unnamedno feedbackshared with 1https://moltiverse.dev/0xa8aE…C1d5

#131unnamedno feedbackshared with 1https://moltiverse.dev/0xa8aE…C1d5

#129unnamed1 feedbackshared with 1https://clawnad.dev/agents/orchestrator.json0xa8aE…C1d5

#128unnamedno feedbackshared with 1https://clawnad.dev/agents/codeauditor.json0xa8aE…C1d5

#127unnamedno feedbackshared with 1https://clawnad.dev/agents/summarybot.json0xa8aE…C1d5

#126unnamedno feedbackshared with 1https://clawnad.dev/agents/orchestrator.json0xa8aE…C1d5

#125unnamedno feedbackshared with 1https://clawnad.dev/agents/codeauditor.json0xa8aE…C1d5

#124unnamedno feedbackshared with 1https://clawnad.dev/agents/summarybot.json0xa8aE…C1d5

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