6 and unsubemail.unsubemail not like '%@aiacademy.tw' and unsubemail.unsubemail not in ('aaa@lll.com','test@test.com','vansindata@gmail.com') ORDER BY `reason_id`,unsubemail.unsubemail DESC EOF; $a = $wpdb->get_results($sql); $EVENT_ID = 1315; $sql = 'INSERT INTO subscr_history (`email`,`op_from`,`op_to`,`datetime`,`event_id`,`reason`) VALUES '; $values = array(); $now = date('Y-m-d H:i:s'); foreach($a as$v){ $values[]=' ("'.$v->unsubemail.'", "y", "n", "'.$now.'", "'.$EVENT_ID.'", "'.$v->reason_label.'") '; } echo'

';
echo $sql.implode(",\n", $values).';';