``` select path from file AS f join users u WHERE ...
# general
g
Copy code
select path from file AS f join users u WHERE f.path LIKE u.directory || '/Library/RenderFiles/%';