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=156) 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=156) 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<>156 AND tp.id_base=1049 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<>156 AND tp.id_base=1049 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





	19 January 2019, 19:00 - Gioachino Rossini "Il barbiere di Siviglia" opera in two acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 19 January 2019, 19:00 - Gioachino Rossini "Il barbiere di Siviglia" opera in two acts
19January
19:00
2019 | Saturday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 3 hours 10 minutes
World premiere: Mariinsky Theatre-2, St Petersburg, Russia, 29 October 2014

Music by Gioachino Rossini
Libretto by Cesare Sterbini after Pierre-Augustin Caron de Beaumarchais' comedy Le Barbier de Séville, ou Précaution inutile

Stage Director and Set Designer: Alain Maratrat 
Musical Preparation: Larisa Gergieva 
Design of Costumes, Headwear and Puppets: Mireille Dessingy 
Production of Puppets: Stéphane Clément 
Production of Headwear: Gregoria Recio 
Lighting Designer: Pascal Noël 
Chorus Master: Pavel Teplov

World premiere: 20 February 1816, Teatro Argentina, Rome
Premiere of this production: 29 October 2014, Mariinsky II, St Petersburg The performance has one interval

SYNOPSIS 

Act I

 Scene 1
A square in Seville early in the morning. In front of Dr Bartolo’s house Count Almaviva and a group of musicians are serenading the Count’s beloved Rosina. Rosina, however, does not appear – she is under the strict supervision of her guardian who himself dreams of marrying his ward and taking possession of her dowry. The barber Figaro appears, an old acquaintance of the Count. On discovering that Almaviva is in love with Rosina, the barber resolves to offer his assistance – after all, Figaro is a welcome guest at Bartolo’s house where he is a barber, doctor and even a botanist. Rosina finally succeeds in throwing a note to the Count from her balcony. Almaviva does not wish to reveal his noble standing, and Figaro advises him to claim he is a student called Lindoro. He then suggests the Count pretend to be a drunken soldier and demand lodgings in Bartolo’s house.

Scene 2
A room in Bartolo’s house. Rosina is dreaming of Lindoro. Don Basilio, who is teaching Rosina a song, on discovering the fervent emotions of Count Almaviva resolves to warn Dr Bartolo and advises him to slander his rival in front of Rosina and society at large. The appearance of a drunken soldier (Almaviva in disguise) enrages Bartolo. The doctor sees that the “soldier” is trying to pass a note to Rosina. Chaos ensues and soldiers rush in to restore order, but when the Count quietly mentions his name to the officer, the latter respectfully welcomes him among the general amazement.


Act II

 Scene 1
Bartolo is sitting in his study. A young man appears and says his name is Don Alonso – he has come to give a music lesson to Rosina instead of Basilio who has fallen ill. Once again it is the Count in disguise. Rosina settles down to study with greater enthusiasm than usual. At the same time the “sham patient” arrives and Figaro again comes to assist – he gives Don Basilio a terrible diagnosis – “scarlatina!” and convinces him to return home and go to bed immediately. During the music lesson Bartolo begins to have his suspicions, before he finally discovers the truth and kicks everyone out. Berta the housekeeper talks of her master’s foolish love.

Scene 2
Bartolo, wishing to hasten on the marriage, sends for a notary. Rosina, whom he has convinced of Lindoro’s deceitfulness, has agreed to marry her guardian. Figaro appears unexpectedly with the Count, who now reveals his true identity. Rosina is thrilled and the lovers decide to elope. But their plans are almost thwarted by the appearance of Don Basilio with the notary, who has come to conclude the marriage contract between Bartolo and Rosina, but the doctor is not at home. Taking advantage of the circumstances, Count Almaviva bribes Basilio, and he agrees to be a witness to the marriage contract concluded by Count Almaviva and Rosina. The appearance of the reprobate Bartolo comes too late to spoil the lovers’ happiness. Moreover, the old man takes comfort in the fact that Almaviva refuses to accept Rosina’s dowry.

Casts & Credits

Conductor: Zaurbek Gugkaev
Costume Designer: Mireille Dessingy
Musical Preparation: Larisa Gergieva
Stage Director: Alain Maratrat
Conductor: Zaurbek Gugkaev
Costume Designer: Mireille Dessingy
Musical Preparation: Larisa Gergieva
Stage Director: Alain Maratrat