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-22' AND tmp.date<='2024-05-12' AND tmp.perf_id=270) 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-22' AND '2024-05-12' AND tmp.perf_id=270) 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<>270 AND tp.id_base=528 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

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<>270 AND tp.id_base=528 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





	25 January 2018, 19:00 - Peter Tchaikovsky "Onegin" (Ballet by John Cranko in three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 25 January 2018, 19:00 - Peter Tchaikovsky "Onegin" (Ballet by John Cranko in three acts)
25January
19:00
2018 | Thursday
Classical ballet
Bolshoi theatre - Small Stage, Moscow
Duration: 2 hours 20 minutes
World premiere: Maly Theatre, Moscow, 12 July 2013

Tchaikovsky’s Eugene Onegin is a radiant example of Russian Lyric Opera. A deeply moving tale packed with big tunes, dances and a heart-stopping duel. As with his ballets, Tchaikovsky brings many symphonic elements to the music, plush orchestrations and highly melodic arias. Onegin is a uniquely Russian opera with a universality that has made it globally popular. None of the characters are easy to associate with and yet the events and their actions ring horribly true.

Choreography by John Cranko
Sets and costumes by Jurgen Rose
Staging - Reid Anderson
Lighting Designer - Steen Berke
Music Director - Pavel Sorokin
Assistant Choreographer - Agnetha Valka, Victor Valka

The plot tries to follow the outline of Pushkin's novel, however, the center story is the story of Tatyana Larina and Eugene Onegin.

Main characters:
Onegin
Lenski
Tatiana
Olga
Prince Gremin (this character was created for the opera "Eugene Onegin", in Pushkin's novel it is Tatiana's husband, but he has no name)


1st act.
Larin estate, which runs quiet and happy life among the nobility of the same serene happy serfs. Neighbor Vladimir Lensky, a young man, the poet, the groom's younger daughter of Madame Larina, comes to visit and brings along his friend, a young metropolitan dandy, playing in the romantic image of a cold-traveled all of Byron on his hero - Eugene Onegin. Not seeing around other men and having read romantic books, young Tatiana - the eldest daughter of Madame Larina - falls in love with a handsome capital Onegin and writes him a grateful letter.

2 act. Celebrated the birthday of Tatiana, where Onegin jokingly decided to hit on to Olga. Quarrel with Lensky in a call to a duel, and in this game Onegin kills his friend in cold blood, and then he shudders at the thought of what he had done.

Act 3. The years pass. Onegin returns to St. Petersburg, and there on the ball meets Tatiana, she is no longer the young girl, she is a married woman. Both of them are adults, and youth playing romantic heroes left behind. Onegin sees a beautiful women ("raspberry beret" completely missing), and all the feelings that once turned to him she is now overwhelmed him. He can not resist it, and sends a letter to Tatyana, and then he comes to it. But Tatiana can not betray her husband and throws Onegin (Pushkin: "I love you, what cunning .... But I'm given to another, I will never leave him").



Ballet "Onegin" is an adaptation of the verse novel Eugene Onegin by Alexander Pushkin set to music by Tchaikovsky (mainly The Seasons) orchestrated by Kurt-Heinz Stolze.

 

John Cranko first had the idea for a ballet based on Alexander Pushkin‘s verse novel when he choreographed dances for Tchaikovky’s opera Eugene Onegin in 1952. He pitched this to the ROH board at Covent Garden but it was rejected. After a string of successful pieces for Sadler’s Wells Ballet (Pineapple Poll 1951, The Lady and the Fool 1956  and The Prince of Pagodas, 1957), Cranko left London for Stuttgart. There he created one of the most successful ballet adaptations of Romeo & Juliet (1962) and confirmed his flair for dramatic narrative, in the same vein as his contemporary and close friend Kenneth MacMillan (whose own choreographic language would be influenced by Cranko’s).

In Stuttgart he received full support from Walter Erich Schafer – General Manager of the opera and dance companies – to revisit his Onegin project, with the caveat that the opera score should not be used. Instead it fell to Kurt-Heinze Stolze, ballet Kapellmeister, to assemble various little known Tchaikovsky pieces into a ballet score. Cranko developed a libretto closely following the novel and the ballet premiered 13 April 1965 with Marcia Haydee as Tatiana and Ray Barra as Onegin. Forty five years on, Onegin is considered Cranko’s definitive masterpiece and remains in the repertory of over 20 ballet companies around the world. At the time of its premiere Onegin was hailed a success with audiences and performers, but there was some controversy with opera purists and other personalities (for instance George Balanchine) who did not approve of the opera score having been discarded.

Between 1965 and 1967 Cranko revised Onegin several times. He scrapped the original ending of Tatiana kissing her children good night, as this lessened the drama of her last encounter with Onegin. He also removed the prologue where Onegin was seen at his uncle’s deathbed, and had the score re-edited accordingly. The version we are now familiar with was first performed by Stuttgart Ballet in October 1967.


Casts & Credits

Choreography: John Cranko
Ballet company: Bolshoi Ballet
Costume Designer: Jurgen Rose
Musical Director: Pavel Sorokin
Choreography: John Cranko
Ballet company: Bolshoi Ballet
Costume Designer: Jurgen Rose
Musical Director: Pavel Sorokin