codice:
SELECT * FROM news 
ORDER BY field(state, 'C', 'D', 'B', 'E')