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-21' AND tmp.date<='2024-06-10' AND tmp.perf_id=2758) 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-21' AND '2024-06-10' AND tmp.perf_id=2758) 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<>2758 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

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





	17 December 2019, 19:00 - "Christmas Ballet-gala" Christmas ballet concert with the stars of the world ballet - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow Kremlin Theatre of Classical Russian Ballet 17 December 2019, 19:00 - "Christmas Ballet-gala" Christmas ballet concert with the stars of the world ballet
17December
19:00
2019 | Tuesday
Classical ballet
Moscow Kremlin Theatre of Classical Russian Ballet, Moscow
Duration: 2 hours

On December 19, 2017, the stage of the State Kremlin Palace will see the Christmas gala concert of the stars of the world ballet.

This project has become the annual Christmas ballet celebration, a bright cultural event, the place to meet the international performers, the many-sided mirror reflecting creative interests and tendencies of international modern ballet art.

This most magical night of the year will gather the brightest world stars of the ballet on the stage, the best compositions of the 20th-21st centuries, directed by outstanding choreographers, with the Moscow premiere of the ballet of Ivan Vasilyev the Christmas Story, based on Charles Dickens story becoming the highlight of the program.

"Through the story of one person, we show what the simple values of life mean: love, friendship, mutual aid — Ivan Vasilyev says. — This character, Scrooge, has forgotten them, has turned into a walking calculator. And he is not alone, there are many fools around".

The choreographer knows and loves the story about the avaricious Mr. Scrooge who on the Christmas night is visited by three spirits of the past. "This story accompanied me since the childhood — the choreographer continues. — I knew it from beginning to end since I was little. For me, it is a very strong association with Christmas and the New Year".

Ivan chose the music for the performance himself: Tchaikovsky's plays from the Children's Album" and the Seasons cycle, fragments from symphonies. "It is similar to the birth of thought — Ivan Vasilyev argues. — Here it is, apparently, and it is necessary to find words to express it; and such words come as if on their own. The same goes for ballet: a music comes to which everything that I want to express is perfectly projected".

In his work Ivan Vasilyev relies on two allies: the sense of humor and the united team that is ready to support any of his undertakings. The ballet is conceived to be full of characters: the Christmas History will feature Irina Perren, Ivan Zaytsev, Marat Shemiunov, Veronika Ignatyeva, Valeria Zapasnikova, Anna Kuligina, Alexey Kuznetsov, who have worked together with Ivan through the experience of the first stagings and many other performers, whom the director has managed to inspire with the new plan. For the main part - that of Mr. Scrooge Ivan Vasilyev "has picked myself".

6,000 viewers will become witnesses of the unforgettable celebration of ballet.

Christmas Ballet Gala is the best gift on the eve of the New Year for all lovers of the world-class ballet!

The night is organized with the support of the International Center of ballet.