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-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=2153) 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-14' AND '2024-06-03' AND tmp.perf_id=2153) 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<>2153 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<>2153 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 May 2018, 19:00 - Beethoven. R. Strauss. Ravel. Symphony Orchestra of the Bavarian Radio. Conductor – Mariss Jansons - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Tchaikovsky Concert Hall 17 May 2018, 19:00 - Beethoven. R. Strauss. Ravel. Symphony Orchestra of the Bavarian Radio. Conductor – Mariss Jansons
17May
19:00
2018 | Thursday

PROGRAM:

  • Beethoven 
  • Symphony No. 3 in E-flat major, Op. 55 ("Eroica").
  • R. Strauss 
  • Simphonic poem "Don Juan", Op. 20.
  • Ravel 
  • La valse, choreographic poem.

 

  • Symphony Orchestra of the Bavarian Radio
  • Conductor – Mariss Jansons

 

The Bavarian Radio Symphony Orchestra is based in Munich, Germany, one of two full-size symphony orchestras operated under the auspices of Bayerischer Rundfunk, or Bavarian Broadcasting (BR). Its primary concert venues are the Philharmonie am Gasteig and the Herkulessaal in the Residenz. The orchestra was founded in 1949, with members of an earlier radio orchestra in Munich as the core personnel. Eugen Jochum was the orchestra's first chief conductor, from 1949 until 1960. Subsequent chief conductors have included Rafael Kubelík, Sir Colin Davis and Lorin Maazel. Since 2003, the orchestra's chief conductor has been Mariss Jansons, whose current contract extends through 2021. Jansons has regularly campaigned for a new concert hall for the orchestra since the start of his BRSO tenure. The orchestra participates in the "Musica Viva" concerts, founded by the composer Karl Amadeus Hartmann, to this day. The orchestra has recorded for a number of commercial labels, including Deutsche Grammophon, RCA, and EMI. The orchestra received the 2006 Grammy Award for Best Orchestral Performance for its recording of Shostakovich's 13th Symphony. The orchestra has recently begun to produce recordings under its own BR-Klassik label.

What is Mariss Jansons’s secret? How does he consistently manage to take his orchestras to a higher level and garner international recognition? In the December 2008 issue of Gramophone, he described his approach as follows: ‘It’s my task to find out the orchestra’s special qualities and preserve them. Then, if through a natural process my own individuality adds something – and theirs to me – that will be fine.’ And fine it most certainly is, a fact that became readily apparent after his appointment as chief conductor of the Royal Concertgebouw Orchestra Amsterdam back in 2004.

Music is in Mariss Jansons’s blood. His father was a conductor and his mother an opera singer. When Jansons was just a boy, the family moved to St Petersburg where he later studied violin and conducting. He continued his studies with Hans Swarowsky in Vienna and Herbert von Karajan in Salzburg. In 1973, Jansons was appointed Yevgeny Mravinsky’s assistant with the St Petersburg orchestra, which Jansons’s father Arvids had also conducted. From 1979 to 2000, he served as music director of the Oslo Philharmonic Orchestra, bringing it great international acclaim. On the occasion of his seventieth birthday in 2013, Jansons has been given Carte Blanche by the Concertgebouw in its World Famous Symphony Orchestras Series.

Jansons has made numerous appearances throughout the world as a guest conductor of the Berlin, the Vienna and the London Philharmonic Orchestras, as well as the leading orchestras in the United States. Jansons was appointed music director of the Pittsburgh Symphony Orchestra in 1997 (a post he held until 2004) and music director of the Bavarian Radio Symphony Orchestra in 2003. Making his first guest appearance with the Royal Concertgebouw Orchestra in 1988, he returned nearly every year thereafter and was appointed its chief conductor in 2004. He is the sixth conductor to hold the post since the orchestra was founded in 1888.

Jansons has received various distinctions for his achievements, including honorary membership of the Royal Academy of Music in London and the Gesellschaft der Musikfreunde in Vienna. He is also the recipient of the Austrian Decoration of Honour for Science and Art, and of Latvia’s highest honour, the Three-Star Order, conferred on him in 2006. In October 2011, the magazine Opernwelt named him ‘conductor of the year’ for his performances of Tchaikovsky’s Yevgeny Onegin with the RCO at De Nederlandse Opera. In November 2011, he was awarded the  Bavarian Maximilian Order for Science and Art, and in December 2011, the Prix d’Amis by the Society of Friends of De Nederlandse Opera. In 2013 Mariss Jansons was awarded the Ernst von Siemens Music Prize.

Casts & Credits

Composer: Maurice Ravel
Composer: Richard Strauss
Conductor: Mariss Jansons