QUERY: (SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.date>='2024-05-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=803) ORDER BY date ASC, ves DESC, time ASC
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1

QUERY: (SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.date>='' AND tmp.date NOT BETWEEN '2024-05-14' AND '2024-06-03' AND tmp.perf_id=803) ORDER BY date ASC, ves DESC, time ASC
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1

QUERY: SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.date>='' AND tmp.perf_id<>803 AND tp.id_base=841 AND tmp.city_id=1 ORDER BY date ASC, ves DESC, time ASC
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1

QUERY: SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.date>='' AND tmp.perf_id<>803 AND tp.id_base=841 AND tmp.city_id=2 ORDER BY date ASC, ves DESC, time ASC
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1





	22 May 2019, 19:00 - "Benois de la Danse" - Russian Ballet Oscar. Different Years Laureats Ballet Gala (Best Dances from different Ballets performed by World and Bolshoi Ballet Stars) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 22 May 2019, 19:00 - "Benois de la Danse" - Russian Ballet Oscar. Different Years Laureats Ballet Gala (Best Dances from different Ballets performed by World and Bolshoi Ballet Stars)

At the moment, the repertoire 2015 is not known. 
Last year's program:


CHARITY GALA STARS
OF BENOIS DE LA DANSE — LAUREATES OF DIFFERENT YEARS

PROGRAMME

PART I

INSPIRED by DIAGHILEV
C. M. von Weber. Le Spectre de la rose
Choreography by Mikhail Fokin
La Scala Theatre Ballet soloists
Vittoria VALERIO
Claudio COVIELLE – Benois-2014 nominee

I. Stravinsky. LE BADINAGE
to music of the 1ST part of Le sacre du printemps
Choreography by Fernando Romero
Fernando ROMERO – Benois de la danse laureateC.
Debussy. N. Sawhney. Faun.
Choreography by Sidi Larbi Cherkaoui – Benois de la danse laureate

Olivia ANCONA
James O’HARA

Lighting Designer Sergei Shevchenko (after original design by Adam Carrйe)
Costume Designer Hussein Chalayan
Production: Sadler's Wells
Theatre National de Chaillot (Paris), Monaco Dance Forum, Teatre Nacional de
Catalunya, Mercat de les Flors (Barcelona), Opera de Dijon, Grand Thйвtre de
Luxembourg Co-production

PART II

S.Prokofiev. Duet from Romeo and Juliet
Choreography by Christian Spuck – Benois de la danse diploma-winner

Zurich Ballet soloists
Katja WȔNSCHE - Benois de la danse diploma-winner
William MOORE

E. Helsted, H. S. Paulli. THE FLOWER FESTIVAL in GENZANO PAS de DEUX
Choreography by August Bournonville

Royal Danish Ballet soloists
J'aime Crandall
Alban LENDORF – Benois de la danse laureate

S. Rakhmaninov. THREE PRELUDES
Choreography by Ben Stevenson

Bavarian State Ballet soloists
Lucia LACCARA – Benois de la danse laureate
Marlon DINO

P. Tchaikovsky. PAS DE DEUX
Choreography by George Balanchine © The George Balanchine Trust

New York City Ballet soloist
Ashley BOUDER – Benois-2014 nominee
Bolshoi Theatre soloist
Semyon CHUDIN – Benois de la danse laureate

M. Richter. Duet from INFRA
Choreography by Wayne McGregor – Benois de la danse laureate

Mariinsky Theatre soloists
Yekaterina Kondaurova – Benois de la danse laureate
Alexander SERGEYEV – Benois de la danse diploma-winner

D.-F.-E. Auber. GRAND PAD CLASSIQUE
Choreography by Victor Gzovsky

Mariinsky Theatre soloists
Anastasia KOLEGOVA
Timur ASKEROV – Benois-2014 nominee

Direction of the ceremony – Andrei MELANYIN
Author of the text – Alexander KOLESNIKOV
Stage-designer - Sergei TIMONIN
Light Designer  - Sergei SHEVCHENKO
Sound engineer - Andrei VOLKOV
Stage operator - Bogdan SHTEPA
Stage managers - Andrei MELANYIN, Vladimir TSHERBAKOV, Mikhail MINEEV
Director of the technical staff -Igor SUVOROV
Chairman of the BENOIS DE LA DANSE Program - YURI GRIGOROVICH
General Director – Regina NIKIFOROVA
Artistic Director – Nina KUDRYAVTSEVA-LOORY
Official photographer – Mikhail LOGVINOV

Project coordinator – Olga GORCHAKOVA
Administrators – Valentina DMITRENKO, Lyudmila RADOMSKAYA
Artistic Director of the Bolshoi Ballet - Sergei FILIN
Musical Director of the Bolshoi Theatre of Russia - Tugan SOKHIEV