Return to Snippet

Revision: 2143
at January 4, 2007 07:23 by berkes

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

Initial URL

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

Initial Title
Count amout of nodeviews in a year

Initial Tags

Initial Language