Skip to content

Instantly share code, notes, and snippets.

@thany
Last active June 7, 2023 22:54
Show Gist options
  • Save thany/61af30b8255a040a92d98870d2cf4eb1 to your computer and use it in GitHub Desktop.
Save thany/61af30b8255a040a92d98870d2cf4eb1 to your computer and use it in GitHub Desktop.
Getting full image filenames + creators from a Lightroom catalog
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