add this to the script:
INSERT INTO `folderstatus` VALUES ('14', '3', '5');
update `typestatus` set idcheck = 0 where idtypestatus = 5;

Now the query:
select folder.idperson, folderstatus.idtypestatus,typestatus.idcheck,
folderstatus.idfolderstatus,
folder.datefolder, folder.idfolder
from typestatus
inner join folderstatus on typestatus.idtypestatus =
folderstatus.idtypestatus
inner join folder on folderstatus.idfolder = folder.idfolder
inner join person on folder.idperson = person.idperson
inner join client on folder.idclient = client.idclient
where typestatus.idcheck = 0
group by idtypestatus, idfolder
having (idfolderstatus = max(folderstatus.idfolderstatus))

I've 4 results but IdFolder 3 is shown twice and I only want the bigger
idfolderstatus for every folder.

How to do so ? I seem close to the final result, I've tried to group by
different manners but no way. Something's wrong and I'm not a MySQL gourou,
so please help me.

Bob