X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/cc3ccf81c83b93069a350f327f6c4ee242d563e1..954ca125d28b5fd3437fc889ef32565ad36c3765:/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