[digikam] [Bug 371578] untagged images no longer shown in "no tags" overview when removing existing tag

[via KDE Bugzilla]

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

--- Comment #1 from beaaeecffmiqwryxcmbw2ta2cukc4 at protected32.unixadm.org ---
For those who want to "clean up" their database, that's how I did it.
Please be REALLY careful and VERIFY the results BEFORE the delete statement.

CREATE TABLE ImageDeleteMe (imageid INT(11) NOT NULL);

INSERT INTO ImageDeleteMe
    SELECT DISTINCT imageid FROM ImageTags WHERE
        tagid IN (
            SELECT id FROM Tags WHERE pid = ( 
                SELECT id FROM Tags WHERE name = '_Digikam_Internal_Tags_'
            ) AND name LIKE ('% None')
        ) AND 
        imageid NOT IN (
            SELECT imageid FROM ImageTags WHERE tagid NOT IN (
                SELECT id FROM Tags WHERE pid = ( 
                    SELECT id FROM Tags WHERE name = '_Digikam_Internal_Tags_'
                ) AND name LIKE ('% None')
            )
        );  

DELETE FROM ImageTags WHERE imageid IN (
    SELECT imageid FROM ImageDeleteMe
);

DROP TABLE ImageDeleteMe;

-- 
You are receiving this mail because:
You are the assignee for the bug.