[Digikam-users] Re: Digikam DB doc

[Matthieu]

On 05/14/2011 01:31 PM, Matthieu wrote:
>    Hello,
> 
> 
> Also I would like to be able to search for all the pictures without
> geolocation information.
> 

In case anyone is interested that would be:

SELECT a.relativePath, i.name FROM Images i INNER JOIN Albums a ON
i.album=a.id  LEFT JOIN ImagePositions ip ON i.id=ip.imageid WHERE
ip.latitude IS NULL