[{"_1":2,"_251":-5,"_252":-5},"loaderData",{"_3":4,"_91":92,"_238":239,"_250":-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,"_233":-5,"_234":-5,"_235":236,"_129":130,"_137":138,"_100":101,"_98":99,"_117":-7,"_50":51,"_237":26},"type","val","author","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18",{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":-5,"_107":108,"_109":110,"_111":26,"_112":110,"_113":114,"_115":116,"_117":118,"_119":26,"_120":121,"_122":121,"_123":31,"_124":121,"_125":31,"_126":31,"_127":-5,"_20":128,"_133":-5,"_134":-7,"_135":136,"_137":138,"_139":140},"name","prolific","valNameId","9a05f6bc-d2bb-11ef-9636-e6cdfca9ef9f","parentFolderId","isOwned","privacy","public","readme","valType","http","currentVersion","0caf6dd0-d2bf-11ef-946c-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	Username	Public Vals

\n \n \n \n `;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}","createdAt",["D",1736890346498],"version",23,"currentUserHasLiked","likeCount",1,"forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","stevekrouse","profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","forkedVal","interval","slug","stevekrouse/prolific","description","An interactive, runnable TypeScript val by stevekrouse","versions",[141,144,148,152,156,160,164,168,172,176,180,184,188,192,196,200,204,208,212,216,220,224,227,230],{"_117":118,"_142":-5,"_115":143,"_112":110},"prId",["D",1736890346498],{"_117":145,"_142":-5,"_115":146,"_112":147},22,["D",1736890271995],"e0482b6a-d2be-11ef-a749-e6cdfca9ef9f",{"_117":149,"_142":-5,"_115":150,"_112":151},21,["D",1736890167586],"a20caace-d2be-11ef-8008-e6cdfca9ef9f",{"_117":153,"_142":-5,"_115":154,"_112":155},20,["D",1736890135984],"8f364d74-d2be-11ef-9d28-e6cdfca9ef9f",{"_117":157,"_142":-5,"_115":158,"_112":159},19,["D",1736890094512],"767d7afa-d2be-11ef-a3e8-e6cdfca9ef9f",{"_117":161,"_142":-5,"_115":162,"_112":163},18,["D",1736890089218],"7354b6fe-d2be-11ef-a489-e6cdfca9ef9f",{"_117":165,"_142":-5,"_115":166,"_112":167},17,["D",1736890035069],"531734d4-d2be-11ef-a5d4-e6cdfca9ef9f",{"_117":169,"_142":-5,"_115":170,"_112":171},16,["D",1736889965136],"29600ada-d2be-11ef-aca5-e6cdfca9ef9f",{"_117":173,"_142":-5,"_115":174,"_112":175},15,["D",1736889954586],"23187518-d2be-11ef-8330-e6cdfca9ef9f",{"_117":177,"_142":-5,"_115":178,"_112":179},14,["D",1736889902255],"03e8c242-d2be-11ef-8ed7-e6cdfca9ef9f",{"_117":181,"_142":-5,"_115":182,"_112":183},13,["D",1736889894277],"ff24dcb4-d2bd-11ef-a3d8-e6cdfca9ef9f",{"_117":185,"_142":-5,"_115":186,"_112":187},12,["D",1736889879408],"f6478e34-d2bd-11ef-9354-e6cdfca9ef9f",{"_117":189,"_142":-5,"_115":190,"_112":191},11,["D",1736889852150],"e6079f78-d2bd-11ef-93d8-e6cdfca9ef9f",{"_117":193,"_142":-5,"_115":194,"_112":195},10,["D",1736889814500],"cf968092-d2bd-11ef-b1e1-e6cdfca9ef9f",{"_117":197,"_142":-5,"_115":198,"_112":199},9,["D",1736889753297],"ab1b8fb4-d2bd-11ef-b258-e6cdfca9ef9f",{"_117":201,"_142":-5,"_115":202,"_112":203},8,["D",1736889706987],"8f81e802-d2bd-11ef-97d7-e6cdfca9ef9f",{"_117":205,"_142":-5,"_115":206,"_112":207},7,["D",1736889696949],"89861b1c-d2bd-11ef-b46e-e6cdfca9ef9f",{"_117":209,"_142":-5,"_115":210,"_112":211},6,["D",1736889595703],"4d2c320a-d2bd-11ef-bbbc-e6cdfca9ef9f",{"_117":213,"_142":-5,"_115":214,"_112":215},5,["D",1736889054990],"0ae3762a-d2bc-11ef-8084-e6cdfca9ef9f",{"_117":217,"_142":-5,"_115":218,"_112":219},4,["D",1736888935693],"c3c7d060-d2bb-11ef-8c62-e6cdfca9ef9f",{"_117":221,"_142":-5,"_115":222,"_112":223},3,["D",1736888928747],"bfa2de12-d2bb-11ef-b438-e6cdfca9ef9f",{"_117":90,"_142":-5,"_115":225,"_112":226},["D",1736888922073],"bba8da00-d2bb-11ef-9d25-e6cdfca9ef9f",{"_117":121,"_142":-5,"_115":228,"_112":229},["D",1736888913894],"b6c977c4-d2bb-11ef-89b7-e6cdfca9ef9f",{"_117":31,"_142":-5,"_115":231,"_112":232},["D",1736888865650],"9a088936-d2bb-11ef-9636-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":240,"_241":242,"_94":243},"single","redirect","/v/stevekrouse/prolific/versions",{"_112":151,"_113":244,"_117":149,"_115":245,"_246":99,"_100":101,"_107":108,"_129":130,"_11":96,"_247":-5,"_248":-5,"_249":-5,"_237":26,"_135":136},"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 \n ${index + 1}\n ${row[0]}\n ${row[1]}\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",1736890167586],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

prolific

Version 21