-- @query details_local_path
-- @db localContent 32.0
-- @param localId TEXT
SELECT h.ItemPath
FROM localContent.ItemHierarchyView h
JOIN localContent.ItemMetadata im ON h.FileSystemID = im.FileSystemID
WHERE im.LocalID = ?localId
LIMIT 1