# HG changeset patch
# User Sebastian Brannstrom <sebastianb@symbian.org>
# Date 1289842320 0
# Node ID a5e419ee2bb322ca21dfb0918e21e35b78c6c909
# Parent  9c4fd008e20fb0134820931803178ed1338ba48d
New shows now list newest shows on top

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;