test where

SELECT SQL_NO_CACHE p.personID,  m.moduleID, s.taskID
    FROM submissions s
    JOIN persons p ON s.PersonID = p.PersonID
    JOIN modules m ON s.ModuleID = m.ModuleID
    WHERE p.PersonID BETWEEN 92 AND 109
        AND m.ModuleName LIKE '%Программирование%';

SELECT SQL_NO_CACHE p.personID, m.moduleID, s.taskID
    FROM submissions s
    JOIN (SELECT personID FROM persons
            WHERE PersonID BETWEEN 92 AND 109) p
        ON p.PersonID = s.PersonID
    JOIN (SELECT moduleID FROM modules
            WHERE ModuleName LIKE '%Программирование%') m
        ON m.ModuleID = s.ModuleID;