select distinct /*c.id cliente_id, pes.id pessoa_id,*/ pes.nomerazao, pes.fantasia, pes.cpfcnpj, pes.fone1, pes.fone2, pes.fone3, pes.email,
    (
        select max(pdd.created_at)
        from ecommerce.pedido pdd
        where pdd.cliente_id = c.id
    ) ultimopedidocriado,
    (
        select count(*)
        from ecommerce.pedido pdd
        where pdd.cliente_id = c.id
        and pdd.situacao = 0
    ) qtdpedidossalvos
from ecommerce.cliente c
inner join ecommerce.pessoa pes
on pes.id = c.pessoa_id
inner join ecommerce.pedido pd
on pd.cliente_id = c.id
where c.id not in (
    select p.cliente_id
    from ecommerce.pedido p
    inner join ecommerce.pedidosituacaolog s
    on s.pedido_id = p.id
    where s.situacao = 1
    group by p.cliente_id
) and c.status = 1 and pes.status = 1;