diff options
| -rw-r--r-- | pkg/database/sql/media.go | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/pkg/database/sql/media.go b/pkg/database/sql/media.go index b13e267..16769bf 100644 --- a/pkg/database/sql/media.go +++ b/pkg/database/sql/media.go @@ -164,7 +164,8 @@ func (self *MediaRepository) List(ctx context.Context, pagination *repository.Pa Offset(pagination.Page * pagination.Size). Limit(pagination.Size). Where("path like '" + pagination.Path + "%'"). - Order("created_at DESC"). + Order("COALESCE (media_exifs.date_shot, media.created_at) DESC"). + InnerJoins("INNER JOIN media_exifs ON media_exifs.media_id = media.id"). Find(&medias) if result.Error != nil { |