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-21' AND tmp.date<='2024-06-10' AND tmp.perf_id=923) 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-21' AND '2024-06-10' AND tmp.perf_id=923) 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<>923 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

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<>923 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





	29 April 2019, 19:00 - Gala Dance Open. Gala concert of world ballet stars - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Russian State Pushkin Academy Drama Theater (Alexandrinsky Theatre) (established 1756) 29 April 2019, 19:00 - Gala Dance Open. Gala concert of world ballet stars
29April
19:00
2019 | Monday
Classical ballet
Russian State Pushkin Academy Drama Theater (Alexandrinsky Theatre) (established 1756), Saint Petersburg

XIII International Ballet Festival Dance Open

Gala Dance Open.
Gala concert of world ballet stars .

Gala Dance Open, traditionally the closing program of the Festival , this year for the first time will be held at the renowned Imperial stage - the Alexandrinsky Theatre .
As always , all participants Gala - the world ballet star , located at the peak of its prosperity . But this time, Dance Open Petersburg present many new names included in the ballet world's top rankings. Among them - Misty Copeland , Melissa Hamilton , Egon de Jong, Sarah Michelle Murawski and others.
In addition, the Gala included in the calendar Crossover Year of Russia and the UK. Constitute a substantial part of the evening not only soloists Royal Ballet, Covent Garden, but also the work of British choreographers - in particular , Wayne McGregor and David Dawson . Both choreographer not only represent British culture , but also recognized today the most popular figures of "radical choreography " - so they represent actual line Gala.
Classic XX century productions will be presented by John Neumeier and Kenneth MacMillan , and Kasian Goleizovsky . His recognizable tone to rethink academic managed to find Jose Martinez .

Dance Open Festival continues inherent in the tradition of last year renovation unfairly , in our view , forgotten choreographic works. The success of " Walpurgis Night " by Leonid Yakobson shown at the Gala in 2013 , inspired by artistic director Vasily Medvedev for more complex searches . Ballet "Bluebeard ", staged by Marius Petipa in 1896 to the music of Peter Schenk , in post-revolutionary Russia would never go . Spectators will see Gala Grand Pas from this ballet soloists of the Bolshoi Theater . Now there is a scrupulous work not only to restore the choreographic text , but also making costumes based on sketches by Ivan Vsevolozhsky - a gifted artist and a director of the imperial theaters. Thus, despite the overall current direction XIII season , Dance Open and did not deny the propaganda of the great history of Russian ballet , which consistently pursued for several years .

Stars of Russian Ballet will also take part in the gala : on the one hand, this Victoria Tereshkina Christina Kretova Semen Chudin working in Russia , and on the other - Natalia Osipova , dancing is currently abroad, but still remaining Russian ballerina.
As always , all participants Gala nominated for V St Petersburg Ballet Award Dance Open. Balloting international jury determines the winners in six categories. However , each viewer has the opportunity to participate in the selection of favorite : lowering your ticket in a special box , any Petersburgian able to vote for the beloved actor. The unanimous opinion of the artists and members of the Jury , "Audience Award " - always the most intriguing Award nomination .

Concert with one interval .