Use entity id as last resort sorting parameter

[blogbundle] / Repository / KeywordRepository.php

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;