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-05-15' AND tmp.date<='2024-06-04' AND tmp.perf_id=2612) 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-05-15' AND '2024-06-04' AND tmp.perf_id=2612) 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<>2612 AND tp.id_base=2729 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<>2612 AND tp.id_base=2729 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





	,  - Pyotr Tchaikovsky "The Sleeping Beauty" (ballet in 2 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Russian National Ballet Theatre , - Pyotr Tchaikovsky "The Sleeping Beauty" (ballet in 2 acts)
|
Classical ballet
Russian National Ballet Theatre, Moscow
Duration: 2 hours 10 minutes

Works by Pyotr Tchaikovsky (1840–1893) were an important milestone in the history and development of ballet. Essentially, it was Tchaikovsky who made ballet a fully-fledged musical and drama genre and released music from its role as illustration to choreography. The composer worked mostly in the rigid frame of ballet dramaturgy. The music of all his ballets is adaptive, choreographic, objective and, at the same time, it has the power of generalization that gives symphonic features to a theatrical piece.

The fairy tale about Sleeping Beauty is known in several adaptations. Two of them became classics – by the Brothers Grimm and by Charles Perrault. Tchaikovsky’s ballet was written to a libretto by Ivan Vsevolozhsky and the great choreographer Marius Petipa based on Perrault’s version. The premiere took place in 1890 at the Mariinsky Theatre. An abundance of splendid character dances, complete music characteristics of the protagonists and the beauty of each number blend in The Sleeping Beauty with the wonderful quality that the prominent musicologist and composer Boris Asafiev called “wholeness of music-and-choreographic performance”.

The Russian Classical Ballet offers the Petipa version adapted by Valentin Grischenko.

“Talent and loyalty to the classical traditions of Russian ballet” is the artistic motto of the company. Its main goal is twofold: on the one hand the company seeks to preserve the classical traditions of Russian ballet and, on the other hand, it looks for new, more contemporary forms of the choreographic art and explores new directions and possibilities of choreography.

The basis of the company's repertoire includes masterpieces of classical ballet such as Adam’s Giselle, Prokofiev’s Romeo and Juliet and Cinderella, Minkus’ Don Quixote, Bizet-Shchedrin’s Suite Carmen to mention but a few. A special page of the repertoire is Tchaikovsky’s three

ballets – Swan Lake, The Nutcracker and The Sleeping Beauty.

Today the company has over 40 ballet dancers. They are graduates of the best choreographic schools in Russia and the former USSR, namely in Moscow, Leningrad-St. Petersburg, Perm, Novosibirsk, Kiev to mention a few.

The artistic director of the company, Valentin Grischenko believes that ballet is not just a show, but an art demanding special sensitivity from both the performer and the spectator. In preserving the traditions of Russian classical ballet, the theatre makes a contribution to the development of this art all over the world.