From 9a781975e63356b272c48ac11d3c634d4d38b432 Mon Sep 17 00:00:00 2001
From: Martin Mares <mj@ucw.cz>
Date: Sat, 13 Nov 2021 01:37:48 +0100
Subject: [PATCH] gal-mj-digikam: Sort by EXIF creation timestamp

---
 bin/gal-mj-digikam | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

diff --git a/bin/gal-mj-digikam b/bin/gal-mj-digikam
index 7a1a331..649b09a 100755
--- a/bin/gal-mj-digikam
+++ b/bin/gal-mj-digikam
@@ -51,12 +51,14 @@ my $res = $dbh->selectall_arrayref( <<AMEN, { Slice => {} },
 		i.name AS name,
 		p.latitudeNumber AS lat,
 		p.longitudeNumber AS lon,
-		p.altitude AS alt
+		p.altitude AS alt,
+		inf.creationDate AS cdate
 	FROM Images i
 	JOIN ImageTags t ON (i.id = t.imageid)
 	LEFT JOIN ImagePositions p ON (i.id = p.imageid)
+	LEFT JOIN ImageInformation inf ON (i.id = inf.imageid)
 	WHERE i.album=? AND t.tagid=?
-	ORDER BY i.modificationDate
+	ORDER BY cdate, i.modificationDate
 AMEN
 	$album_id,
 	$tag_id,
-- 
2.39.2