in:
[select news_date_published from news_articles where news_status = '1' and to_days(news_date_published) <= to_days(now()) group by news_date_published desc limit 7]