November Statistik?

Code:

mysql> create table temp_date as select count(*)/(round
((unix_timestamp(date_add(from_unixtime(dateline), interval 1 month))-
dateline)/86400)) as ppd, count(*)/(24*round((unix_timestamp
(date_add(from_unixtime(dateline), interval 1 month))-
dateline)/86400)) as pph, count(*)/(1440*round((unix_timestamp
(date_add(from_unixtime(dateline), interval 1 month))-
dateline)/86400)) as ppm, count(*) as total, from_unixtime((dateline),"%Y/%m") 
as month from post group by month order by month; select 
temp_date.*, sum(month >= from_unixtime(joindate,"%Y/%m")) as 
totalusers, avg(if(month >= from_unixtime(joindate,"%Y/%m") and 
unix_timestamp(birthday)>1,(unix_timestamp(CONCAT(REPLACE
(month,"/","-"),"-01")) - unix_timestamp(birthday))/
(86400*365.2425),NULL)) as avg_age,  sum(month = from_unixtime
(joindate,"%Y/%m")) as newusers, avg(if(month = from_unixtime
(joindate,"%Y/%m") and unix_timestamp(birthday)>1,(joindate - 
unix_timestamp(birthday))/(86400*365.2425),NULL)) as joinage, 
total/sum(month >= from_unixtime(joindate,"%Y/%m")) as ppu  from 
temp_date left join user on (month >= from_unixtime(joindate,"%Y/%
m")) group by month; drop table temp_date;

Query OK, 35 rows affected (10.29 sec)
Records: 35  Duplicates: 0  Warnings: 0

+---------+---------+-------+------+-------+------------+---------------+----------+---------------+-------+
| month   | ppd     | pph   | ppm  | total | totalusers | avg_age       | newusers | joinage       | ppu   |
+---------+---------+-------+------+-------+------------+---------------+----------+---------------+-------+
| 1970/01 |    0.03 |  0.00 | 0.00 |     1 |          0 |          NULL |        0 |          NULL |  NULL |
| 2000/03 |    1.03 |  0.04 | 0.00 |    32 |         27 | 19.4425906532 |       27 | 19.4645224292 |  1.19 |
| 2000/04 |    6.00 |  0.25 | 0.00 |   180 |         62 | 20.2624200899 |       35 | 20.7160963183 |  2.90 |
| 2000/05 |    6.45 |  0.27 | 0.00 |   200 |         97 | 20.4425042381 |       35 | 20.7103530658 |  2.06 |
| 2000/06 |   20.30 |  0.85 | 0.01 |   609 |        154 | 19.7012135393 |       57 | 18.1039822857 |  3.95 |
| 2000/07 |   39.39 |  1.64 | 0.03 |  1221 |        218 | 20.0468695456 |       64 | 20.8709652947 |  5.60 |
| 2000/08 |  106.52 |  4.44 | 0.07 |  3302 |        299 | 19.2594112034 |       81 | 17.4378590176 | 11.04 |
| 2000/09 |  133.23 |  5.55 | 0.09 |  3997 |        396 | 18.9732167987 |       97 | 17.7644451485 | 10.09 |
| 2000/10 |  131.35 |  5.47 | 0.09 |  4072 |        478 | 18.8477909044 |       82 | 17.8367226340 |  8.52 |
| 2000/11 |  215.37 |  8.97 | 0.15 |  6461 |        566 | 18.7044155858 |       88 | 17.5609844340 | 11.42 |
| 2000/12 |  196.68 |  8.19 | 0.14 |  6097 |        660 | 18.8114916802 |       94 | 19.0082967358 |  9.24 |
| 2001/01 |  222.52 |  9.27 | 0.15 |  6898 |        769 | 18.9485991241 |      109 | 19.5639426774 |  8.97 |
| 2001/02 |  227.64 |  9.49 | 0.16 |  6374 |        942 | 19.1788473572 |      173 | 19.7417165004 |  6.77 |
| 2001/03 |  248.97 | 10.37 | 0.17 |  7718 |       1135 | 19.1144888447 |      193 | 18.5606207527 |  6.80 |
| 2001/04 |  360.83 | 15.03 | 0.25 | 10825 |       1284 | 19.3898145025 |      149 | 20.5181603090 |  8.43 |
| 2001/05 |  375.06 | 15.63 | 0.26 | 11627 |       1388 | 19.4758612207 |      104 | 19.5606293411 |  8.38 |
| 2001/06 |  467.00 | 19.46 | 0.32 | 14010 |       1497 | 19.3869157731 |      109 | 18.5527255315 |  9.36 |
| 2001/07 |  571.32 | 23.81 | 0.40 | 17711 |       1659 | 19.3383554651 |      162 | 18.9204640150 | 10.68 |
| 2001/08 |  653.97 | 27.25 | 0.45 | 20273 |       1799 | 19.4273705047 |      140 | 19.4941083137 | 11.27 |
| 2001/09 |  622.77 | 25.95 | 0.43 | 18683 |       1917 | 19.4349160086 |      118 | 18.8178541417 |  9.75 |
| 2001/10 |  753.42 | 31.39 | 0.52 | 23356 |       2037 | 19.4895489582 |      120 | 19.2543405210 | 11.47 |
| 2001/11 |  879.73 | 36.66 | 0.61 | 26392 |       2161 | 19.6360495408 |      124 | 20.2899064342 | 12.21 |
| 2001/12 |  996.97 | 41.54 | 0.69 | 30906 |       2338 | 19.5847890046 |      177 | 18.7394135337 | 13.22 |
| 2002/01 | 1169.13 | 48.71 | 0.81 | 36243 |       2432 | 19.5703780909 |       94 | 18.2231230063 | 14.90 |
| 2002/02 | 1269.25 | 52.89 | 0.88 | 35539 |       2509 | 19.6102258384 |       77 | 18.9543176813 | 14.16 |
| 2002/03 | 1177.77 | 49.07 | 0.82 | 36511 |       2655 | 19.6529982692 |      146 | 19.2485246645 | 13.75 |
| 2002/04 | 1229.43 | 51.23 | 0.85 | 36883 |       2760 | 19.6509653475 |      105 | 18.1140207062 | 13.36 |
| 2002/05 | 1365.19 | 56.88 | 0.95 | 42321 |       2891 | 19.7222347230 |      131 | 19.5938000780 | 14.64 |
| 2002/06 | 1532.73 | 63.86 | 1.06 | 45982 |       3113 | 19.8093702675 |      222 | 19.8644083894 | 14.77 |
| 2002/07 | 1719.13 | 71.63 | 1.19 | 53293 |       3321 | 19.8278078151 |      208 | 19.2908265577 | 16.05 |
| 2002/08 | 1956.35 | 81.51 | 1.36 | 60647 |       3547 | 19.8723785948 |      226 | 19.3843349755 | 17.10 |
| 2002/09 | 1616.50 | 67.35 | 1.12 | 48495 |       3756 | 19.9351285754 |      209 | 19.6844289618 | 12.91 |
| 2002/10 | 1526.61 | 63.61 | 1.06 | 47325 |       3982 | 20.0054983696 |      226 | 19.9030351524 | 11.88 |
| 2002/11 | 1676.73 | 69.86 | 1.16 | 50302 |       4226 | 20.0502750519 |      244 | 19.5426485630 | 11.90 |
| 2002/12 |  221.00 |  9.21 | 0.15 |  6851 |       4256 | 20.1102958446 |       30 | 18.0343360749 |  1.61 |
+---------+---------+-------+------+-------+------------+---------------+----------+---------------+-------+

Query OK, 0 rows affected (0.01 sec)