diff options
Diffstat (limited to 'backend/controllers/mapController.go')
| -rw-r--r-- | backend/controllers/mapController.go | 2 |
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 { |