Cette salle de spectacle ouverte en 2009 a vu de nombreux spectacles s’y produire.

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) = '111' ) ) 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:11' OR (wp_postmeta.meta_value <= '2017-05-28 06:34:11' AND tribe_event_end_date.meta_value >= '2017-05-28 06:34:11' )) 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

Sesel I La

Read more
June 3
20H00 - 23H00
J & J Auditorium - Phoenix
Region : Center

FunTastic Family Entertainment

It is with immense pleasure that Keglers Entertainment brings to you a group of extraordinary… Read more
June 9 - June 10 - June 10 (2 events)
20H00 - 8:00 pm
J & J Auditorium - Phoenix
Region : Center
|
Rs800 - Rs2000
More details

Miss And Mr India Worldwide Mauritius 2017

Read more
July 1
18H30
J & J Auditorium - Phoenix
Region : Center
|
Rs500 - Rs1000
More details

Bharti Singh Live

Upon the Invitation of Excelmedia and B live Studio the numero uno female comedian of… Read more
July 16
18H00
J & J Auditorium - Phoenix
Region : Center
|
Rs800 - Rs2000
More details