Feature idea : new tracks (including singles)

[tomchiverton]

I'd like something that's like the "random track" favourite that's a sort of dynamic playlist, but for newly added tracks (not albums).

For instance, I might drop a few things in to $cfg['misc_tracks_misc_artists_folder'] and re-run the main update.

There's no easy way to find these recent non-album additions.

Currently, I have a favourite called "New" and each night I run

delete
from favoriteitem 
where favorite_id =21
;
insert into favoriteitem 
(track_id,position,favorite_id)
select track_Id,@rownum := @rownum + 1,21
from track t
-- create variable
cross join (select @rownum := 0) r
order by updated  desc
limit 50

I'm wondering if this would be useful to anyone else, and if so if it's best done as an (non-editable ?) playlist, and the update process takes care of re-running the above ?