");";
")";
    public static void removeRedundant(Context context)        throws SQLException    {        // this horrid looking query tests to see if there are any groups or        // workspace items which match up to the ones in the linking database        // table.  If there aren't, we know that the link is out of date, and         // it can be deleted.        String query = "DELETE FROM epersongroup2workspaceitem " +                       "WHERE NOT EXISTS ( " +                       "SELECT 1 FROM workspaceitem WHERE workspace_item_id " +                       "= epersongroup2workspaceitem.workspace_item_id " +                       ") OR NOT EXISTS ( " +                       "SELECT 1 FROM epersongroup WHERE eperson_group_id " +                       "= epersongroup2workspaceitem.eperson_group_id " +                       ");";                DatabaseManager.updateQuery(context, query);    }