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;