Changing photo sort order seems to break album covers

[wodger1912]

When photos are sorted by "Title", the album covers appear normally, whereas if the photos are sorted by "Date Take", only some of the albums get covers (screenshots linked below)

Steps to reproduce the behavior:

1. Observe albums correct with photos sort by title
2. Change from sort by title to sort by date take
3. Observe some of the albums have no covers

Screenshots Sort By Title Sort By Date Take

Output of the diagnostics [REQUIRED]

` Diagnostics

Warning: Dropbox import not working. dropbox_key is empty.
Warning: You may experience problems when uploading a photo of large size. Take a look in the FAQ for details.
Error: APP_URL does not match the current url. This will break WebAuthn authentication. Please update APP_URL to reflect this change.
Error: /app/www/.git (and subdirectories) are not executable, check the permissions
Foreign key: access_permissions.user_id     → users.id             : CASCADE
Foreign key: albums.parent_id               → albums.id            : RESTRICT
Foreign key: albums.id                      → base_albums.id       : RESTRICT
Foreign key: albums.cover_id                → photos.id            : CASCADE
Foreign key: base_albums.owner_id           → users.id             : RESTRICT
Foreign key: jobs_history.owner_id          → users.id             : RESTRICT
Foreign key: photos.album_id                → albums.id            : RESTRICT
Foreign key: photos.owner_id                → users.id             : RESTRICT
Foreign key: size_variants.photo_id         → photos.id            : RESTRICT
Foreign key: sym_links.size_variant_id      → size_variants.id     : RESTRICT
Foreign key: tag_albums.id                  → base_albums.id       : RESTRICT

System Information
--------------
Lychee Version (git):                    ?? (a87d2e2) -- Could not compare.
DB Version:                              4.13.0

composer install:                        --no-dev
APP_ENV:                                 production
APP_DEBUG:                               false

System:                                  Linux
PHP Version:                             8.2.12
PHP User agent:                          Lychee/4 (https://lycheeorg.github.io/)
Timezone:                                Asia/Manila
Max uploaded file size:                  20M
Max post size:                           200M
Max execution time:                      200
MySQL Version:                           10.11.5-MariaDB-log

exec() Available:                        yes
Imagick Available:                       1
Imagick Enabled:                         1
Imagick Version:                         1809
GD Version:                              bundled (2.1.0 compatible)
Number of foreign key:                   11 found.

Config Information
--------------
version:                                 041300
check_for_updates:                       0
sorting_photos_col:                      title
sorting_photos_order:                    ASC
sorting_albums_col:                      title
sorting_albums_order:                    ASC
imagick:                                 1
skip_duplicates:                         0
small_max_width:                         0
small_max_height:                        360
medium_max_width:                        1920
medium_max_height:                       1080
lang:                                    en
image_overlay_type:                      none
default_license:                         CC-BY-ND-4.0
compression_quality:                     90
grants_full_photo_access:                1
delete_imported:                         0
mod_frame_enabled:                       1
mod_frame_refresh:                       30
thumb_2x:                                1
small_2x:                                1
medium_2x:                               1
landing_page_enable:                     0
site_owner:                              Cecille Paine
landing_title:                           John Smith
landing_subtitle:                        Cats, Dogs & Humans Photography
sm_facebook_url:                         https://www.facebook.com/JohnSmith
sm_flickr_url:                           https://www.flickr.com/JohnSmith
sm_twitter_url:                          https://www.twitter.com/JohnSmith
sm_instagram_url:                        https://instagram.com/JohnSmith
sm_youtube_url:                          https://www.youtube.com/JohnSmith
landing_background:                      dist/cat.webp
site_title:                              Cecille's Garden Online Gallery
footer_show_copyright:                   1
site_copyright_begin:                    2018
site_copyright_end:                      2023
footer_additional_text:                  
footer_show_social_media:                0
public_search:                           0
SL_enable:                               0
SL_for_admin:                            0
recent_age:                              1
grants_download:                         0
photos_wraparound:                       0
map_display:                             0
zip64:                                   1
map_display_public:                      0
map_provider:                            Wikimedia
force_32bit_ids:                         0
map_include_subalbums:                   0
update_check_every_days:                 3
has_exiftool:                            1
share_button_visible:                    0
import_via_symlink:                      0
has_ffmpeg:                              1
location_decoding:                       0
location_decoding_timeout:               30
location_show:                           0
location_show_public:                    0
rss_enable:                              0
rss_recent_days:                         7
rss_max_items:                           100
prefer_available_xmp_metadata:           0
editor_enabled:                          1
lossless_optimization:                   0
swipe_tolerance_x:                       150
swipe_tolerance_y:                       250
local_takestamp_video_formats:           .avi|.mov
log_max_num_line:                        1000
unlock_password_photos_with_url_param:   0
nsfw_visible:                            1
nsfw_blur:                               0
nsfw_warning:                            0
nsfw_warning_admin:                      0
nsfw_banner_override:                    
map_display_direction:                   1
album_subtitle_type:                     oldstyle
upload_processing_limit:                 4
public_photos_hidden:                    1
new_photos_notification:                 0
legacy_id_redirection:                   1
zip_deflate_level:                       6
SA_enabled:                              1
default_album_protection:                1
album_decoration:                        photo
album_decoration_orientation:            row
allow_username_change:                   1
auto_fix_orientation:                    1
use_job_queues:                          0
random_album_id:                         starred
use_last_modified_date_when_no_exif_date: 0
ffmpeg_path:                             /usr/bin/ffmpeg
ffprobe_path:                            /usr/bin/ffprobe
layout:                                  justified

`

Browser and system:

Firefox Ubuntu 22.04 Docker image: lscr.io/linuxserver/lychee:latest

[ildyria]

I'll need a bit of time to investigate that one.