From 85e3d49aa800d5e289f376023173847e0a2077f0 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Gertz?= <git@rapsys.eu>
Date: Sun, 7 Apr 2024 03:55:22 +0200
Subject: [PATCH] Fix subscribed key name

---
 Repository/SessionRepository.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/Repository/SessionRepository.php b/Repository/SessionRepository.php
index d44db55..e264552 100644
--- a/Repository/SessionRepository.php
+++ b/Repository/SessionRepository.php
@@ -976,9 +976,9 @@ SQL;
 
 		//Set the request
 		$req = <<<SQL
-SELECT us.user_id
+SELECT us.subscribed_id
 FROM Rapsys\AirBundle\Entity\UserSubscription AS us
-WHERE us.subscriber_id = :uid
+WHERE us.user_id = :uid
 SQL;
 
 		//Replace bundle entity name by table name
@@ -988,7 +988,7 @@ SQL;
 		$rsm = new ResultSetMapping();
 
 		//Declare user id field
-		$rsm->addScalarResult('user_id', 'user_id', 'integer');
+		$rsm->addScalarResult('subscribed_id', 'subscribed_id', 'integer');
 
 		//Set subscription sql part
 		$subscriptionSql = '';
-- 
2.41.1