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-23' AND tmp.date<='2024-05-13' AND tmp.perf_id=1992) 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-23' AND '2024-05-13' AND tmp.perf_id=1992) 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<>1992 AND tp.id_base=1994 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<>1992 AND tp.id_base=1994 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





	10 February 2018, 13:00 - Ballet to music by Igor Stravinsky "Petrouchka" funny scenes in four scenes - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 10 February 2018, 13:00 - Ballet to music by Igor Stravinsky "Petrouchka" funny scenes in four scenes
10February
13:00
2018 | Saturday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 40 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 6 February 2010

PÉTROUCHKA

burlesque in four scenes

CREDITS

Music by Igor Stravinsky
Choreography by Michel Fokine (1911)

Libretto, sets and costumes by Alexandre Benois
Musical Director: Valery Gergiev 
Staging by Gary Chryst
Revival Designer: Batozhan Dashitsyrenov 
Lighting design: Vladimir Lukasevich 
Coach: Igor Petrov

World premiere: 13 June 1911, Les Ballets Russes de Serge Diaghilev, Théâtre du Châtelet, Paris 
Premiere of this production: 6 February 2010, Mariinsky Theatre, St Petersburg 

Running time: 40 minutes

 

Igor Stravinsky’s ballet Pétrouchka was first staged by Michel Fokine during the saisons russes in Paris in 1911. Fokine’s ballet was brought to the Mariinsky Theatre’s repertoire by Leonid Leontiev in 1920. Specially for the VI Festival Maslenitsa (Shrovetide), the American dancer and choreographer Gary Chryst has worked to bring back the ballet to the Mariinsky Theatre. Chryst worked on stage rehearsals of Pétrouchka for the acclaimed Joffrey Ballet in New York in 1970 under Diaghilev’s friend Léonide Massine, a soloist with the Ballets russes and an renowned choreographer. In 2006, Chryst staged Pétrouchka for American Ballet Theatre and later for the National Ballet of Canada.

 

 

Casts & Credits

Composer: Igor Stravinsky
Choreography: Michel Fokine
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Alexei Repnikov
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
Conductor: Alexei Repnikov
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Revival Designer: Batozhan Dashitsyrenov
Stage Director: Andrei Petrov