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,
							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 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 
Torchlight Parade

The Scouts and Bnei Akiva youth movements in a torchlight parade with all Caesarea's children and families

Leaving from the Caesarea Centre                                               

At the end of the parade Caesarea teens will operate crafts workshops and games for children in the spirit of the holiday.

Date: 08/12/2015 17:30 Category: Tourism and Leisure
Morning Highlight - World proverbs

the wisdom of humanity

Lecturer: Ricardo Blank                       

Date: 10/12/2015 00:00 Category: Tourism and Leisure
"Rhythm and fire"

family oriented show with fire juggling and stunts

Free admission at the Youth Centre plaza.                      

Date: 10/12/2015 17:30 Category: Tourism and Leisure
Morning Highlight - Trials with no jurists

Lecturer: Adv. Ofer Yehiel

Date: 13/12/2015 00:00 Category: Tourism and Leisure
Morning Highlight -The Nixon era

the Black September affair and the airlift on Yom Kippur

Lecturer: Gary Pal                                                                                                

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