SELECT id, anounce, DATE_FORMAT(date, '%d/%m/%Y') as data FROM news WHERE YEAR(date) = '2010' AND view=1 ORDER by date DESC