X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/f338800ff68dbc6a872e9d428c37cb6a6fd1773d..85ef482b73d65d8c60d7091b79db19da39dcb594:/Repository/SessionRepository.php?ds=sidebyside

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 = '';