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 - Current affairs from outer space
Date:
22/12/2015 00:00
Category: Tourism and Leisure
"The Wisdom of Crowds"
Lior is a writer, lecturer, and researcher. He is one of the few lecturers invited to speak at a TED international conference about his book "Mindsharing". He will speak about how the wisdom of crowds changes lives and makes it possible to reach better decisions and to make dreams come true.
Admission: NIS 40
Date:
22/12/2015 20:30
Category: Tourism and Leisure
Morning Highlight - ZAKA's other role
Lecturer: Yehuda Meshi Zahav (ZAKA)
Date:
24/12/2015 00:00
Category: Tourism and Leisure
Morning Highlight - Chicago – City of blues, architecture and crime
Lecturer: Devora Rothbert
Date:
27/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:
27/12/2015 20:30
Category: Tourism and Leisure