Only trainers with a name (trainers.name IS NOT NULL AND trainers.name != '') are selected for a course.