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  5 10 15 20 25 30 50 100 All

"Coming Home"

Local Art

Exhibition

 

Anne Bloch

 

Multimedia artist exhibits oil and acrylic paintings, wall hangings, soft sculpture, original hats and clothes

 

Curator: Nava Bloch

 

Exhibition opening

 

Friday 5 February, 11 am

 

At the Caesarea Centre Events Hall

 

Date: 05/02/2016 11:00 Category: Tourism and Leisure

Morning Highlight - Current affairs from outer space

Lecturer: Tal Inbar

Date: 07/02/2016 00:00 Category: Tourism and Leisure

"Where then does wisdom come from", facilitated by Dr. Rochale Grovais

Date: 08/02/2016 09:30 Category: Tourism and Leisure

Story Time - Illustration encounter with illustrator Nurit Tzarfati

Nurit directs and draws the story plot together with the children who become characters in the story. The children learn about different illustration styles. The encounter will end with an art activity.

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

Morning Highlight - Issues involving the military, security, and Israeli policy

Lecturer: Yariv Peled

Date: 09/02/2016 00:00 Category: Tourism and Leisure

Start«12131415161718192021»End