[DanCooper]

Good idea, that query should working:

sql:
SELECT

  *

FROM

  movielist

WHERE

  dateModified >= ((SELECT MAX(dateModified) FROM movielist) - 86400)

While a database update all new added movies, tv show and episodes will be tagged as "new". All "new" tags will be reset to "false" in the beginning of a database update or if you close Ember. It's not optimal in every case and will be changed or better to control in next versions, but that's how it's work ATM. There is an additional option in the settings to "mark" (red) new files while a database update. This "mark" will persist until you remove it manually (context menu, shortcut or with the unmark button on top of the movie list).