INSERT INTO wp_4_wpmlautoresponderemails (subscriber_id, autoresponder_id, created, modified, senddate) (SELECT DISTINCT wp_4_wpmlsubscriberslists.subscriber_id, wp_4_wpmlautoresponderslists.autoresponder_id, '2011-08-04 12:58:02', '2011-08-04 12:58:02', '2011-08-07 12:58:02' FROM wp_4_wpmlsubscriberslists LEFT JOIN wp_4_wpmlautoresponderslists ON (wp_4_wpmlsubscriberslists.list_id = wp_4_wpmlautoresponderslists.list_id) LEFT JOIN wp_4_wpmlautoresponderemails ON (wp_4_wpmlautoresponderemails.autoresponder_id != '3' AND wp_4_wpmlautoresponderemails.subscriber_id != '1') WHERE (wp_4_wpmlsubscriberslists.list_id = '1' OR wp_4_wpmlsubscriberslists.list_id = '4' OR wp_4_wpmlsubscriberslists.list_id = '3' OR wp_4_wpmlsubscriberslists.list_id = '6' OR wp_4_wpmlsubscriberslists.list_id = '5' OR wp_4_wpmlsubscriberslists.list_id = '2') AND wp_4_wpmlautoresponderslists.autoresponder_id = '3')