https://bugs.kde.org/show_bug.cgi?id=371578
--- Comment #1 from beaaeecffmiqwryxcmbw2ta2cu...@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 watching all bug changes.
