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) = '4873' ) ) 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:32:18' OR (wp_postmeta.meta_value <= '2017-05-28 06:32:18' AND tribe_event_end_date.meta_value >= '2017-05-28 06:32:18' )) 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

IAM en concert

The album which gave some virtue to French rap returns on stage. To celebrate the… Read more
October 14
21H00
Domaine Gros Cailloux - Gros Cailloux
Region : West
|
Rs750 - Rs1500
More details