161
161
# a single query, and we cache the list of viewers for each offering.
162
162
offering_viewers_cache = {}
163
163
for (ssn, year, sem, name, psid, pspath, gid, offeringid) in store.find(
164
(Subject.short_name, Semester.year, Semester.semester,
164
(Subject.short_name, Semester.year, Semester.url_name,
165
165
ProjectGroup.name, ProjectSubmission.id, ProjectSubmission.path,
166
166
ProjectGroup.id, Offering.id),
167
167
Assessed.id == ProjectSubmission.assessed_id,