Posted By

berkes on 01/04/07

Tagged

1 person have marked this snippet as a favorite

/ Published in: SQL

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

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

Comment:

You need to login to post a comment.