Prova così:
codice:
select from_unixtime(campo_timestamp,'%Y-%m') as mese_anno,
count(from_unixtime(campo_timestamp,'%Y-%m')) as quanti
from tabella
where from_unixtime(campo_timestamp,'%Y-%m') >= '2007-01'
group by mese_anno
order by mese_anno desc