1 SELECT2     t1.xcjyrq,3     t1.*4 FROM5     view_sbxx t16 WHERE7     t1.syzt = 18 AND YEAR (t1.xcjyrq) > YEAR (NOW()) - 19 AND YEAR (t1.xcjyrq) < YEAR (NOW()) + 1;

SELECT    t1.xcjyrq,    t1.*FROM    view_sbxx t1WHERE    t1.syzt = 1AND YEAR (t1.xcjyrq) > YEAR (NOW()) - 1AND YEAR (t1.xcjyrq) < YEAR (NOW()) + 1;