Re: Having problems getting started with Zyons

[Ian Holsman]

try  order by 3 desc On 19/07/2006, at 8:40 PM, tonemcd wrote: I dug around a little, <a href=""http://archives.neohapsis.com/archives/mysql/2005-q2/1966.html">http://archives.neohapsis.com/archives/mysql/2005-q2/1966.html">this helped a lot</a> - and I found that this works (4.1.18-standard); mysql> select content_type_id, object_id, sum( unique_views)  from counter_objecthourcounter  where site_id=1 and effective_date >= '2006-07-18 09:50:07' and content_type_id in (30) group by content_type_id, object_id  LIMIT 40; Empty set (0.00 sec) But of course the 'order by sum (unique_views) desc' has gone. Tone --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---