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=2248) 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=2248) 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<>2248 AND tp.id_base=2591 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<>2248 AND tp.id_base=2591 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





	11 July 2018, 19:00 - La bayadere - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Russian National Ballet Theatre 11 July 2018, 19:00 - La bayadere
11July
19:00
2018 | Wednesday
Classical ballet
Russian National Ballet Theatre, Moscow
Duration: 3 hours

Bayaderek called Indian girls who served as dancers in temples, where they were given by parents because they were unloved and unwanted. There are various versions that explain why the idea arose for creating a performance on a plot exotic for Russia at that time. For certain it is not known, therefore disputes between historians of theater are conducted till now.The idea of ​​creating "La Bayadere" belongs to the main choreographer of the Russian Imperial troupe - Marius Petipa. According to one of the versions, he decided to stage such a performance in Russia under the influence of the French ballet "Shakuntala", the creator of which was his elder brother Lucien. The author of the music for the French production was Ernest Reyer, the author of the libretto, based on the ancient Indian drama of Kalidasty, - Theophile Gautier. The prototype of the main character was Amani - a dancer, a prima of the Indian troupe, touring Europe, which committed suicide. Gaultier decided to stage a ballet in memory of her. But there is no evidence that this is really so. Therefore, it can not be said that the "La Bayadere" (ballet) was born under the influence of the "Shakuntala". Its content is very different from the plot of the Parisian production. In addition, Petip Jr.'s ballet appeared on the Russian stage only 20 years after the production in Paris. There is another version of the emergence of Marius Petipa's idea of ​​creating "La Bayadere" - a fashion for the eastern (in particular, Indian) culture. The author of the music was an Austrian of Czech descent, who served with the Russian Emperor, composer, violinist and conductor - Ludwig Minkus. "La Bayadere" became one of the most famous of his works.

Libretto by: Marius Petipa and Sergei Khudekov
Music: Ludwig Minkus
Choreographer: Marius Petipa

Of course, many of the creative personality the positivist of the NINETEENTH century were inclined to mysticism, had an irresistible need for knowledge of the occult Sciences, but whose native land was considered the East. It is unlikely that it belonged to Petipa, most likely unwittingly created in “La Bayadere” their “metaphysics”, his “white East”. The act of shadows (and Ivanovskie Swan) is a ballet for the ages. In the valley among the Himalaya descends to the dance of the shadows (a shadow in romantic tradition — soul). Dancers in white tunica with hoops on their heads, which, as the owner, attached to imitating wings white air scarves. (Variation with scarf dancing and the main character — Nikiya.)

Endless prayer or Eastern melody is reminiscent of their almost meditative course. A symbolic “snake” they descend from the heavenly world, and then arranged in a rectangle — a sign of land. Eloquently and quantity of shadows: the premiere in the Bolshoi Stone theatre was their 64 (a perfect square! ), later at the Mariinsky — 32. These magic numbers will continue to meet in classical ballet — the thirty two swans in Swan lake, sixty-four snowflakes in the Nutcracker. Shadow dance is hypnotizing, always immersing the audience in a state of unconsciously-enthusiastic contemplation of beauty. In passing the act draws a process of spiritual enlightenment Solor. It begins as a lyrical Nocturne-the memory of “beloved shadow”, and ends with a jubilant Coda “together forever”.

Composer: Ludwig Minkus
Composer: Ludwig Minkus