SELECT id,nombre FROM catalogo_modelos where CURDATE()>=STR_TO_DATE(novedad,'%d/%m/%Y') and CURDATE()<=STR_TO_DATE(fin_novedad,'%d/%m/%Y') order by novedad DESC