icon Park1 eng
icon RealEstate3 eng
SELECT a.*, CONCAT_WS(":",, a.alias) AS `id`,v.street,, v.state,, v.title AS vtitle, AS `country_code`,cc.title as cctitle, AS `country`,CASE
							WHEN a.repeated != "" THEN evr.start
							ELSE a.start
						END AS evr_start,
							WHEN a.repeated != "" THEN evr.end
							ELSE a.end
						END AS evr_end,
						a.starttime AS evr_starttime,
						a.endtime AS evr_endtime,
							WHEN a.repeated != "" THEN
							ELSE 0
						END AS evr_id
FROM #__events_v5_events AS a
INNER JOIN #__events_v5_venues AS v ON a.venue_id =
INNER JOIN #__events_v5_categories AS cc ON a.category_id =
INNER JOIN #__events_v5_countries AS c ON c.code =
LEFT JOIN ( SELECT main_evd.event_id, main_evd.start,, 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 = 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 
Morning Highlight - Dvorak

Lecturer: Roy Aloni

Date: 11/02/2016 00:00 Category: Tourism and Leisure
Tribute to Arik Einstein

at the Events Hall

Tribute to Arik Einstein                                            

His best eternal songs in new, young, fresh adaptations

Lead singer: Ilan Shechtman

Musical director, piano, and singing: Roy Shpigler

Guitar and singing: Lidor Levy

Bass: Eyal Raveh

Drums: Dekel Dvir

Director: Ofer Shafrir

Date: 11/02/2016 20:30 Category: Tourism and Leisure
Friday Tours – Southward

Visit to solitary farms established in the 1960s

The Tze'ela Farm – settlement story, sheep pen and cheese tasting

Experimental station for growing peppers, spices, and tomatoes

The pipe bridge and the observation deck of the water reservoirs – a new site

and of course – the anemones.

Please bring sandwiches.

Price of tour: NIS 200, including admissions

For registration and further information: Adina Elkayam

03-6340484 / 04-6363381

leaving from the Caesarea Centre at 7 am

Date: 12/02/2016 07:00 Category: Tourism and Leisure
Morning Highlight - Trials with no jurists

Lecturer: Adv. Ofer Yechiel

Date: 16/02/2016 00:00 Category: Tourism and Leisure
"גיבורות נטולות הילה"


בהנחיית הרבה ד"ר אילה סמואלס

Date: 17/02/2016 20:00 Category: Tourism and Leisure