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





	4 June 2018, 19:00 - "Stars of the Russian Cinema of 30`s-40`s" performed by Russian State Symphony Orchestra of Cinematography. Conductor Sergey Skripka - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Tchaikovsky Concert Hall 4 June 2018, 19:00 - "Stars of the Russian Cinema of 30`s-40`s" performed by Russian State Symphony Orchestra of Cinematography. Conductor Sergey Skripka
Duration: 1 hours 32 minutes

  • Russian State Symphony Orchestra of Cinematography
  • Conductor – Sergey Skripka
  • Pavel Milyukov (violin), Laureate of the 15th International Tchaikovsky Competition

PROGRAM:

Brahms 
Concerto for Violin and Orchestra
Selected Hungarian Dances

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.

Sergei Ivanovich Skripka is a prominent Russian conductor, and a People's Artist of Russia, conductor of the State Symphony Cinema Orchestra.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.

Graduated from the Moscow Conservatory studying under Prof. Vladimir Ivanov (2004–2009) and continued advanced studies under him. During 2013 studied at the University of Music and Performing Arts in Graz under Prof. Boris Kuschnir. At present he is taking instruction from Lidia Baich at the Vienna Conservatory. He has won prizes in international competitions, among them the 5th Niccolo Paganini International Violin Competition in Moscow (2007, second prize), the competition in Astana (2008, grand prix), in Seoul (2012, second prize), and the 8th Aram Khachaturian Competition in Yerevan (2012, first prize). In 2011 he participated in the XIV International Tchaikovsky Competition. He performs in cities throughout Russia, Austria, Belgium, China, and Korea among other countries. Since 2008 he has been as soloist at the Saint Petersburg House of Music, and since 2012 soloist for the Moscow Philharmonic. He plays the “ex-Szigeti” instrument made by Pietro Guarneri and provided by the Neva Foundation.