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=620) 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=620) 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<>620 AND tp.id_base=490 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<>620 AND tp.id_base=490 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





	,  - Cinderella - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

|
Classical ballet
Russian National Ballet Theatre, Moscow
Duration: 2 hours
World premiere: Theater "Russian Ballet", 2001

Neglected and mistreated by her step-family, poor Cinderella dreams of a better life. The magical appearance of her Fairy Godmother restores hope, and all her wishes are granted. Able to take her place amongst the ladies at Prince Charming’s ball, the Prince is enchanted with the beautiful girl. But when the magic fades at midnight and she flees, leaving behind only a slipper –will the Prince find his true love again? And can Cinderella find her happy ending? The enduring tale of Cinderella will delight audiences with the beauty and majesty of classical ballet wrapped in the promise of “happily ever after.”

Composer: Sergei Prokofiev

Orchestra: Symphony orchestra of the Summer Ballet Seasons

Classical Ballet in 2 acts

The ballet based of S.Perrot’s fairy-tale

Music experts say that “Cinderella” – is one of the best ballet scores of the XX-th century. Prokofiev wrote about the ballet: “For me it was very important, that “Cinderella” should become dancing, and all the dances came from the plot, were different; that dancers had a chance to show their skills in their most. I wrote “Cinderella” in old classic ballet traditions”.
The end of the war was the period of creating the ballet-tale. There is devastation and starvation. Prokofiev was in personal sorrow. He had lost his wife in a prisoner-camp. It was she, to whom he devoted his “Cinderella”. He wanted his hero to be a simple girl, searching her fortune; a real girl, who just managed. And she is the kind on the stage now.



Act One

 

Cinderella’s morning begins with sisters’ angry tricks and quarrels as usual. Only mice in the kitchen feel sorry for the girl, and her Father secretly from her Step-mother gives her wooden shoes. Her mother used to wear them. But peevish Step-mother doesn’t let her husband to spend time with his daughter. Only being alone, Cinderella sees a beggar at the fire-place. Where is she from? The girl feels sorry for the old woman and gives her shoes to her.
Cinderella’s sisters are getting ready for the ball. They try dresses, quarrelling and envying each other’s clothes. The quarrel is interrupted by the Ball Organizer. The sisters are bad at dancing lessons, but Cinderella repeats all exercises easily and with grace. It causes envy of Sisters and Step-mother’s anger. She demands her money for dancing lessons back from the Teacher.
Cinderella sees her Father for the ball and imagines herself a princess. Father catches the game and pretends being the prince. But her Step-mother appears and forces her husband to leave. Cinderella stays alone and cries.
Suddenly the kitchen is filled with strange light and the girl sees old beggar. Funny little people peep from the fire-place – they are dwarves. Old dress falls down from the woman – and Cinderella sees a miraculously wonderful Fairy. There are four more Fairies of the Season with a suite of dwarves-months with her. The Spring Fairy gives Cinderella a wonderful dress, made of golden and silver brocade, decorated with precious stones. The Summer Fairy turns mice and rats into brave postilion and a pair of fast horses. The Autumn Fairy turns a pumpkin into a gorgeous carriage, and the Winter Fairy gives Cinderella a diamond crown and a sparkling cloak. But the best present is made by the main Fairy – it is porcelain shoes. The girl recognizes the Christian Mother in her.
The Fairy warns Cinderella strictly, that she should return home before midnight. Otherwise her splendid dress will turn into and old dress again, horses will become mice, and the carriage – the pumpkin.

Act Two

Guests are gathering to the ball at the King’s palace. Noble princes from far off countries – Spain, China and Chukot – are among them.
There are a lot of beauties at the ball. But the one, who has entered the last, is the most charming. She has a gorgeous dress on, but it’s not the dress, that attracts everybody. It’s a strange girl herself. She radiates kindness and tenderness. Surely, it’s Cinderella.
All the guests are eager to dance with the beauty and give her rich presents.
The Prince suggests the girl his heart and sole. Beloved seem to fly into a magic garden – a permanently wonderful garden of the Seasons.
Suddenly the clock strikes twelve. The ball is over for Cinderella. She rushes from the palace, dropping a tiny shoe.
Even the Prince, who holds this tiny finding, can’t recognize his vanished beloved in a poorly dressed girl.

Act Three

The Prince does his best to find the beautiful stranger. But not a single shoe-maker can say what a skillful master has made this unusual porcelain shoe.
The Prince leaves for far off countries, hoping to find his beloved there. But one misfortune follows the other – the porcelain shoe is small both Spanish and Chinese princesses. And far off the Chukot prince suggests the Prince marring his bride – according to the ways of his country. He is so sorry for his friend! But the Prince needs the only girl in the world – the one, whom the shoe will match. The Prince makes up his mind to return home.
A porcelain shoe – it’s the only thing, left to Cinderella after the magic ball. In her dreams she dances again and she is happy again. Her Step-mother and sisters break her dreams.
Cinderella’s father doesn’t want to suffer his wife’s and her daughters’ cruelty. He makes an attempt to force the sister sweep the floor. A terrible quarrel seems to be inevitable. Suddenly the Prince with his suite appears at the door. He has been to dozens of houses, trying to find his bride. Now it’s the turn of Cinderella’s father.
The Step-mother and the sisters are out of their minds with the attempts to put on the shoe. The Step-mother is ready to shorten her foot. Trying to stop her, Cinderella drops the other porcelain shoe. The Prince sees his beloved.
And than the merriest and the most gorgeous wedding was held!

Casts & Credits

Artistic Director: Evgeny Amosov
Artistic Director: Vladimir Moiseyev
Artistic Director: Evgeny Amosov
Artistic Director: Vladimir Moiseyev