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=2192) 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=2192) 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<>2192 AND tp.id_base=2194 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<>2192 AND tp.id_base=2194 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





	16 July 2019, 19:00 - Peter Tchaikovsky "Onegin" (Ballet by John Cranko in three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 16 July 2019, 19:00 - Peter Tchaikovsky "Onegin" (Ballet by John Cranko in three acts)
16July
19:00
2019 | Tuesday
Classical ballet
Bolshoi theatre - Small Stage, Moscow
Duration: 2 hours 35 minutes
World premiere: Bolshoi theatre - Historic Stage, 12 July 2013

Choreography: John Cranko
Sets and Costumes: Jürgen Rose
Choreographic supervision: Reid Anderson
Ballet Masters: Agneta Valcu, Victor Valcu
Lighting Designer: Steen Bjarke
Music Director: Pavel Sorokin
Rights owner: Dieter Graefe

Synopsis

Act I

Scene 1
Madame Larina’s GardenMadame Larina, Olga and the nurse are finishing the party dresses and gossiping about Tatiana’s upcoming birthday festivities. Madame Larina speculates on the future and reminisces about her own lost beauty and youth. Lensky, a young poet engaged to Olga, arrives with a friend from St. Petersburg. He introduces Onegin, who, bored with the city, has come to see if the country can offer him any distraction. Tatiana, full of youthful and romantic fantasies, falls in love with the elegant stranger, so different from the country people she knows. Onegin, on the other hand, sees in Tatiana only a naive country girl who reads too many romantic novels.

Scene 2
Tatiana’s BedroomTatiana, her imagination aflame with impetuous first-love, dreams of Onegin and writes him a passionate love letter, which she gives to her nurse to deliver.

Act II

Scene 1
Tatiana’s BirthdayThe provincial gentry have come to celebrate Tatiana’s birthday. They gossip about Lensky’s infatuation with Olga and whisper prophecies of a dawning romance between Tatiana and the newcomer. Onegin finds the company boring. Stifling his yawns, he finds it difficult to be civil to them; furthermore he is irritated by Tatiana’s letter which he regards merely as an outburst of adolescent love. In a quiet moment, he seeks out Tatiana and, telling her that he cannot love her, tears up the letter. Tatiana’s distress, instead of awakening pity, merely increases his irritation. Prince Gremin, a distant relation, appears. He is in love with Tatiana and Madame Larina hopes for a brilliant match but Tatiana, troubled with her own heart, hardly notices her kindly, older relation. Onegin, in his boredom, decides to provoke Lensky by flirting with Olga who light-heartedly joins in his teasing. But Lensky takes the matter with passionate seriousness. He challenges Onegin to a duel.

Scene 2
The DuelTatiana and Olga try to reason with Lensky but his high romantic ideals are shattered by the betrayal of his friend and the fickleness of his beloved; he insists that the duel take place. Onegin kills his friend and for the first time his cold heart is moved by the horror of his deed. Tatiana realizes that her love was an illusion and that Onegin is self-centred and empty.

Act III

Scene 1
St. PetersburgOnegin, having travelled the world for many years in an attempt to escape his own futility, returns to St. Petersburg where he is received at a ball in the palace of Prince Gremin. Gremin has recently married and Onegin is astonished to recognize in the stately and elegant young princess, Tatiana, the uninteresting little country girl whom he once turned away. The enormity of his mistake and loss engulfs him. His life now seems even more aimless and empty.

Scene 2
Tatiana’s BoudoirTatiana reads a letter from Onegin, which reveals his love for her. Suddenly he stands before her, impatient to know her answer. Tatiana sorrowfully tells him that although she still feels her passionate girlhood love for him, she is now a woman and she could never find happiness with him or have respect for him. She orders him to leave her forever.

Casts & Credits

Choreography: John Cranko
Ballet company: Bolshoi Ballet
Conductor: Igor Dronov
Musical Director: Pavel Sorokin