... order by IF(SCADENZA>CURDATE(),1,0), evidenzia DESC, ID desc