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,H4sIABv2k2kAA61XzW7jNhC+71MI7jWRlHU2a+9tsWiBnlpgeysKYUyNZNYUqZKUE22Rd+9HyrFlxflxGh8kazg/nOHMN8N/PyTJzPctz74ks7X3rfuSZSxbl7Jfs+WuSY2ts59//f17IF8u8vz6J8u1dN6Sl0Zfbq9mF0GJpiYq+Wqt0cm3NBnIJTthZRtYw2pCmlT/g5OSPF0kDW34ArQy4TsWneekkpq0kKSSkoV0EHMXSSktC6/6RGrPloSXuk5upV8nK2XERqxJ6oSFcb3z3LjBsmyoPnILvKs0OOAE6ZTaNrvmnOYL5nz5+VNeLqr5VZ4vqs9X9OkmL69ExTcs6GZOYr7K82X+cVldV/NP8/lyuaCKl4v077YejDm2WynYwd6f+E6SENjw28flt6/ff4m8kcq6bA28Ge+vhkPdKhWmyajWXvSZIVdlB6Et2xCQILPN00WaH5bcRip1sB5pcF/7wlix5ofTyqxRXJBzstYNVvcKAns4GS8FqWLQljWEHMAj0iyTMxqBj+Ti1tiyaK1ZqYeAv0XNY/KbVNVsGva2f5Nw21kuok+mRXKFML3gkDAlBEdfXHhTlEYgzFg4X9qgPhr5I9o+3zQ3rSKP3DtD0vOdD5sOGs60ePh6U7hBNJabkDvbyXmvyPEgPaYGpChY11Izh/BmkfBPR0r6PuQyOzfN5dMyQjFNc6zkrWld0Sg8M6krSzjETviQFHGLoeImMrVBJQaYYsQPwZfhb9YaJUWPTGrbV/Fb6TbYUijGCjGann3TKS+LxpSkMupKacJ2gDAuBnF3fK5lFuuxmCZsHQFXpOsOCDCWGp3R4TxOEf+Xwgr4XMDhk16drW0HMYUzapouz+lC94qK9g0D2LeShIOWXtZnbQtJYWzIY6OxL1Q4b0OS9xqZ7KQb/MV57My8l9oX1t/LzEabW8UlhN5dtWNC75ntlP2171WladCvJ82Ky27Ilmz/b7yP0XKBKrbTLD0hjr14FIc2ytRHnYE127rPhteTCyhkDYenyLLjac0t2wINdtcxTrBYvG8JyQsgemxpKzEmBeUhZEJyQAShMLN4nMTw/bLAMXUAoHOlGtSZNwEkXyEpTgTzFKPrnMcZ00oGkB7zD/MdZhBdFqsOeYRkylakN5MNnOTbEV/Ld0R8UUjqLeak4Eixn+ZekkHakzzqVmsm5deCLGcNlxGDTmfhukOCoW6c6SxMZWsL1QMAHtmd8oVub3pmkND1p8PKlDv0G9ZuKNK4dSRjJf2zQpPv51gxl9tOxqg9xwZwlKFk4xbQchntdiojdYmssRj9Q+l1AVa72Lup80CMaZU9yY6GYaZBBNwAxo669KniVlyj24aeoRQuHBgxAt5hKjzO4YEtPp8gB9cH9Hu8fmhAD8gY3/cD56N7wzd4aZrnbw6VqYyglMLVCxcuTDkp5vMNrgspgp0Nhu7xjCA8G9/fIgwPZNe1rbGeyz8sbB7wGfxt58cHMBO2b725BB5o00jxQPbMl+Qxiu649xZDa9wGdzBbcaTcXecfdwZ35A/3/wGsFR1MjQ4AAA==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 ESCAPE '\' OR lower(a.owner) LIKE $3 ESCAPE '\' OR lower(coalesce(a."agentWallet",'')) LIKE $4 ESCAPE '\' OR lower(coalesce(a."tokenUri",'')) LIKE $5 ESCAPE '\' OR a."agentId"::text = $6)
ORDER BY coalesce(fb.evidence, 0) DESC, coalesce(r."memberCount", 1) ASC, a."agentId" DESC
LIMIT $7 OFFSET $8