SELECT arrdato.arrid, MAX(arrstart), COUNT(arrid) FROM arrdato WHERE ((arrdato.stedid=1 OR arrdato.arrangid=1) AND arrdato.arrstart<'2009-01-22 14:00:21') GROUP BY arrdato.arrid ORDER BY ~MAX(arrstart) LIMIT 10 OFFSET 0; Result
[(3, u'2009-01-20 14:53:46', 1), (4, u'2009-01-14 16:56:11', 1), (5, u'2009-01-11 16:58:00', 1), (12, u'2009-01-20 13:08:00', 1), (15, u'2009-01-22 13:16:00', 1), (16, u'2009-01-20 13:34:00', 1), (1, u'2008-12-31 15:08:41', 1)] 3 2009-01-20 14:53:46 4 2009-01-14 16:56:11 5 2009-01-11 16:58:00 12 2009-01-20 13:08:00 15 2009-01-22 13:16:00 16 2009-01-20 13:34:00 1 2008-12-31 15:08:41 I don't understand this result!? I first suspected that the wrong order was caused by string values. But the "order by" should work even for string-values. Ascendig sort works fine: SELECT arrdato.arrid, MAX(arrstart), COUNT(arrid) FROM arrdato WHERE ((arrdato.stedid=1 OR arrdato.arrangid=1) AND arrdato.arrstart<'2009-01-22 14:11:21') GROUP BY arrdato.arrid ORDER BY MAX(arrstart) LIMIT 10 OFFSET 0; Result [(1, u'2008-12-31 15:08:41', 1), (5, u'2009-01-11 16:58:00', 1), (4, u'2009-01-14 16:56:11', 1), (12, u'2009-01-20 13:08:00', 1), (16, u'2009-01-20 13:34:00', 1), (3, u'2009-01-20 14:53:46', 1), (15, u'2009-01-22 13:16:00', 1)] 1 2008-12-31 15:08:41 5 2009-01-11 16:58:00 4 2009-01-14 16:56:11 12 2009-01-20 13:08:00 16 2009-01-20 13:34:00 3 2009-01-20 14:53:46 15 2009-01-22 13:16:00 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
