From 88f3fe64659899961216def629335594af9048df Mon Sep 17 00:00:00 2001 From: Martin Mares Date: Sun, 15 Jun 2014 18:47:20 +0200 Subject: [PATCH] gal-mj-digikam: sort by date --- gal/bin/gal-mj-digikam | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gal/bin/gal-mj-digikam b/gal/bin/gal-mj-digikam index e222e5d..435cf25 100755 --- a/gal/bin/gal-mj-digikam +++ b/gal/bin/gal-mj-digikam @@ -40,7 +40,7 @@ print "## Tag ID: $tag_id\n"; open OUT, '|-', $ENV{GALLERY_ROOT} . '/bin/gal-scan' or die "Cannot feed gal scan\n"; for my $r (@{$dbh->selectall_arrayref( - 'SELECT i.name AS name FROM Images i JOIN ImageTags t ON (i.id = t.imageid) WHERE i.album=? AND t.tagid=? ORDER BY i.name', + 'SELECT i.name AS name FROM Images i JOIN ImageTags t ON (i.id = t.imageid) WHERE i.album=? AND t.tagid=? ORDER BY i.modificationDate', { Slice => {} }, $album_id, $tag_id)}) { print OUT "$photos_root/$album/" . $r->{name}, "\n"; -- 2.39.2