The first screen show is mdl_files_reference table ... not the same as mdl_files table.

Can see they are all videos ... mp4's ... and the repo id on them show the number 12 .... + they have a 'lastsync' that's an epoch time stamp.   Many of their names have #.nameofvideo.mp4. There is, however, no repo ID 12.

I guess the #. in their filenames was for your purposes in display ordering them?

Do you re-call if you uploaded the .mp4's to a file system repo via FTP and then linked to them or not/

Let's take just one of the video file names:

2.Being Single.mp4 ... which has a space in it's name .... 2.Being%20Single.mp4.

Use phpmyadmin and query the mdl_files table for the 'filename like '2.Being'.   That's just the front of the file name before the space.

Can't show you what it would look like exactly, but the output of looking at mdl_files for that file name should show a 'contenthash' ... bunch of letters and numbers .... looks like

ab04ab04wqsele34lsksksk

The  file location is actually in:

moodledata/filedir/ab/04/ and the actual file name is as above.

First 2 characters of the contenthash is a subdirectory of moodledata/filedir/

moodledata/filedir/ab/

The 2nd 2 characters of the contenhash is a subdirectory of the subdirectory above.

moodledata/filedir/ab/04/

Inside the last, a file named thusly:

ab04ab04wqsele34lsksksk

Dunno if your tool that browses files also has a mimetype or get file attributes or not ... but if that was one of those .mp4's it should show that.

Now if you used a file system repo in those courses those files might have been in:

moodledata/repository/[somedirectory] where [somedirectory] may have been something like 'vidoes'.

Did you ever use box or any other remote file system like 'drop box' for the videos?  Were these courses using "Legacy files"?

'spirit of sharing', Ken