Posted By

berkes on 01/04/07


Tagged

drupal statistics nodes 47


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

basicmagic


Count amout of nodeviews in a year


 / Published in: SQL
 

Counts the total amout of nodeviews between now and a year ago (the last 31536000 seconds).

  1. SELECT SUM(count.totalcount) FROM node_counter count LEFT JOIN node n ON n.nid = count.nid WHERE n.created > (UNIX_TIMESTAMP(NOW())-31536000);

Report this snippet  

You need to login to post a comment.