Query Run
select SUBSTRING(rc_timestamp,1,10) as hour, count(*), sum(rc_bot=1) as bot,... 9 years ago
select SUBSTRING(rc_timestamp,1,10) as hour, count(*), sum(rc_bot=1) as bot,... 9 years ago