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-11' AND tmp.date<='2024-05-31' AND tmp.perf_id=218) 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-11' AND '2024-05-31' AND tmp.perf_id=218) 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<>218 AND tp.id_base=933 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<>218 AND tp.id_base=933 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





	19 May 2020, 19:00 - "Soul of dance" Ballet Gala - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre 19 May 2020, 19:00 - "Soul of dance" Ballet Gala
19May
19:00
2020 | Tuesday
Classical ballet
Stanislavsky theatre, Moscow

Ballet is more than just a dance… It is a particular world - full of beauty, harmony, passion and expressiveness. Ballet is craving for beauty ideals, it is opportunity to elevate people through dance.

This evening you will see the group of amazing dancers who are recognized throughout the world, perform on the main stages of the most famous theatres all over the world as well as are the faces of various ballet festivals, fashion magazines, ballet books and famous brands.

"Ballet" magazine presents:
"The Soul of the Dance" Award Ceremony and Ballet Gala

Laureates:

"Magician of Dance"
Iosif Sumbatashvili, set designer (Moscow),
Karen Khachaturyan, composer (Moscow)

"Legend"
Maya Plisetskaya, People’s artist of the USSR (Moscow)

"Queen of Ballet"
Nadehzda Gracheva, soloist of the Bolshoi Theatre (Moscow)

"Dance Maitre"
Svetlana Adyrkhaeva, repetiteur of the Bolshoi Theatre (Moscow)

"Teacher"
Altynay Asylmuratova, artistic director of the Vaganova Ballet Academy (Saint-Petersburg)

"Ballet Cavalier"
Andris Liepa, chairman of Maris Liepa Charity Foundation (Moscow)

"Contemporary Dance Cavalier"
Sergey Smirnov, director of the Eccentric Ballet (Yekaterinburg)

"Star"
Eugenia Obraztsova, soloist of the Mariinsky Theatre (Saint-Petersburg)

"Rising Star"
Maria Semenyachenko, soloist of the Stanislavsky and Nemirovich-Danchenko Moscow Music Theatre,
Artem Ovcharenko, of the Bolshoi Theatre (Moscow)

"Folk Dance Cavalier"
Anatoly Borzov, dean, head of Choreography Department at Natalia Nesterova Dance Academy (Moscow)

"Press Leader"
Arkady  Sokolov-Kaminsky, professor at Saint Petersburg Conservatory


Ballet Gala participants:


Soloists of the Bolshoi Theatre (Moscow): Nadezhda Gracheva, Galina Stepanenko, Ruslan Skvortsov, Ekaterina Krysanova, Anastasia Stashkevich, Mikhail Lobukhin, Vyacheslav Lopatin, Vadim Kurochkin

Soloist of the Mariinsky Theatre (Saint-Petersburg): Eugenia Obraztsova

Soloists of the Stanislavsky and Nemirovich-Danchenko Moscow Music Theatre: Maria Semenyachenko, Semen Chudin

Soloist of the Moscow Classical Ballet Ekaterina Berezina and ballet artists

Sergei Smirnov Eccentric Ballet (Yekaterinburg)

Students of the Vaganova Academy of Russian Ballet (Saint Petersburg)

State Academic Song and Dance Ensemble of the Ministry of Internal Affairs of Russian Federation (Moscow)