X-Git-Url: https://git.rapsys.eu/blogbundle/blobdiff_plain/7711361c419c68c35f8e59b93cbbcc9c15a33ed1..refs/heads/master:/Repository/ArticleRepository.php?ds=sidebyside diff --git a/Repository/ArticleRepository.php b/Repository/ArticleRepository.php index a19d63c..a2e1a5e 100644 --- a/Repository/ArticleRepository.php +++ b/Repository/ArticleRepository.php @@ -79,7 +79,7 @@ LEFT JOIN RapsysBlogBundle:ArticleKeyword AS ak ON (ak.article_id = a.id) LEFT JOIN RapsysBlogBundle:Keyword AS k ON (k.id = ak.keyword_id) LEFT JOIN RapsysBlogBundle:KeywordTranslation AS kt ON (kt.keyword_id = k.id AND kt.locale = :locale) GROUP BY a.id -ORDER BY updated, created DESC +ORDER BY updated, created DESC, a.id LIMIT :offset, :count SQL;