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 - Topic to be announced
Date:
17/12/2015 00:00
Category: Tourism and Leisure
Friday Tours with Adina
Around the Sea of Galilee
"Bayit Bagalil – visit"
The Yigal Alon Museum
Visit to Migdal, new archeological site, the Jesus trail and spring - hike
For registration and information: Adina Elkayam 04-6363381/ 054-4510254
Price: NIS 200 per participant, including admissions.
Date:
18/12/2015 07:00
Category: Tourism and Leisure
Morning Highlight -Movie
Date:
20/12/2015 00:00
Category: Tourism and Leisure
Saving Money – Workshop for financial planning of the present and future
Two-session workshop on: Control of management fees paid to financial entities
Correct tax planning for retirement
Negotiating with banks, insurance companies, and
investment firms, and more.
Lecturer: Yoram Gershoni – expert on the capital market
Price for the two sessions: NIS 100
Date:
20/12/2015 20:30
Category: Tourism and Leisure
Story Time
Date:
21/12/2015 17:00
Category: Tourism and Leisure