I need select quiz regarding specific course so I used this query
SELECT * FROM moodle_amsg_2017.mdl_quiz where course=4;
but it also select deleted quizzes in that course, how can i exclude those deleted quizzes.
I haven't seen any is_deleted flag in db. Any idea ?
When a quiz is deleted, the entry in the mdl_quiz table should also be deleted (specifically, by this line of code: https://github.com/moodle/moodle/blob/master/mod/quiz/lib.php#L205 ).
If that is not happening, then there is a bug on your system that needs investigating.