aboutsummaryrefslogtreecommitdiff
path: root/backend/controllers
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--backend/controllers/mapController.go2
1 files changed, 1 insertions, 1 deletions
diff --git a/backend/controllers/mapController.go b/backend/controllers/mapController.go
index 7dfd2be..7a26554 100644
--- a/backend/controllers/mapController.go
+++ b/backend/controllers/mapController.go
@@ -43,7 +43,7 @@ func FetchMapSummary(c *gin.Context) {
43 INNER JOIN categories c ON r.category_id = c.id 43 INNER JOIN categories c ON r.category_id = c.id
44 INNER JOIN map_history h ON r.map_id = h.map_id AND r.category_id = h.category_id 44 INNER JOIN map_history h ON r.map_id = h.map_id AND r.category_id = h.category_id
45 LEFT JOIN map_ratings rt ON r.map_id = rt.map_id AND r.category_id = rt.category_id 45 LEFT JOIN map_ratings rt ON r.map_id = rt.map_id AND r.category_id = rt.category_id
46 WHERE r.map_id = $1 AND h.score_count = r.score_count GROUP BY c.id, h.user_name, h.score_count, h.record_date, r.description, r.showcase 46 WHERE r.map_id = $1 AND h.score_count = r.score_count GROUP BY r.id, c.id, h.user_name, h.score_count, h.record_date, r.description, r.showcase
47 ORDER BY h.record_date ASC;` 47 ORDER BY h.record_date ASC;`
48 rows, err := database.DB.Query(sql, id) 48 rows, err := database.DB.Query(sql, id)
49 if err != nil { 49 if err != nil {