{"params":{},"requestedAt":"2026-07-24T02:54:33.442+00:00","finishedAt":"2026-07-24T02:54:33.471+00:00","spent":0.029,"sql":"WITH top_10_collections AS (\n\tSELECT c.id, c.name, c.past_month_visits\n\tFROM collections c\n\tORDER BY c.past_month_visits DESC\n\tLIMIT 10\n)\nSELECT *\nFROM (\n\tSELECT\n\t\ttc.id,\n\t\ttc.name,\n\t\ttc.past_month_visits AS visits,\n\t\tci.repo_id,\n\t\tci.repo_name,\n\t\tROW_NUMBER() OVER (PARTITION BY ci.collection_id ORDER BY IFNULL(ci.last_month_rank, 999999)) AS `rank`,\n\t\tci.last_month_rank,\n\t\tci.last_2nd_month_rank,\n\t\t(ci.last_2nd_month_rank - ci.last_month_rank) AS rank_changes,\n\t\tCOUNT(*) OVER (PARTITION BY ci.collection_id) AS repos\n\tFROM collection_items ci\n\tJOIN top_10_collections tc ON ci.collection_id = tc.id\n) sub\nWHERE `rank` <= 3\nORDER BY visits DESC;\n","fields":[{"name":"id","columnType":8},{"name":"name","columnType":253},{"name":"visits","columnType":3},{"name":"repo_id","columnType":8},{"name":"repo_name","columnType":253},{"name":"rank","columnType":8},{"name":"last_month_rank","columnType":3},{"name":"last_2nd_month_rank","columnType":3},{"name":"rank_changes","columnType":8},{"name":"repos","columnType":8}],"data":[{"id":2,"name":"Open Source Database","visits":1796,"repo_id":208728772,"repo_name":"milvus-io/milvus","rank":1,"last_month_rank":1,"last_2nd_month_rank":5,"rank_changes":4,"repos":40},{"id":2,"name":"Open Source Database","visits":1796,"repo_id":138754790,"repo_name":"duckdb/duckdb","rank":2,"last_month_rank":2,"last_2nd_month_rank":1,"rank_changes":-1,"repos":40},{"id":2,"name":"Open Source Database","visits":1796,"repo_id":60246359,"repo_name":"ClickHouse/ClickHouse","rank":3,"last_month_rank":3,"last_2nd_month_rank":2,"rank_changes":-1,"repos":40},{"id":10013,"name":"Game Engine","visits":297,"repo_id":234798675,"repo_name":"bevyengine/bevy","rank":3,"last_month_rank":3,"last_2nd_month_rank":2,"rank_changes":-1,"repos":72},{"id":10013,"name":"Game Engine","visits":297,"repo_id":11007313,"repo_name":"BabylonJS/Babylon.js","rank":2,"last_month_rank":2,"last_2nd_month_rank":5,"rank_changes":3,"repos":72},{"id":10013,"name":"Game Engine","visits":297,"repo_id":15634981,"repo_name":"godotengine/godot","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":72},{"id":1,"name":"Static Site Generator","visits":110,"repo_id":70107786,"repo_name":"vercel/next.js","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":35},{"id":1,"name":"Static Site Generator","visits":110,"repo_id":348060227,"repo_name":"withastro/astro","rank":2,"last_month_rank":2,"last_2nd_month_rank":2,"rank_changes":0,"repos":35},{"id":1,"name":"Static Site Generator","visits":110,"repo_id":94911145,"repo_name":"facebook/docusaurus","rank":3,"last_month_rank":3,"last_2nd_month_rank":4,"rank_changes":1,"repos":35},{"id":10001,"name":"CSS Framework","visits":103,"repo_id":106017343,"repo_name":"tailwindlabs/tailwindcss","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":8},{"id":10001,"name":"CSS Framework","visits":103,"repo_id":2126244,"repo_name":"twbs/bootstrap","rank":2,"last_month_rank":2,"last_2nd_month_rank":2,"rank_changes":0,"repos":8},{"id":10001,"name":"CSS Framework","visits":103,"repo_id":50264296,"repo_name":"jgthms/bulma","rank":3,"last_month_rank":3,"last_2nd_month_rank":3,"rank_changes":0,"repos":8},{"id":10010,"name":"Artificial Intelligence","visits":102,"repo_id":65600975,"repo_name":"pytorch/pytorch","rank":3,"last_month_rank":3,"last_2nd_month_rank":4,"rank_changes":1,"repos":36},{"id":10010,"name":"Artificial Intelligence","visits":102,"repo_id":458588993,"repo_name":"nebuly-ai/optimate","rank":2,"last_month_rank":2,"last_2nd_month_rank":2,"rank_changes":0,"repos":36},{"id":10010,"name":"Artificial Intelligence","visits":102,"repo_id":155220641,"repo_name":"huggingface/transformers","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":36},{"id":10004,"name":"Web Framework","visits":96,"repo_id":20904437,"repo_name":"gin-gonic/gin","rank":3,"last_month_rank":3,"last_2nd_month_rank":3,"rank_changes":0,"repos":63},{"id":10004,"name":"Web Framework","visits":96,"repo_id":80945428,"repo_name":"nestjs/nest","rank":2,"last_month_rank":2,"last_2nd_month_rank":2,"rank_changes":0,"repos":63},{"id":10004,"name":"Web Framework","visits":96,"repo_id":331293626,"repo_name":"refinedev/refine","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":63},{"id":10027,"name":"Testing Tools","visits":90,"repo_id":90796663,"repo_name":"puppeteer/puppeteer","rank":2,"last_month_rank":2,"last_2nd_month_rank":2,"rank_changes":0,"repos":24},{"id":10027,"name":"Testing Tools","visits":90,"repo_id":221981891,"repo_name":"microsoft/playwright","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":24},{"id":10027,"name":"Testing Tools","visits":90,"repo_id":31629751,"repo_name":"cypress-io/cypress","rank":3,"last_month_rank":3,"last_2nd_month_rank":4,"rank_changes":1,"repos":24},{"id":10018,"name":"APM Tool","visits":88,"repo_id":45721011,"repo_name":"apache/skywalking","rank":2,"last_month_rank":2,"last_2nd_month_rank":3,"rank_changes":1,"repos":13},{"id":10018,"name":"APM Tool","visits":88,"repo_id":56342508,"repo_name":"jaegertracing/jaeger","rank":3,"last_month_rank":3,"last_2nd_month_rank":2,"rank_changes":-1,"repos":13},{"id":10019,"name":"React Framework","visits":88,"repo_id":70107786,"repo_name":"vercel/next.js","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":11},{"id":10019,"name":"React Framework","visits":88,"repo_id":331293626,"repo_name":"refinedev/refine","rank":2,"last_month_rank":2,"last_2nd_month_rank":2,"rank_changes":0,"repos":11},{"id":10019,"name":"React Framework","visits":88,"repo_id":94911145,"repo_name":"facebook/docusaurus","rank":3,"last_month_rank":3,"last_2nd_month_rank":3,"rank_changes":0,"repos":11},{"id":10018,"name":"APM Tool","visits":88,"repo_id":326404870,"repo_name":"signoz/signoz","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":13},{"id":10029,"name":"Cross Platform GUI Tool","visits":88,"repo_id":196701619,"repo_name":"tauri-apps/tauri","rank":1,"last_month_rank":1,"last_2nd_month_rank":1,"rank_changes":0,"repos":12},{"id":10029,"name":"Cross Platform GUI Tool","visits":88,"repo_id":31792824,"repo_name":"flutter/flutter","rank":2,"last_month_rank":2,"last_2nd_month_rank":2,"rank_changes":0,"repos":12},{"id":10029,"name":"Cross Platform GUI Tool","visits":88,"repo_id":29028775,"repo_name":"facebook/react-native","rank":3,"last_month_rank":3,"last_2nd_month_rank":3,"rank_changes":0,"repos":12}],"expiresAt":"2026-07-25T02:54:33.471+00:00","refresh":true}