I dug around a little, <a href="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 -~----------~----~----~----~------~----~------~--~---
