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-18' AND tmp.date<='2024-06-07' AND tmp.perf_id=2560) 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-18' AND '2024-06-07' AND tmp.perf_id=2560) 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<>2560 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<>2560 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





	3 February 2019, 19:00 - The ballets of Mikhail Fokin: Petrouchka. Sheherazade. The Firebird - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 3 February 2019, 19:00 - The ballets of Mikhail Fokin: Petrouchka. Sheherazade. The Firebird
3February
19:00
2019 | Sunday
Classical ballet
Mariinsky Theater, Saint Petersburg
Evening of one act ballets
Music by Igor Stravinsky, Nikolai Rimsky-Korsakov
Choreography by Michel Fokine

PETROUCHKA

burlesque in four scenes

Music by Igor Stravinsky
Choreography by Michel Fokine (1911)
Libretto by Alexandre Benois
Staging by Gary Chryst
Revival Designer: Batozhan Dashitsyrenov
Lighting design: Vladimir Lukasevich
Coach: Igor Petrov

World premiere: 13 June 1911, Thйвtre du Chвtelet, Paris
Premiere of this production: 6 February 2010, Mariinsky Theatre, St Petersburg


THE FIREBIRD

russian fairytale in two scenes

Music by Igor Stravinsky
Choreography by Michel Fokine (1910)
Libretto by Michel Fokine
Reconstruction by Isabelle Fokine, Andris Liepa
Set and costume design by Anna and Anatoly Nezhny
after original sketches by Alexander Golovin, Lйon Bakst and Michel Fokine

World premiere: 25 June 1910, Les Ballets Russes de Serge de Diaghilev, Theatre de lґOpйra, Paris
In the repertoire of the Mariinsky Theatre since 1994

Running time: 44 minutes


SCHEHERAZADE

choreographic drama in one act

Music by Nikolai Rimsky-Korsakov (Symphony suite Schйhйrazade)
Choreography by Michel Fokine (1910)
Scenario by Lйon Bakst and Michel Fokine after Arabian Nights fairytales
Reconstruction by Isabelle Fokine, Andris Liepa
Set and costume design by Anna Nezhnaya, Anatoly Nezhny after original sketches by Lйon Bakst

World premiere: 4 June 1910, Les Ballets Russes de Serge de Diaghilev, Thйвtre de lґOpйra, Paris
In the repertoire of the Mariinsky Theatre since 1994

Running time: 45 minutes

Casts & Credits

Composer: Igor Stravinsky
Choreography: Michel Fokine
Ballet company: Mariinsky (Kirov) Ballet
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Revival Designer: Batozhan Dashitsyrenov
Stage Director: Andrei Petrov
Composer: Igor Stravinsky
Choreography: Michel Fokine
Ballet company: Mariinsky (Kirov) Ballet
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Revival Designer: Batozhan Dashitsyrenov
Stage Director: Andrei Petrov