select cc.userid,cc.course,cm.instance,cc.timecompleted from mdl_course_completions cc,mdl_course_modules cm where cc.timestarted is not NULL and cc.timestarted != '0' and cm.course in (select id from mdl_course where idnumber between '100' and '300') and cc.course=cm.course and cm.module=(select id from mdl_modules where name='quiz') order by cc.course
select id,email from tbl_course_completion_email where userid='2149' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='1538' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='1915' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='931' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='1923' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='729' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='1797' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='1217' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='1925' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='728' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='2184' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='741' and courseid='3' and quizid='5'
select id,email from tbl_course_completion_email where userid='1923' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='776' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='1797' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='931' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='2184' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='1217' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='2149' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='728' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='741' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='1915' and courseid='4' and quizid='6'
select id,email from tbl_course_completion_email where userid='1923' and courseid='5' and quizid='7'
select id,email from tbl_course_completion_email where userid='2184' and courseid='5' and quizid='7'
select id,email from tbl_course_completion_email where userid='1797' and courseid='5' and quizid='7'
select id,email from tbl_course_completion_email where userid='2149' and courseid='5' and quizid='7'
select id,email from tbl_course_completion_email where userid='1217' and courseid='5' and quizid='7'
select id,email from tbl_course_completion_email where userid='1915' and courseid='5' and quizid='7'
select id,email from tbl_course_completion_email where userid='2184' and courseid='6' and quizid='8'
select id,email from tbl_course_completion_email where userid='2149' and courseid='6' and quizid='8'
select id,email from tbl_course_completion_email where userid='1217' and courseid='6' and quizid='8'
select id,email from tbl_course_completion_email where userid='1797' and courseid='6' and quizid='8'
select id,email from tbl_course_completion_email where userid='1217' and courseid='7' and quizid='14'
select id,email from tbl_course_completion_email where userid='2184' and courseid='7' and quizid='14'
select id,email from tbl_course_completion_email where userid='1797' and courseid='7' and quizid='14'
select id,email from tbl_course_completion_email where userid='2149' and courseid='7' and quizid='14'
select id,email from tbl_course_completion_email where userid='2184' and courseid='18' and quizid='48'
select id,email from tbl_course_completion_email where userid='2149' and courseid='18' and quizid='48'
select id,email from tbl_course_completion_email where userid='1797' and courseid='18' and quizid='48'