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
Morning Highlight - Dvorak
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
