Posted By

berkes on 01/04/07


drupal statistics nodes 47

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


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.