I tried this query for generating quiz' questions and their answers. But this query depends in user's attempt on quiz.
select
distinct q.course,
q.name,
quiza.quiz,
qa.questionsummary,
qa.rightanswer
FROM
mdl_quiz_attempts quiza
JOIN mdl_quiz q ON q.id = quiza.quiz
JOIN mdl_question_usages qu ON qu.id = quiza.uniqueid
JOIN mdl_question_attempts qa ON qa.questionusageid = qu.id
where
q.id = 1
What I want is regular sql query to list questions and answer by quiz.id/course/id, irrelevant to user's attempt on quiz. Can someone help me?