SQL Queries for admins in Discourse
active 2023-08-17 → 2025-09-05 (UTC)
Activity over time
Daily event counts in the loaded window
Line chart, 751 days from 2023-08-17 to 2025-09-05. Pushes: 215 total, peak 8 in a day. Pull requests: 220 total, peak 7 in a day. Issues: 0 total, peak 0 in a day. Comments: 92 total, peak 9 in a day. Stars: 17 total, peak 1 in a day.
- Pushes
- Pull requests
- Issues
- Comments
- Stars
Stars, PRs, issues and forks are under-captured in the later part of this window. GH Archive progressively stopped capturing non-push events during 2026 — −95% or worse by the end of the window. Every series here except Pushes fades for that reason, so a decline above reflects the archive, not this repository. Pushes stay reliable throughout, so read them, and the contributor counts derived from them, as the real signal. Data health has the measurements.
Top contributors
Pushes, PRs, issues, reviews and comments — stars and forks excluded, so this is contribution rather than popularity
| Contributor | Contributions | Pushes | PRs | Comments |
|---|---|---|---|---|
| Lhcfl | 111 | 43 | 36 | 19 |
| CvX | 106 | 34 | 38 | 5 |
| martin-brennan | 73 | 21 | 14 | 19 |
| gschlager | 52 | 16 | 19 | 0 |
| jjaffeux | 39 | 3 | 2 | 12 |
| davidtaylorhq | 36 | 10 | 15 | 0 |
| dbattersby | 30 | 17 | 6 | 4 |
| tgxworld | 27 | 2 | 1 | 8 |
| nattsw | 27 | 15 | 7 | 3 |
| discourse-translator-bot | 22 | 6 | 16 | 0 |
| pento | 20 | 10 | 6 | 2 |
| Drenmi | 18 | 2 | 2 | 7 |
| ZogStriP | 15 | 1 | 1 | 1 |
| dependabot[bot] | 15 | 2 | 12 | 1 |
| janzenisaac | 14 | 6 | 7 | 0 |
| SamSaffron | 10 | 0 | 0 | 5 |
| tyb-talks | 10 | 2 | 6 | 0 |
| OsamaSayegh | 8 | 3 | 4 | 0 |
| renato | 8 | 2 | 4 | 1 |
| pmusaraj | 7 | 4 | 3 | 0 |
Recent activity
Latest issues, pull requests and releases
- Pull request#382davidtaylorhq2025-07-14 14:09
- Pull request#381Lhcfl2025-07-04 09:03
- Pull request#380tgxworld2025-07-03 03:32
- Pull request#380Lhcfl2025-07-02 18:38
- Pull request#379lis22025-06-11 04:28
- Issue comment#377yuriyaran2025-06-04 12:53UX: category-id-input: allows no-category selection
- Pull request#376CvX2025-05-26 20:55
- Pull request#374dependabot[bot]2025-05-08 14:53
- Pull request#373gschlager2025-05-07 13:17
- Pull request#373discourse-translator-bot2025-04-29 13:02
- Pull request#370gschlager2025-04-28 11:42
- Pull request#372dbattersby2025-04-28 08:12
- Pull request#372dbattersby2025-04-23 06:27
- Pull request#371lis22025-04-23 06:02
- Pull request#371lis22025-04-23 05:44
- Pull request#369dbattersby2025-04-18 11:50
- Pull request#369dbattersby2025-04-18 10:26
- Pull request#368CvX2025-04-09 12:23
- Pull request#368Flink2025-04-01 15:40
- Pull request#367tyb-talks2025-03-28 15:05
- Pull request#367tyb-talks2025-03-28 14:57
- Pull request#366davidtaylorhq2025-03-17 10:58
- Pull request#366CvX2025-03-14 23:26
- Pull request#365pento2025-03-14 03:17
- Pull request#365pento2025-03-14 03:05
Totals cover only the window loaded into ClickHouse and count events, not GitHub's lifetime totals — 17 stars here means stars gained during the window, not the repo's star count.