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=1819) 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=1819) 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<>1819 AND tp.id_base=1912 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<>1819 AND tp.id_base=1912 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





	16 April 2019, 19:00 - Gioacchino Rossini "The Barber of Seville" comic opera in two acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 16 April 2019, 19:00 - Gioacchino Rossini "The Barber of Seville" comic opera in two acts
16April
19:00
2019 | Tuesday
Opera
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours 50 minutes
World premiere: Mikhailovsky Theater, 7 September 2017

Dashing Count Almaviva has lost his heart to the spunky Rosina, whose doddering guardian is determined to marry her himself. It’s Figaro to the rescue, as the resourceful barber conjures up wacky schemes and strategies to unite the young lovers.A topnotch cast sails through the score’s bel canto glories, thrilling the audience as characters that are just as vivid today as when they first took the stage. Rossini’s razor-sharp musical wit glints through every scene of this delicious comedy, one of the most playful and popular in the entire operatic repertoire.

Libretto by Cesare Sterbini after the comedy by Pierre-Augustin Caron de Beaumarchais 

Musical Director of the production: Mikhail Tatarnikov
Stage Director, Costume Designer: Éric Vigié
Stage Designer: Emmanuelle Favre
Lighting Designer: Alexander Kibitkin
Assistant to Conductor: Philipp Selivanov
Assistant to Costume Designer: Alexandra Leonidova
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh

One of the most popular operas in the world whose joyous melodies are instantly recognizable, it has been an indispensable fixture in the Mikhailovsky’s repertoire since 1918, when the Theatre’s own opera company was founded. Swiss director Éric Vigié has created his own unique production of this opera, harking back to a time when opera was not yet seen as the domain of the elites, but was designed to appeal to the most varied audiences. Colourful and heady, Seville is a true Southern city an incomparable microcosm of Spain as a whole. The crowd scenes are filled with footballers, pop stars, flamenco dancers, guitarists and even... a monkey, a donkey, and a ‘little blue dog’. This operatic scherzo — bright, elegant, and unfettered by the traditional canon — is guaranteed to leave audiences in the very best of spirits.

SYNOPSIS

ACT I

Seville. Count Almaviva comes in disguise to the house of Doctor Bartolo and serenades Rosina, whom Bartolo keeps confined to the house. Figaro the barber, who knows all the town’s secrets and scandals, explains to Almaviva that Rosina is Bartolo’s ward, not his daughter, and that the doctor intends to marry her. Figaro devises a plan: the count will disguise himself as a drunken soldier with orders to be quartered at Bartolo’s house so that he may gain access to Rosina. Almaviva is excited and Figaro looks forward to a nice cash pay-off.
Rosina reflects on the voice that has enchanted her and resolves to use her considerable wiles to meet the man it belongs to—as Almaviva has led her to believe, a poor student named Lindoro. Bartolo appears with Rosina’s music master, Don Basilio. Basilio warns Bartolo that Count Almaviva, who has made known his admiration for Rosina, has been seen in Seville. Bartolo decides to marry Rosina immediately. Basilio suggests slander as the most effective means of getting rid of Almaviva. Figaro, who has overheard the plot, warns Rosina and promises to deliver a note from her to Lindoro. Bartolo suspects that Rosina has indeed written a letter, but she outwits him at every turn. Bartolo warns her not to trifle with him.
Almaviva arrives, creating a ruckus in his disguise as a drunken soldier, and secretly passes Rosina his own note. Bartolo is infuriated by the stranger’s behavior and noisily claims that he has an official exemption from billeting soldiers. Figaro announces that a crowd has gathered in the street, curious about the argument they hear coming from inside the house. The civil guard bursts in to arrest Almaviva, but when he secretly reveals his true identity to the captain he is instantly released. Everyone except Figaro is amazed by this turn of events.

ACT II

Bartolo suspects that the „soldier“ was a spy planted by Almaviva. The count returns, this time disguised as Don Alonso, a music teacher and student of Don Basilio, to give Rosina her singing lesson in place of Basilio, who, he says, is ill at home. „Don Alonso“ then tells Bartolo that when visiting Almaviva at his inn, he found a letter from Rosina. He offers to tell her that it was given to him by another woman, seemingly to prove that Lindoro is toying with Rosina on Almaviva’s behalf. This convinces Bartolo that „Don Alonso“ is indeed a student of the scheming Basilio, and he allows him to give Rosina her lesson. With Bartolo dozing off, Almaviva and Rosina declare their love.
Figaro arrives to give Bartolo his shave and manages to snatch the key that opens the doors to Rosina’s balcony. Suddenly Basilio shows up looking perfectly healthy. Almaviva, Rosina, and Figaro convince him with a quick bribe that he is in fact ill and must go home at once. While Bartolo gets his shave, Almaviva plots with Rosina to meet at her balcony that night so that they can elope. But the doctor overhears them and realizing he has been tricked again, flies into a rage. Everyone disperses.
The maid Berta comments on the crazy household. Bartolo summons Basilio, telling him to bring a notary so Bartolo can marry Rosina that very night. Bartolo then shows Rosina her letter to Lindoro, as proof that he is in league with Almaviva. Heartbroken and convinced that she has been deceived, Rosina agrees to marry Bartolo. A thunderstorm passes. Figaro and the count climb a ladder to Rosina’s balcony and let themselves in with the key. Rosina appears and confronts Lindoro, who finally reveals his true identity as Almaviva. Basilio shows up with the notary. Bribed and threatened, he agrees to be a witness to the marriage of Rosina and Almaviva. Bartolo arrives with soldiers, but it is too late. He accepts that he has been beaten, and Figaro, Rosina, and the count celebrate their good fortune.