SELECT C.ID ,C.UUID ,C.NavigationID ,C.ContentTypeID ,C.Headline ,C.Abstract ,C.Author ,C.Source ,C.Location ,C.Body ,C.InternalURL ,C.ExternalURLFlag ,C.ExternalURL ,C.FileName ,C.AuditUserUUID ,C.DisplayFlag ,C.ArticleDateTime ,C.StartDateTime ,C.EndDateTime ,C.PublishDateTime ,C.DisplayDate ,C.CreateDateTime ,C.UpdateDateTime ,C.DeleteDateTime ,N.Label AS Label FROM Content C, Navigation N WHERE C.ID = #url.id# AND N.ID = C.NavigationID