Creditos Reporte

SELECT c.id, em.nombre as nombre_empresa, c.empresa, c.id_cliente, c.ejecutivo, c.fecha_solicitud, c.deudor, c.taza_anual, c.orden_venta, c.enganche, c.monto, c.monto_pagado, c.fecha_captura, c.hora_captura, c.plazo_meses, c.plazo, c.taza_anual, c.pago_fijo, c.usuario_captura, c.status, c.dia_pago, emp.nombre, emp.ap_paterno, emp.ap_materno, c.status, cte.referencia, cte.cliente as nombre_cliente, mc.clave_moneda, e.monto as monto_pagado, e.id as folio, e.ieps, e.moneda, e.tipo_cambio, fp.descripcion as forma_pago, e.tns_interna, e.tipo, e.fecha_pago, c.tipo as tipoCredito, YEAR(e.fecha_pago) as year, MONTHNAME(e.fecha_pago) as mes, e.descripcion, ( SELECT SUM(eg.monto) FROM egreso AS eg WHERE eg.credito=c.id and eg.movimiento='INGRESO') AS TotalPagodo, ov.status as status_ov FROM creditos as c LEFT JOIN orden_venta as ov ON c.orden_venta=ov.id LEFT JOIN c_empresa AS em ON em.id=c.empresa LEFT JOIN egreso as e ON e.credito=c.id and movimiento='INGRESO' LEFT JOIN c_forma_pago as fp ON fp.id_forma_pago=e.forma_pago LEFT JOIN usuarios AS u ON c.usuario_captura = u.id LEFT JOIN empleados as emp ON emp.id_empleado=u.id_relacion LEFT JOIN c_moneda as mc ON mc.id=c.moneda LEFT JOIN c_cliente as cte ON cte.id_cliente=c.id_cliente ORDER BY e.fecha_pago DESC