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=280) 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=280) 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<>280 AND tp.id_base=513 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<>280 AND tp.id_base=513 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





	23 January 2019, 19:00 - Giuseppe Verdi "Don Carlos" (Opera in four acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 23 January 2019, 19:00 - Giuseppe Verdi "Don Carlos" (Opera in four acts)
23January
19:00
2019 | Wednesday
Opera
Bolshoi theatre - Historic Stage, Moscow
World premiere: 17 December 2013

Don Carlo contains a host of vividly drawn characters, depicted through some of Verdi’s most complex music. The chilling Grand Inquisitor imposes his will in thunderous, dark-toned music, while the revolutionary Marquis of Posa sings a stirring duet with Don Carlos in praise of freedom. And in Eboli and Elizabeth, Verdi created two of his most sympathetic heroines. Verdi's music masterfully controls the twisting and turning story. Vivid orchestral colours and affecting melodies manipulate his audience to devastating effect: we love, we hate, we turn and sympathise as each note reveals a little more of these complex, charismatic characters.
The Bolshoi is celebrating the 200th anniversary of Giuseppe Verdi’s birth with a full-scale production of
the composer’s imposing masterpiece Don Carlos, after the tragedy of the same name by Friedrich
Schiller (a four-act version of the opera in Italian). The production is by the well-known English director,
Adrian Noble, for many years artistic director of The Royal Shakespeare Company at Stratford-on-Avon
(England), celebrated for his charismatic productions of Shakespeare’s plays and who works on a regular
basis in opera. He has done productions for New York’s Met, Rome Opera, Vienna State Opera, Lyons
Opera. Bolshoi Theatre Music Director and Chief Conductor Vassily Sinaisky leads a powerful
international team of singers from Russia, Italy, Mexico, Poland and the USA.

Don Carlos is a five-act grand opera composed by Giuseppe Verdi to a French language libretto by Camille du Locle and Joseph Mery, based on the dramatic play Don Carlos, Infant von Spanien (Don Carlos, Infante of Spain) by Friedrich Schiller. When performed in Italian, the opera is called Don Carlo. The story is based on conflicts in the life of Carlos, Prince of Asturias (1545–1568), after his betrothed Elisabeth of Valois was married instead to his father Philip II of Spain as part of the peace treaty ending the Italian War of 1551–1559 between the Houses of Habsburg and Valois. It was commissioned and produced by the Theвtre Imperial de l’Opera (Paris Opera) and premiered at the company's theatre, the Salle Le Peletier, on 11 March 1867.

Over the following twenty years, cuts and additions were made to the opera, resulting in a number of versions being available to directors and conductors. No other Verdi opera exists in so many versions. At its full length (including the ballet and the cuts made before the first performance), it contains about four hours of music and is Verdi's longest opera.


 

©
 photo by Damir Yusupov 


Casts & Credits

Composer: Giuseppe Verdi
Opera company: Bolshoi Opera
Conductor: Keri-Lynn Wilson
Bass-baritone: Nikolai Kazansky
Soloist: Yusif Eyvazov
Soprano: Anna Nechaeva
Costume Designer: Moritz Junge
Director: Adrian Noble
Lighting Designer: Jean Kalman
Musical Director: Vassily Sinaisky
Scenography: Tobias Hoheisel
Composer: Giuseppe Verdi
Opera company: Bolshoi Opera
Conductor: Keri-Lynn Wilson
Bass-baritone: Nikolai Kazansky
Soloist: Yusif Eyvazov
Soprano: Anna Nechaeva
Costume Designer: Moritz Junge
Director: Adrian Noble
Lighting Designer: Jean Kalman
Musical Director: Vassily Sinaisky
Scenography: Tobias Hoheisel