When querying the database, the following script can be run to return the location of the content item in the workarea as well as its folder path on the file system to locate the file. This query will return the path to the content in the workarea and the ID path for corresponding assets/privateassets on the file system
--Replace x with the content id
select content_folder_tbl.FolderPath, '/0/' + content_folder_tbl.FolderIdPath from content_folder_tbl
inner join content on content.folder_id = content_folder_tbl.folder_id
where content_id = x