select distinct CONCAT (tc.numero) as Numero, tc.fecha as Fecha, tc.tipo_docto as Docto, tc.serie as Serie, tc.total as Cargo, tc.saldo as Saldo, tc.tipo_docto as Docto, numero_cancelado as Guia from transacciones as tc Left join doc_cancelados As dc On tc.numero = dc.numero_cancelado and tc.serie = dc.serie_cancelada left join transacciones as tc1 on dc.numero = tc1.numero and dc.serie = tc1.serie where tc.codigo_cliente = 10138 and (tc.saldo <> 0 or (tc1.fecha >= ((select concat_ws('-', ifnull(MAX(anio), year(now())), ifnull(MAX(mes), month(now())), 01) from mes_operacion)) and (tc1.tipo_docto = 'RC' or tc1.tipo_docto = 'NC' or tc1.tipo_docto = 'NB' or tc1.tipo_docto = 'FEL'))) order by tc.fecha, Docto, numero;

SELECT DISTINCT CONCAT (tc.numero) as Numero, tc.fecha as Fecha, tc.tipo_docto as Docto, tc.serie as Serie,  tc.total as Cargo, tc.saldo as Saldo, tc.tipo_docto as Docto, numero_cancelado as Guia FROM transacciones as tc 
LEFT JOIN doc_cancelados As dc On tc.numero = dc.numero_cancelado AND tc.serie = dc.serie_cancelada
LEFT JOIN transacciones as tc1 ON dc.numero = tc1.numero AND dc.serie = tc1.serie
WHERE tc.codigo_cliente =  10138 AND (tc.saldo <> 0 OR (tc1.fecha >= 
((SELECT CONCAT_WS('-', IFNULL(MAX(anio), YEAR(NOW())), IFNULL(MAX(mes), MONTH(NOW())), 01) FROM mes_operacion)) AND 
(tc1