Delete records based on another table SQL / insert ignore

DELETE t1 FROM topic_merge_candidates t1 JOIN topic t2 ON t1.topic_id = t2.topic_id where t2.status=2; show open tables where in_use>0; show processlist; kill 181120 (process_id); insert ignore into topic_merge_candidates (topic_id, title, articles, create_date, status) ( select topic_id, title, articles, create_date, status from topic where create_date >='2016-10-14' and articles <=1 and status = 1 and mark_like = 0) ;