--- android/TrainInfoService/src/dk/thoerup/traininfoservice/DumpResultSet.java 2010/06/09 21:04:54 813 +++ android/TrainInfoService/src/dk/thoerup/traininfoservice/DumpResultSet.java 2010/06/10 07:25:47 815 @@ -141,7 +141,7 @@ } else if (dump.equals("updatecoords")) { res = dumpUpdate("UPDATE trainstations SET earth_coord = ll_to_earth(latitude,longitude)"); } else if (dump.equals("trainstatistics")) { - res = dumpResultset("SELECT * FROM trainstatistics ORDER BY statisticsdate"); + res = dumpResultset("SELECT * FROM trainstatistics ORDER BY statisticsdate DESC"); } else if (dump.equals("trainstatistics_avg")) { res = dumpResultset("SELECT round(avg(location),1) as location, round(avg(name),1) as name, round(avg(favorites),1) as favorites, " + "round(avg(departure),1) as departure, round(avg(depcache),1) as depcache, round(avg(deperror),1) as deperror, " +