SELECT d.EmailAddress, d.firstname, d.lastname, d.gender, l.status as status FROM [DE NAME] d INNER JOIN _ListSubscribers l ON l.SubscriberKey = d.EmailAddress WHERE l.ListId = '12345' and l.status = 'active'