[Digikam-devel] [Bug 273852] Showing only one tag results in photos where this tag is not set
Marcel Wiesweg
marcel.wiesweg at gmx.de
Mon May 23 19:51:00 BST 2011
https://bugs.kde.org/show_bug.cgi?id=273852
--- Comment #3 from Marcel Wiesweg <marcel wiesweg gmx de> 2011-05-23 20:50:59 ---
I am testing with 2.0 and SQlite, so chances are I cannot reproduce this.
The relevant SQL is
SELECT DISTINCT Images.id, Images.name, Images.album,
Albums.albumRoot,
ImageInformation.rating, Images.category,
ImageInformation.format,
ImageInformation.creationDate,
Images.modificationDate, Images.fileSize,
ImageInformation.width,
ImageInformation.height
FROM Images
INNER JOIN ImageInformation ON
Images.id=ImageInformation.imageid
INNER JOIN Albums ON Albums.id=Images.album
WHERE Images.status=1 AND Images.id IN
(SELECT imageid FROM ImageTags
WHERE tagid=:tagID );
so the relevant subquery is
SELECT imageid FROM ImageTags WHERE tagid=:tagID
which is simple enough.
--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Digikam-devel
mailing list