SELECT
  UserID,
  CONCAT(FullName,' (',EmailAddress,')') AS UserLabel
FROM
  taUsers
WHERE
  (Status = 1) AND
  (EmailAddress IS NOT NULL) AND
  (LENGTH(EmailAddress) > 0)
ORDER BY
  UserLabel
