Discourse Meta
Attempting to create Monthly Leaderboard query - head exploding
Gemeenschap
Gegevens en rapportage
sql-query
mcwumbly
(Dave McClure)
3 mei 2018 om 13:41
2
I think you just need to add a join in there:
left join b on b.user_id = users.id
bericht weergeven in topic
Gerelateerde topics
Topic
Antwoorden
Weergaven
Activiteit
The default badge queries
Data & reporting
reference
,
sql-triggered-badge
1
1148
27 augustus 2023
What is the bug reporter badge?
Data & reporting
sql-triggered-badge
33
10071
17 september 2023
Help finding some monthly site stats about topics and user trust levels
Data & reporting
sql-query
20
5921
20 december 2018
Badge for posts with Likes from a specific group
Data & reporting
sql-triggered-badge
22
1195
27 augustus 2023
Find the users which are more likely to become TL3
Data & reporting
trust-levels
,
sql-query
21
4864
12 februari 2026