T114099
MariaDB [commonswiki_p]> select substr( log_timestamp, 1, 8 ), log_action, log_user_text, count(*) from logging_logindex where log_type = 'gwtoolset' and log_timestamp > '20150900000000' group by substr( log_timestamp, 1, 8 ), log_action, log_user_text order by 2, 1;
+-------------------------------+-------------------------+--------------------------+----------+
| substr( log_timestamp, 1, 8 ) | log_action | log_user_text | count(*) |
+-------------------------------+-------------------------+--------------------------+----------+
| 20150901 | mediafile-job-failed | DimitraCharalampidou | 17 |
| 20150902 | mediafile-job-failed | Jason.nlw | 393 |
| 20150902 | mediafile-job-failed | DimitraCharalampidou | 22 |
| 20150910 | mediafile-job-failed | Hansmuller | 7676 |
| 20150910 | mediafile-job-failed | DimitraCharalampidou | 899 |
| 20150911 | mediafile-job-failed | DimitraCharalampidou | 1268 |
| 20150911 | mediafile-job-failed | Hansmuller | 4072 |
| 20150912 | mediafile-job-failed | Hansmuller | 5 |
| 20150913 | mediafile-job-failed | Hansmuller | 1273 |
| 20150914 | mediafile-job-failed | DimitraCharalampidou | 56 |
| 20150914 | mediafile-job-failed | Hansmuller | 868 |
| 20150915 | mediafile-job-failed | Hansmuller | 10 |
| 20150916 | mediafile-job-failed | Hansmuller | 2883 |
| 20150917 | mediafile-job-failed | Hansmuller | 4110 |
| 20150917 | mediafile-job-failed | LizzyJongma | 272 |
| 20150922 | mediafile-job-failed | LizzyJongma | 200 |
| 20150923 | mediafile-job-failed | LizzyJongma | 1528 |
| 20150924 | mediafile-job-failed | Hansmuller | 21 |
| 20150924 | mediafile-job-failed | LizzyJongma | 1142 |
| 20150925 | mediafile-job-failed | LizzyJongma | 1452 |
| 20150925 | mediafile-job-failed | Hansmuller | 12 |
| 20150926 | mediafile-job-failed | LizzyJongma | 13 |
| 20150928 | mediafile-job-failed | Hansmuller | 5 |
| 20150901 | mediafile-job-succeeded | DimitraCharalampidou | 15 |
| 20150902 | mediafile-job-succeeded | DimitraCharalampidou | 5 |
| 20150902 | mediafile-job-succeeded | Pdproject | 15 |
| 20150902 | mediafile-job-succeeded | Jason.nlw | 1 |
| 20150903 | mediafile-job-succeeded | DimitraCharalampidou | 4 |
| 20150903 | mediafile-job-succeeded | Pdproject | 8 |
| 20150907 | mediafile-job-succeeded | Hansmuller | 1325 |
| 20150908 | mediafile-job-succeeded | Hansmuller | 2923 |
| 20150909 | mediafile-job-succeeded | Hansmuller | 3419 |
| 20150910 | mediafile-job-succeeded | Basel University Library | 1 |
| 20150910 | mediafile-job-succeeded | DimitraCharalampidou | 5050 |
| 20150910 | mediafile-job-succeeded | Hansmuller | 2675 |
| 20150911 | mediafile-job-succeeded | DimitraCharalampidou | 1070 |
| 20150911 | mediafile-job-succeeded | Hansmuller | 2536 |
| 20150912 | mediafile-job-succeeded | Hansmuller | 386 |
| 20150913 | mediafile-job-succeeded | Hansmuller | 5951 |
| 20150914 | mediafile-job-succeeded | Hansmuller | 3961 |
| 20150914 | mediafile-job-succeeded | DimitraCharalampidou | 1693 |
| 20150915 | mediafile-job-succeeded | Hansmuller | 6070 |
| 20150916 | mediafile-job-succeeded | Hansmuller | 1860 |
| 20150917 | mediafile-job-succeeded | LizzyJongma | 350 |
| 20150917 | mediafile-job-succeeded | Hansmuller | 55 |
| 20150918 | mediafile-job-succeeded | Hansmuller | 57 |
| 20150923 | mediafile-job-succeeded | Hansmuller | 262 |
| 20150923 | mediafile-job-succeeded | LizzyJongma | 297 |
| 20150924 | mediafile-job-succeeded | LizzyJongma | 598 |
| 20150924 | mediafile-job-succeeded | Hansmuller | 463 |
| 20150925 | mediafile-job-succeeded | Hansmuller | 546 |
| 20150925 | mediafile-job-succeeded | LizzyJongma | 490 |
| 20150926 | mediafile-job-succeeded | Hansmuller | 380 |
| 20150927 | mediafile-job-succeeded | Hansmuller | 316 |
| 20150928 | mediafile-job-succeeded | Hansmuller | 397 |
| 20150929 | mediafile-job-succeeded | Hansmuller | 230 |
| 20150901 | metadata-job | DimitraCharalampidou | 4 |
| 20150902 | metadata-job | Pdproject | 15 |
| 20150902 | metadata-job | Jason.nlw | 14 |
| 20150902 | metadata-job | DimitraCharalampidou | 3 |
| 20150903 | metadata-job | Pdproject | 8 |
| 20150903 | metadata-job | DimitraCharalampidou | 1 |
| 20150907 | metadata-job | Hansmuller | 265 |
| 20150908 | metadata-job | Hansmuller | 585 |
| 20150909 | metadata-job | Hansmuller | 545 |
| 20150910 | metadata-job | Basel University Library | 1 |
| 20150910 | metadata-job | DimitraCharalampidou | 1098 |
| 20150910 | metadata-job | Hansmuller | 651 |
| 20150911 | metadata-job | Hansmuller | 486 |
| 20150911 | metadata-job | DimitraCharalampidou | 277 |
| 20150912 | metadata-job | Hansmuller | 39 |
| 20150913 | metadata-job | Hansmuller | 626 |
| 20150914 | metadata-job | Hansmuller | 429 |
| 20150914 | metadata-job | DimitraCharalampidou | 343 |
| 20150915 | metadata-job | Hansmuller | 607 |
| 20150916 | metadata-job | Hansmuller | 433 |
| 20150917 | metadata-job | LizzyJongma | 22 |
| 20150917 | metadata-job | Hansmuller | 258 |
| 20150918 | metadata-job | Hansmuller | 7 |
| 20150922 | metadata-job | LizzyJongma | 6 |
| 20150923 | metadata-job | LizzyJongma | 38 |
| 20150923 | metadata-job | Hansmuller | 27 |
| 20150924 | metadata-job | Hansmuller | 47 |
| 20150924 | metadata-job | LizzyJongma | 49 |
| 20150925 | metadata-job | Hansmuller | 55 |
| 20150925 | metadata-job | LizzyJongma | 49 |
| 20150926 | metadata-job | Hansmuller | 38 |
| 20150927 | metadata-job | Hansmuller | 32 |
| 20150928 | metadata-job | Hansmuller | 42 |
| 20150929 | metadata-job | Hansmuller | 23 |
+-------------------------------+-------------------------+--------------------------+----------+
90 rows in set (0.58 sec)