function get_child_contexts($context) {
// ...
case CONTEXT_COURSE:
// ...
$sql = " SELECT ctx.*
FROM

{context} ctx
WHERE ctx.path LIKE ?
AND ctx.contextlevel IN (".CONTEXT_MODULE.",".CONTEXT_BLOCK.")
UNION
SELECT ctx.*
FROM {context}

ctx
JOIN

{groups}

g ON (ctx.instanceid=g.id AND ctx.contextlevel=".CONTEXT_GROUP.")
WHERE g.courseid=?
UNION
SELECT ctx.*
FROM

{context}

ctx
JOIN

{block_pinned}

b ON (ctx.instanceid=b.blockid AND ctx.contextlevel=".CONTEXT_BLOCK.")
WHERE b.pagetype='course-view'";

That is so wrong!