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
"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
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