Skip to content

Instantly share code, notes, and snippets.

@kalyan02

kalyan02/lightroom_select.sql

Created December 14, 2012 09:11
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 kalyan02/4283903 to your computer and use it in GitHub Desktop.
Save kalyan02/4283903 to your computer and use it in GitHub Desktop.
Download ZIP
Query to select all the images, their metadata, tags, attributes, info about virtual copy, parent copy, etc from your "Lightroom" sqlite file ( .lrcat catalog file )
Raw
lightroom_select.sql
SELECT
rf.absolutePath,
fo.pathFromRoot,
fi.baseName || '.' || fi.extension as fullName,
ai.*,
ds.*,
fi.*,
rf.*
FROM
Adobe_images ai
LEFT JOIN
Adobe_imageDevelopSettings ds
ON ai.id_local = ds.image
LEFT JOIN
AgLibraryFolderStackImage fsi
ON ai.id_local = fsi.image
LEFT JOIN
AgLibraryFile fi on ai.rootFile = fi.id_local
LEFT JOIN
AgLibraryFolder fo on fi.folder = fo.id_local
LEFT JOIN
AgLibraryRootFolder rf on fo.rootFolder = rf.id_local
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment