diff -r 9c4fd008e20f -r a5e419ee2bb3 engine/src/ShowEngine.cpp --- a/engine/src/ShowEngine.cpp Mon Nov 15 17:25:39 2010 +0000 +++ b/engine/src/ShowEngine.cpp Mon Nov 15 17:32:00 2010 +0000 @@ -712,7 +712,8 @@ void CShowEngine::DBGetNewShowsL(RShowInfoArray& aShowArray) { DP("CShowEngine::DBGetNewShows"); - _LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype, lasterror, deletedate from shows where playstate=%u"); + _LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype, lasterror from shows where playstate=%u order by pubdate desc"); + iSqlBuffer.Format(KSqlStatement, ENeverPlayed); sqlite3_stmt *st;