X-Git-Url: https://git.rapsys.eu/blogbundle/blobdiff_plain/ed28648958cc334b451590c91a74dd6c0784c1fe..eae4b5e135c63c0a887b81ef7abed2e06a1e879f:/Repository/ArticleRepository.php?ds=sidebyside

diff --git a/Repository/ArticleRepository.php b/Repository/ArticleRepository.php
index 0d5a069..a19d63c 100644
--- a/Repository/ArticleRepository.php
+++ b/Repository/ArticleRepository.php
@@ -166,9 +166,9 @@ SQL;
 		$req = <<<SQL
 SELECT
 	b.id,
-	b.created,
-	b.updated,
-	b.modified,
+	GREATEST(b.created, kat.created) AS created,
+	GREATEST(b.updated, kat.updated) AS updated,
+	GREATEST(b.created, b.updated, kat.created, kat.updated) AS modified,
 	b.body,
 	b.description,
 	b.slug,
@@ -184,7 +184,6 @@ FROM (
 		a.id,
 		GREATEST(a.created, at.created, k.created, kt.created) AS created,
 		GREATEST(a.updated, at.updated, k.updated, kt.updated) AS updated,
-		GREATEST(a.created, at.created, k.created, kt.created, a.updated, at.updated, k.updated, kt.updated) AS modified,
 		at.body,
 		at.description,
 		at.slug,