X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/d78978fe9a4dcfc9f5ff109adb4fca502ef1c105..1a35f270bc2cd8cee255d9553699b85145f04f0b:/Repository/SessionRepository.php diff --git a/Repository/SessionRepository.php b/Repository/SessionRepository.php index 2893d74..7c6f574 100644 --- a/Repository/SessionRepository.php +++ b/Repository/SessionRepository.php @@ -2070,7 +2070,7 @@ FROM ( d.l_previous, d.g_score, d.o_tr_ratio, - MAX(gu.group_id) AS group_id, + MAX(ug.group_id) AS group_id, d.remaining, d.premium, d.hotspot, @@ -2146,7 +2146,7 @@ FROM ( ORDER BY NULL LIMIT 0, :limit ) AS d - LEFT JOIN RapsysAirBundle:GroupUser AS gu ON (gu.user_id = d.user_id) + LEFT JOIN RapsysAirBundle:UserGroup AS ug ON (ug.user_id = d.user_id) GROUP BY d.id LIMIT 0, :limit ) AS e