https://bugs.kde.org/show_bug.cgi?id=334014
--- Comment #5 from Daniel Vrátil <[email protected]> --- Try this please (sorry, I don't have MySQL DB with Akonadi database in it to test the queries at the moment) DELETE FROM CollectionTable WHERE parentId NOT IN (SELECT * FROM (SELECT id FROM CollectionTable) AS tableA) AND parentId IS NOT NULL; -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Kdepim-bugs mailing list [email protected] https://mail.kde.org/mailman/listinfo/kdepim-bugs
