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=223) 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=223) 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<>223 AND tp.id_base=529 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<>223 AND tp.id_base=529 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





	,  - The Sleeping Beauty - P.Tchaikovsky (Ballet in two acts based on the fairy tales by Charles Perrault) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" , - The Sleeping Beauty - P.Tchaikovsky (Ballet in two acts based on the fairy tales by Charles Perrault)
Duration: 2 hours 40 minutes

From the simplicity and intimacy of the famous fairy tale on which it is based, the ballet opens out into a spectacle of grand virtuosity, generous and incomparable displays of technique, ravishing stagecraft and unapologetic theatrical ostentation. The Sleeping Beauty has long been considered an almost ideal instance of the integration of music and dance and it is arguably the greatest of the Tchaikovsky-Petipa collaborations. Its breadth of musical and choreographic vision, its incorporation of so many dance styles and traditions into one radiant whole and its combination of sophistication and accessibility make it a classical ballet nonpareil.

Choreographers: Marius Petipa, Nataliya Kasatkina, Vladimir Vasilyov
Set and Costume Designer: Elizaveta Dvorkina
The Orchestra of the Novaya Opera Theatre
Conductor: Valery Kritskov

 

The Kasatkina and Vasilyov State Academic Classical Ballet Theatre(Moscow Classical Ballet) 

The State Academic Theatre of Classical Ballet’s production of The Sleeping Beauty was premiered in Cannes (France), where the theatre toured as part of the Russian Arts Festival in August of 2004. A few days after the performance the French press bristled with exultant headlines extoling the producers and the cast of Sleeping Beauty: “…a fest of ballet”, “…triumph…”, “brilliant achievement…”, “Ekaterina Berezina is a perfect Princess Aurora…”, “Charming Berezina is an example of delicate grace and confident technique”.
Despite the great success in France, the Moscow premiere (in September 2004) was slightly updated. For instance, Kasatkina and Vasilyov added what they call “avant-garde” lighting, as well as scenery andmore than 50 costumes, which had not been ready for the premiere in Cannes because of lack of time. Suffice it to say that there were 300 costumes to be made for The Sleeping Beauty and some actors change costumes 5 or 6 times during the performance.
Like all other ballets staged by Natalia Kasatkina and Vladimir Vasilyov, The Sleeping Beauty can be regarded as an original production. Preserving all the classical masterpieces of Marius Petipa’s choreography, the producers filled the music with new action. Combination of two tales by Charles Perrault, Sleeping Beauty and The Beauty and the Beast, has made the plot more dynamic, intriguing and magical. For instance, in the old version of the production Princess Aurora and Prince Desire see each other for the first time, when Aurora awakes after Desire kisses her. Kasatkina and Vasilyov have made the Prince go through all many trials, turn into an exhausted old man and be on the verge of life and death. He does it all to resuscitate the Princess. But love, if it is true, is well worth it.The producers have also changed another old tradition – to give the part of the evil fairy Carabosse to a man. In Kasatkina and Vasilyov’s version the evil embodied in Carabosse is attractive and graceful, which makes it even more dangerous.
This ballet, which mingles sophisticated virtuosity and sublime sensuality, the fabulous fantasy of the producers and the elegant style of the classics, requires a special type of performers. And this, as the main part of the production’s success is spoken of by the leaders of the State Academic Theatre of Classical Ballet, Natalia Kasatkina and Vladimir Vasilyov: ”…Along with brilliant technique an actor has to be a personality; he has to work on every detail, not only using his body, but using his heart and head. This is the only way to make ballet stars. If actors do not have these qualities, any performance, and /The Sleeping Beauty in particular, becomes ceremonial, dull and cold, as if this castle of Terpsichore is inhabited by sleeping beauties.”/