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 
Show "If we'd only know to love" –the songs of Yossi Banai

Energetic musical show by five young actors from the Habima, Cameri, and Beit Lessin theatres: Elad Raviv, Doris Nimni, Rani Alon, Alona Alexander, Yonatan Paz Bouganim

Adapted and directed by: Ofer Shafrir

Musical director: Tahel Shoham

Admission: NIS 50

Date: 03/12/2015 20:30 Category: Tourism and Leisure
Amos Ivri in an Opening Event " Art and Creative Exhibit"

Collage paintings of nature in acrylic, print, and oil pastels

Free admission

Date: 05/12/2015 11:00 Category: Tourism and Leisure
Morning Highlight - UNESCO

sites – journey to the world's most beautiful sites

Lecturer: Naftali Hilger             

Date: 06/12/2015 00:00 Category: Tourism and Leisure
Chanukah Festival in Caesarea

free admission to all events 

Youth Centre plaza

"Story of a Dreidel" – Interactive family oriented show by the Theatre Group.

Directed by: Orly Adiv                                                 

Festive candle lighting with Rabbi Zvi Elon and Chanukah doughnuts for all

Date: 06/12/2015 17:30 Category: Tourism and Leisure
Morning Highlight

Visit to the Intelligence Heritage Centre at Glilot

Date: 08/12/2015 00:00 Category: Tourism and Leisure