Differences

This shows you the differences between two versions of the page.

--- ensembles [2022/01/14 23:05] – created Iain Hallam
+++ ensembles [2022/01/16 22:09] (current) – Iain Hallam
@@ Line 1: / Line 1: @@
 ====== Ensembles ======
+===== Current ensembles =====
 ---- struct table ----
-schema: ensemble
+from: ensemble, group
-cols: %title%
+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
 ----
+===== Past ensembles =====
+---- 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
+----