Events

SELECT a.*, CONCAT_WS(":", a.id, a.alias) AS `id`,v.street, v.zip, v.state, v.city, v.title AS vtitle, v.country AS `country_code`,cc.title as cctitle,c.name AS `country`,CASE
							WHEN a.repeated != "" THEN evr.start
							ELSE a.start
						END AS evr_start,
						CASE
							WHEN a.repeated != "" THEN evr.end
							ELSE a.end
						END AS evr_end,
						a.starttime AS evr_starttime,
						a.endtime AS evr_endtime,
						CASE
							WHEN a.repeated != "" THEN evr.id
							ELSE 0
						END AS evr_id
FROM #__events_v5_events AS a
INNER JOIN #__events_v5_venues AS v ON a.venue_id = v.id
INNER JOIN #__events_v5_categories AS cc ON a.category_id = cc.id
INNER JOIN #__events_v5_countries AS c ON c.code = v.country
LEFT JOIN ( SELECT main_evd.event_id, main_evd.start, main_evd.id, main_evd.end FROM #__events_v5_repeating_days AS main_evd LEFT JOIN
						(
							SELECT event_id, MAX(start) AS past_event_start
							FROM #__events_v5_repeating_days
							WHERE `start` < NOW()
							GROUP BY event_id
						) AS past_event ON main_evd.event_id = past_event.event_id LEFT JOIN
						(
							SELECT event_id, MIN(start) AS future_event_start 
							FROM #__events_v5_repeating_days
							WHERE `start` >= NOW()
							GROUP BY event_id 
						) AS future_event ON main_evd.event_id = future_event.event_id WHERE (future_event.event_id IS NOT NULL AND main_evd.start = future_event.future_event_start)
						OR (future_event.event_id IS NULL AND main_evd.start = past_event.past_event_start)) AS evr ON a.id = evr.event_id
WHERE a.published > 0 AND a.access IN (1,1) AND a.language in ('en-GB','*') AND cc.language in ('en-GB','*')
ORDER BY a.start

Literary Jewels

Facilitator: Zvia Yedidya

Monday 10:30-12:30 am

Free admission

This month's session: 25 December

Date: 25/12/2017 10:30 Category: Tourism and Leisure

Club birthday – Festive encounter

Date: 26/12/2017 00:00 Category: Tourism and Leisure

"Um Shmum" – Ben Gurion and the issue of Jerusalem in the UN, December 1949

Lecturer: Gary Pal

Date: 28/12/2017 00:00 Category: Tourism and Leisure

Assaf Amdursky in an Acoustic Concert

Thursday 28 December, 8:30 pm at the Ralli Museum

The eternal rock star has turned down the volume and is appearing on stages around the country with an acoustic guitar and the stories behind the songs

Admission for residents of Caesarea: NIS 60

Admission for guests: NIS 70

Admission on-site: NIS 80

Date: 28/12/2017 20:30 Category: Tourism and Leisure