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 
Literary Jewels

at the Library

Monthly literary encounters                                                 

Facilitator: Zvia Yedidya

Free admission

Date: 25/01/2016 10:30 Category: Tourism and Leisure
Tu Bi'Shvat Event

at the Caesarea Centre courtyard

Arts and crafts in the spirit of the holiday. Artwork made of pinecones and scented herbal sachets.

Date: 25/01/2016 17:00 Category: Tourism and Leisure
Caesarea Song and Dance Groups - Winter Show

at the Events Hall

In honor of Ti Bi'Shvat and the middle of the year

The Caesarea song and dance groups invite everyone to an evening of their best songs.

Free admission.

Date: 25/01/2016 18:30 Category: Tourism and Leisure
Morning Highlight - Hansel and Gretel

Lecturer: Merav Barak

Date: 26/01/2016 00:00 Category: Tourism and Leisure
Morning Highlight - Topic to be announced

Lecturer: Alon Klivanov

Date: 28/01/2016 00:00 Category: Tourism and Leisure