SELECT 
       cmsMember.nodeId
      ,cmsMember.Email
      ,cmsMember.LoginName
      ,umbracoNode.text AS fullName
      ,cmsMember.Password
  FROM [cmsMember]
  INNER JOIN umbracoNode ON umbracoNode.id = cmsMember.nodeId
  WHERE 
  Email NOT LIKE '%access.without'
  AND Email NOT LIKE '%boofx.com'
  AND Email NOT LIKE '%bvhrs.com'
  AND Email NOT LIKE 'cmillson@cantab.net'
  AND Email NOT LIKE '%companyuser%'
  AND Email NOT LIKE '%cuoly.com'
  AND Email NOT LIKE '%email.add'
  AND Email NOT LIKE '%eoopy.com'
  AND Email NOT LIKE '%jeoce.com'
  AND Email NOT LIKE '%jiooq.com'
  AND Email NOT LIKE '%mail.ru'
  AND Email NOT LIKE '%mailinator.com'
  AND Email NOT LIKE '%member.com'
  AND Email NOT LIKE '%mzico.com'
  AND Email NOT LIKE '%nthrl.com'
  AND Email NOT LIKE '%qopow.com'
  AND Email NOT LIKE '%register.com'
  AND Email NOT LIKE '%saatec.com'
  AND Email NOT LIKE '%test.com'
  AND Email NOT LIKE '%testn%'
  AND Email NOT LIKE '%zwoho.com'
  AND LoginName NOT LIKE '%access.without'
  AND LoginName NOT LIKE '%boofx.com'
  AND LoginName NOT LIKE '%bvhrs.com'
  AND LoginName NOT LIKE 'cmillson@cantab.net'
  AND LoginName NOT LIKE '%companyuser%'
  AND LoginName NOT LIKE '%cuoly.com'
  AND LoginName NOT LIKE '%email.add'
  AND LoginName NOT LIKE '%eoopy.com'
  AND LoginName NOT LIKE '%jeoce.com'
  AND LoginName NOT LIKE '%jiooq.com'
  AND LoginName NOT LIKE '%mail.ru'
  AND LoginName NOT LIKE '%mailinator.com'
  AND LoginName NOT LIKE '%member.com'
  AND LoginName NOT LIKE '%mzico.com'
  AND LoginName NOT LIKE '%nthrl.com'
  AND LoginName NOT LIKE '%qopow.com'
  AND LoginName NOT LIKE '%register.com.com'
  AND LoginName NOT LIKE '%saatec.com'
  AND LoginName NOT LIKE '%test.com'
  AND LoginName NOT LIKE '%testn%'
  AND LoginName NOT LIKE '%zwoho.com'