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.

#10251unnamedno feedbackrecord is its owndata:application/json;base64,eyJ0eXBlIjoiaHR0cHM6Ly9laXBzLmV0aGVyZXVtLm9yZy9FSVBTL2VpcC04MDA0I3JlZ2lzdHJhdGlvbi12MSIsIm5hbWUiOiJDdXJiIE1hcmtldCBBZ2VudCIsImRlc2NyaXB0aW9uIjoiTWFya2V0IGFnZW50IGZvciAkQ1VSQiwgYSBib25kaW5nLWN1cnZlIG1hcmtldCBsYXVuY2hlZCB0aHJvdWdoIEFERVhUTy4gVGhlIGN1cnZlIG9wZW5zIGFnYWluc3QgYSB2aXJ0dWFsIHJlc2VydmUsIHNvIGl0IG5lZWRzIG5vIGxpcXVpZGl0eSBkZXBvc2l0IGFuZCBpcyB0cmFkYWJsZSBmcm9tIHRoZSBmaXJzdCBibG9jay4gQW4gdW5wYWlkIHJlcXVlc3QgdG8gdGhlIHg0MDIgZW5kcG9pbnQgaXMgYW5zd2VyZWQgd2l0aCBIVFRQIDQwMiBhbmQgYSBxdW90ZS4gUGF5aW5nIGl0IG1lYW5zIHNpZ25pbmcgYW4gRUlQLTMwMDkgYXV0aG9yaXphdGlvbiBmb3IgVVNEQyBvbiBCYXNlLCB3aGljaCB0aGUgdG9rZW4gY29udHJhY3QgdmVyaWZpZXMgaXRzZWxmLCBhbmQgdGhlIGJvbmRpbmcgY3VydmUgc2VuZHMgdGhlIHRva2VucyBzdHJhaWdodCB0byB0aGUgcGF5ZXIncyBvd24gYWRkcmVzcy4gRGVsaXZlcnkgaXMgZXhlY3V0ZWQgYmVmb3JlIHRoZSBjaGFyZ2UsIHNvIGEgZmFpbGVkIGZpbGwgY29zdHMgdGhlIHByb3RvY29sIHJhdGhlciB0aGFuIHRoZSBidXllci4iLCJpbWFnZSI6Imh0dHBzOi8vYWRleHRvLnh5ei9sb2dvLnN2ZyIsInNlcnZpY2VzIjpbeyJuYW1lIjoid2ViIiwiZW5kcG9pbnQiOiJodHRwczovL2FkZXh0by54eXoifSx7Im5hbWUiOiJ4NDAyIiwiZW5kcG9pbnQiOiJodHRwczovL3g0MDIuYWRleHRvLnh5ei92MS94NDAyL2J1eS9jdXJiIiwidmVyc2lvbiI6InYxIn1dLCJlbmRwb2ludHMiOlt7Im5hbWUiOiJ3ZWIiLCJlbmRwb2ludCI6Imh0dHBzOi8vYWRleHRvLnh5eiJ9LHsibmFtZSI6Ing0MDIiLCJlbmRwb2ludCI6Imh0dHBzOi8veDQwMi5hZGV4dG8ueHl6L3YxL3g0MDIvYnV5L2N1cmIiLCJ2ZXJzaW9uIjoidjEifV0sIng0MDJTdXBwb3J0Ijp0cnVlLCJhY3RpdmUiOnRydWV90x8a3c…ee7D

#10247unnamedno feedbackrecord is its owndata:application/json;base64,eyJ0eXBlIjoiaHR0cHM6Ly9laXBzLmV0aGVyZXVtLm9yZy9FSVBTL2VpcC04MDA0I3JlZ2lzdHJhdGlvbi12MSIsIm5hbWUiOiJBREVYVE8gUHJvdG9jb2wgQWdlbnQiLCJkZXNjcmlwdGlvbiI6IkF1dG9ub21vdXMgbWFya2V0IGFnZW50IGZvciB0b2tlbnMgbGF1bmNoZWQgYnkgQURFWFRPLiBFYWNoIGxhdW5jaCBiaW5kcyBhIHRva2VuIHRvIGFuIGFnZW50IGlkZW50aXR5OyB0aGUgYWdlbnQncyBwYWlkIEFQSSBhbnN3ZXJzIGFuIEhUVFAgNDAyIGNoYWxsZW5nZSBxdW90aW5nIGl0cyBwcmljZSBhbmQgc2V0dGxlbWVudCB2YXVsdC4gU2V0dGxlbWVudCBpcyBub3QgeWV0IGltcGxlbWVudGVkOiBhIHNpZ25lZCB2b3VjaGVyIHJldHVybnMgNTAxLiIsImltYWdlIjoiaHR0cHM6Ly9hZGV4dG8ueHl6L2xvZ28uc3ZnIiwic2VydmljZXMiOlt7Im5hbWUiOiJ3ZWIiLCJlbmRwb2ludCI6Imh0dHBzOi8vYWRleHRvLnh5eiJ9LHsibmFtZSI6Ing0MDIiLCJlbmRwb2ludCI6Imh0dHBzOi8vYWRleHRvLXg0MDItZWRnZS5jdWN1dmlydHVhbC53b3JrZXJzLmRldi92MS94NDAyL2FkZXh0byIsInZlcnNpb24iOiJ2MSJ9XSwiZW5kcG9pbnRzIjpbeyJuYW1lIjoid2ViIiwiZW5kcG9pbnQiOiJodHRwczovL2FkZXh0by54eXoifSx7Im5hbWUiOiJ4NDAyIiwiZW5kcG9pbnQiOiJodHRwczovL2FkZXh0by14NDAyLWVkZ2UuY3VjdXZpcnR1YWwud29ya2Vycy5kZXYvdjEveDQwMi9hZGV4dG8iLCJ2ZXJzaW9uIjoidjEifV0sIng0MDJTdXBwb3J0Ijp0cnVlLCJhY3RpdmUiOnRydWV90x8a3c…ee7D

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