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=632) 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=632) 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<>632 AND tp.id_base=763 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<>632 AND tp.id_base=763 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





	10 October 2021, 12:00 - Mikhail Glinka "Ruslan and Lyudmila" (magical opera in five acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 10 October 2021, 12:00 - Mikhail Glinka "Ruslan and Lyudmila" (magical opera in five acts)
10October
12:00
2021 | Sunday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 4 hours 30 minutes
World premiere: Mariinsky Theatre, St Petersburg, 1994

Libretto: Mikhail Glinka, Konstantin Bakhturin, Alexander Shakhovskoi, Valerian Shirkov, Mikhail Gedeonov, Nestor Kukol’nik and Nikolay Markevich, after the poem by Alexander Pushkin

Decorations are restored from the 1904 version of the performance by Alexander Golovin and Konstantin Korovin

Set Design: Thierry Bosquet (Belgium)

World Premiere: 27 November (9 December) 1842, Bolshoi Theatre, St Petersburg;
Premiere of this production: 1994, Mariinsky Theatre, St Petersburg

Performed in Russian

The Performance has three intermissions

Ruslan and Lyudmila (Russian: Ruslan i Ljudmila) is an opera in five acts (eight tableaux) composed by Mikhail Glinka between 1837 and 1842. The opera is based on the 1820 poem of the same name by Aleksandr Pushkin.

"At one of Zhukovsky’s soirees when speaking of his poem Ruslan and Lyudmila, Pushkin said that there was much he would like to change; I wanted him to tell me exactly what changes he would make, though his untimely death robbed me of the opportunity to do so," Mikhail Ivanovich Glinka recorded in his Notes. The composer began work on the opera in 1837, the libretto not yet being complete and the poet’s tragic death forcing him to turn to amateur poets from among his friends and acquaintances. Unlike the literary source material which was written with the irony and light humour of a young rake (Pushkin began the work when still a lyceum pupil and planned to rewrite it several times as a result), the opera is epic in character, monumental images of bylina Old Russian bogatyrs blended together with the fairytale oriental flavour of Chernomor’s kingdom, the abundance of crowd scenes setting off the protagonists’ famous arias which have become jewels in the treasure casket of Russian music, as has done the brilliant overture.

Casts & Credits

Composer: Mikhail Glinka
Choreography: Michel Fokine
Mezzo soprano: Yekaterina Krapivina
Mezzo soprano: Zlata Bulycheva
Costume Designer: Konstantin Korovin
Director: Irkin Gabitov
Lighting Designer: Vladimir Lukasevich
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Stage Director: Lotfi Mansouri
Composer: Mikhail Glinka
Choreography: Michel Fokine
Mezzo soprano: Yekaterina Krapivina
Mezzo soprano: Zlata Bulycheva
Costume Designer: Konstantin Korovin
Director: Irkin Gabitov
Lighting Designer: Vladimir Lukasevich
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Stage Director: Lotfi Mansouri