burkybang
02/08/2022, 6:45 PMRichard Tanner
02/08/2022, 7:36 PMselect
  f.id,
  f.name,
  fo.appfolder,
  replace(fo.appfolder,' : ','/')||'/'||f.name as path
from
  File f
  join MediaItemFolder fo on fo.id = f.folder
where
  replace(fo.appfolder,' : ','/')||'/'||f.name=<PATH TO LOOKUP>burkybang
02/08/2022, 7:38 PMRichard Tanner
02/08/2022, 7:38 PMburkybang
02/08/2022, 7:39 PMburkybang
02/08/2022, 7:43 PM