select Year(ci.data) as ano, month(ci.data) as mes, round( sum(ci.valor)) as "Valor a Receber R$"  from conta_item ci
inner join conta c using(id_conta)
where ci.ativo = 'S' and c.ativo = 'S'
and c.tipo_conta = 'Receber'
and (ci.data_pagamento is null or ci.data_pagamento = '' or ci.data_pagamento='0000-00-00')
and month(ci.data) = month(current_date)
group by ano,mes
order by data