tried this for my other post, but return 0 values:

select person.idperson, folderstatus.idtypestatus,typestatus.idcheck,
folder.datefolder, folder.idclient, 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
group by folder.idfolder
having (folderstatus.idtypestatus = max(folderstatus.idtypestatus) and
typestatus.idcheck = 0)