Custom Instructor role -Does anybody know, what is needed to narrow the results of assignments furth

Summary:

I have built a custom Instructor role that almost works perfectly.
My SQL-condition already restricts visibility for learning assignments so an primary instructor only sees a learners record in the learning assigment area if that learner is enrolled in one of the offerings where the instructor is the primary instructor.

However, once the instructor opens the Learning Assignments area, he or she could see all of the learner’s assignments — also those unrelated to the instructor’s offerings — instead of only the assignments that belong to the offering(s) where the instructor is the primary instructor.

This is the almost perfect SQL code at the moment: