SELECT Parent.Numero,ParentVersion.Title FROM Parent INNER JOIN Child ON Parent.Numero=Child.NoParent WHERE Child.Numero = (SELECT TOP 1 Numero FROM Child Child2 WHERE Child2.NoParent=Parent.Numero ORDER BY Child2.ModDate DESC)