How to find files with no author (orphan files)

[SJ77]

HI,

Trying to setup a block to list downloads files by "guest"
I have many files that no longer have an author because the member deleted their account.

How can I select only those files?

Thank you 🙂

 

[SJ77]

Well one option is to create an actual guest account and then every so often run this query assuming your guest account has ID of 131225

Update downloads_files SET file_submitter = 131225
where file_submitter = 0;