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=1065) 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=1065) 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<>1065 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<>1065 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





	2 December 2018, 14:00 - Nino Rota "Aladino e la lampada magica" Opera in 3 acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre 2 December 2018, 14:00 - Nino Rota "Aladino e la lampada magica" Opera in 3 acts
2December
14:00
2018 | Sunday
Opera
Stanislavsky theatre, Moscow
Duration: 2 hours 20 minutes
World premiere: The Stanislavsky and Nemirovich-Danchenko Moscow Academic Music Theatre, 02 October 2015

Music  Nino Rota
Libretto  Vinci Verginelli (russian text by Dmitry Abaulin)
Music Director and Conductor  Vyacheslav Volich
Stage Director  Lyudmila Naletova
Set Designer  Semyon Pastukh
Costume Designer  Galina Solovyova
Lighting Designer  Damir Ismagilov
Chorus Master  Alexander Rybnov
The score has been made available by Schott Music

World premiere: January 14, 1968
The Teatro di San Carlo, Naples

Russian premiere: October 2, 2015
The Stanislavsky and Nemirovich-Danchenko 
Moscow Academic Music Theatre
Overview

"The Magic Lamp of Aladdin" was written by the outstanding italian composer of the XX century Nino Rota. His name is particularly well-known to cinema fans because of his film scores, notably for the films of Federico Fellini, Luchino Visconti, Franco Zeffirelli and Francis Ford Coppola.

Alongside this great body of film work, Nino Rota composed several operas and dozens of other orchestral, choral and chamber works. The children's opera "The Magic Lamp of Aladdin" is one of his most popular works, based on the well-known story from the "Thousand and One Nights". 

A fascinating story, vivid and colorful music make the opera "The Magic Lamp of Aladdin" an excellent choice for introducing young audiences to opera.

Сast
Music Director and Conductor 
Vyacheslav Volich
Aladdin 
Chingis Ayusheev
Sergey Nikolaev
Artem Safronov
Magician Magrebbin 
Denis Makarov
Roman Ulybin
Princess Badr-al-Budur 
Evgenia Afanasieva
Lilia Gaisina
Maria Makeeva
Daria Terekhova
Mother of Aladdin 
Natalia Vladimirskaya
Irina Chistyakova
Natalia Zimina
The Sultan 
Felix Kudryavtsev
Maxim Osokin
Leonid Zimnenko
The Jinn of the Ring 
Andrey Baturkin
Dmitry Kondratkov
Ilya Pavlov