From 56ca08d83dce247073ddc90be1f01e8a57ddea5e Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Wed, 12 Jul 2023 12:09:39 +0300
Subject: fix: sql typo

Former-commit-id: a86ddf35ba75a5940575df760ee705473542fd38
---
 backend/controllers/modController.go | 5 +----
 1 file changed, 1 insertion(+), 4 deletions(-)

(limited to 'backend/controllers')

diff --git a/backend/controllers/modController.go b/backend/controllers/modController.go
index d6dc4d4..ff79e3e 100644
--- a/backend/controllers/modController.go
+++ b/backend/controllers/modController.go
@@ -144,10 +144,7 @@ func EditMapSummary(c *gin.Context) {
 	defer tx.Rollback()
 	// Fetch route category and score count
 	var categoryID, scoreCount int
-	sql := `SELECT mr.category_id, mr.score_count
-		FROM map_routes mr
-		INNER JOIN maps m
-		WHERE m.id = $1 AND mr.id = $2`
+	sql := `SELECT mr.category_id, mr.score_count FROM map_routes mr INNER JOIN maps m ON m.id = mr.map_id WHERE m.id = $1 AND mr.id = $2`
 	err = database.DB.QueryRow(sql, mapID, request.RouteID).Scan(&categoryID, &scoreCount)
 	if err != nil {
 		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
-- 
cgit v1.2.3