sql

SELECT
    b.nome,
    CONCAT('55',IF(LENGTH((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))=11 AND SUBSTR((((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))), 3, 1) = '9',
        (REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')),
        (
            IF(LENGTH((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))=11 AND SUBSTR((((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE(c2.fone,'_',''),' ',''),'(','')),')','')),'-','')))), 3, 1) = '9',
                (REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')),
                IF(LENGTH((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))=10 AND (
                    SUBSTR(((
                    (REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-',''))
                    )), 1, 3)  IN (
                        '419', '429', '439', '449', '459', '469', '479', '489', '499', '519', '539', '549', '559',
                        '418', '428', '438', '448', '458', '468', '478', '488', '498', '518', '538', '548', '558'
                        '417', '427', '437', '447', '457', '467', '477', '487', '497', '517', '537', '547', '557'
                    )
                ),
                    ((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-',''))),
                    (
                        IF(LENGTH((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))=10 AND (
                            SUBSTR((((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-',''))
                                )), 1, 3)  IN (
                                    '419', '429', '439', '449', '459', '469', '479', '489', '499', '519', '539', '549', '559',
                                    '418', '428', '438', '448', '458', '468', '478', '488', '498', '518', '538', '548', '558'
                                    '417', '427', '437', '447', '457', '467', '477', '487', '497', '517', '537', '547', '557'
                                )
                            ),
                            (((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))),
                            NULL  
                        )                      
                    )
                )
            )
        )
    )) AS CELULAR
FROM
    tb_doacao AS a
    INNER JOIN tb_usuario_dados AS b ON b.cod_usuario = a.cod_usuario
    INNER JOIN tb_usuario_fone AS c1 ON c1.cod_usuario = a.cod_usuario
    INNER JOIN tb_usuario_fone AS c2 ON c2.cod_usuario = a.cod_usuario AND c2.fone <> c1.fone
    #`valoresHfAsc``valoresHfAsc`INNER JOIN `pmkcom_hf`.`numero403` As numero403 ON numero403.
WHERE
    a.cod_campanha = '403'
    AND
	(a.pagamento_status <> 'S' OR (a.pagamento_status = 'S' AND a.data_pagamento > '2016-11-04')) 
		
    AND (
        IF(LENGTH((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))=11 AND SUBSTR((((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))), 3, 1) = '9',
        (REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')),
        (
            IF(LENGTH((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))=11 AND SUBSTR((((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE(c2.fone,'_',''),' ',''),'(','')),')','')),'-','')))), 3, 1) = '9',
            (REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')),
            IF(LENGTH((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))=10 AND (
                SUBSTR(((
                (REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-',''))
                )), 1, 3)  IN (
                '419', '429', '439', '449', '459', '469', '479', '489', '499', '519', '539', '549', '559',
                '418', '428', '438', '448', '458', '468', '478', '488', '498', '518', '538', '548', '558'
                '417', '427', '437', '447', '457', '467', '477', '487', '497', '517', '537', '547', '557'
                )
            ),
                ((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c1.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-',''))),
                (
                IF(LENGTH((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))=10 AND (
                    SUBSTR((((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-',''))
                    )), 1, 3)  IN (
                        '419', '429', '439', '449', '459', '469', '479', '489', '499', '519', '539', '549', '559',
                        '418', '428', '438', '448', '458', '468', '478', '488', '498', '518', '538', '548', '558'
                        '417', '427', '437', '447', '457', '467', '477', '487', '497', '517', '537', '547', '557'
                    )
                    ),
                    (((REPLACE((REPLACE((REPLACE(REPLACE(REPLACE((CONCAT(c2.ddd, c1.fone)),'_',''),' ',''),'(','')),')','')),'-','')))),
                    NULL  
                )                      
                )
            )
            )
        )
        )
    ) IS NOT NULL
    GROUP BY CELULAR