I was wondering if you could help me with this Query.
select b.firstname, b.lastname, b.email, d.fullname as CourseName, d.shortname as ModuleIdentifier, a.submission_grade, DATE_ADD('1970-01-01', INTERVAL a.submission_modified SECOND) AS SubmissionDateTime from mdl_turnitintooltwo_submissions as a
join mdl_user as b on a.userid = b.id
join mdl_turnitintooltwo c on c.id = a.id
join mdl_course d on c.course = d.id
This is only picking up 1000 reports. I had earlier changed the report limit but on this report its picking up only 1000 odd reports probably something wrong in the Query.
Any help would be appreciated