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
Tu Bi'Shvat Celebrations at Caesarea
Family trip to the Yeshach Caves
Saturday 16 January, 9:30 am
We will meet at the Rakit parking lot (not far from the Carmel Forest Resort)
We will go on a family outing to a nearby and less known part of Mt. Carmel – the Yeshach Caves.
The trip will take about 3 hours.
On the way we will see an ancient embelished burial cave, mysterious caves in the mountain, amazing views and lots of flowers! We will hear tales, play, enjoy a fun hike and finally – cook something tasty!
The trip is suitable for ages 5 and older.
Price per family: NIS 130
Individual transportation
For more information please contact Zohar 04-6109519
This Tu Bi'Shvat Caesarea families will enjoy an outing in the flowering outdoors!
Date:
16/01/2016 08:30
Category: Tourism and Leisure
Morning Highlight - The soap opera of Beatrice de Luna
Date:
17/01/2016 00:00
Category: Tourism and Leisure
Morning Highlight - IDF spokesman – battles on the information front
Date:
17/01/2016 00:00
Category: Tourism and Leisure
Morning Highlight - The elderly in cinema
Date:
17/01/2016 00:00
Category: Tourism and Leisure
Morning Highlight - The elderly in cinema
Date:
17/01/2016 00:00
Category: Tourism and Leisure