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 
The Eight Chapters of Maimonides

Facilitator: Rochale Groweiss

Monday 9:30-11 am

Price: NIS 50 for single session

This month's sessions: 1 January, 15 January, 29 January

Date: 01/01/2018 09:30 Category: Tourism and Leisure
Vietnam – a tale of two cities, Hanoi and Saigon

Lecturer: Dvora Rotbart

Date: 02/01/2018 00:00 Category: Tourism and Leisure
Maternity Leave Club

Tuesdays at the Caesarea Centre, 10:30 am

Admission: NIS 25

  1. 2 January         Dancing with babies - Facilitator: Merav Manor, at 9:30 am
  2. 9 January         Lecture: "The last bite gives the most strength" – developing healthy

                        eating habits at a young age. Facilitator: Hila Sharon

  1. 16 January       Developmental support workshop. Facilitator: Inbal Bi'tnuah
  2. 23 January       Magic of music workshop. Facilitator: Sasha Yagudin
Date: 02/01/2018 10:30 Category: Tourism and Leisure
Club for Toddlers

Tuesdays 5:30-6:30 pm

at the Caesarea Centre

2 January       Drums, play, and rhythm

9 January       Story time: "The Scarecrow"

16 January     Rhythm and movement

23 January     Theatre games

30 January     Knowledge-based games

For ages 3-6

Admission: NIS 20 per child

Date: 02/01/2018 17:30 Category: Tourism and Leisure
Movie – details will be provided
Date: 04/01/2018 00:00 Category: Tourism and Leisure