X-Git-Url: https://git.rapsys.eu/blogbundle/blobdiff_plain/d35d293c7ae158d46716f3d98ce96d259114cb90..c82e4952bcd9c5f4c638bb67b54ac7dcbe9cec3d:/Repository/KeywordRepository.php diff --git a/Repository/KeywordRepository.php b/Repository/KeywordRepository.php index f531711..4bd8aa8 100644 --- a/Repository/KeywordRepository.php +++ b/Repository/KeywordRepository.php @@ -72,7 +72,7 @@ SELECT FROM RapsysBlogBundle:Keyword AS k JOIN RapsysBlogBundle:KeywordTranslation AS kt ON (kt.keyword_id = k.id AND kt.locale = :locale) GROUP BY k.id -ORDER BY updated, created DESC +ORDER BY updated, created DESC, k.id LIMIT :offset, :count SQL;