X-Git-Url: https://git.rapsys.eu/blogbundle/blobdiff_plain/22f1dcfaa25237a059218334c26712ba3a1cfa00..86f4f59f5e02415a4945ae879e14d4034308dbb2:/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;