[support] week's and month's popular content

[tbjkids Webmaster]

Hi Vasanth,

I've recently created this project which might be what you are looking
for:

http://drupal.org/project/node_extended_stats

I've only got a d5 version right now but with some Views 2 wizardry it
could be ported to d6.

-jaydub



> Hi all,
>  The requirement is to display the popular content of this week and popular
> content of  this month.
>  This is done by fetching the content which has more number of hits or
> views.
> 
>  We have Drupal's node_counter table in which we have the totalcount and
> daycount fields which has views per day and total.
> 
> 
> Any one help me optimized MySQL query which  can fetch this details in a
> quicker way.
> 
> Currently the data is fetched from accesslog table which is not much
> optimized and very slow.
> Thanks in advance.
> 
> 
> 
> Thanks & Regards
> Vasanth Govind