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-06-07' AND tmp.date<='2024-06-27' AND tmp.perf_id=811) 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-06-07' AND '2024-06-27' AND tmp.perf_id=811) 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<>811 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<>811 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





	16 October 2018, 20:00 - Modern Dance Ballet of Boris Eifman "Requiem" - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Russian State Pushkin Academy Drama Theater (Alexandrinsky Theatre) (established 1756) 16 October 2018, 20:00 - Modern Dance Ballet of Boris Eifman "Requiem"
16October
20:00
2018 | Tuesday
Classical ballet
Russian State Pushkin Academy Drama Theater (Alexandrinsky Theatre) (established 1756), Saint Petersburg

Academic Ballet Theatre of Boris Eifman .

Premiere .
Boris Eifman's ballet based on the poem by Anna Akhmatova music of Shostakovich , Mozart .
Decoration : Simon Shepherd , Zinovy ​​Margolin . Costumes: Olga Shaishmelashvili . Light: Boris Eifman .
The premiere will take place on January 27, 2014 Alexandrinsky Theatre .

The history of this unusual performance . In 1991 , at the dawn of a new era of Boris Eifman set to music "Requiem" by Mozart -act ballet of the same name - a philosophical parable about the sacrament of the eternal human life.
Decades later Eifman - artist "troublesome" warehouse , located in constant search of perfect plastic forms - turned again to his work and created on its basis a full-scale performance . Significantly rethinking choreographic score earlier statement , he added, in another act ballet , composed by Anna Akhmatova 's poem "Requiem" to the music of Chamber Symphony "In memory of the victims of fascism and war" Shostakovich .
The premiere will be dedicated to the 70th anniversary of the complete liberation of Leningrad from the Nazi blockade - the great feast , which marks the victory of life over death and destruction elements . Artists troupe Boris Eifman Ballet will present "Requiem" in conjunction with the State Chamber Orchestra "Moscow Virtuosi" (artistic director and chief conductor - Vladimir Spivakov ) and Academic big chorus " Masters of Choral Singing ." The first new show will see the World War II veterans , advocates and residents of besieged Leningrad, who will receive an invitation to the premiere . The initiators of this socio- cultural action was the St. Petersburg State Academic Ballet Theatre of Boris Eifman , the orchestra "Moscow Virtuosi" and Alexandrinsky Theatre .

Boris Eifman : "Reading the poem " Requiem " , I always marvel at how rampant the pain that pulsates in rows Akhmatova. Again and again the images of mourning " rabid years » fills the heart . And string buried alive frozen in eternal waiting at the prison gates ...
Screaming woman , whose share fell terrible ordeals , Akhmatova 's poem echoing moans thousand unfortunate wives and mothers . This symphony of sorrow never ceases to sound in me. Sacred pain does not subside .
Truly, the world of human suffering bottomless . But in the course of life is hidden divine continuity of being , which brilliantly sung in his "Requiem" by Mozart. Listening to his work, feel the breath of eternity. Anxiety and fears disappear , you're riddled with foreboding universal mystery. Where am I? Why should I ? What am I? Appealed to his memory. That she enters the world of unprotected youth , raises test maturity , wisdom, and the impotence of old age. How much malice , slander and violence in my mind ... And how many perennial touch of happiness, love ! ..
Suffering , despair , hope - all in me , in all of us . And dirge merges with Mozart's hymn to life . "