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





	15 September 2018, 19:00 - 10th Grand Festival of Russian National Orchestra. Conductor – Mikhail Pletnev. Vadim Repin (violin) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Tchaikovsky Concert Hall 15 September 2018, 19:00 - 10th Grand Festival of Russian National Orchestra. Conductor – Mikhail Pletnev. Vadim Repin (violin)
15September
19:00
2018 | Saturday

PROGRAM:

Bruch 

Concerto No. 1 for Violin and Orchestra in G minor, Op. 26.

Shostakovich 

Symphony No. 15 in A major, Op. 141.

  • Russian National Orchestra
  • Conductor – Mikhail Pletnev
  • Vadim Repin (violin)

Russian National Orchestra has been in demand throughout the music world ever since its 1990 Moscow premiere. Of the orchestra's 1996 debut at the BBC Proms in London, the Evening Standard wrote, "They played with such captivating beauty that the audience gave an involuntary sigh of pleasure." More recently, they were described as "a living symbol of the best in Russian art" (Miami Herald) and "as close to perfect as one could hope for" (Trinity Mirror).

Mikhael Pletnev was born in Arkhangelsk, Russia, in 1957. His father was an accordion teacher, his mother a pianist. They recognized his talent early on. Mikhail grew up in Kazan where he learnt several instruments, including the piano. At the age of 13, he transferred to the Central School of Music in Moscow to study under Yevgeny Timakin. In 1974, Pletnev entered the Moscow Conservatory, studying with Yakov Fliyer, and, after Fliyer’s death, with Lev Vlasenko.

Born in Siberia in 1971, Vadim Repin was eleven when he won the gold medal in all age  categories in the Wienawski Competition and gave his recital debuts in Moscow and St  Petersburg. At 14 he made his debuts in Tokyo, Munich, Berlin, Helsinki; a year later in Carnegie Hall.  At 17 he was the youngest ever winner of the Reine Elisabeth Concours. 

Since then he has performed with all the world’s greatest orchestras and conductors. Among the highlights of his career in the past few seasons have been tours with the London Symphony Orchestra and Valery Gergiev, the NHK Orchestra and Dutoit; a tour of Australia with the London Philharmonic Orchestra and Vladimir Jurowski, and acclaimed premières in London, Philadelphia, New York’s Carnegie Hall, the Salle Pleyel in Paris and Amsterdam's Concertgebouw of the violin concerto written for him by Sir James MacMillan, culminating in a BBC Prom at the Royal Albert Hall. 

 

Casts & Credits

Composer: Max Bruch
Violin soloist: Vadim Repin
Composer: Max Bruch
Violin soloist: Vadim Repin