public int mdl_question_usages_DS_state_finished_() { string procname = @"SELECT mdl_question_usages.id, mdl_question_usages.contextid, mdl_question_usages.component, mdl_question_usages.preferredbehaviour FROM mdl_question_usages INNER JOIN mdl_quiz_attempts ON mdl_question_usages.id = mdl_quiz_attempts.uniqueid WHERE mdl_quiz_attempts.state='finished'"; DbAccessMySqlOffline db = new DbAccessMySqlOffline(); db.CreateNewSqlCommand_Text(); return(db.Execute_int(procname)); }