—- struct table —- from: ensemble, group select: %title%, ensemble.types, ensemble.age_groups, ensemble.genders, ensemble.weekdays, ensemble.recruiting, ensemble.audition where: group.end_date > $TODAY$ or: group.end_date = headers: Name

—- struct table —- from: ensemble, group select: %title%, ensemble.types, ensemble.age_groups, ensemble.genders where: group.end_date ⇐ $TODAY$ and: group.end_date != headers: Name