SELECT
        SUBSTRING_INDEX(
                SUBSTRING_INDEX(
                        CONCAT(
                                "|",
                                (
                                        SELECT


                                        VALUE


                                        FROM
                                                settings
                                        WHERE
                                                NAME = 'EFTDuesPriceList'
                                        LIMIT 1
                                ),
                                "|(NODUESNAME)"
                        ),
                        CONCAT(
                                "@",
                                FORMAT(EFT_DUES_AMOUNT, 2),
                                "|"
                        ),
                        1
                ),
                "|" ,- 1
        ) AS DUES_NAME,
        FORMAT(CONVERT(EFT_DUES_AMOUNT,decimal(10,2)),2) AS EFT_DUES_AMOUNT,
        SUM(IF(current_status='OK',1,0)) AS ACTIVE_Member_Count,
        SUM(IF(current_status='FROZEN',1,0)) AS FROZEN_Member_Count,
        count(*) AS TOTAL_Member_Count
FROM
        customers
WHERE
        EFT_DUES_AMOUNT > 0
AND CURRENT_STATUS IN ('OK','FROZEN')
AND CUSTOMER_TYPE = "MEMBER"
AND MEMBERSHIP_FORM_OF_PAYMENT IN ('BILLME', 'BILLTO')
GROUP BY
        EFT_DUES_AMOUNT
ORDER BY
        EFT_DUES_AMOUNT DESC;