Create table Portfolios(KlientoID integer);

insert into Portfolios(KlientoID) Values
(1);
insert into Portfolios(KlientoID) Values
(2);
insert into Portfolios(KlientoID) Values
(6);



create table ClientsPortfolios(KlientoID integer, ClientID integer);


Insert into ClientsPortfolios(KlientoID, ClientID ) Values (1,3);

Insert into ClientsPortfolios(KlientoID, ClientID ) Values (2,3);

Insert into ClientsPortfolios(KlientoID, ClientID ) Values (5,4);

Insert into ClientsPortfolios(KlientoID, ClientID ) Values (8,4);
Insert into ClientsPortfolios(KlientoID, ClientID ) Values (5,4);
Insert into ClientsPortfolios(KlientoID, ClientID ) Values (6,25);
Insert into ClientsPortfolios(KlientoID, ClientID ) Values (20,25);
Insert into ClientsPortfolios(KlientoID, ClientID ) Values (6,20);


select  kl.KlientoID from ClientsPortfolios as kl
where  (kl.ClientID  in  (select  cl.ClientID from ClientsPortfolios as cl group by cl.ClientID having Count(cl.ClientID) > 1 and  kl.KlientoID in (select notas.KlientoID from Portfolios as notas)))
or (kl.ClientID  in( select cl.ClientID from ClientsPortfolios as cl group by cl.ClientID having Count(cl.ClientID) > 1))
and kl.KlientoID  in(select kl.KlientoID from Portfolios as kl);

 select cl.KlientoID from ClientsPortfolios cl  where (cl.ClientID in (select kl.ClientID from ClientsPortfolios as kl group by kl.ClientID having Count(kl.ClientID) > 1) and (cl.KlientoID in (select pl.KlientoID from Portfolios as pl))) or
 (cl.ClientID in(select zl.ClientID from ClientsPortfolios as zl group by zl.ClientID having Count(zl.ClientId) > 1) and (cl.KlientoID not  in (select zl.KlientoID from Portfolios as zl group by zl.KlientoID ) and (cl.ClientID in ( select zl.ClientID from ClientsPortfolios as zl group by zl.ClientID having Count(zl.ClientId) > 1) )));


 select
 case when (cl.CLientID in (select zl.ClientID from ClientsPortfolios as zl group by zl.ClientID having Count(zl.ClientId) > 1) and cl.KlientoID in (select zl.KlientoID from Portfolios as zl))  then cl.KlientoID
when (cl.CLientID in (select zl.ClientID from ClientsPortfolios as zl group by zl.ClientID having Count(zl.ClientId) > 1) and cl.KlientoID not in (select zl.KlientoID from Portfolios as zl)) then
case  when cl.CLientID  in (select zl.ClientID from ClientsPortfolios as zl group by zl.ClientID having Count(zl.ClientId) > 1) and cl.ClientID not in (select zbig.ClientID from ClientsPortfolios as zbig
where (zbig.KlientoID  in (select c.KlientoID from Portfolios as c))) then cl.KlientoID end
 end
 from ClientsPortfolios as cl;




select ClientID from ClientsPortfolios
where (KlientoID not in (select c.KlientoID from Portfolios as c));

select  * from ClientsPortfolios
LIMIT 1;


select  cl.KlientoID from ClientsPortfolios as cl where( cl.ClientID in (select sl.ClientID from ClientsPortfolios as sl group by sl.ClientID having Count(sl.ClientID) > 1) and cl.KlientoID in (select sl.KlientoID from Portfolios as sl))
or cl.ClientID in (select sl.ClientID from ClientsPortfolios as sl group by sl.ClientID having Count(sl.ClientID) > 1)
and cl.ClientID not in (select zbig.ClientID from ClientsPortfolios as zbig
where (zbig.KlientoID  in (select c.KlientoID from Portfolios as c)))
LIMIT 1;