From 211f1b48372c0c1885141d1ab214ab7418520008 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Thu, 29 Jun 2023 13:41:47 +0300
Subject: fix: map summary sql

Former-commit-id: 3edddea55add68a877d2dbdfcaf3e83f774da775
---
 backend/controllers/mapController.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'backend/controllers/mapController.go')

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) {
     INNER JOIN categories c ON r.category_id = c.id
     INNER JOIN map_history h ON r.map_id = h.map_id AND r.category_id = h.category_id
     LEFT JOIN map_ratings rt ON r.map_id = rt.map_id AND r.category_id = rt.category_id 
-	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
+	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
 	ORDER BY h.record_date ASC;`
 	rows, err := database.DB.Query(sql, id)
 	if err != nil {
-- 
cgit v1.2.3