From 6f28f28ecd899fd7f90df42528ef178a94f6677d Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sun, 24 Sep 2023 12:13:15 +0300
Subject: feat: removing (by flag) records (#56)

Former-commit-id: cc1bed84ee7ff9133192e1278c8315afee73d23a
---
 backend/handlers/home.go | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'backend/handlers/home.go')

diff --git a/backend/handlers/home.go b/backend/handlers/home.go
index c9742f2..5863218 100644
--- a/backend/handlers/home.go
+++ b/backend/handlers/home.go
@@ -49,11 +49,11 @@ func Rankings(c *gin.Context) {
 			SELECT
 			user_id,
 			MIN(score_count) AS min_score_count
-			FROM records_sp
+			FROM records_sp WHERE is_deleted = false
 			GROUP BY user_id, map_id
 			) AS subquery
 		WHERE user_id = u.steam_id) 
-	FROM records_sp sp JOIN users u ON u.steam_id = sp.user_id GROUP BY u.steam_id, u.user_name`
+	FROM records_sp sp JOIN users u ON u.steam_id = sp.user_id WHERE is_deleted = false GROUP BY u.steam_id, u.user_name`
 	rows, err := database.DB.Query(sql)
 	if err != nil {
 		c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
@@ -81,11 +81,11 @@ func Rankings(c *gin.Context) {
 			host_id,
 			partner_id,
 			MIN(score_count) AS min_score_count
-			FROM records_mp
+			FROM records_mp WHERE is_deleted = false
 			GROUP BY host_id, partner_id, map_id
 			) AS subquery
 		WHERE host_id = u.steam_id OR partner_id = u.steam_id) 
-	FROM records_mp mp JOIN users u ON u.steam_id = mp.host_id OR u.steam_id = mp.partner_id GROUP BY u.steam_id, u.user_name`
+	FROM records_mp mp JOIN users u ON u.steam_id = mp.host_id OR u.steam_id = mp.partner_id WHERE is_deleted = false GROUP BY u.steam_id, u.user_name`
 	rows, err = database.DB.Query(sql)
 	if err != nil {
 		c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
-- 
cgit v1.2.3