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





	8 September 2018, 19:00 - Borodin. Glazunov. P. I. Tchaikovsky. Performed by Moscow State Symphony Orchestra (MSSO) and Sergey Dogadin (violin). Conductor – Renat Salavatov - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Tchaikovsky Concert Hall 8 September 2018, 19:00 - Borodin. Glazunov. P. I. Tchaikovsky. Performed by Moscow State Symphony Orchestra (MSSO) and Sergey Dogadin (violin). Conductor – Renat Salavatov
Duration: 1 hours 28 minutes

PROGRAM:

  • Borodin 
  • "Polovtsian Dances" from the opera "Prince Igor"
  • Glazunov 
  • Concerto for Violin and Orchestra
  • P. I. Tchaikovsky 
  • Symphony No. 4

 

  • Moscow State Symphony Orchestra (MSSO)
  • Sergey Dogadin (violin)
  • Conductor – Renat Salavatov

 

The MSSO was founded in 1943 by the Kremlin and is one of the oldest symphony orchestras in Russia.

Leo Steinberg, the Peoples Artist of USSR and conductor of the Bolshoi Theatre, became the MSSO first Chief Conductor, a post he held until his death in 1945. He was succeeded by a series of distinguished Soviet musical giants that has included Nicolay Anosov (1945 – 1950), Leo Ginsburg (1950 – 1954), Mikhail Terian (1954 – 1960), and Veronica Dudarova (1960 – 1989). Owing to the collaboration with such figures the orchestra became one of most prominent national symphonic ensembles, but in the first place it was known through its performances of Russian and Soviet classical music, involving many premieres of Myaskovsky, Prokofiev, Shostakovich, Glier.

Sergei Dogadin was born in September 1988 in a musical family. He began to study the violin at the age of six under the renowned teacher L.A. Ivashchenko.

He has worked with conductors including Alexander Dmitriev, Nikolai Alexeyev, Alexander Rudin, Vladislav and Alexander Chernushenko, Vladimir Altshuler, Vasily Petrenko, Anu Tali, Mischa Santora, Fabio Mastrangelo, Alexander Sulsky, Norman Schnee, Dmitry Liss, Saulus Sondeckis and Mikhail Nesterovich. Performs at numerous international festivals. He has had the honour of playing the violins of Niccolò Paganini and Johann Strauss.

  • Conductor – Renat Salavatov

Honored Artist of Russia, People's Artist of Tatarstan. Award of the Order "Kurmet" (Kazakhstan). He was artistic director and chief conductor of the State Symphony Orchestra of the Tatar SSR from 1979 to 1985, chief conductor of the Musa-Jalil Tatar Academic Opera and Ballet Theater since September 2003.

 

Casts & Credits