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=56) 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=56) 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<>56 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

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<>56 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





	19 January 2019, 12:00 - Cinderella (Opera in 2 Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 19 January 2019, 12:00 - Cinderella (Opera in 2 Acts)
19January
12:00
2019 | Saturday
Opera
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours
World premiere: Mikhailovsky Theater, 30 December 1999

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.”

Opera in 2 Acts with 1 interval (20 min).

Libretto by Olga Mukhortova after the screenplay by Evgeny Schwarz and the fairy-tale by Charles Perrault
Orchestrated by Vladislav Uspensky 

Stage Director: Olga Mukhortova
Stage Designer: Vyacheslav Okunev
Lighting Designer: Mikhail Mekler
Costume Technology: Alla Marusina
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Director: Vyacheslav Kalyuzhny
Principal Pianist: Maria Mikirtumova
Chorus Masters: Alexey Dmitriev, Sergey Tsyplenkov
Choreography: Maria Bolshakova, Evgeny Myasishchev Stage Manager: Olga Kokh 

An opera for children written by Boris Asafiev in 1906, and staged in the style of the renowned Soviet film of the same name, which was released in 1947. It is a marvellous, magical tale in which the heroine, with the help of a fairy, turns into a princess overnight and finds herself at the royal ball. The opera brings warm smiles to the faces of adults, while it fills children with excitement and joy, and teaches them empathy and compassion. Based on the story by Charles Perrault and the screenplay by Evgeny Schwartz, the opera is a wonderful first introduction to musical theatre, in which the music complements the dance and the spoken dialogue.

SYNOPSIS

Act I

Scene 1
Cinderella’s stepmother and stepsisters are getting ready for the ball thrown by the King of the fairy kingdom. Cinderella is cleaning the house and dreaming to see the ball — at least through the window of the palace. Cinderella’s stepsisters Anna and Mariana are laughing at her. They discuss who is more beautiful of the two and who will be chosen by the Prince to become his wife.
Cinderella has sewn ball gowns for her stepmother and stepsisters. She helps them get ready for the ball. The King’s corporal arrives to invite everybody to the ball. The stepmother and stepsisters leave, Cinderella stays alone.

Scene 2
Cinderella’s god mother, a Fairy, brings her to the fairy wood. The Fairy wants to reward Cinderella for her kindness and patience. She turns Cinderella’s old dress into a wonderful ball gown, makes a carriage from a pumpkin and gives Cinderella magic shoes.
Cinderella’s dream has come true — she’s going to the ball. The only thing is that she must leave the palace at midnight, at the time when the magic things will lose its power.

Scene 3
The ball at the palace. The King greets his guests. Cinderella arrives. Everybody is enchanted by the unknown beauty. The Prince falls in love with her. The Kind Magician sends them together to a magic country. The Prince tells Cinderella of his love.
The clock is striking midnight. Cinderella runs away leaving a shoe in a hurry. The Kings suggests that they should find her using the shoe: if the shoe fits a girl, the girl will become the Prince’s fiancée. The corporal and soldiers hurry to execute the order.

Act II

Scene 4
Cinderella is going sticking in the wood. She recollects meeting the Prince. The Prince who is looking for his beloved appears in the wood. Cinderella hides from him.

Scene 5
Cinderella’s stepmother and stepsisters dream of the future wedding. The woman is sure that the Prince will marry one of her daughters.
The corporal appears. He announces the King’s order. Anna and Marianna try the shoe on but it doesn’t fit. Stepmother begs Cinderella to help Anna and with Cinderella’s help the shoe fits.

Scene 6
Everybody in the palace is waiting for the Prince’s fiancée. When triumphant stepmother brings Anna to the palace the King is at a loss. Marquis Pasdetrois invites everybody to dance. While Anna is dancing the shoe slips off her foot.
Suddenly the Fairy and Cinderella arrive. The King recognizes the mysterious guest who enchanted everybody in the palace. Cinderella’s stepmother and sisters laugh at her but Marquis Pasdetrois puts the shoe on Cinderella’s foot and her dress transforms into a marvelous ball gown.
The Kind Magician brings the Prince back from faraway where he tried to find Cinderella. At last the Prince and Cinderella are together.

Casts & Credits

Composer: Boris Asafiev
Opera company: Mikhailovsky Opera
Principal Chorus Master: Alexandr Chernov
Production: Olga Mukhortova
Set Designer: Vyacheslav Okunev
Composer: Boris Asafiev
Opera company: Mikhailovsky Opera
Principal Chorus Master: Alexandr Chernov
Production: Olga Mukhortova
Set Designer: Vyacheslav Okunev