select date(published) dd, count(1) from sa_twitter_tweets f, sa_twitter_tweets_acc k
where
f.id = k.id and
name='Firefox'
group by date(published)
order by date(published) desc