153
 
events_banner.jpg
icon Park1 eng
icon RealEstate3 eng
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 
   Display Num 
"Back from Tuichi – The Power to Survive"

Sunday 25 November, 8:30 pm, at the Caesarea Centre hall

Admission: NIS 40

Tickets may be purchased at www.caesarea.com

In a breathtaking lecture, Yossi tells the story of his personal adventures and how from a victim of the circumstances he became a skilled survival machine, how he fought tigers and carnivorous ants, and how his life was saved thanks to hallucinations, on the role of faith in the preservation of animals and on actual miracles that happened in front of his eyes.

Lecturer: Yossi Ghinsberg – His survival story has become a classic and even a "cult" phenomenon in Israel and elsewhere. His book "Back from Tuichi" has been translated into twenty languages and has won acclaim as an international best-seller. The Discovery Channel produced a documentary and recently a Hollywood film has been released, starring Daniel Radcliffe (Harry Potter), who plays Yossi and reconstructs his fascinating journey in the Amazon.

Date: 25/11/2018 20:30 Category: Tourism and Leisure
Literary Jewels

Monthly literary encounters

Facilitator: Zvia Yedidya

Beginning: Monday 26 November, 10:30 am, at the Caesarea Centre library

Free admission

Date: 26/11/2018 00:00 Category: Tourism and Leisure
Tour of the "Habima" area, including a visit behind the scenes

With Avivit Brukstein

Date: 27/11/2018 00:00 Category: Tourism and Leisure
Movie – details will be provided
Date: 29/11/2018 00:00 Category: Tourism and Leisure
Community Evening "Israeli Childhood"

Thursday 29 November, 8 pm at the Caesarea Centre hall

Caesarea residents put on stories and songs in honor of November 29

Produced by Shirley Veizer and Orna Ashkenazi

Date: 29/11/2018 08:00 Category: Tourism and Leisure