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 
Smetana, the Moldau

Lecturer: Roy Aloni

Date: 21/12/2017 00:00 Category: Tourism and Leisure
Being the parent of a competitive athlete – a lecture

Using a few simple tools, you can learn how to support, relieve pressure, boost the young athlete and help him realize his full potential.

About the lecturer:

Yuval Lavsky, mental coach for athletes, biofeedback therapist and licensed NLP therapist. Yuval works with the Israel windsurfing teams, young Olympic athletes, and the Wingate unit for competitive sports.

Thursday 21 December, 8 pm at the Caesarea Centre Events Hall

Admission: NIS 25

Tel: 04-61009503/4

Date: 21/12/2017 20:00 Category: Tourism and Leisure
Friday Tours – Jerusalem

Friday, 22 December, Leaving at 7 am

The Anava interchange – breakfast

Mt. Herzl – Visit to the Memorial shrine for fallen IDF soldiers

Givat Hatachmoshet – new museum

The Kokia House – a moving family story and about the seven species

Price: NIS 200 per person

Including admissions, guidance and transportation

For information and registration: 04-6363381

Date: 22/12/2017 07:00 Category: Tourism and Leisure
A Midsummer Night's Dream / Britten

Lecturer: Merav Barak

Date: 24/12/2017 00:00 Category: Tourism and Leisure
Alon Ben David: "Israel's Future in the Middle East"

Sunday 24 December, 8:30 pm at the Events Hall

The stories and insights that are not portrayed in the media. Is ISIS indeed a threat to us? What chance is there of another military operation in Gaza or of war in northern Israel? How does Trump's election as president of the global empire affect us?

Lecturer: Alon Ben David, defense correspondent for Channel 10 News

Admission: NIS 40

Date: 24/12/2017 20:30 Category: Tourism and Leisure