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
"Heroines with no halo"
at the library
facilitated by Rabbi Dr. Ayala Samuels
Date:
17/02/2016 20:00
Category: Tourism and Leisure
פספורט מוזיקלי-שלישיית עתר
במוזיאון ראלי
שלישיית עתר מארחת את הזמרת יעלה אביטל– קונצרט "חלום בתוך חלום" מוסיקה יהודית, יידיש וקברט- קלאסיקות של המאה העשרים מאת אייבס, לצד רפרטואר עכשווי מאת לבינסון ושייטין, נגנים: עפר שלי – פסנתר ועיבודים, טניה בלצר – כינור, מרינה כץ – צ'לו, יעלה אביטל – סופרן.
מחיר כרטיס לתושב במכירה מוקדמת :30 ₪
מחיר כרטיס לתושב חוץ במכירה מוקדמת: 35 ₪
מחיר כרטיס ביום האירוע לכולם: 35 ש"ח
Date:
19/02/2016 16:00
Category: Tourism and Leisure
Musical Passport – the Atar Trio
at the Ralli Museum
The Atar Trio hosts singer Yeela Avital – "Dream within a dream" concert
Jewish, Yiddish and Cabaret music – Twentieth century classics by Ives, as well as a contemporary repertoire by Levinson and Shatin. Musicians: Ofer Shelley – piano and adaptations, Tanya Beltser – violin, Marina Katz – cello, Yeela Avital – soprano.
Tickets for residents – advance sale: NIS 30
Tickets for guests – advance sale: NIS 35
On-site tickets for everyone: NIS 35
Date:
19/02/2016 16:00
Category: Tourism and Leisure
Morning Highlight - Art and the mind, the hidden force of art
Date:
21/02/2016 00:00
Category: Tourism and Leisure
"Security above All"
at the Events Hall
Evening of interviews with residents of Caesarea, among the leaders of Israel's security systems.
On global hot topics: ISIS, terrorist knifings, cyber, Iran, the atom, Paris, falling governments, the lack of borders, Obama dropping, Putin on the rise.
Are we heading for a Third World War?
Featuring:
Brigadier General (res.) Ron Kitri – Head of the Institute for Intelligence and Policy Research at the Intelligence Heritage Centre, former IDF spokesman
Asaf Hefetz – Former Police Commissioner, founder of the Israel Police Counter Terrorist Unit
Major General (res.) David Ben Bashat – Former commander of the Navy.
Brigadier General (res.) Dr. Dov Tamari – Head of the Civilian Defense track at Beit Berl College
Brigadier General (res.) Agai Yehezkel – Division commander and head of the IDF planning division
Moderator: Netanel Semrik, media figure, program facilitator
Date:
21/02/2016 20:30
Category: Tourism and Leisure