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
     , boletocomum.nossoNumero                                                                         AS campo5
     , "0000000000000000000000R00906"                                                                  AS campo6
     , DATE_FORMAT(NOW(), "%d%m%y")                                                                    AS campo7
     , "          "                                                                                    AS campo8
     , "00000000"                                                                                      AS campo9
     , boletocomum.nossoNumero                                                                         AS campo10
     , DATE_FORMAT(boletocomum.dataVencimento, "%d%m%y")                                               AS campo11
     , SUM(boletocomum.valor)                                                                          AS valor
     , contacra.codigoBanco                                                                            AS campo13
     , "04274"                                                                                         AS campo14
     , "  "                                                                                            AS campo15
     , "000000000000000000000000000000000000000000000000000000000000000000000000000000"                AS campo16
     , SUM(boletocomum.valor + boletocomum.valorTaxa)                                                  AS valorPago
     , "000000000000000000000000000  "                                                                 AS campo18
     , DATE_FORMAT(boletocomum.dataVencimento, "%d%m%y")                                               AS campo19
     , "             00000000000000                                                                  " AS campo20
     , boletocomum.valor                                                                               AS saldo
FROM boletocomum
         INNER JOIN boletoROTINAQUEVCESTATESTANDO ON boletoROTINAQUEVCESTATESTANDO.id_boletocomum = boletocomum.id_boletocomum
         INNER JOIN contacra ON contacra.id_contacra = boletoROTINAQUEVCESTATESTANDO.id_contacra
GROUP BY boletocomum.nossoNumero;