X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/200af578afb1727f3a69cacba536c9ef73456bb1..b55e9a8e7d1e5d43380d650129737dca42907375:/Repository/LocationRepository.php diff --git a/Repository/LocationRepository.php b/Repository/LocationRepository.php index f5efbc6..129a176 100644 --- a/Repository/LocationRepository.php +++ b/Repository/LocationRepository.php @@ -148,7 +148,7 @@ ORDER BY '.(!empty($userId)?'COUNT(a.id) DESC, ':'').'COUNT(s.id) DESC, l.id' ]; //Set the request - $req = 'SELECT l.id, l.title, l.short + $req = 'SELECT l.id, l.title FROM RapsysAirBundle:UserLocation AS ul JOIN RapsysAirBundle:Location AS l ON (l.id = ul.location_id) WHERE ul.user_id = :uid'; @@ -164,7 +164,6 @@ WHERE ul.user_id = :uid'; $rsm->addEntityResult('RapsysAirBundle:Location', 'l'); $rsm->addFieldResult('l', 'id', 'id'); $rsm->addFieldResult('l', 'title', 'title'); - $rsm->addFieldResult('l', 'short', 'short'); //Send result return $em