Sorry Ian, I didn't mean to diss your application in the main discusssion forum! I just thought it might be a stupid user problem (I couldn't find it in the zyons.com forum).
I've been watching the development of zyons for a while with a view to using it for the first stage of our Zope migration project and thought that I'd have a go at the latest release. Stupidly, I have posted the wrong SQL, it should be; 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 order by sum( unique_views ) desc LIMIT 40 I'll post the trackback in the 'bugs' forum at zyons.com Thanks for what looks like a really useful application by the way! Cheers, 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 -~----------~----~----~----~------~----~------~--~---