SELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) WHERE 1=1 AND ( ( ( wp_postmeta.meta_key = 'recurrence_%_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2017-05-28' ) OR wp_postmeta.meta_key = '_EventStartDateUTC' ) AND ( mt1.meta_key = '_EventVenueID' AND CAST(mt1.meta_value AS CHAR) = '3067' ) ) AND wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'paused' OR wp_posts.post_status = 'active' OR wp_posts.post_status = 'queued' OR wp_posts.post_status = 'finished' OR wp_posts.post_status = 'autoresponder') AND ( ( t.language_code = 'en' AND wp_posts.post_type IN ('post','page','acf-field-group','product','product_variation','ticket-meta-fieldset','tribe_rsvp_tickets','tribe_events','tribe_venue','tribe_organizer','tribe_wooticket','portfolio' ) ) OR wp_posts.post_type NOT IN ('post','page','acf-field-group','product','product_variation','ticket-meta-fieldset','tribe_rsvp_tickets','tribe_events','tribe_venue','tribe_organizer','tribe_wooticket','portfolio' ) ) AND (wp_postmeta.meta_value >= '2017-05-28 06:34:21' OR (wp_postmeta.meta_value <= '2017-05-28 06:34:21' AND tribe_event_end_date.meta_value >= '2017-05-28 06:34:21' )) ORDER BY EventStartDate ASC, wp_posts.post_date ASC ) a GROUP BY IF( post_parent = 0, ID, post_parent ) ORDER BY EventStartDate ASC LIMIT 0, 100

Damian ‘Jr Gong’ Marley

IMMEDIA and SAKIFO PRODUCTION have pulled a production wonder as they bring home the most… Read more
June 4
19H00
SVICC - Les Pailles
Region : West
|
Rs900 - Rs1500
More details

Bharati 2

After the amazing success of “Bharati: Once Upon a Time in India”, which whisked away… Read more
June 30 - July 1 - July 1 (3 events)
20H00 - 8:00 pm
SVICC - Les Pailles
Region : Center
|
Rs600 - Rs2500
More details

Laurent Gerra

‘My name is Laurent, I am 5 years old and I will show you my… Read more
November 4
20H00
SVICC - Les Pailles
Region : Center
|
Coming Soon
More details