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-04-22' AND tmp.date<='2024-05-12' AND tmp.perf_id=2067) 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-04-22' AND '2024-05-12' AND tmp.perf_id=2067) 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<>2067 AND tp.id_base=2069 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

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<>2067 AND tp.id_base=2069 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





	11 March 2018, 20:00 - Ballet Gala. Best Dances from different Ballets Marking 200 years since the birth of Marius Petipa - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 11 March 2018, 20:00 - Ballet Gala. Best Dances from different Ballets Marking 200 years since the birth of Marius Petipa
11March
20:00
2018 | Sunday

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.

This Ballet Gala performance is a special surprise by Maestro Valery Gergiev to Ballet lovers. Programme includes: choreographic miniatures, scenes and pas de deux from the classical ballets. The detailed programme is kept in secret and announced just before the event. Below you can see the previous year programme:
Get What You Gave
Music by Plaid
Choreography by Alexei Miroshnichenko
Performed by Elena Sheshina & Andrei Merkuriev
Pavlova and Cecchetti
Music by Pyotr Tchaikovsky
Choreography by John Neumeier
Performed by Ulyana Lopatkina & Viktor Baranov
Pas d'ensemble of the Snowflakes
from the ballet The Nutcracker
Music by Pyotr Tchaikovsky
Staging and costumes by Mihail Chemiakin
Choreography by Kirill Simonov
Performed by Tatiana Tkachenko
& artists of the ballet
Scene from Act III of the ballet
The Nutcracker
Music by Pyotr Tchaikovsky
Choreography by Vasily Vainonen
Performed by Yevgenia Obraztsova &Vladimir Shklyarov
and artists of the ballet
Grand pas classique
Music by
Daniel Francois Espri Auber
Choreography by Viktor Gsovsky
Performed by Viktoria Tereshkina & Anton Korsakov
The programme also includes choreographic miniatures and scenes from the classical ballets, performed by J'aime Crandall (Den Kongelige Ballet), Ulyana Lopatkina, Olesya Novikova, Veronika Part  (ABT), Alina Somova, Viktoria Tereshkina, Timur Askerov, Alban Lendorf (Den Kongelige Ballet), Jared Matthews (ABT), Marat Shemiunov (Mikhailovsky Theatre) and Vladimir Shklyarov.
MARIINSKY THEATRE SYMPHONY ORCHESTRA
Artistic Director – Valery Gergiev
Concert Supervisor – Irkin Gabitov
Principal Chorus Master – Andrei Petrenko