DELETE FROM wp_wpmlsubscribers WHERE wp_wpmlsubscribers.id IN (SELECT wp_wpmlsubscriberslists.subscriber_id FROM wp_wpmlsubscriberslists WHERE wp_wpmlsubscriberslists.list_id = '7' AND wp_wpmlsubscriberslists.active = 'N');