Count amout of nodeviews in a year - SQL Snipplr Social Repository

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

drupal

Initial Language

SQL