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=216) 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=216) 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<>216 AND tp.id_base=835 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<>216 AND tp.id_base=835 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





	,  - Gaetano Donizetti "Lucia di Lammermoor" (tragic opera in three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre , - Gaetano Donizetti "Lucia di Lammermoor" (tragic opera in three acts)
Duration: 2 hours 40 minutes (one intermission)
World premiere: The Stanislavsky and Nemirovich-Danchenko Moscow Academic Music Theatre, 13 February 2009

Music  Gaetano Donizetti
Libretto  Salvatore Cammarano
Music Director  Wolf Gorelik
Conductor 
Vyacheslav Volich
Felix Korobov
Stage Director  Adolf Shapiro
Set Designer  Andris Freibergs
Costume Designer  Elena Stepanova
Lighting Designer  Gleb Filshtinsky
World premiere: September 26, 1835
Teatro di San Carlo, Naples

Premiere of the production: February 13, 2009
The Stanislavsky and Nemirovich-Danchenko
Moscow Academic Music Theatre

Overview

 

"Lucia de Lammermoor" premiered in 1835 at the San Carlo Theatre of Naples. The composer, Gaetano Donizetti, was not only fascinated with the novel "The Bride of Lammermoor" by Walter Scott, which by then had more than once been adjusted to opera, but also had a personal fascination with the plot: one of his ancestors, Donald Izett (whose name was easily metamorphosed  into Donizetti) was a Scott. 

Despite the giddy difficulties for performers (or perhaps because of them) this work of Donizetti’s is one of the most popular ones in the world. The first Lucia was the beautiful Fanny Tacchinardi Persiani. During the 19th and 20th centuries all the legendary opera divas have shined out in the part: Adelina Patti, Lily Ponce, Joan Sutherland, Maria Callas, Beverly Sills, Renata Scotto, Edita Gruberova. The 21st century’s prima donnas keep conquering the main character’s cloud-piercing heights of coloratura. Tenors too aspire to their glory; they too have in stock extremely high notes that the composer reserved for them towards the end of the opera. 

Lucia di Lammermoor has everything that can be expected of an opera classic: wonderful melodies that instantly stick in mind; passionate love and as passionate hatred against the background of an ancient Scottish castle; a magnificent opera prima donna and a tenor in love with her. 

The Music Theatre’s production was named one of the most spectacular events of the 2008-09 opera season and won the Golden Mask National Theater Award and the Casta Diva Russian Opera Award.

 

Сast
Conductor 
Vyacheslav Volich
Felix Korobov
Lucia 
Evgenia Afanasieva
Hibla Gerzmava
Nadezhda Pavlova
Daria Terekhova
Sir Edgardo di Ravenswood 
Chingis Ayusheev
Najmiddin Mavlyanov
Lord Enrico Ashton 
Andrey Baturkin
Dmitry Zuev
Ilya Pavlov
Raimondo Bidebent 
Dmitry Ulyanov
Roman Ulybin
Lord Arturo Bucklaw 
Sergey Balashov
Alexander Nesterenko
Kirill Zolochevsky
Alisa 
Veronika Vyatkina
Ella Feyginova
Normanno 
Evgeny Liberman
Valery Mikitsky