X-Git-Url: https://git.rapsys.eu/blogbundle/blobdiff_plain/7711361c419c68c35f8e59b93cbbcc9c15a33ed1..c07bc0ac6e76a72234b6dfc74261d6ad2495079f:/Repository/ArticleRepository.php

diff --git a/Repository/ArticleRepository.php b/Repository/ArticleRepository.php
index a19d63c..9708751 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;
 
@@ -128,7 +128,7 @@ SQL;
 				'created' => $data['created'],
 				'updated' => $data['updated'],
 				'modified' => $data['modified'],
-				'link' => $this->router->generate('rapsys_blog_article_view', ['id' => $id, 'slug' => $slug]),
+				'link' => $this->router->generate('rapsysblog_article_view', ['id' => $id, 'slug' => $slug]),
 				'keywords' => []
 			];
 
@@ -146,7 +146,7 @@ SQL;
 					'id' => $id,
 					'slug' => $slug = $data['k_slugs'][$k],
 					'title' => $data['k_titles'][$k],
-					'link' => $this->router->generate('rapsys_blog_keyword_view', ['id' => $id, 'slug' => $slug]),
+					'link' => $this->router->generate('rapsysblog_keyword_view', ['id' => $id, 'slug' => $slug]),
 				];
 			}
 		}
@@ -246,7 +246,7 @@ SQL;
 			'created' => $data['created'],
 			'updated' => $data['updated'],
 			'modified' => $data['modified'],
-			'link' => $this->router->generate('rapsys_blog_article_view', ['id' => $id, 'slug' => $slug]),
+			'link' => $this->router->generate('rapsysblog_article_view', ['id' => $id, 'slug' => $slug]),
 			'alternates' => [],
 			'keywords' => []
 		];
@@ -265,7 +265,7 @@ SQL;
 				'id' => $kid,
 				'slug' => $slug = $data['k_slugs'][$k],
 				'title' => $data['k_titles'][$k],
-				'link' => $this->router->generate('rapsys_blog_keyword_view', ['id' => $kid, 'slug' => $slug]),
+				'link' => $this->router->generate('rapsysblog_keyword_view', ['id' => $kid, 'slug' => $slug]),
 			];
 		}
 
@@ -283,7 +283,7 @@ SQL;
 				'locale' => $locale,
 				'slug' => $slug = $data['kat_slugs'][$k],
 				'title' => $data['kat_titles'][$k],
-				'link' => $this->router->generate('rapsys_blog_article_view', ['_locale' => $locale, 'id' => $id, 'slug' => $slug]),
+				'link' => $this->router->generate('rapsysblog_article_view', ['_locale' => $locale, 'id' => $id, 'slug' => $slug]),
 			];
 		}