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





	29 March 2019, 19:00 - Concert performed by Russian State Symphony Orchestra of Cinematography. Conductor – Sergey Skripka - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Tchaikovsky Concert Hall 29 March 2019, 19:00 - Concert performed by Russian State Symphony Orchestra of Cinematography. Conductor – Sergey Skripka
29March
19:00
2019 | Friday
  • Russian State Symphony Orchestra of Cinematography
  • Conductor – Sergey Skripka

 

Russian State Symphony Cinema Orchestra is a cinematographic orchestra of Russia under the control of the Ministry of Culture Symphony Orchestra, performing musical party for the movie. Founded in November 1924, until 1991 was known as the State Symphony Orchestra of Cinematography at the Council of Ministers of the USSR. Unofficially founded on November 1924 at the famous Moscow cinema "Ars", located on Arbat Street.
In 1924, in a Moscow cinema "Ars" in Arbat the first time instead of the usual for that time pianist tapёra he made the orchestra. Such a change in the musical accompaniment of films became popular among the spectators. Since then, under the direction of conductor David Blok, the orchestra began to play in other theaters.
In 1930-1940's orchestra performed music for films such directors as Sergei Eisenstein, Vsevolod Pudovkin, Grigori Aleksandrov and Ivan Pyryev. Among the later films, musical party which served the orchestra - movies, The awarded "Oscar" ("War and Peace", "Dersu Uzala", "Burnt by the Sun", "Moscow Does Not Believe in Tears"), as well as modern Russian films ( "Doctor Zhivago", "Miracle", "The House number 6," "Pete on the way to heaven", "King", "12", "Admiral").
At various times over the conductor's stand was Alexander Gauk, Svetlanov, Yuri Nikolaev, Mark Ermler, Krimets Constantine, George Garanian.
In the years 1953-1963 the artistic director and director of the orchestra was Levon Atovmyan. From 1993 to the present chief conductor and artistic director of the orchestra is Sergey Skripka, People's Artist of Russia, laureate of the State Prize of the Russian Federation in the field of culture.

Sergei Ivanovich Skripka is a prominent Russian conductor, and a People's Artist of Russia, conductor of the State Symphony Cinema Orchestra. Skripka graduated in 1972 from the Kharkov Institute of Arts as chorusmaster. In 1973 he entered the Moscow State Tchaikovsky Conservatoire, where he accomplished his course of studies under professor Leo Ginsburg as an opera–symphony conductor. In 1977 Skripka stayed in the Conservatoire for two more years as a postgraduate under the same professor as his practicing assistant.After graduating from the Conservatoire in 1979, Skripka started to work with the Russian State Symphony Orchestra of Cinematography, and since 1993 he has been their Artistic Director and Chief Conductor. He has conducted a great number of the orchestra's concerts and recordings, including those with Mikhail Pletnyov, Konstantin Shsherbakov, Mikhail Bezverhnij, Dmitri Hvorostovsky, and Sergei Sudzilovsky. The orchestra toured Berlin in 1991, Frankfurt-am-Main in 1992, and Tunis in 1998. Concert programs include Britten's "War Requiem", Mozart's Requiem, Tchaikovsky's String Serenade, Mozart's Symphony in G-minor.Skripka was the first in Russia to perform St. Marcus Passion by R. Keiser, and he also made the very first CD recordings of music by Degtyaryov, Gliere, Mosolov and Shebalin.Simultaneously Skripka has conducted the Zhukovsky Symphony Orchestra since 1979, with which he has toured Switzerland (in 1991) and Hungary (in 1998). The concert program comprised works by Mozart, Bach, Corelli, Vivaldi, Ambrosio, Boccherini, Tchaikovsky, Gershwin and others.Currently Skripka is also a professor at the Department of Orchestra Conducting in the Russian Gnesin Academy of Music.Skripka speaks both German and English which greatly facilitates his work with foreign orchestras.