My Most Popular Days

Wednesday, December 29, 2004, at 04:41PM

By Eric Richardson

I was just fixing up the styles for the "On This Date" feature and got curious about how many days of the year I've posted on in the 6+ years this blog's been running. A simple MySQL query later*, I had the answer: 348. So out of the 366 possible days of the year, I've missed 18. The most popular day, with 10 posts:

Fascinatingly, I implemented "On This Date" on Dec. 11, 2003. Close behind, with 9 posts:

The query, in case you wondered:

  from_unixtime(timestamp,"%m/%d") as d,
  count(id) as c
group by d
order by c,d