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-22' AND tmp.date<='2024-06-11' AND tmp.perf_id=2267) 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-22' AND '2024-06-11' AND tmp.perf_id=2267) 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<>2267 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<>2267 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





	2 August 2018, 19:30 - Evening of one-act ballets "Pavlovsk" "Divertissement of the King" - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 2 August 2018, 19:30 - Evening of one-act ballets "Pavlovsk" "Divertissement of the King"
2August
19:30
2018 | Thursday
Classical ballet
Mariinsky Theatre - Mariinsky II, Saint Petersburg

Pavlovsk 

CREDITS

Music by Karen LeFrak 

Choreographer and Set Designer: Maxim Petrov 

Costume Designer: Tatiana Noginova 

Lighting Designer: Konstantin Binkin

 

Premiere: 7 April 2016, Mariinsky Theatre, St Petersburg 

(as a part of the project A Creative Workshop of Young Choreographers)

Running time 10 minutes

 

Divertissement of the King

CREDITS

Music by Jean-Philippe Rameau
Choreography by Maxim Petrov
Costume Designer: Tatiana Noginova
Lighting Designer: Konstantin Binkin
Libretto by Bogdan Korolyok

ABOUT THE PRODUCTION

Le Divertissement du Roi is a neoclassical fantasy on a baroque theme, it is recollections of the happy beginnings of the art of ballet that unfolded in the Louvre and in Versailles. The protagonist of the ballet is a King who loves to appear at the theatre dressed as the Sun. The prototypes number more than just Louis XIV: contrary to popular opinion, the epithet Le Roi Soleil was first attributed to his most august father, Louis XIII. Just as much as his son, he loved to take part in Court masquerade balls, and not always as the star of day. Much more frequently he appeared as marginalised urban dwellers and port idlers - such as a drunken Dutch captain. 
Maxim Petrov’s ballet is a catalogue of cherished images of baroque ballet. Although the music used is by Jean-Philippe Rameau – and this is a very late score from the baroque theatre tradition – the divertissement features entrées typical of earlier times. There are peasants on the stage (the indispensable gallants), Play and Pleasure as well as miraculous snails which are also ugly furies. But the protagonist of the evening is Armide the magician. The mistress of enchanted salons that appear and disappear as she waves her hand is, arguably, a key feature of baroque art, tensely feeling the border between dreams and reality, trying to separate illusions from truth. In brief, no-one can ultimately guarantee that the entire so-called “king’s divertissement” is not an illusion – a jester’s trick with fairground comedians. 
Bogdan Korolyok

Premiere: 14 June 2015, Mariinsky Theatre, St Peterburg

Running time 25 minutes