Album Thumbnail in database

[Sweetener]

Hello there!
I was wondering if someone knows how the album thumbnail is saved in the database, because I am trying to fetch it with an I cant find where is the album thumbnail

thank u

[gmc]

Hello there!
I was wondering if someone knows how the album thumbnail is saved in the database, because I am trying to fetch it with an I cant find where is the album thumbnail

thank u

In the cpgxxx_albums table, the column 'thumb' contains the pid of the album thumbnail - which is the 'pid' in the cpgxxx_pictures table of the thumb image.
The images themselves are of course not in the database - the name of the thumb file is constructed from the 'filepath' and 'filename' in the cpgxxx_pictures table along with the 'thumb_pfx' value from cpgxxx_config:
  {filepath}{thumb_pfx}{filename} would be the thumbnail displayed for the album.

[Sweetener]

In the cpgxxx_albums table, the column 'thumb' contains the pid of the album thumbnail - which is the 'pid' in the cpgxxx_pictures table of the thumb image.
The images themselves are of course not in the database - the name of the thumb file is constructed from the 'filepath' and 'filename' in the cpgxxx_pictures table along with the 'thumb_pfx' value from cpgxxx_config:
  {filepath}{thumb_pfx}{filename} would be the thumbnail displayed for the album.

Thank you so much