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=983) 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=983) 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<>983 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<>983 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





	,  - Evening of one-act ballets. Carmen Suite. Le Jeune Homme et la Mort. - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II , - Evening of one-act ballets. Carmen Suite. Le Jeune Homme et la Mort.
|
Classical ballet
Mariinsky Theatre - Mariinsky II, Saint Petersburg

Carmen is a passionate, free-spirited woman in contrast to the temperamental and fickle Don Jose. Fate, a ballerina dressed in black and a representation of Carmen’s alter ego, shows Carmen the cards. After a fight with tobacco dealers, Carmen seduces Don Jose and convinces him to release her from jail. Carmen is subsequently caught in a love triangle between Don Jose and the popular bullfighter Escamillo.

Le Jeune Homme et la Mort is one of the earliest and most famous works by Roland Petit. The ballet was staged in post-war Paris in 1946 for the recently established company Les Ballets des Champs-Elysees. The ballet by Roland Petit which we know today is considered based on mime drama by Jean Cocteau. In actual fact, both the theme of relationships between an artist and death and the very image of a girl as death and lovers as death were key themes for Cocteau; he had his own accounts to settle with women and he himself was an artist.


Carmen Suite.

World premiere: 20 April 1967, Bolsoi Theatre, Moscow
Premiere at the Mariinsky Theatre: 19 April 2010

Running time: 45 minutes 

Carmen is a passionate, free-spirited woman in contrast to the temperamental and fickle Don Josй. Fate, a ballerina dressed in black and a representation of Carmen’s alter ego, shows Carmen the cards. After a fight with tobacco dealers, Carmen seduces Don Josй and convinces him to release her from jail. Carmen is subsequently caught in a love triangle between Don Josй and the popular bullfighter Escamillo..

Le Jeune Homme et la Mort

Running time 16 minutes

Le Jeune Homme et la Mort is one of the earliest and most famous works by Roland Petit. The ballet was staged in post-war Paris in 1946 for the recently established company Les Ballets des Champs-Йlysйes. The ballet by Roland Petit which we know today is considered based on mime drama by Jean Cocteau. In actual fact, both the theme of relationships between an artist and death and the very image of a girl as death and lovers as death were key themes for Cocteau; he had his own accounts to settle with women and he himself was an artist.

A studio. The artist is unable to relax as he waits in torment. A woman appears: mysterious, sharp and heartless – the typical crafty Parisian woman – and during her brief visit she prompts the Youth to commit suicide. Moreover, she is, in fact, Death itself, its unique and original personification.

Production Sponsor: Toshihiko Takahashi

Casts & Credits

Composer: Georges Bizet
Choreography: Alberto Alonso
Choreography: Roland Petit
Ballet company: Mariinsky (Kirov) Ballet
Artistic Director: Boris Messerer
Production design: Boris Messerer
Composer: Georges Bizet
Choreography: Alberto Alonso
Choreography: Roland Petit
Ballet company: Mariinsky (Kirov) Ballet
Artistic Director: Boris Messerer
Production design: Boris Messerer