SELECT * FROM news WHERE (CURDATE() >= date_from AND CURDATE() <= date_to) AND active = 'y' ORDER BY date_from DESC