Helpful SQL commands for debugging purpose

List all the trash entries without corresponding oc_filecache entry

select t.* from oc_group_folders_trash as t LEFT join oc_filecache as f on f.path = CONCAT("__groupfolders/trash/", t.folder_id, "/", t.name, ".d", t.deleted_time) where f.fileid is NULL;
``