ANSI join ON clauses should contain only the join condition. Also, added prefix to the ORDER BY to prevent duplicate names.
ANSI join ON clauses should contain only the join condition. Also,
added prefix to the ORDER BY to prevent duplicate names.

dilawar/moodle