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=1192) 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=1192) 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<>1192 AND tp.id_base=1801 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<>1192 AND tp.id_base=1801 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, 19:30 - The ballets of Mikhail Fokin:  Le Sacre du printemps. Petrouchka. - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 10 February 2018, 19:30 - The ballets of Mikhail Fokin: Le Sacre du printemps. Petrouchka.
10February
19:30
2018 | Saturday
Classical ballet
Mariinsky Theater, Saint Petersburg
World premiere: Les Ballets Russes de Serge Diaghilev, Théâtre du Châtelet, Paris, 13 June 1911

I discovered the wondereful music for this ballet once it had already been completed by Stravinsky and the ballet's plot, created together with Alexandre Benois, was completely ready. I entered a collaboration with the composer and the designer when they had already created the plot's protagonists and the main line of its development. Nevertheless, when I say "my ballet Pétrouchka", when I say that it is one of my most successful achievements, one of my most significant productions, I feel I have every right so to do. 
The ballet Pétrouchka may be spoken of as a dramatic musical opus by Igor Stravinsky which holds an exceptional place in new music. The ballet Pétrouchka may be spoken of as one of the very best works by the designer Benois. The ballet Pétrouchka may be spoken of as a Fokine production that is one of the fullest embodiments of ballet reform. In this case there was no collaboration in the sense of us all working together at the same time, the joint work of the composer, choreographer and designer. It was not at all like working on The Fire Bird, when Stravinsky played the music for me at the very outset of its creation and I tried to convey to him every instant of the ballet and excite his imagination with the scenes that I saw so clearly. Here the work followed an entirely different scheme. The composer dealt with his task, and only then did I approach my own. (…) We both spoke of the sufferings of Pétrouchka in our own language: Stravinsky through sounds and I through gestures. (…)
The thing that touches me in the music of Pétrouchka is the characters of Pétrouchka and the Moor. Not because the cries of the oboe so closely resemble the nasal voice of puppeteer who accompanies the movements of Pétrouchka the puppet through silly cries through his nose. Mozart said that the most dreadful situations should be conveyed in such a manner that the music soothes the ears. Pétrouchka is an example of how, tormenting the ears, one can caress the soul. It sits well with me. I can't express how wonderful it is for me that the composer found those sounds, those combinations of sounds and timbres that depict before my eyes the image of the loving, downtrodden and forever miserable Pétrouchka. Now, when I choose these words to describe what Pétrouchka is, I feel how inadequate words are and how helpless I am, and value all the more the eloquence of the music and the gestures. 
The entire image of the Moor embodies blunt self-satisfaction. A voluptuous lucky man. A favourite child of Fate. Everything in him is foolish. The sounds that Stravinsky do not caress the ears. There is no melody that provides pleasure. No-one would ever think of singing the Moor's melody for their own pleasure. To a large extent it is barking, snorting or bass pizzicatos. But each integral image is formed in the imagination. It is such a joy that the character is so accurately expressed. 

Michel Fokine. Extract from the book "Against the Tide"