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=84) 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=84) 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<>84 AND tp.id_base=512 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<>84 AND tp.id_base=512 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





	2 December 2018, 19:00 - Giuseppe Verdi "Aida" (opera in four acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 2 December 2018, 19:00 - Giuseppe Verdi "Aida" (opera in four acts)
2December
19:00
2018 | Sunday
Opera
Mariinsky Theater, Saint Petersburg
Duration: 4 hours 05 minutes
World premiere: Mariinsky Theatre, St Petersburg, 1 April 1877

This grandest of grand operas features an epic backdrop for what is in essence an intimate love story. Set in ancient Egypt and packed with magnificent choruses, complex ensembles, and elaborate ballets, Aida never loses sight of its three protagonists: Amneris, the proud daughter of the pharaoh; her slave, Aida, who is the princess of the rival kingdom of Ethiopia; and Radamès, the Egyptian warrior they both love. Few operas have matched Aida in its exploration of the conflict of private emotion and public duty, and perhaps no other has remained to the present day so unanimously appreciated by audiences and critics alike.

Music: Giuseppe Verdi
Production by Alexei Stepaniuk

Libretto by Antonio Ghislanzoni

Performed in Italian

Musical Director: Valery Gergiev
Stage Director: : Alexei Stepanyuk
Set Designer: Pyotr Schildknekht
Set Revival Director and Costume Designer: Vyacheslav Okunev
Principal Chorus Master: Andrei Petrenko
Musical Preparation: Irina Soboleva

Premiere: 24 December 1871, Opera House, Cairo;
Premiere at the Mariinsky Theatre: 1 April 1877, St Petersburg;
Premiere of this production: 30 December 1998, Mariinsky Theatre, St Petersburg

The Performance has three intermissions

Casts & Credits

Composer: Giuseppe Verdi
Choreography: Georgy Aleksidze
Choreography: Igor Belsky
Conductor: Andrei Petrenko
Mezzo soprano: Natalia Yevstafieva
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Set Designer: Pyotr Schildknekht
Set Designer: Vyacheslav Okunev
Set Revival Director: Vyacheslav Okunev
Stage Director: Alexei Stepanyuk
Stage Director: Alexei Stepanyuk
Composer: Giuseppe Verdi
Choreography: Georgy Aleksidze
Choreography: Igor Belsky
Conductor: Andrei Petrenko
Mezzo soprano: Natalia Yevstafieva
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Set Designer: Pyotr Schildknekht
Set Designer: Vyacheslav Okunev
Set Revival Director: Vyacheslav Okunev
Stage Director: Alexei Stepanyuk
Stage Director: Alexei Stepanyuk