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-04-25' ) OR wp_postmeta.meta_key = '_EventStartDateUTC' ) AND ( mt1.meta_key = '_EventVenueID' AND CAST(mt1.meta_value AS CHAR) = '5201' ) ) 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-04-25 02:44:23' OR (wp_postmeta.meta_value <= '2017-04-25 02:44:23' AND tribe_event_end_date.meta_value >= '2017-04-25 02:44:23' )) 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

La Belle au Bois Dormant

Due to technical problems, the event has been postponed to Thursday, April 27th 2017. We… Read more
April 27
19H30
MCine – Trianon
Region : Center