[Digikam-devel] [Bug 273852] Showing only one tag results in photos where this tag is not set

[Francesco Riosa]

https://bugs.kde.org/show_bug.cgi?id=273852


Francesco Riosa <francesco+kde at pnpitalia.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |ASSIGNED
                 CC|                            |francesco+kde at pnpitalia.it
     Ever Confirmed|0                           |1




--- Comment #5 from Francesco Riosa <francesco+kde pnpitalia it>  2011-05-24 23:40:22 ---
confirmed; in mysql it 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=? 
           OR tagid IN (SELECT id FROM Tags WHERE lft BETWEEN (SELECT lft FROM
Tags WHERE id=?) AND (SELECT rgt FROM Tags WHERE id=?))
        )
need to review the thing (tomorrow?)

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.