View

slot_availability

Booked, admitted and remaining places for every dated slot. Replaces the stored 2020 count.

Rows 76–100 of 443

slot_availability, page 4 of 18
slot_idINTEGER	exhibition_idINTEGER	titleTEXT	slot_dateTEXT	start_timeTEXT	capacityINTEGER	bookedany	admittedany	remainingany
76	5	Scribes of the Nile	2016-10-12	13:15	45	2	1	43
77	5	Scribes of the Nile	2016-10-18	15:00	45	4	4	41
78	5	Scribes of the Nile	2016-10-26	17:15	45	2	1	43
79	5	Scribes of the Nile	2016-11-24	16:00	45	1	1	44
80	5	Scribes of the Nile	2016-11-26	12:45	45	4	4	41
81	5	Scribes of the Nile	2016-12-15	09:45	45	3	3	42
82	5	Scribes of the Nile	2016-12-28	15:30	45	2	2	43
83	5	Scribes of the Nile	2017-01-06	11:15	45	3	2	42
84	5	Scribes of the Nile	2017-01-07	09:45	45	1	1	44
85	6	Light on the Water: Venetian Views	2017-02-22	16:00	35	4	3	31
86	6	Light on the Water: Venetian Views	2017-02-23	17:15	35	1	0	34
87	6	Light on the Water: Venetian Views	2017-02-26	12:00	35	1	1	34
88	6	Light on the Water: Venetian Views	2017-02-27	15:45	35	3	2	32
89	6	Light on the Water: Venetian Views	2017-02-28	12:15	35	1	1	34
90	6	Light on the Water: Venetian Views	2017-03-06	11:30	35	1	1	34
91	6	Light on the Water: Venetian Views	2017-03-10	13:45	35	2	0	33
92	6	Light on the Water: Venetian Views	2017-03-11	12:45	35	4	4	31
93	6	Light on the Water: Venetian Views	2017-03-12	12:45	35	1	1	34
94	6	Light on the Water: Venetian Views	2017-03-14	12:15	35	35	29	0
95	6	Light on the Water: Venetian Views	2017-03-14	12:30	35	5	5	30
96	6	Light on the Water: Venetian Views	2017-03-15	12:00	35	35	32	0
97	6	Light on the Water: Venetian Views	2017-03-15	12:15	35	14	14	21
98	6	Light on the Water: Venetian Views	2017-03-15	16:00	35	5	5	30
99	6	Light on the Water: Venetian Views	2017-03-16	15:00	35	3	2	32
100	6	Light on the Water: Venetian Views	2017-03-18	13:15	35	1	1	34

View definition

CREATE VIEW slot_availability AS
SELECT
  s.slot_id,
  s.exhibition_id,
  e.title,
  s.slot_date,
  s.start_time,
  s.capacity,
  count(b.booking_id)              AS booked,
  count(h.scan_id)                 AS admitted,
  s.capacity - count(b.booking_id) AS remaining
FROM exhibition_slot s
JOIN exhibition e ON e.exhibition_id = s.exhibition_id
LEFT JOIN exhibition_booking b ON b.slot_id = s.slot_id
LEFT JOIN hall_napoleon_scan h ON h.booking_id = b.booking_id
GROUP BY s.slot_id;