Sorry that was a really much more complicated. I think I understand whey the syntax was changed now. However all the questions of this type really need to be reviewed now. I put together an SQL query for Configurable reports that finds all questions with unshuffled MC subquestions and provides links to test and edit them.
SELECT DISTINCT
COALESCE(cc.instanceid, m.course) AS courseid,
qc.name AS categoryname,
CONCAT('<a target="_new" href="%%WWWROOT%%/question/preview.php?id=',
parent.id,
CASE WHEN (cm.instanceid IS NULL) THEN '' ELSE CONCAT('&cmid=',cm.instanceid) END,
'">',parent.id,'</a>',
' <a target="_new" href="%%WWWROOT%%/question/question.php?courseid=',
COALESCE(cc.instanceid, m.course),
CASE WHEN (cm.instanceid IS NULL) THEN '' ELSE CONCAT('&cmid=',cm.instanceid) END,
'&id=',parent.id,'">Edit</a>') AS question,
parent.questiontext
FROM prefix_question parent
JOIN prefix_question child ON child.parent = parent.id
JOIN prefix_question_categories qc ON qc.id = parent.category
LEFT JOIN prefix_context cc ON qc.contextid = cc.id AND cc.contextlevel = 50
LEFT JOIN prefix_context cm ON qc.contextid = cm.id AND cm.contextlevel = 70
LEFT JOIN prefix_course_modules m ON m.id = cm.instanceid
WHERE child.qtype = 'multichoice'
AND parent.qtype = 'multianswer'
AND child.qtype = 'multichoice'
AND (child.questiontext LIKE '{%:MC:%'
OR child.questiontext LIKE '{%:MULTICHOICE:%'
OR child.questiontext LIKE '{%:MCV:%'
OR child.questiontext LIKE '{%:MULTICHOICE_V:%'
OR child.questiontext LIKE '{%:MCH:%'
OR child.questiontext LIKE '{%:MULTICHOICE_H:%'
)
ORDER BY courseid, categoryname, question
