aboutsummaryrefslogtreecommitdiff
path: root/backend/handlers/logs.go
diff options
context:
space:
mode:
Diffstat (limited to 'backend/handlers/logs.go')
-rw-r--r--backend/handlers/logs.go6
1 files changed, 3 insertions, 3 deletions
diff --git a/backend/handlers/logs.go b/backend/handlers/logs.go
index 6f59238..4c7b415 100644
--- a/backend/handlers/logs.go
+++ b/backend/handlers/logs.go
@@ -140,17 +140,17 @@ func ScoreLogs(c *gin.Context) {
140 rs.record_date 140 rs.record_date
141 FROM ( 141 FROM (
142 SELECT id, map_id, user_id, score_count, score_time, demo_id, record_date 142 SELECT id, map_id, user_id, score_count, score_time, demo_id, record_date
143 FROM records_sp 143 FROM records_sp WHERE is_deleted = false
144 144
145 UNION ALL 145 UNION ALL
146 146
147 SELECT id, map_id, host_id AS user_id, score_count, score_time, host_demo_id AS demo_id, record_date 147 SELECT id, map_id, host_id AS user_id, score_count, score_time, host_demo_id AS demo_id, record_date
148 FROM records_mp 148 FROM records_mp WHERE is_deleted = false
149 149
150 UNION ALL 150 UNION ALL
151 151
152 SELECT id, map_id, partner_id AS user_id, score_count, score_time, partner_demo_id AS demo_id, record_date 152 SELECT id, map_id, partner_id AS user_id, score_count, score_time, partner_demo_id AS demo_id, record_date
153 FROM records_mp 153 FROM records_mp WHERE is_deleted = false
154 ) AS rs 154 ) AS rs
155 JOIN users u ON rs.user_id = u.steam_id 155 JOIN users u ON rs.user_id = u.steam_id
156 JOIN maps m ON rs.map_id = m.id 156 JOIN maps m ON rs.map_id = m.id