SELECT
CONCAT(c.LASTNAME,', ',c.FIRSTNAME) 'NAME',
FORMAT(ROUND(DATEDIFF(CURDATE(),c.bday)/365,1),1) AGE,
c.EMAIL,
SUBSTRING_INDEX(
                SUBSTRING_INDEX(
                        CONCAT(
                                "|",
                                (
                                        SELECT


                                        VALUE


                                        FROM
                                                settings
                                        WHERE
                                                NAME = 'EFTDuesPriceList'
                                        LIMIT 1
                                ),
                                "|(NODUESNAME)"
                        ),
                        CONCAT(
                                "@",
                                FORMAT(c.EFT_DUES_AMOUNT, 2),
                                "|"
                        ),
                        1
                ),
                "|" ,- 1
        ) AS DUES_NAME,
FORMAT(convert(c.EFT_DUES_AMOUNT,decimal(10,2)),2) AS EFT_DUES_AMOUNT,
c.CURRENT_STATUS,


CONCAT(r.LASTNAME,', ',r.FIRSTNAME) 'BILLTO'
FROM
        customers c
LEFT JOIN customers r ON r.CUSTOMER_ID = c.RESPONSIBLE_PARTY_ID
WHERE
        c.EFT_DUES_AMOUNT > 0
        AND c.CURRENT_STATUS IN ('OK','FROZEN')
        AND c.CUSTOMER_TYPE = "MEMBER"
        AND c.MEMBERSHIP_FORM_OF_PAYMENT IN ('BILLME', 'BILLTO')
ORDER BY
c.EFT_DUES_AMOUNT DESC,
c.LASTNAME ASC,
c.FIRSTNAME ASC