User:ShakataGaNai/ENWN stats

Random Stats from EnWN.net. Anonymized where needed.

Unique IP count
Updated: 2010-01-25

SELECT `ip`, count( `ip` ) AS cnt FROM `logs` WHERE `event` = 'HIT' GROUP BY `ip` ORDER BY cnt DESC LIMIT 0 , 30;


 * A - 3255
 * B - 2090
 * C - 1428
 * D - 1399
 * E - 1386
 * F - 1333
 * G - 1295
 * H - 1265
 * I - 1226
 * J - 1210
 * K - 1170
 * L - 1159
 * M - 1148
 * N - 1131
 * O - 1073
 * P - 1059
 * Q - 996
 * R - 958
 * S - 957
 * T - 842
 * U - 810
 * V - 790
 * W - 776
 * X - 742
 * Y - 727

Click through by date
Updated: 2010-01-31@0732 UTC

SELECT CONVERT( DATE_ADD( `when`, INTERVAL 8 HOUR ) , DATE ) "when", COUNT( CONVERT( DATE_ADD( `when` , INTERVAL 8 HOUR ) , DATE ) ) "count" FROM `logs` WHERE event = 'HIT' GROUP BY CONVERT( DATE_ADD( `when` , INTERVAL 8 HOUR ) , DATE ) LIMIT 0 , 999

when 	count 2009-08-19 	193 2009-08-20 	301 2009-08-21 	249 2009-08-22 	397 2009-08-23 	288 2009-08-24 	442 2009-08-25 	440 2009-08-26 	395 2009-08-27 	320 2009-08-28 	266 2009-08-29 	325 2009-08-30 	236 2009-08-31 	316 2009-09-01 	199 2009-09-02 	333 2009-09-03 	268 2009-09-04 	246 2009-09-05 	309 2009-09-06 	483 2009-09-07 	322 2009-09-08 	237 2009-09-09 	241 2009-09-10 	415 2009-09-11 	682 2009-09-12 	1006 2009-09-13 	791 2009-09-14 	197 2009-09-15 	259 2009-09-16 	385 2009-09-17 	330 2009-09-18 	344 2009-09-19 	523 2009-09-20 	375 2009-09-21 	255 2009-09-22 	658 2009-09-23 	502 2009-09-24 	357 2009-09-25 	524 2009-09-26 	740 2009-09-27 	157 2009-09-28 	267 2009-09-29 	288 2009-09-30 	636 2009-10-01 	581 2009-10-02 	691 2009-10-03 	532 2009-10-04 	641 2009-10-05 	247 2009-10-06 	429 2009-10-07 	358 2009-10-08 	577 2009-10-09 	769 2009-10-10 	612 2009-10-11 	354 2009-10-12 	536 2009-10-13 	272 2009-10-14 	243 2009-10-15 	461 2009-10-16 	764 2009-10-17 	515 2009-10-18 	601 2009-10-19 	908 2009-10-20 	383 2009-10-21 	769 2009-10-22 	826 2009-10-23 	649 2009-10-24 	283 2009-10-25 	484 2009-10-26 	723 2009-10-27 	155 2009-10-28 	343 2009-10-29 	465 2009-10-30 	787 2009-10-31 	419 2009-11-01 	1038 2009-11-02 	583 2009-11-03 	657 2009-11-04 	693 2009-11-05 	1108 2009-11-06 	1133 2009-11-07 	1097 2009-11-08 	1321 2009-11-09 	812 2009-11-10 	915 2009-11-11 	568 2009-11-12 	590 2009-11-13 	406 2009-11-14 	783 2009-11-15 	456 2009-11-16 	702 2009-11-17 	983 2009-11-18 	515 2009-11-19 	934 2009-11-20 	747 2009-11-21 	896 2009-11-22 	1437 2009-11-23 	409 2009-11-24 	817 2009-11-25 	420 2009-11-26 	460 2009-11-27 	500 2009-11-28 	498 2009-11-29 	429 2009-11-30 	603 2009-12-01 	361 2009-12-02 	447 2009-12-03 	513 2009-12-04 	592 2009-12-05 	600 2009-12-06 	932 2009-12-07 	704 2009-12-08 	798 2009-12-09 	391 2009-12-10 	948 2009-12-11 	611 2009-12-12 	609 2009-12-13 	694 2009-12-14 	775 2009-12-15 	1012 2009-12-16 	569 2009-12-17 	618 2009-12-18 	606 2009-12-19 	901 2009-12-20 	850 2009-12-21 	935 2009-12-22 	888 2009-12-23 	482 2009-12-24 	839 2009-12-25 	411 2009-12-26 	959 2009-12-27 	941 2009-12-28 	567 2009-12-29 	635 2009-12-30 	1091 2009-12-31 	863 2010-01-01 	450 2010-01-02 	154 2010-01-03 	155 2010-01-04 	84 2010-01-05 	196 2010-01-06 	367 2010-01-07 	168 2010-01-08 	212 2010-01-09 	277 2010-01-10 	2465 2010-01-11 	1491 2010-01-12 	1043 2010-01-13 	1126 2010-01-14 	721 2010-01-15 	890 2010-01-16 	366 2010-01-17 	786 2010-01-18 	1167 2010-01-19 	1123 2010-01-20 	729 2010-01-21 	606 2010-01-22 	912 2010-01-23 	625 2010-01-24 	327 2010-01-25 	2913 2010-01-26  	2702 2010-01-27  	2729 2010-01-28 	1273 2010-01-29 	1284 2010-01-30 	1777 2010-01-31 	426