SELECT vod_id type_id vod_name vod_year vod_timeFROM mac_vod AS t1WHERE EXISTS SELECT 1 FROM mac_vod AS t2 WHERE t1vod_name = t2vod_name AND t1vod_year - t2vod_year = 1 AND t1vod_year

以下是修改后的SQL语句：

SELECT t1.vod_id, t1.type_id, t1.vod_name, t1.vod_year, t1.vod_time FROM mac_vod AS t1 WHERE t1.type_id IN (1,5,6,7,8,9,10,11,12,20,21,22,23,24,25,26) AND EXISTS ( SELECT 1 FROM mac_vod AS t2 WHERE t1.vod_name = t2.vod_name AND t1.vod_year - t2.vod_year <= 1 AND t1.vod_year - t2.vod_year >= -1 AND t1.vod_id <> t2.vod_id ) ORDER BY t1.vod_name ASC, t1.vod_time DESC LIMIT 30