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=58) 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=58) 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<>58 AND tp.id_base=1166 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<>58 AND tp.id_base=1166 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





	25 March 2018, 13:00 - Chipollino. Ballet in 2 Acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 25 March 2018, 13:00 - Chipollino. Ballet in 2 Acts
25March
13:00
2018 | Sunday
Classical ballet
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours 5 minutes
World premiere: Mikhailovsky Theater, 15 декабря 15 2007

Libretto by Gennady Rykhlov after the fairy-tale by Gianni Rodari
Choreography: Genrikh Mayorov

Stage and Costume Designer: Valery Levental
Lighting Design: Mikhail Mekler
Assistant Choreographer: Anna Mayorova
Répétiteurs: Evgenia Kostyleva, Tatiana Legat, Natalia Tsyplakova, Evgeny Popov, Mikhail Sivakov 

This ballet enchants you from its very first minute. The harmony of the melodic and ear-catching music by Karen Khachaturian, bright sets and costumes by Valery Levental and vivid choreography by Genrikh Mayorov, perfect both for children and for grown-ups, made it a real blockbuster. The fairy-tale story by Italian author Gianni Rodari tells of the adventures of the Little Onion boy (in Italian, Cipollino), who fights the unjust treatment of his fellow vegetable folk (his little girlfriend Radish, old Mr Pumpkin, handyman Master Grape) by the fruit ‘aristocracy’ (foppish Prince Lemon, martinet Signor Tomato and twin Countesses Cherries). Even though the ballet was created especially for young people, it never lacks ‘serious’ choreography of classical ballet. The principal dancers of the Mikhailovsky Ballet really enjoy themselves turning from Siegfrieds and Odettes into ‘vegetables’ and ‘fruits’. The rhythms of dance, the portrayal and humour of the characters, and the exceptional performances will keep everyone enthralled. 

Synopsis

Act I

A square in a fairytale town. It seems there are only vegetable baskets and fruit cases. But in fact those are big and small houses where fruits and vegetables live. And all the fruits and vegetables resemble people so much.

The family of the Radishes meet the family of the Onions. Mother Cipolla and father Cipollone are trying to cope with naughty Cipollino who is tired of nursing his little sister Cipolletta. Master Grape is mending shoes. Mister Pumpkin is looking for some bricks to build a house for himself. Professor Pear is playing the violin and all the citizens of the town are dancing. Suddenly Signor Tomato appears on the square and announces the visit of Prince Lemon who’d like to talk to his citizens. Prince Lemon has just issued a new law: the sunshine, the wind blow, and the rain must be paid for. Vegetables and fruits are indignant.

In the stampede Cipollino has inadvertently stepped on Lemon’s foot. The guards are outraged: Prince Lemon has been insulted. The ‘rebel’ must be punished. But Cipollino has vanished and the guards arrest his father, the old Cipollone.

The Onions are grieving. But other families have problems too. Mister Pumpkin on his own cannot build a house. All the citizens united by Cipollino are helping him. No sooner than the house has been built, Signor Tomato appears. He’s nearly bursting with anger: the Pumpkin’s house has been built on the land of Countesses Cherries. It’s private property and nobody can use it. The Guard of Prince Lemon destroy the house. The poor old Pumpkin is desperate. Cipollino sets for revenge.

Act II

Cipollino and his friend little Radish are going to the palace to find the place where old Cipollone is kept. On the way they meet young Count Cherry who is very lonely in the palace. Cipollino, Radish, and Cherry make friends. Trying to find the imprisoned Cipollone they are nearly caught by Signor Tomato but manage to escape. The Countesses Cherries are throwing a feast in honour of Prince Lemon. While everybody is busy dancing the friends manage to set Cipollone free.

Lemon’s Guard and the police are looking for the runaways. Cipollino hides his father and Radish but gets arrested.

In the gardens of the palace Count Cherry meet Magnolia. Together they find Cipollino incarcerated. Magnolia with her fragrance sends the guards to sleep; Count Cherry ties them up and sets Cipollino free.

Prince Lemon comes to the prison to punish the ‘rebel’ but finds only the guards tied up.

The enraged Prince orders to fire the cannon into the townsfolk but Cipollino and his friends manage to push the Prince into the cannon. When the smoke rolls away there is no Prince Lemon, no cannon, and no guards. From now on everybody will happily live in the fairytale town. There will be a new town under the clear blue sky — a town of friends! 

Casts & Credits

Composer: Andrey Petrov
Choreography: Genrikh Mayorov
Ballet company: Mikhailovsky Ballet
Dancer: Ella Persson
Dancer: Ivan Zayzev