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=1334) 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=1334) 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<>1334 AND tp.id_base=-1 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<>1334 AND tp.id_base=-1 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





	,  - Charles Gounod "Faust" (opera in three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" , - Charles Gounod "Faust" (opera in three acts)
|
Opera
Moscow theatre "New Opera", Moscow
Duration: 3 hours 40 minutes
World premiere: Moscow theatre "New Opera", 15 September 2016

Music Director and Conductor: Jan Latham-Koenig
Conductor: Andrey Lebedev
Stage Director: Ekaterina Odegova
Set Designer: Etel Ioshpa
Costume Designer: Svetlana Grishchenkova
Lighting Designer: Nikita Smolov
Choirmaster: Yulia Senyukova
Drama Advisor: Mikhail Muginshtein

Performed in French with Russian Subtitles

harles Gounod’ Faust after the Goethe tragedy enjoys pride of place among the operas that captured Russian hearts back in the 19th century. The opera almost immediately gained popularity in Russia. The Bolshoi Theatre staged the first version in 1866, just seven years after the Paris premiere. 

Faust is quite literally part of Russian and Moscow opera culture. Among the exited admirers of this piece was a young doctor who later became a famous writer and playwright, Mikhail Bulgakov (1891–1940). Gounod’s opera is a recurrent character in Bulgakov’s work, and it is mentioned in the novel Master and Margarita

The Novaya Opera Theatre presented its Faust in the year of the 150th anniversary of the opera’s Moscow premiere, and of the 125th anniversary of Mikhail Bulgakov’s birth. In this production, made by stage director Ekaterina Odegova and dramatist and opera critic Mikhail Muginshtein, Goethe’s and Gounod’s characters will possess recognizable Moscow features.

In playing with Marguerite and Faust – light and dark, Mephistopheles represents the dialectics of good and evil, raises these forces to the absolute and observes. The demoniac source of energy for life and death is an ever-changing, destructive, but also irresistibly captivating thing. It is a narcotic for the restless Faust: “Satan, have mercy on my long distress!” (Charles Baudelaire). Signing the contract with Mephistopheles is a mere formality, a trick. Mephistopheles will get Faust’s soul de-jure, but he already possesses it de-facto. Even before appealing to Satan, Faust curses faith and God. For him Dieu (God) is identical to Rien (Nothing). God is something permanent, complete and ideal. The embodiment of the Divine on the earth is Marguerite, a romantic’s woman. But in the end, the ideal woman for a romantic is a dead woman. Only the death of an ideal can be proof of its phenomenon (from Wagner’s Senta to Verdi’s Desdemona). That’s why for Mephistopheles Faust is not the aim, but a means to achieve it in the struggle for the maiden’s soul. And Marguerite saves her soul with the light of faith and integrity. No matter how the loving soul suffers, its suffering will never win it joy, though it might come to realize itself, wrote the poet Fyodor Tyutchev. Marguerite’s exhausted, hard-won soul deserves the light. The journey of the romantic Faust is over. He has seen God in Marguerite. But Faust deserves neither the light nor peace…

The three main characters are associated with three scenic leit-motifs: light(from a light bulb to jack-o'-lanterns), movement (the devil’s energy), a handkerchief. An armchair scientist (Faust) and an ecumenical philosopher (Mephistopheles) contrast not only in the scale and way of learning, but also in its tool. Faust’s devices and instruments are useless before the optics of the Devil’s camera obscura. In conclusion we’d like to emphasize the fact that the action is not linear, the journey through time and space dictates the form: from Faust’s black study to Mephistopheles’ black study (Acts 1 and 5), through a medieval German town (Act 2) and a romantic garden (Act 3) with their mirror reprise (Act 4).