'."\n";
$route .= mdb2_single_val($db, <<= cap, 'disabled ', ''), 'value="', route_id, '">', route_title, ' (', cnt, '/', cap, ')') SEPARATOR '')
FROM (
SELECT route_id, route_title, cap, IFNULL(cnt, 0) AS cnt FROM routes
JOIN (
SELECT route_id, SUM(capacity) AS cap
FROM capacity
GROUP BY route_id
) AS tmp USING (route_id)
LEFT JOIN (
SELECT route_id, COUNT(inschrijving_id) cnt
FROM ouders
WHERE timestamp_delete IS NULL
GROUP BY route_id
) AS tmp3 USING (route_id)
) AS tmp2
EOQ
);
$route .= "";
$timeslots = mdb2_single_val($db, <<' SEPARATOR '\n')
FROM routes
JOIN (
SELECT route_id, GROUP_CONCAT('') AS stuff
FROM timeslots
JOIN capacity USING (timeslot_id)
LEFT JOIN (
SELECT route_id, timeslot_id, COUNT(inschrijving_id) cnt FROM ouders
WHERE timestamp_delete IS NULL
GROUP BY route_id, timeslot_id
) AS derived2 USING (route_id, timeslot_id)
GROUP BY route_id
) AS derived1 USING (route_id)
EOQ
);
if (deadline_expired()) { ?>
Inschrijving voor open dag HAVO/VWO OVC<!-- - <?=$deadline_text?> - <?=$inloop_text?>-->
De inschrijving voor de open dag is op dit moment niet geopend. Voor meer informatie over de open dag verwijzen we u naar de website van het Oostvaarders College.