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.
#1944unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xB8D9…0693
#1943unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8505…c586
#1942unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE1fb…3745
#1941unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA6f9…8EbA
#1940unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE806…3816
#1939unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x46d4…f2BC
#1938unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9b70…A184
#1937unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x63c0…1a9E
#1936unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7337…bF87
#1935unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE033…B60a
#1934unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdbE1…1CEf
#1933unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x45AF…DA39
#1932unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xda4C…2761
#1931unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xC841…26e1
#1930unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8Be4…D756
#1929unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3bA1…Fcf2
#1928unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6f3E…07a9
#1927unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9444…0a4A
#1926unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5ff2…D5aC
#1925unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x754f…e859
#1924unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x023a…61e3
#1923unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA4cB…157B
#1922unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x73Ee…1b97
#1921unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x2957…6315
#1920unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4785…6662
#1919unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x6934…265E
#1918unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAE94…650F
#1917unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xdCB8…7a54
#1916unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4F3c…e750
#1915unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9f2c…3186
#1914unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF6f5…35EF
#1913unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd36b…00c8
#1912unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA612…0951
#1911unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x7Aa4…aF5D
#1910unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xF097…d907
#1909unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x206F…3f9D
#1908unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x0E35…3226
#1907unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3119…9CfD
#1906unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x759D…488B
#1905unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x4689…795c
#1904unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9367…2b52
#1903unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDE3a…17f4
#1902unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xA759…1D40
#1901unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xAFa6…9822
#1900unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x329a…133d
#1899unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5Bef…2b9B
#1898unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xce89…2B4a
#1897unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1581…9C8f
#1896unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x8c9A…3c36
#1895unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x3607…d7b1
#1894unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xd0B0…d45d
#1893unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x09D6…3606
#1892unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x5652…B993
#1891unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x395b…3c22
#1890unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1B80…cd1c
#1889unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xDfC4…7F09
#1888unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x107A…D1Dd
#1887unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0xE4AC…f4Be
#1886unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x1C29…AD76
#1885unnamedno feedbackshared with 8,092https://eve-8004.vercel.app/metadata/b.json0x9Fe6…aA75
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
ORDER BY coalesce(fb.evidence, 0) DESC, coalesce(r."memberCount", 1) ASC, a."agentId" DESC
LIMIT $2 OFFSET $3