SET @cartorio_id = 33; SET @taxaBoleto = (SELECT taxa_boleto FROM parametro_boleto); SELECT "10209577844000174000" AS campo1 , "00090032000005002" AS campo2 , " " AS campo3 , "00000000" AS campo4 , boleto.nosso_numero AS campo5 , "0000000000000000000000R00906" AS campo6 , DATE_FORMAT(NOW(), "%d%m%y") AS campo7 , " " AS campo8 , "00000000" AS campo9 , boleto.nosso_numero AS campo10 , DATE_FORMAT(boleto.data_vencimento, "%d%m%y") AS campo11 , SUM(titulo_encargo.valor) + titulo.saldo + @taxaBoleto AS valor , "237" AS campo13 , "00320" AS campo14 , " " AS campo15 , "000000000000000000000000000000000000000000000000000000000000000000000000000000" AS campo16 , SUM(titulo_encargo.valor) + titulo.saldo + @taxaBoleto AS valorPago , "000000000000000000000000000 " AS campo18 , DATE_FORMAT(boleto.data_vencimento, "%d%m%y") AS campo19 , " 00000000000000 " AS campo20 , SUM(titulo_encargo.valor) + titulo.saldo + @taxaBoleto AS saldo FROM boleto INNER JOIN envolvido on boleto.envolvido_id = envolvido.id INNER JOIN titulo ON titulo.id = envolvido.titulo_id INNER JOIN titulo_encargo ON titulo_encargo.titulo_id = titulo.id WHERE titulo.protocolo IN (0000000515) AND titulo.cartorio_id = @cartorio_id GROUP BY boleto.nosso_numero;