View

slot_availability

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

Rows 101–125 of 443

slot_availability, page 5 of 18
slot_idINTEGER	exhibition_idINTEGER	titleTEXT	slot_dateTEXT	start_timeTEXT	capacityINTEGER	bookedany	admittedany	remainingany
101	6	Light on the Water: Venetian Views	2017-03-20	16:45	35	1	1	34
102	6	Light on the Water: Venetian Views	2017-03-25	13:00	35	2	2	33
103	6	Light on the Water: Venetian Views	2017-03-25	13:15	35	2	2	33
104	6	Light on the Water: Venetian Views	2017-03-25	14:30	35	1	1	34
105	6	Light on the Water: Venetian Views	2017-03-28	13:00	35	1	1	34
106	6	Light on the Water: Venetian Views	2017-03-29	11:15	35	1	1	34
107	6	Light on the Water: Venetian Views	2017-04-05	14:45	35	1	1	34
108	6	Light on the Water: Venetian Views	2017-04-12	12:15	35	2	1	33
109	6	Light on the Water: Venetian Views	2017-04-18	10:45	35	1	1	34
110	6	Light on the Water: Venetian Views	2017-04-19	11:00	35	1	1	34
111	6	Light on the Water: Venetian Views	2017-04-19	11:15	35	1	1	34
112	6	Light on the Water: Venetian Views	2017-04-19	13:30	35	2	2	33
113	6	Light on the Water: Venetian Views	2017-04-19	15:00	35	4	3	31
114	6	Light on the Water: Venetian Views	2017-04-20	12:15	35	4	4	31
115	6	Light on the Water: Venetian Views	2017-04-22	16:30	35	1	1	34
116	6	Light on the Water: Venetian Views	2017-04-23	11:15	35	2	2	33
117	6	Light on the Water: Venetian Views	2017-04-23	14:15	35	4	4	31
118	6	Light on the Water: Venetian Views	2017-04-28	17:15	35	2	2	33
119	6	Light on the Water: Venetian Views	2017-04-29	13:30	35	1	1	34
120	6	Light on the Water: Venetian Views	2017-05-01	15:15	35	2	2	33
121	6	Light on the Water: Venetian Views	2017-05-04	16:00	35	1	1	34
122	6	Light on the Water: Venetian Views	2017-05-06	11:00	35	5	5	30
123	6	Light on the Water: Venetian Views	2017-05-06	16:15	35	1	1	34
124	6	Light on the Water: Venetian Views	2017-05-07	13:15	35	5	5	30
125	6	Light on the Water: Venetian Views	2017-05-07	17:15	35	3	2	32

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;