Wow, that was some complicated SQL. I think this is only the boards that have had activity over the past 30 days, it didn't give any data for some fields.
Board 7 days 30 days
----- ------- -------
a 36.5975 37.9541
big 5.6850 1.6333
cats 0.5308
dis 0.3159 0.3712
f 1.6373 0.5962
m 1.6769 2.2300
ma 1.0307 0.1758
p 0.2736
w 2.2696 1.9325
z 2.0427 1.9255For the record, that was:
select t7.boardname as "Board", t7.rate as "7 days", t30.rate as "30 days" --*-sql-*-
from (
select boardname, count(postid) / ((max(posttime) - min(posttime)) / 60 / 60 / 24) rate
from posts
where posttime > unix_timestamp() - (60 * 60 * 24 * 7)
group by boardname
) as t7, (
select boardname, count(postid) / ((max(posttime) - min(posttime)) / 60 / 60 / 24) rate
from posts
where posttime > unix_timestamp() - (60 * 60 * 24 * 30)
group by boardname
) as t30
where t7.boardname = t30.boardname
order by t7.boardname;