search

mysociety / annual-report

Simple static site describing mySociety’s year in numbers
https://mysociety.org
1 stars 5 forks source link

WriteToThem number of messages stat is not correct #13

Closed dracos closed 9 years ago

dracos commented 9 years ago

I make it 171,163.

select count(*) from message where state='finished' and 'epoch'::timestamp+created*'1 second'::interval between date('2014-01-01') and date('2015-01-01');