Revision: 2143
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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