select * from apublishingtask where thepublisher='去标示符串 ' and complete='完成' and date_sub(curdate(), INTERVAL 30 DAY) <= date(`add_time`);
