SELECT DISTINCT ic.* FROM images_courses as ic INNER JOIN course_parent as cp ON cp.coursenumber_id = ic.coursenumber_id INNER JOIN courses as c ON c.parent = cp.id WHERE cp.id =470 Volkskunstschule Oederan