Skip to content

Instantly share code, notes, and snippets.

@thany

thany/Lightroom filenames & creators.sql

Last active June 7, 2023 22:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save thany/61af30b8255a040a92d98870d2cf4eb1 to your computer and use it in GitHub Desktop.
Save thany/61af30b8255a040a92d98870d2cf4eb1 to your computer and use it in GitHub Desktop.
Download ZIP
Getting full image filenames + creators from a Lightroom catalog
Raw
Lightroom filenames & creators.sql
select
replace(AgLibraryRootFolder.absolutePath || AgLibraryFolder.pathFromRoot || AgLibraryFile.idx_filename, '/', '\') as filename,
AgInternedIptcCreator.value as creator
from AgHarvestedIptcMetadata
left join AgInternedIptcCreator on AgHarvestedIptcMetadata.creatorRef=AgInternedIptcCreator.id_local
left join Adobe_images on AgHarvestedIptcMetadata.image=Adobe_images.id_local
left join AgLibraryFile on Adobe_images.rootFile=AgLibraryFile.id_local
left join AgLibraryFolder on AgLibraryFile.folder=AgLibraryFolder.id_local
left join AgLibraryRootFolder on AgLibraryFolder.rootFolder=AgLibraryRootFolder.id_local
where creator is not null
order by filename
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment