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-20' AND tmp.date<='2024-06-09' AND tmp.perf_id=397) 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-20' AND '2024-06-09' AND tmp.perf_id=397) 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<>397 AND tp.id_base=-1 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<>397 AND tp.id_base=-1 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





	30 March 2020, 19:00 - Ballet Without Borders - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 30 March 2020, 19:00 - Ballet Without Borders
30March
19:00
2020 | Monday
Concert
Bolshoi theatre - Small Stage, Moscow

The concert will be attended by stars of the world of ballet, at one time studied at the Kiev Ballet School, as well as their star partners:

Svetlana Zakharova (Bolshoi Theatre of Russia)
Nina Zmievets (St. Petersburg State Academic Ballet Theatre of Boris Eifman)
Alina Cojocaru (English National Ballet)
Natalia Osipova (The Royal Ballet, Covent Garden)
Yana Salenko (Berlin State Ballet)
Sergey Volobuev (St. Petersburg State Academic Ballet Theatre of Boris Eifman)
Patrick De Bana (France)
Ivan Putrov (UK)
Dennis Rodkin (Bolshoi Theatre of Russia)
Dean Tamazlakaru (Berlin State Ballet)
Leonid Sarafanov (Mikhailovsky Theatre)

At the gala concert will also feature the future stars, and now the most gifted students of the Kiev Ballet School.

The program - excerpts from ballets that have become "business cards" theaters, on the stages of which are the participants of the concert.


Artistic director of the concert - the prima ballerina of the Bolshoi Theatre,
Etoile La Scala Theatre, People's Artist of Russia, Svetlana Zakharova
Producer of the project - Yuri Baranov


PROGRAM

Part I

Georges Bizet - Rodion Shchedrin
"Carmen Suite"
choreography by Alberto Alonso
set design and costumes - Boris Messerer

Carmen - Svetlana Zakharova
Jose - Dennis Rodkin


Part II

GF Handel, KP Quintana
"Digital Love« / Digital Love
choreography by Patrick De Bana
Costumes - Stephanie Boyerli, Svetlana Zakharova
Light - Patrick De Bana

Svetlana Zakharova
Patrick De Bana


Sergei Prokofiev
"Romeo and Juliet." A scene from the balcony
choreography by Kenneth MacMillan

Natalia Osipova
Ivan Putrov


Pyotr Tchaikovsky, Georges Bizet, Alfred Schnittke
"Red Giselle". Detail of ballet
choreography by Boris Eifman

Nina Zmievets
Sergey Volobuev

Pyotr Tchaikovsky
Pas de deux from the ballet "Swan Lake"
Editorial Patrice Bart

Yana Salenko
Dino Tamazlakaru

Casts & Credits

Composer: Georges Bizet
Choreography: Alberto Alonso
Choreography: Boris Eifman
Choreography: Kenneth MacMillan
: