DELETE FROM `nome_tabella` WHERE `classificazione`= 27 AND `data` BETWEEN `2019-01-01` AND `2020-07-01`;