Im guessing there might be a SP of this but can't seem to find one.
One way to do it is to take the [tblTree] and combine it with the URLSegment from tblPageLanguage.
Else if you have access to edit mode and just want the list to do a access to all the pages you could get the pageIds and just go to /<UIsecretPath>/edit/default.aspx?id=<pageId>
Hi Guys, Just wondering if there is a query that will return the full page link. I can get the pagelink ie "~/link/9a0b36db31914b959638525a4cbaa820.aspx" but it doesn't work (even if I included the id of the page. This is episerver 6.