SELECT "10220256306000110000"                                                                          AS campo1
     , LPAD(CONCAT("00", contacra.carteira, LPAD(contacra.agencia, 5, "0"), "000", contacra.conta, contacra.contaDv),
            17, "0")                                                                                   AS campo2
     , "                         "                                                                     AS campo3
     , "00000000"                                                                                      AS campo4
     , boleto.nossoNumero                                                                              AS campo5
     , "0000000000000000000000R00906"                                                                  AS campo6
     , DATE_FORMAT(NOW(), "%d%m%y")                                                                    AS campo7
     , "          "                                                                                    AS campo8
     , "00000000"                                                                                      AS campo9
     , boleto.nossoNumero                                                                              AS campo10
     , DATE_FORMAT(boleto.dataVencimento, "%d%m%y")                                                    AS campo11
     , SUM(retornotitulo.saldoTitulo)                                                                  AS valor
     , contacra.codigoBanco                                                                            AS campo13
     , "04274"                                                                                         AS campo14
     , "  "                                                                                            AS campo15
     , "000000000000000000000000000000000000000000000000000000000000000000000000000000"                AS campo16
     , SUM(retornotitulo.saldoTitulo) + boleto.valorTaxa                                               AS valorPago
     , "000000000000000000000000000  "                                                                 AS campo18
     , DATE_FORMAT(boleto.dataVencimento, "%d%m%y")                                                    AS campo19
     , "             00000000000000                                                                  " AS campo20
     , retornotitulo.saldoTitulo                                                                       AS saldo
FROM boleto
         INNER JOIN contacra ON contacra.id_contacra = boleto.id_contacra
         INNER JOIN boletoretorno ON boletoretorno.id_boleto = boleto.id_boleto
         INNER JOIN retornotitulo ON retornotitulo.id_retornotitulo = boletoretorno.id_retornotitulo
GROUP BY boleto.id_boleto;