screen with error in displaying the data, sql code does not work

[nandosilva]

this page has an error when pressing the money button to consult, I have sql code but it is not working properly



sql code used:

SELECT
e.nomeEvento,p. nomecompl,c.nom ecasa, COALESCE(l.obse rvacao,'Sem informação') AS `observacao`, CONCAT('R$ ',REPLACE(REPLA CE(REPLACE(FORM AT(IFNULL(l.val orExtornado, 0), 2), ".", "@"), ",", "."), "@", ",")) AS `valorExtornado `,
l.idpart, l.parcela, p.id AS idParticipante, DATE_FORMAT(l.d atavcto, '%d/%m/%Y') AS `dataVcto`,
CONCAT('R$ ',REPLACE(REPLA CE(REPLACE(FORM AT(l.valor, 2), ".", "@"), ",", "."), "@", ",")) AS `valorDevido`,
IF(l.datapgto IS NULL,'danger',' success') AS `pagoCSS`,
IF(l.datapgto IS NULL,'Pendente' ,'Pago') AS `pago`,
IFNULL(DATE_FOR MAT(l.datapgto, '%d/%m/%Y'),'') AS `dataPgto`, CONCAT('R$ ',REPLACE(REPLA CE(REPLACE(FORM AT(IFNULL(l.val orpago, 0), 2), ".", "@"), ",", "."), "@", ",")) AS `valorPago`,
(SELECT COUNT(1) FROM UF_financeiro_l ctofinan WHERE id_eventos_part icipante=p.id AND fl_excluido='N' ) AS NUM_PARCELAS
FROM UF_financeiro_l ctofinan AS l
LEFT JOIN UF_eventos_part icipantes AS p ON l.id_eventos_pa rticipante=p.id
LEFT JOIN UF_eventos AS e ON e.id_evento=p.i d_evento
LEFT JOIN UF_casas AS c ON p.idcasainscr = c.idcasa
LIMIT 150 -- retirar esse LIMIT depois, isso é apenas para debugar

[dev7060]

What is it in English?