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=91) 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=91) 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<>91 AND tp.id_base=767 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<>91 AND tp.id_base=767 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 May 2019, 19:00 - Felix Mendelssohn -Bartholdy "A midsummer night`s dream" (ballet in 2 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 19 May 2019, 19:00 - Felix Mendelssohn -Bartholdy "A midsummer night`s dream" (ballet in 2 acts)
19May
19:00
2019 | Sunday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 2 hours 15 minutes
World premiere: Mariinsky Theatre, 6 June 2012

Music by Felix Mendelssohn-Bartholdy
Choreography by George Balanchine (1962)
Staging by Sandra Jennings
Production Design by Luisa Spinatelli
Lighting Design by Sergei Lukin

World premiere: 17 January 1962, New York City Ballet
Premiere at the Mariinsky Theatre: 06 June 2012


A Midsummer Night’s Dream
This work by the outstanding American choreographer George Balanchine was christened by critics as “a dream about Russian ballet.” That is, in fact, what it is; George Balanchine, once called Georgy Melitonovich Balanchivadze, the son of a Georgian composer and graduate of the St Petersburg Conservatoire, never forgot his childhood in St Petersburg, which he spent at the Imperial Theatre School and at the Imperial Mariinsky Theatre. These memories run vibrantly through all of his art and provide a strong and stable foundation for his artistic innovations and new choreographic language that became the essence of 20th century ballet.
But Balanchine was no trumpeter of nostalgia. He was a modernist to his very fingertips, and it is rejoicing, not sadness, that is connected with imagery of his childhood in St Petersburg and the imperial ballet. Neither is it illustra tive images but rather classical forms moulded into new tempi and ultra-contemporary rhythms, the architectonics of spatial structures that refer back to both the ballet ensembles of Petipa and the architectural ensembles of Rossi. It is these kinds of reminiscences about St Petersburg that flow through Diamonds, Symphony in C, Ballet Imperial (Piano Concerto No 2), Theme and Variations and many more of Balanchine’s works besides.
But how was it that A Midsummer Night’s Dream, a Shakespearian tale, also came to be associated with St Petersburg in his mind? It’s all very simple. In his childhood years, as a pupil at the Theatre School George appeared in many performances of the Imperial Theatres, one of which was Shakespeare’s A Midsummer Night’s Dream to music by Felix Mendelssohn at the Mikhailovsky Theatre. That was in 1917 and he performed the role of an elf; soon that era collapsed and vanished, ushering in the utterly different, mad and constructivist 20s – Balanchivadze was actively involved in the culture of the time until he fled Soviet Russia in 1924.
In 1958, now the great Balanchine – the founder of American ballet in particular and ballet neo-classicism as a whole – was asked to stage the dance entrances of the fairies and the elves in a production of A Midsummer Night’s Dream for the Shakespeare Festival in Stratford staged by Jack Landau. (Apropos, one of the founders of the festival was none other than Lincoln Kirstein, who in 1934 had the life-changing idea of inviting specifically a Russian from among the countless Russian dancers wandering around Europe to work at the School of American Ballet that he dreamed of: a former member of Diaghilev’s company and, at that point in history, the director of a small company in Paris with the provocatively temporary name of Les Ballets 1933. That Russian was George Balanchine.)
The music in the 1958 production was not by Mendelssohn but rather that of Marc Blitzstein, a man of Brechtian character, the author of the musical The Cradle Will Rock and the translator of the texts for Die Dreigroschenoper (The Threepenny Opera) , though working on Shakespeare’s play, one way or another, must have reminded Balanchine of St Petersburg. In any case, some time later (1962) he staged his own A Midsummer Night’s Dream to music by Mendelssohn, a ballet that was totally atypical for him: it had a plot, there were two acts, it had costumes, sets and numerous characters (his typical ballets were plot-less, in one act and conceptually performed in rehearsal clothes with the action being portrayed not by characters but by dancers, like the voices of a choreographic score).
The Dream was to be what was Balanchine’s only work in which references to the forms of St Petersburg ballet performances from his childhood years would appear so directly. Not the stylisation, of course – that never interested him at all, it was those latent rhythms of American urban culture, the contemporary speeds which run through all of the mature Balanchine’s new classicism, mixing and merging with bewitching lentos. Yet, at the same time, there are those very same ancient forms, those very same artistic collisions which, it would seem, Balanchine had abandoned once and for all: pantomime as the antithesis of dance, the grotesque as the antithesis of classicism and, indeed, the very image of a ballet dream that formed the core of almost every single work by Petipa. Only with Petipa the dreams, governed by pure classicism, were expressed in the choreographic “drama” with its indispensable plot and dramatic effect, shaking off its “reality” for the sake of the triumph of dance; while here the lightly stirring plot is as if asked by Balanchine to visit the choreographic world of new classicism where it was dance that had long since become the selfsufficient content, meaning and language of ballet.
Inna Sklyarevskaya