Differences

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

--- people:iain-hallam [2022/01/15 01:01] – Iain Hallam
+++ people:iain-hallam [2022/01/15 01:46] (current) – Iain Hallam
@@ Line 3: / Line 3: @@
 ---- struct serial ----
 schema: profile_link
+----
+===== Ensemble leadership =====
+---- struct table ----
+select: %title%, position, start_date, end_date
+from: ensemble_leader
+where: person = $ID$
+----
+===== Ensemble membership =====
+---- struct table ----
+select: %title%, start_date, end_date
+from: group_member
+where: person = $ID$
 ----