every registered agent, filterable by what shares its record

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.

10,426 matching agents · page 146 of 174

#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