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