From: Raphaël Gertz <git@rapsys.eu>
Date: Sun, 28 Jan 2024 06:48:02 +0000 (+0000)
Subject: Use entity id as last resort sorting parameter
X-Git-Url: https://git.rapsys.eu/blogbundle/commitdiff_plain/86f4f59f5e02415a4945ae879e14d4034308dbb2?hp=22f1dcfaa25237a059218334c26712ba3a1cfa00

Use entity id as last resort sorting parameter
---

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;
 
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;