[steveearle86]

Hi,
Can anyone tell me how (or possibly provide the SQL query) albums are ordered in recently added albums.

From looking in the database the only way I can match what I see in my Kodi setup is

Code:

SELECT * FROM MyMusic60.albumview ORDER BY idAlbum DESC;

My top three records have album ids of

2055
2034
2012

so 2034 is the second most recently added album. However

Code:

SELECT * FROM song WHERE idAlbum = 2034

returns 11 songs all with the added date of 2015-12-19

whereas

Code:

SELECT * FROM song WHERE idAlbum = 2012

returns 12 songs with an added date of 2017-07-15

so actually, id 2034 should be no where near my recently added!?

Can someone please confirm how this ordered in the app?