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=1595) 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=1595) 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<>1595 AND tp.id_base=-1 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<>1595 AND tp.id_base=-1 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





	4 January 2019, 19:00 - Pyotr Tchaikovsky "A Christmas Carol" ballet in two acts after the novella by Charles Dickens. Choreography Ivan Vasiliev - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Hermitage Theatre 4 January 2019, 19:00 - Pyotr Tchaikovsky "A Christmas Carol" ballet in two acts after the novella by Charles Dickens. Choreography Ivan Vasiliev
4January
19:00
2019 | Friday
Ballet in two acts after the novella by Charles DickensA Christmas Carol in Prose, Being a Ghost-Story of Christmasset to music by Pyotr Tchaikovsky
CREDITS
Choreography: Ivan Vasiliev
Stage and Costume Design: Alexandra Leonidova
Principal Repetiteur: Elvira Khabibullina
Repetiteur: Mikhail Sivakov

 

Ivan Vasiliev, inspired by the success of his first choreographic works, is to stage a full scale ballet. A Christmas Carol, based on Charles Dickens’ novella of the same name, will premiere at the Hermitage Theatre on 31 December. “Through the story of one man, we reveal the meaning of the simple values in life — love, friendship, and helping one another,” explains Ivan Vasiliev. “My protagonist, Scrooge, has forgotten what these things mean: he’s erased them from his life, and turned into a money-counting machine. And he’s not the only one — there are plenty as foolish as him.”

The choreographer knows and loves the story of the miserly Mr. Scrooge, who is visited on Christmas Eve by three ghosts. “This story has been part of my life since childhood,” he says. “I have known it from start to finish since I was small. I associate this story very strongly with Christmas and New Year.”

Ivan chose the music for the production himself. And his composer of choice was Tchaikovsky: pieces from The Children’s Album and The Seasons, and fragments from the symphonies. “It’s like the way that ideas come about,” says Ivan Vasiliev. “The idea is there, seemingly, but you need to find the right words to express it; and then the words come, and it’s as if they’ve appeared out of nowhere. The same with this ballet: I found the kind of music which reflects perfectly everything I would like to convey.”

Ivan Vasiliev relies on two allies in his work — a sense of humour and a close-knit team ready to support his every endeavour. The ballet has a large cast: Irina Perren, Ivan Zaytsev, Marat Shemiunov, Veronika Ignatyeva, Valeria Zapasnikova, Anna Kuligina, and Alexey Kuznetsov, who have all worked with Ivan on his first ballets, will appear in A Christmas Carol, together with many others whom Vasiliev has inspired with this new concept. Ivan Vasiliev has “confirmed himself” in the main role of Scrooge.

Casts & Credits

Choreography: Ivan Vasiliev
Choreography: Ivan Vasiliev