Fotografieren: Adobe Lightroom: Sample SQL Query – Metadaten meiner Fotos

Zum Auslesen von Metadaten über meine katalogisierten Fotos habe ich begonnen, eine SQL-Abfrage aufzubauen:

Select AgLibraryIPTC.id_local, caption, AgLibraryIPTC.image, rootFile, originalFilename, locationRef, cityRef, countryRef, AgInternedIptcCity.value from AgLibraryIPTC, Adobe_images, AgLibraryFile, AgHarvestedIptcMetadata, AgInternedIptcCity where (AgLibraryIPTC.image=Adobe_images.id_local) AND (rootFile=AgLibraryFile.id_local) AND extension="JPG" AND (AgLibraryIPTC.image=AgHarvestedIptcMetadata.image) AND (cityRef=AgInternedIptcCity.id_local)

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*
Website