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-23' AND tmp.date<='2024-05-13' AND tmp.perf_id=12) 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-23' AND '2024-05-13' AND tmp.perf_id=12) 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<>12 AND tp.id_base=520 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<>12 AND tp.id_base=520 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





	28 April 2019, 12:00 - Ludwig Minkus "La Bayadere" (ballet in 3 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 28 April 2019, 12:00 - Ludwig Minkus "La Bayadere" (ballet in 3 acts)
28April
12:00
2019 | Sunday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 2 hours 55 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, February 10, 1941

La Bayadere, the treasure of the Russian Classical Ballet ballet, form the basis of the ballet repertoire of the Mariinsky Theater together with the Swan Lake: more than a hundred years ago, they were choreographed by Marius Petipa and are considered to be a hallmark of the Mariinsky Ballet. These classical masterpiece were performed almost uncountable number of times at the Mariinsky Theatre and in the course of numerous tours.

Music: Ludwig Minkus
Choreography: Marius Petipa (1877)
Revised choreography: Vladimir Ponomarev and Vakhtang Chabukiani (1941)
Libretto: Marius Petipa, Sergei Khudekov

Set design: Mikhail Shishliannikov (after set designs by Adolf Kvapp, Konstantin Ivanov, Pyotr Lambin and Orest Allegri (for the Mariinsky Theatre 1900 production))
Costumes: Yevgeny Ponomarev (for the production of 1900 in the Mariinsky Theatre)

Premiere: 1877, Bolshoi Theatre, St Petersburg

Synopsis

Set in the Royal India of the past, La Bayadиre is a story of eternal love, mystery, fate, vengeance, and justice. The ballet relates the drama of a temple dancer (bayadиre), Nikiya, who is loved by Solor, a noble warrior. She is also loved by the High Brahmin, but does not love him in return, as she does Solor.

Act I
Scene I
Outside Temple in the Sacred Forest:
The High Brahmin, priests, and temple dancers are celebrating the Indian Ritual of Fire. Nikiya, the most beautiful of the bayadиres, has been chosen to be consecrated the lead temple dancer. The High Brahmin declares his love for Nikiya, but is rejected by her. Nikiya meets secretly with Solor later than evening. They dance together and swear eternal love over the Sacred Fire, but are discovered by the jealous High Brahmin, who vows to kill Solor.

Scene II
A Room in the Palace:
The Rajah has decided to reward Solor’s valor and decrees that the warrior will marry his daughter, Gamzatti. Gamzatti falls in love with Solor’s portrait, and when they meet, he is overwhelmed by her beauty. Even though he has sworn eternal love to Nikiya, he cannot defy the wishes of the Rajah and agrees to marry Gamzatti. The High Brahmin informs the Rajah of Nikiya and Solor’s secret love, hoping that the Rajah will do away with Solor. Instead, the Rajah decides to kill Nikiya. The conversation is overhead by Gamzatti, who summons Nikiya to her rooms and attempts to bribe Nikiya to give up Solor. Refusing, Nikiya frantically attempts to kill Gamzatti. Nikiya flees and Gamzatti swears to destroy her.

Scene III
The Garden of the Palace:
At the betrothal of Solor and Gamzatti, Nikiya is commanded to dance. Gamzatti presents her with a basket of flowers which Nikiya believes to be from Solor, and which conceals a deadly snake. Nikiya is bitten, and when Solor leaves with Gamzatti, she refuses the proffered antidote and dies.

Act II
The Tent of Solor:
Solor, grief stricken and under the influence of opium, dreams of being reunited with Nikiya in the Kingdom of the Shades. Awakening, he realizes that he must prepare to marry Gamzatti.

Act III
The Temple:
The vision of Nikiya remains with Solor as the wedding ceremony begins at the Sacred Temple. As Solor and Gamzatti say their vows and are blessed by the High Brahmin, the vengeance of the gods is unleashed, and the temple and all the celebrants are destroyed. Nikiya and Solor are once again united in eternal love.


 

Casts & Credits

Composer: Andrey Petrov
Composer: Ludwig Minkus
Choreography: Marius Petipa
Choreography: Konstantin Sergeyev
Choreography: Vakhtang Chabukiani
Choreography: Vladimir Ponomarev
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Gavriel Heine
Costume Designer: Yevgeny Ponomarev
Composer: Andrey Petrov
Composer: Ludwig Minkus
Choreography: Marius Petipa
Choreography: Konstantin Sergeyev
Choreography: Vakhtang Chabukiani
Choreography: Vladimir Ponomarev
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Gavriel Heine
Costume Designer: Yevgeny Ponomarev