Can anyone help me with the SQL query that will show the actual filename associated with a given mdl_resource record. I want to locate all the .flv mdl_resource records, but the filename is not in mdl_resource, but linked somehow through the database to, I'm guessing, mdl_files. This will help us determine what mdl_resource records need to be tweeked after our upgrade to 2.1.
Thanks a lot - Chris