[{"_1":2,"_169":-5,"_170":-5},"loaderData",{"_3":4,"_91":92,"_156":157,"_168":-5},"root",{"_5":6,"_32":33,"_58":59,"_89":90},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":29,"_30":31},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","fa80b67e1f763bfb4b247c3f5ca4f0b0730f3f5c","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","API_URL","https://api.val.town","WORKER_FINGERPRINT","799d99f2805306c2714a7cfefbeae178","clerkState",{"_60":61},"__internal_clerk_state",{"_62":63,"_64":43,"_65":66,"_67":66,"_68":26,"_69":66,"_70":66,"_71":66,"_72":66,"_73":66,"_74":66,"_75":66,"_76":66,"_77":78,"_87":26,"_88":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_79":26,"_80":66,"_81":82,"_83":66,"_84":43,"_85":26,"_86":66},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_93":94,"_95":96,"_94":97,"_151":-5,"_152":-5,"_153":154,"_128":129,"_141":142,"_100":101,"_98":99,"_117":-7,"_50":51,"_155":26},"type","val","author","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185",{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":66,"_107":108,"_109":110,"_111":26,"_112":110,"_113":114,"_115":116,"_117":118,"_119":26,"_120":31,"_121":31,"_122":31,"_123":118,"_124":31,"_125":31,"_126":-5,"_20":127,"_132":133,"_138":-7,"_139":140,"_141":142,"_143":144},"name","prolific","valNameId","37fada2a-e9a7-11ef-9947-e6cdfca9ef9f","parentFolderId","isOwned","privacy","public","readme","valType","http","currentVersion","5005d732-e9a7-11ef-9dd1-e6cdfca9ef9f","legacyPrivate","id","code","import { db } from \"https://esm.town/v/sqlite/db\";\n\nexport default async function(): Promise {\n const res = await db.execute(\n `SELECT author_username, count(*) as count\n FROM vals \n GROUP BY author_username\n ORDER BY count DESC\n LIMIT 100\n `,\n );\n\n const tableRows = res.rows.map((row, index) => {\n const username = row[0];\n const truncatedUsername = username.length > 13 ? username.slice(0, 13) + \"...\" : username;\n return `\n \n ${index + 1}\n \n \n ${truncatedUsername}\n \n \n ${row[1]}\n \n `;\n }).join(\"\");\n\n const html = `\n \n \n \n \n \n Most prolific Val Town users\n \n \n \n \n \n

Most Prolific Val Town Users

\n \n \n \n \n \n \n \n \n \n ${tableRows}\n \n

Rank	\n Username\n \n	\n Public Vals\n \n

\n \n \n \n \n `;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}","createdAt",["D",1739409028286],"version",1,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","nbbaier","profileImageUrl","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","forkedVal",{"_112":134,"_128":135,"_98":99,"_117":136,"_137":-5},"0caf6dd0-d2bf-11ef-946c-e6cdfca9ef9f","stevekrouse",23,"prDisabledHint","interval","slug","nbbaier/prolific","description","An interactive, runnable TypeScript val by nbbaier","versions",[145,148],{"_117":118,"_146":-5,"_115":147,"_112":110},"prId",["D",1739409028286],{"_117":31,"_146":-5,"_115":149,"_112":150},["D",1739408987965],"380e6cc0-e9a7-11ef-9947-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":158,"_159":160,"_94":161},"single","redirect","/v/nbbaier/prolific/versions",{"_112":150,"_113":162,"_117":31,"_115":163,"_164":99,"_100":101,"_107":108,"_128":129,"_11":96,"_165":-5,"_166":-5,"_167":-5,"_155":26,"_139":140},"import { db } from \"https://esm.town/v/sqlite/db\";\n\nexport default async function(): Promise {\n const res = await db.execute(\n `SELECT author_username, count(*) as count\n FROM vals \n GROUP BY author_username\n ORDER BY count DESC\n LIMIT 100\n `,\n );\n\n const tableRows = res.rows.map((row, index) => {\n const username = row[0];\n const truncatedUsername = username.length > 13 ? username.slice(0, 13) + \"...\" : username;\n return `\n \n ${index + 1}\n \n \n ${truncatedUsername}\n \n \n ${row[1]}\n \n `;\n }).join(\"\");\n\n const html = `\n \n \n \n \n \n Most prolific Val Town users\n \n \n \n \n \n

Most Prolific Val Town Users

\n \n \n \n \n \n \n \n \n \n ${tableRows}\n \n

Rank	Username	Public Vals

\n \n \n \n `;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}",["D",1739408987965],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

prolific

Version 0