mysql:research@s3-analytics-slave [frwiki]> select substring(log_timestamp, 1, 8) as day, count(*) from logging where log_type='patrol' and log_action='patrol' and log_timestamp >= '20170801000000' group by day;
+----------+----------+
| day      | count(*) |
+----------+----------+
| 20170801 |      443 |
| 20170802 |      379 |
| 20170803 |      415 |
| 20170804 |      564 |
| 20170805 |      370 |
| 20170806 |      462 |
| 20170807 |      435 |
| 20170808 |      449 |
| 20170809 |      515 |
| 20170810 |      417 |
| 20170811 |      382 |
| 20170812 |      379 |
| 20170813 |      296 |
| 20170814 |      474 |
| 20170815 |      367 |
| 20170816 |      534 |
| 20170817 |      526 |
| 20170818 |      444 |
| 20170819 |      513 |
| 20170820 |      512 |
| 20170821 |      525 |
| 20170822 |      543 |
| 20170823 |      724 |
| 20170824 |      432 |
| 20170825 |      594 |
| 20170826 |      392 |
| 20170827 |      422 |
| 20170828 |      981 |
| 20170829 |      470 |
| 20170830 |      640 |
| 20170831 |      564 |
| 20170901 |      443 |
| 20170902 |      410 |
| 20170903 |      570 |
| 20170904 |      543 |
| 20170905 |      438 |
| 20170906 |      486 |
| 20170907 |      502 |
| 20170908 |      425 |
| 20170909 |      451 |
| 20170910 |      551 |
| 20170911 |      564 |
| 20170912 |      421 |
| 20170913 |      570 |
| 20170914 |      406 |
| 20170915 |      425 |
| 20170916 |      595 |
| 20170917 |      527 |
| 20170918 |      608 |
| 20170919 |      565 |
| 20170920 |      501 |
| 20170921 |      462 |
| 20170922 |      428 |
| 20170923 |      466 |
| 20170924 |      519 |
| 20170925 |      501 |
| 20170926 |      568 |
| 20170927 |      478 |
| 20170928 |      363 |
| 20170929 |      483 |
| 20170930 |      457 |
| 20171001 |      548 |
| 20171002 |      527 |
| 20171003 |      467 |
| 20171004 |      532 |
| 20171005 |      566 |
| 20171006 |      540 |
| 20171007 |      503 |
| 20171008 |      582 |
| 20171009 |      612 |
| 20171010 |      583 |
| 20171011 |      530 |
| 20171012 |      553 |
| 20171013 |      534 |
| 20171014 |      385 |
| 20171015 |      583 |
| 20171016 |      657 |
| 20171017 |      501 |
| 20171018 |      506 |
| 20171019 |      394 |
| 20171020 |      490 |
| 20171021 |      408 |
| 20171022 |      461 |
| 20171023 |      497 |
| 20171024 |      548 |
| 20171025 |      471 |
| 20171026 |      561 |
| 20171027 |      431 |
| 20171028 |      468 |
| 20171029 |      479 |
| 20171030 |      549 |
| 20171031 |      765 |
| 20171101 |      498 |
| 20171102 |      573 |
| 20171103 |      458 |
| 20171104 |      512 |
| 20171105 |      428 |
| 20171106 |      533 |
| 20171107 |      504 |
| 20171108 |      504 |
| 20171109 |      467 |
| 20171110 |      443 |
| 20171111 |      576 |
| 20171112 |      661 |
| 20171113 |      537 |
| 20171114 |      553 |
| 20171115 |      511 |
| 20171116 |      410 |
| 20171117 |      480 |
| 20171118 |      673 |
| 20171119 |      673 |
| 20171120 |      463 |
| 20171121 |      449 |
| 20171122 |      460 |
| 20171123 |      472 |
| 20171124 |      599 |
| 20171125 |      746 |
| 20171126 |      704 |
| 20171127 |      652 |
| 20171128 |      466 |
| 20171129 |      586 |
| 20171130 |      542 |
| 20171201 |      581 |
| 20171202 |      851 |
| 20171203 |      785 |
| 20171204 |      787 |
| 20171205 |      670 |
| 20171206 |      676 |
| 20171207 |      541 |
| 20171208 |      504 |
| 20171209 |      681 |
| 20171210 |      767 |
| 20171211 |      635 |
| 20171212 |      617 |
| 20171213 |      604 |
| 20171214 |      521 |
| 20171215 |      665 |
| 20171216 |      718 |
| 20171217 |      751 |
| 20171218 |      523 |
| 20171219 |      624 |
| 20171220 |      572 |
| 20171221 |      458 |
| 20171222 |      401 |
| 20171223 |      605 |
| 20171224 |      441 |
| 20171225 |      291 |
| 20171226 |      799 |
| 20171227 |      535 |
| 20171228 |      854 |
| 20171229 |      561 |
| 20171230 |      711 |
| 20171231 |      578 |
| 20180101 |      626 |
| 20180102 |      683 |
| 20180103 |      648 |
| 20180104 |      722 |
| 20180105 |      752 |
| 20180106 |      656 |
| 20180107 |      714 |
| 20180108 |      657 |
| 20180109 |      565 |
| 20180110 |      539 |
+----------+----------+