User:ShakataGaNai/ENWN stats
Random Stats from EnWN.net. Anonymized where needed.
Unique IP count
editUpdated: 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
editUpdated: 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