select count(*) from fmsistemas10.pedido a left join nfe.shopee_tracker b using(pedido_id) 
		where a.estatus in (18,0,5,9) 
		and loja in (select loja from nfe.shopee where expira>current_timestamp)
		and b.status not in (1,2,3)