SELECT celebrity.*,count(celebrity_tweets.tweet_id) as total_tweets_today FROM celebrity,celebrity_tweets where celebrity.status='active' AND celebrity_tweets.created_at >='2012-01-28' order by total_tweets_today DESC limit 0,10

Program Exited