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=28) 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=28) 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<>28 AND tp.id_base=538 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<>28 AND tp.id_base=538 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





	4 October 2020, 11:30 - Wolfgang Amadeus Mozart "Le Nozze di Figaro" ("The Marriage of Figaro") opera buffa in four acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 4 October 2020, 11:30 - Wolfgang Amadeus Mozart "Le Nozze di Figaro" ("The Marriage of Figaro") opera buffa in four acts
4October
11:30
2020 | Sunday
Duration: 3 hours 20 minutes
World premiere: Mariinsky Theatre, St Petersburg, 23 October 1998

Le nozze di Figaro had its premiere in 1786 at the Burgtheater in Vienna. Lorenzo da Ponte – with whom Mozart later collaborated on Don Giovanni and Così fan tutte – created the libretto. It was based on Pierre Beaumarchais’ controversial play Le Mariage de Figaro, which was banned in Vienna due to its seditious content. David McVicar’s acclaimed production sets the action in a French chateau in 1830 on the eve of revolution, amplifying the opera’s undercurrents of class tension. The entire household is drawn into the notoriously complex plot, which covers all shades of human emotion: spirited playfulness, such as when Figaro sends Cherubino off to war in ‘Non più andrai’, is combined with heartfelt despair, such as the Countess’s grief at her husband’s infidelity in 'Dove sono i bei momenti'. But affection and fidelity prevail in this most warm-hearted of operas: the Count’s plea for forgiveness in the final act, ‘Contessa, perdono’, is one of the most moving moments in opera.

Music: Wolfgang Amadeus Mozart
Production by Yuri Alexandrov (1998)

Libretto by Lorenzo da Ponte, after the comedy by Pierre-Augustin Caron de Beaumarchais

Performed in Italian

Stage Director: Yuri Alexandrov
Set Designer: Vyacheslav Okunev
Lighting Designer: Sergei Martinov
Principal Chorus Master: Andrei Petrenko
Musical Preparation: Larisa Larionova

World premiere: 1 May 1786, Burgtheater, Vienna
Premiere of this production: 23 October 1998, Mariinsky Theatre, St Petersburg

Casts & Credits

Choreography: Gali Abaidulov
Baritone: Vladimir Moroz
Lighting Designer: Sergei Martinov
Musical Preparation: Larisa Larionova
Principal Chorus Master: Andrei Petrenko
Set Designer: Vyacheslav Okunev
Stage Director: Yuri Alexandrov
Choreography: Gali Abaidulov
Baritone: Vladimir Moroz
Lighting Designer: Sergei Martinov
Musical Preparation: Larisa Larionova
Principal Chorus Master: Andrei Petrenko
Set Designer: Vyacheslav Okunev
Stage Director: Yuri Alexandrov