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=261) 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=261) 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<>261 AND tp.id_base=515 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<>261 AND tp.id_base=515 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





	20 April 2019, 19:00 - Giuseppe Verdi "Traviata" (Opera in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 20 April 2019, 19:00 - Giuseppe Verdi "Traviata" (Opera in two acts)
20April
19:00
2019 | Saturday
Opera
Bolshoi theatre - Historic Stage, Moscow
Duration: 2 hours 40 minutes
World premiere: Bolshoi theatre, Moscow, Russia, 7 October 2012

The most lyrical Verdi’s work is La traviata, based on the novel by Alexandre Dumas, fils The Lady of the Camellias. The title La traviata means literally The Fallen Woman, or perhaps more figuratively, The Woman Who Goes Astray. The title character of the play is Marguerite Gautier, who is based on Marie Duplessis, the real-life lover of author Dumas, fils. Duplessis was both a popular courtesan and the hostess of a salon, where politicians, writers, and artists gathered for socializing. Alexandre Dumas, père allegedly insisted on his son splitting up with Duplessis: and when he returned to Paris, she had already died of consumption. Since its debut as a play, numerous editions have been performed at theatres around the world. Giuseppe Verdi attended the Paris première of the play and soon turned to composing the opera. When Dumas, fils heard La traviata, he said: “Nobody would have remembered my Lady of the Camellias in 50 years but for Verdi, who made it immortal”.

Opera (performed in Italian)

Libretto by Francesco Maria Piave based on the novel La dame aux Camelias by Alexandre Dumas, fils

Music Director: Laurent Campellone
Stage Director: Francesca Zambello
Associated Director: Julia Pevzner
Set Designer: Peter John Davison
Costume Designer: Tanya McCallin
Lighting Designer: Mark McCullough
Chorus Master: Valery Borisov
Choreographer: Ekaterina Mironova

 

First performance: Teatro la Fenice, Venice, March 6, 1853. Traviata means literally The Woman Who Strayed.

The project is run by an international team, a world renowned Francesca Zambello is the director. It is already the third production for her at the Bolshoi Theater. (In 2002 she staged Turandot by G. Puccini, and in 2004 — for the first time at the Bolshoi — The Fiery Angel by S. Prokofiev).

Francesca Zambello:

La Traviata — surely is one of the greatest operas ever written, and one of the most important works from the so-called” middle period “in the works of Verdi. For the first time ever the composer based his opera on a modern, popular, book which shocked the society, and not a myth, or, say, a play by Shakespeare. It was a real revolution, a real shock to the public: the opera, which tells about real people, living in the present, with real problems, the opera telling the story about love between an experienced woman and a very young man who, in addition, came from different social strata, about an incurable disease. And, please, note that La Traviata does not belong to those works where love overcomes all obstacles.

Today we no longer think about it. La Traviata is not perceived by us as a revolutionary product, but it seems to me that even now it is still very important to find in the characters that force and ‘intensity’ of emotions that shocked people.

For me and for all the staging team it is a huge honor to work on La Traviata at the Bolshoi Theatre. This opera has not been on a stage for rather a long time. And for us it is a chance to tell a story which seems to be well-known to everybody, but which nobody really knows. In this performance we will at the story via the perception of Violetta herself — a mysterious and beautiful woman, whom everyone loved and idealized, but — no one knew”.

Venera Gimadieva, the soloist of the Bolshoi, Albina Shagimuratova — a splendid Lyudmila in the last season premiere at the Bolshoi Theatre and the Mariinsky soloist Oksana Shilova rehearse the part of Violetta. An admirable tenor Alexey Dolgov, who joined the Bolshoi troupe this season, and the singer from the Youth opera program Evgeny Nagovitsyn will sing Alfredo. Igor Golovatenko and Vasily Ladyuk, soloists of the “New Opera” which has a long and successful history of cooperation with the Bolshoi, will sing Germont.

The Musical Director of the production is Laurent Kampellone, a French conductor, already familiar to the Moscow public: in 2010 he conducted a concert performance of Offenbach “Tales of Hoffmann” in the opera season ticket of the Moscow Philharmonic (Orchestra — “New Russia” and an international team of singers).

Casts & Credits

Composer: Giuseppe Verdi
Choreography: Ekaterina Mironova
Opera company: Bolshoi Opera
Conductor: Pavel Klinichev
Baritone: Elchin Azizov
Mezzo soprano: Irina Dolzhenko
Mezzo soprano: Yelena Novak
Tenor: Rame Lahaj
Choirmaster producer: Valery Borisov
Musical Director: Loran Campellone
Stage Director: Francesca Zambello
Composer: Giuseppe Verdi
Choreography: Ekaterina Mironova
Opera company: Bolshoi Opera
Conductor: Pavel Klinichev
Baritone: Elchin Azizov
Mezzo soprano: Irina Dolzhenko
Mezzo soprano: Yelena Novak
Tenor: Rame Lahaj
Choirmaster producer: Valery Borisov
Musical Director: Loran Campellone
Stage Director: Francesca Zambello