diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-06-29 13:41:47 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-06-29 13:41:47 +0300 |
| commit | 211f1b48372c0c1885141d1ab214ab7418520008 (patch) | |
| tree | 209ccb52b86072e9ff45f3135f83a0d27b0344aa /backend/controllers/mapController.go | |
| parent | feat: support for multiple route edit, image field (diff) | |
| download | lphub-211f1b48372c0c1885141d1ab214ab7418520008.tar.gz lphub-211f1b48372c0c1885141d1ab214ab7418520008.tar.bz2 lphub-211f1b48372c0c1885141d1ab214ab7418520008.zip | |
fix: map summary sql
Former-commit-id: 3edddea55add68a877d2dbdfcaf3e83f774da775
Diffstat (limited to '')
| -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 { |