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-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=878) 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-14' AND '2024-06-03' AND tmp.perf_id=878) 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<>878 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<>878 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





	23 November 2019, 19:30 - Evening of one-act ballets by Michel Fokine. One act ballets: Chopiniana. Le Spectre de la Rose. The Swan. Carnaval - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 23 November 2019, 19:30 - Evening of one-act ballets by Michel Fokine. One act ballets: Chopiniana. Le Spectre de la Rose. The Swan. Carnaval
23November
19:30
2019 | Saturday
one act ballets
Music: Frederic Chopin, Carl Maria von Weber, Camille Saint-Saens, Robert Schumann
Choreography: Michel Fokine


Chopiniana
choreographic composition in one act
Music: Frederic Chopin (suite of piano pieces orchestrated: Alexander Glazunov and Maurice Keller)
Choreography: Michel Fokine (1908)
Scenario: Michel Fokine
Revised version: Agrippina Vaganova (1931)
Set design based on original sketches: Orest Allegri

World premiere: 8 March 1908, Mariinsky Theatre, St Petersburg

Running time: 35 minutes


Le Spectre de la Rose
choreographic tableau

Music: Carl Maria von Weber (Invitation to the Dance orchestrated: Hector Berlioz)
Choreography: Michel Fokine (1911)
Concept: Jean-Louis Vaudoyer based on the poem: Theophile Gautier
Scenario: Michel Fokine
Reconstruction: Isabelle Fokine
Set design: Viacheslav Okunev
Costume design after original designs: Leon Bakst

World premiere: 19 April 1911, Les Ballets Russes de Serge de Diaghilev, Theatre de Monte Carlo
In the repertoire of the Mariinsky Theatre since 1997

Running time: 11 minutes


The Swan
choreographic composition

Music: Camille Saint-Saens (from the Carnaval des animaux suite)
Choreography: Michel Fokine (1907)

World premiere: 22 December 1907, Mariinsky Theatre, St Petersburg

Running time: 4 minutes


Carnaval
pantomime ballet in one act Music: Robert Schumann (Le Carnaval, Op. 9, orchestrated by N. Rimsky-Korsakov, A. Lyadov, A. Glazunov, N. Cherepnin, A. Arensky)
Choreography: Michel Fokine (1910)
Set and Costume design: Leon Bakst
The revival team:
Choreography staged: Sergei Vikharev
Sets reproduced: Mikhail Shishliannikov
Lighting: Alexander Naumov and Mikhail Shishliannikov
Costumes reproduced: Tatiana Noginova

Casts & Credits

Composer: Frederic Chopin
Composer: Hector Berlioz
Composer: Robert Schumann
Choreography: Michel Fokine
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Alexei Repnikov
Costume Designer: Tatiana Noginova
Lighting Designer: Alexander Naumov
Set Designer: Vyacheslav Okunev