Use entity id as last resort sorting parameter

diff --git a/Repository/ArticleRepository.php b/Repository/ArticleRepository.php
index a19d63c8f9d989a53b7043065b8a9be8899d7a05..a2e1a5eb3576e9168eb0ea60755eb7544d14f38b 100644 (file)
--- 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
 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;
 
 LIMIT :offset, :count
 SQL;
 

diff --git a/Repository/KeywordRepository.php b/Repository/KeywordRepository.php
index f531711d1b189ac22243988c7c55efb5eaf50ab4..4bd8aa833f00abd99a3a4ee348c415924d0ad657 100644 (file)
--- 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
 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;
 
 LIMIT :offset, :count
 SQL;