How can I do this in one query? I want to generate a results set like today 0 30-day 5 60-day 18 I would like to extract this in a single statement. I'm currently doing it in 3 queries like this: mysql> select count(me_id) from messages where to_days(me_date)>to_days(now())-7; +--------------+ | count(me_id) | +--------------+ | 1 | +--------------+ 1 row in set (0.00 sec) mysql> select count(me_id) from messages where to_days(me_date)>to_days(now())-30; +--------------+ | count(me_id) | +--------------+ | 5 | +--------------+ 1 row in set (0.00 sec) mysql> select count(me_id) from messages where to_days(me_date)>to_days(now())-60; +--------------+ | count(me_id) | +--------------+ | 18 | +--------------+ 1 row in set (0.00 sec)