SELECT
CONCAT(c.LASTNAME,', ',c.FIRSTNAME) Member_Name,
c.CUSTOMER_TYPE,
c.CURRENT_STATUS,
IF(c.BANK_ROUTE <> '','#######','') BANK_ROUTE,
IF(c.BANK_ACCOUNT <> '','######','') BANK_ACCOUNT,
c.XW_MASKED_CC
FROM
customers c
WHERE
c.CUSTOMER_TYPE = 'MEMBER' AND
(c.CURRENT_STATUS = 'OK' OR
c.CURRENT_STATUS = 'FROZEN') AND
c.MEMBERSHIP_FORM_OF_PAYMENT = 'BILLME' AND
c.BANK_ROUTE <> '' AND
c.BANK_ACCOUNT <> '' AND
c.XW_MASKED_CC <> ''