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) = '132' ) ) 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:48:03' OR (wp_postmeta.meta_value <= '2017-04-25 02:48:03' AND tribe_event_end_date.meta_value >= '2017-04-25 02:48:03' )) 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

Zero Waste with Béa Johnson

How to reduce and dispose waste in a more responsible way? Known as ‘the zero-waste… Read more
May 11
19H00 - 20H30
Trianon Convention Centre - Quatre Bornes, Trianon
Region : Center