SELECT * FROM wp_wpmlsubscribers LEFT JOIN wp_wpmlsubscriberslists ON wp_wpmlsubscribers.id = wp_wpmlsubscriberslists.subscriber_id WHERE wp_wpmlsubscriberslists.active = 'Y';