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=256) 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=256) 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<>256 AND tp.id_base=506 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<>256 AND tp.id_base=506 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 February 2019, 14:00 - George Balanchine "Jewels" (ballet in three parts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 17 February 2019, 14:00 - George Balanchine "Jewels" (ballet in three parts)
17February
14:00
2019 | Sunday
Classical ballet
Bolshoi theatre - Historic Stage, Moscow
Duration: 2 hour 30 minutes
World premiere: New York City Ballet, New York State Theater, 5 May 2012

Jewels is unique: a full-length, three-act plotless ballet that uses the music of three very different composers. Balanchine was inspired by the artistry of jewelry designer Claude Arpels, and chose music revealing the essence of each jewel. He explained: “Of course, I have always liked jewels; after all, I am an Oriental, from Georgia in the Caucasus. I like the color of gems, the beauty of stones, and it was wonderful to see how our costume workshop, under Karinska’s direction, came so close to the quality of real stones (which were of course too heavy for the dancers to wear!).” Each section of the ballet is distinct in both music and mood. Emeralds, which Balanchine considered “an evocation of France — the France of elegance, comfort, dress, perfume,” recalls the 19th century dances of the French Romantics. Rubies is crisp and witty, epitomizing the collaboration of Stravinsky and Balanchine. Diamonds recalls the order and grandeur of Imperial Russia and the Maryinsky Theater, where Balanchine was trained. Mary Clarke and Clement Crisp have written: “If the entire imperial Russian inheritance of ballet were lost, Diamonds would still tell us of its essence.”
Ballet in three parts
Music by Gabriel Faure, Igor Stravinsky, Peter Tchaikovsky
Choreography by George Balanchine (1967)


Music: Gabriel Faure, Igor Stravinsky, Pyotr Tchaikovsky
Choreography: George Balanchine (1967)

I. Emeralds
Music: Gabriel Faure from Pelleas et Melisande (1898) and Shylock (1889)

II. Rubies
Music: Igor Stravinsky (Capriccio for Piano and Orchestra, 1929)

III. Diamonds
Music: Pyotr Tchaikovsky from Symphony No. 3 in D Major, 1875 (first movement omitted)

Staging: Karin von Aroldingen, Sarah Leland, Elyse Borne and Sean Lavery
Scenery: Peter Harvey (1967)
Costumes: Karinska (1967)
Recreations of costumes supervised: Holly Hines
Original lighting: Ronald Bates
Lighting: Perry Silvey

World premiere: 13 April 1967, New York City Ballet, New York State Theater
Premiere at the Mariinsky Theatre: 30 October 1999, St Petersburg

Casts & Credits

Composer: Gabriel Faure
Composer: Igor Stravinsky
Choreography: George Balanchine
Ballet company: Bolshoi Ballet
Costume Designer: Yelena Zaytseva
Musical Director: Pavel Sorokin
Set Designer: Alyona Pikalova
Composer: Gabriel Faure
Composer: Igor Stravinsky
Choreography: George Balanchine
Ballet company: Bolshoi Ballet
Costume Designer: Yelena Zaytseva
Musical Director: Pavel Sorokin
Set Designer: Alyona Pikalova