SELECT mfl.id,mcr.id AS courseid, mus.firstname, mcr.fullname,mfl.filename,mfl.contenthash,mag.name, FROM_UNIXTIME(mfl.timecreated) AS timecreateds, FROM_UNIXTIME(mfl.timemodified) AS timemodifieds FROM mdl_course_modules mcm JOIN mdl_context mct ON mcm.id=mct.instanceid JOIN mdl_files mfl ON mct.id=mfl.contextid JOIN mdl_user mus ON mfl.userid=mus.id JOIN mdl_course mcr ON mcm.course=mcr.id JOIN mdl_assign mag ON mag.id=mcm.instance WHERE mcm.module = 1 AND mct.contextlevel = '70' AND mfl.filesize!=0 AND mfl.component='assignsubmission_file'