X-Git-Url: https://git.rapsys.eu/blogbundle/blobdiff_plain/d35d293c7ae158d46716f3d98ce96d259114cb90..HEAD:/Repository/KeywordRepository.php?ds=sidebyside

diff --git a/Repository/KeywordRepository.php b/Repository/KeywordRepository.php
index f531711..555f107 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;
 
@@ -116,7 +116,7 @@ SQL;
 				'created' => $data['created'],
 				'updated' => $data['updated'],
 				'modified' => $data['modified'],
-				'link' => $this->router->generate('rapsys_blog_keyword_view', ['id' => $id, 'slug' => $slug])
+				'link' => $this->router->generate('rapsysblog_keyword_view', ['id' => $id, 'slug' => $slug])
 			];
 		}
 
@@ -249,7 +249,7 @@ SQL;
 			'created' => $data['created'],
 			'updated' => $data['updated'],
 			'modified' => $data['modified'],
-			'link' => $this->router->generate('rapsys_blog_keyword_view', ['id' => $id, 'slug' => $slug]),
+			'link' => $this->router->generate('rapsysblog_keyword_view', ['id' => $id, 'slug' => $slug]),
 			'alternates' => [],
 			'articles' => []
 		];
@@ -273,7 +273,7 @@ SQL;
 				'description' => $data['a_descriptions'][$k],
 				'slug' => $slug = $data['a_slugs'][$k],
 				'title' => $data['a_titles'][$k],
-				'link' => $this->router->generate('rapsys_blog_article_view', ['id' => $aid, 'slug' => $slug]),
+				'link' => $this->router->generate('rapsysblog_article_view', ['id' => $aid, 'slug' => $slug]),
 				'keywords' => []
 			];
 		}
@@ -296,7 +296,7 @@ SQL;
 				'id' => $data['ak_kids'][$k],
 				'slug' => $slug = $data['ak_slugs'][$k],
 				'title' => $data['ak_titles'][$k],
-				'link' => $this->router->generate('rapsys_blog_keyword_view', ['id' => $data['ak_kids'][$k], 'slug' => $slug]),
+				'link' => $this->router->generate('rapsysblog_keyword_view', ['id' => $data['ak_kids'][$k], 'slug' => $slug]),
 			];
 		}
 
@@ -314,7 +314,7 @@ SQL;
 				'locale' => $locale,
 				'slug' => $slug = $data['ckt_slugs'][$k],
 				'title' => $data['ckt_titles'][$k],
-				'link' => $this->router->generate('rapsys_blog_keyword_view', ['_locale' => $locale, 'id' => $id, 'slug' => $slug]),
+				'link' => $this->router->generate('rapsysblog_keyword_view', ['_locale' => $locale, 'id' => $id, 'slug' => $slug]),
 			];
 		}