2022-11: Warosu is now out of maintenance. Become a Patron!
Query | select (floor(timestamp/300)%288)*300,count(*),count(media_hash),count(case when email = 'sage' then 1 else NULL end) from `ic` use index(timestamp_index) where timestamp>1685418502-86400 group by floor(timestamp/300)%288 order by floor(timestamp/300)%288; |
---|---|
Updated | 54 years ago. Next update VERY SOON! |