Lesson shows no attempts if associated with a grouping

A lesson associated with a grouping will have the report.php display that no attempts were made. But there are results in the lesson_attempts table and the gradebook.

The problem is because of an incorrect query for groupings and groups.

Replication steps:

1. Create a group/grouping with students
2. Create lesson and associate that lesson with the created grouping
3. As a student in the created grouping, attempt the lesson activity
4. View the report page for the lesson

Expected result: The report page will display the attempt that was made.

Actual result: A message is displayed "No attempts have been made on this lesson."