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=2222) 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=2222) 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<>2222 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<>2222 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





	27 January 2019, 13:00 - Dmitry Shostakovich "The Young Lady and the Hooligan" - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 27 January 2019, 13:00 - Dmitry Shostakovich "The Young Lady and the Hooligan"
27January
13:00
2019 | Sunday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 45 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, May 30, 2001

Music: Dmitry Shostakovich
Choreography: Konstantin Boyarsky (1962)
Libretto: Alexander Belinsky based on the play: Vladimir Mayakovsky
Set design: Vyacheslav Okunev after Valery Dorrer
Costume design: Tatiana Noginova
Lighting design: Vladimir Lukasevich

 

World premiere: 28 December, 1962, Maly Opera Theatre, Leningrad
Premiere of the reconstructed version: 30 May, 2001, Mariinsky Theatre, St Petersburg

ABOUT THE PRODUCTION

This ballet is something of an "adopted child" at the Mariinsky Theatre: created in 1962 at Leningrad's Maly Opera and Ballet Theatre and having been performed at numerous theatres in the Soviet Union, it was only in 2001 that it entered the Mariinsky Theatre's repertoire. The pre-history of this once incredibly popular production about post-revolutionary hard times is as follows; in 1918 Russian cinemas screened the art film The Young Lady and the Hooligan, staged after a scenario by Vladimir Mayakovsky. The plot was based on Italian writer Edmondo De Amicis' story La maestrina degli operai (The Workers' Young Schoolmistress). The protagonist is the Hooligan as depicted by Mayakovsky, who sees the new schoolmistress on the street and falls in love with her at first sight. Soon he begins to attend her class. One day, however, when protecting the teacher (the Young Lady), the Hooligan is fatally wounded in a brawl and dies before his beloved's eyes. In the early 1960s after motifs of the film, Alexander Belinsky produced the libretto for the eponymous ballet, while the choreographer of the Maly Theatre Konstantin Boyarsky created the choreography. The music was taken from three unfortunate ballets by Dmitry Shostakovich - The Bolt, The Golden Age and The Limpid Brook, the score also featuring highlights from Shostakovich's music for films. The premiere of the ballet The Young Lady and the Hooligan took place in 1962. Soviet audiences, who over the years of the reign of "drama-ballet" on the stage had become used to ballet plays, were transfixed by the story-in-dance about the Hooligan's moral transformation under the influence of the emotion of love which he had not known before. The ballet remained in the repertoire of the Maly Theatre as late as 1987. One of the last Hooligans there, Yevgeny Myasishchev - together with his theatre colleague Yekaterina Pavlova and Sergei Savkov who dazzled as the Hooligan at the Novosibirsk Opera and Ballet Theatre - brought Boyarsky's ballet back to life at the Mariinsky Theatre in 2001. Olga Makarova

SYNOPSIS

Episode 1. A workers' district. The&nbsp;street is ruled by the young Hooligan.
The Young Lady makes a&nbsp;tremendous impression on him.

Episode 2. At school. The Hooligan recognises the new pupil as the Young Lady.
She stops the "unbridled' Hooligan.

Episode 3. A park. The Hooligan wishes to tell the Young Lady of his love.
She runs away.

Episode 4.The Hooligan is in a&nbsp;restaurant.
The Young Lady appears to him as a vision. He runs to her.
The Leader tries to restrain him.

Episode 5. The Hooligan at the Young Lady's house.

Episode 6. A park. Drunken youths are scaring the people walking there.
The Hooligan defends the Young Lady and her friends.
The Hooligan's former friends take their revenge.
Fatally wounded, he heads for the Young Lady's house.

Episode 7. The street. The Hooligan dies in the Young Lady's arms.