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-06' AND tmp.date<='2024-06-26' AND tmp.perf_id=1936) 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-06' AND '2024-06-26' AND tmp.perf_id=1936) 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<>1936 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<>1936 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





	27 November 2017, 19:00 - Schumann. Beethoven. Schubert. Performed by Sergey Redkin (piano) and Moscow State Symphony Orchestra. Conductor – Uroš Lajovic (Slovenia) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Tchaikovsky Concert Hall 27 November 2017, 19:00 - Schumann. Beethoven. Schubert. Performed by Sergey Redkin (piano) and Moscow State Symphony Orchestra. Conductor – Uroš Lajovic (Slovenia)

PROGRAM:

  • Schumann 
  • Overture to the drama "The Bride of Messina" by F.Schiller
  • Beethoven 
  • Concerto No. 1 for Violin and Orchestra
  • Schubert 
  • "Rosamunde", D.797 (Incidental Music To Helmina von Chézy's Play)

 

  • Sergey Redkin (piano)
  • Moscow State Symphony Orchestra
  • Conductor – Uroš Lajovic (Slovenia)

 

Sergei Redkin was born in 1991 in Krasnoyarsk. He studied at the music lyceum of the Krasnoyarsk State Academy of Music and Theater (piano Boguslavskaya class, E. Markaich's improvisation class), then at the Central Special Music School at the St. Petersburg Conservatory (piano class O. Kurnavina, composition class of Professor A. Mnatsakanyan). During the training he became the winner of the All-Russian competition "Young talents of Russia" and won awards at the international youth pianist competitions named after S. Rachmaninov in St. Petersburg, G. Neuhaus in Moscow, the Baltic Sea countries in Estonia and "Classic" in Kazakhstan.
In 2015, Sergei graduated from the St. Petersburg Rimsky-Korsakov Conservatoire in two specialties: "piano" (class of Professor A. Sandler) and "composition" (class of Professor A. Mnatsakanyan) and continued his studies in graduate school. In the same year, the young pianist brilliantly performed at the XV International Tchaikovsky Competition and was awarded the III Prize and the Bronze Medal. Also among his achievements are the awards at the I. Paderewski international contests in Poland, May Lind in Finland and S. Prokofiev in St. Petersburg.
Sergei Redkin - a scholarship fund "Palaces of St. Petersburg", the St. Petersburg House of Music and Joint Stock Bank "Russia". Since 2008, he has participated in many projects of the House of Music: the Russian National Music Team, the Talent River, the Embassy of Excellence, Russian Thursdays, Russian Tuesdays, concerts in the northern capital, regions of Russia and abroad. In the direction of the St. Petersburg House of Music, the pianist underwent an internship at the International Piano Academy on Lake Como (Italy). He took part in the master classes of A. Yasinsky, N. Petrov and D. Bashkirov.
Sergey Redkin performs at the best venues in Moscow and St. Petersburg, among which the halls of the St. Petersburg Philharmonic, the St. Petersburg Chapel and the Mariinsky Theater Concert Hall, take part in the programs of the Moscow Philharmonic, including the concerts of the Young Talents and Stars XXI century "in the Concert Hall named after P. Tchaikovsky. Participates in prestigious international festivals - Mariinsky Theater Festival "Faces of Modern Pianism", Moscow Easter Festival and others.
He tours extensively in Russia and abroad - in Germany, Austria, France, Switzerland, Sweden, Finland, Portugal, Monaco, Poland, Israel, USA and Mexico. Cooperates with the Mariinsky Theater Symphony Orchestra under Valery Gergiev, the St. Petersburg State Academic Symphony Orchestra, the State Academic Symphony Orchestra of Russia named after EF Svetlanov and other well-known collectives.

The Moscow State Academic Symphony Orchestra (MGASO) was founded in 1943 by the Government of the USSR and is one of the oldest symphony orchestras in Russia.
The first chief conductor of the ensemble was the conductor of the Bolshoi Theater People's Artist of the USSR Lev Shteinberg. He headed the orchestra until the end of his life (1945). Then the leadership of MGASO was carried out by such renowned Soviet musicians as Nikolai Anosov (1945-1950), Leo Ginzburg (1950-1954), Mikhail Terian (1954-1960), Veronika Dudarova (1960-1989). Thanks to their cooperation with them, the orchestra became one of the best symphony ensembles in the country, but was known primarily for the performances of Russian and Soviet classics, including the premieres of S. Prokofiev, N. Myaskovsky, D. D. Shostakovich, R. M. Glière.
A new era in the history of MGASO began under the leadership of Pavel Kogan. Maestro took the post of artistic director and chief conductor of the orchestra in 1989 and immediately reformed the group's repertoire, enriching it with works of European and American musical literature.
The visiting card of the orchestra was the grandiose monographic cycles of complete collections of symphonic compositions by the greatest composers of I. Brahms, L. van Beethoven, F. Schubert, R. Schumann, R. Strauss, F. Mendelssohn, G. Mahler, A. Bruckner, J. Sibelius, A. Dvorak, P. I. Tchaikovsky, A. K. Glazunov, S. V. Rachmaninov, S. C. Prokofiev, D. D. Shostakovich, A. N. Scriabin, G. Berlioz, C. Debussy, M. Ravel. The large-scale programs of the collective consist of symphonic, opera and vocal-symphonic classics, works by contemporary composers, a lot of forgotten and unfamiliar works.
Thanks to the variety of programs and the invariably high level of their performance, MGAIC deserved the respect and love of listeners in their country and abroad. The orchestra annually gives concerts in the Great Hall of the Moscow Conservatory and the PI Tchaikovsky Concert Hall, including in the framework of popular personal and mixed subscription cycles. The group regularly performs in the Great Hall of the St. Petersburg Academic Philharmonic named after D. D. Shostakovich and on the stages of other cities of Russia, and also conducts a tour abroad - during the last twenty five years the tour of MGASO took place in more than fifty countries, including the United States, Great Britain , Japan, Spain, Austria, Italy, Germany, Czech Republic, Poland, Hungary, France, South Korea, Australia, China and Switzerland.
The team created a collection of records, including CD and DVD with studio and live performances, radio and television broadcasts. In 1990, Pioneer made a live recording of Tchaikovsky's piano and violin concertos and Shostakovich's Symphony No. 10 performed by the Moscow State Academic Symphony Orchestra and Maestro Kogan (soloists Alexei Sultanov and Maxim Vengerov). In the early 90's, the film "Journey with the Orchestra" was released on the tour of MGASO, directed by Pavel Kogan in Europe and St. Petersburg. The cycle of Rachmaninov's works published by the Alto label is widely known and popular: the composers created by MGASO and P. Kogan interpreted the three symphonies and the Symphonic Dances of the composer headed the lists of all existing readings.
The orchestra is proud of its partnership with outstanding conductors and soloists: Evgeny Svetlanov, Kirill Kondrashin, Alexander Orlov, Nathan Rakhlin, Samuel Samosud, Valery Gergiev, David Oistrakh, Emil Gilels, Leonid Kogan, Vladimir Sofronitsky, Sergey Lemeshev, Ivan Kozlovsky, Svyatoslav Knushevitsky, Svyatoslav Richter, Mstislav Rostropovich, Daniil Shafran and many others.
Cooperation with Pavel Kogan brought the orchestra the reputation of a team that promotes the highest standards of artistic excellence, demonstrating an artistic approach to the formation of programs that have a wide range of faithful admirers around the world. From concert to concert this wonderful tandem fully justifies its status. IGASO never stops on what has been achieved and tirelessly strives for the uncharted peaks.

Uros Lajovic is a native of Ljubljana (1944), where he graduated from the Academy of Music in Classes of Composition (1967) and conducting (1969) and was awarded in both subjects by the Preshern Student Prize. The next step on the way to mastery was teaching at the Vienna University of Music and Performing Arts with Professor Hans Swarovski, who Laiovitz graduated with honors in 1971. He also improved his skills at the Salzburg Summer Academy, where he trained under the direction of Bruno Maderna (1968, 1969).
Over 40 years of his artistic career, Uros Lajovitz gave about 1,400 concerts. Among his partners on the stage are over 90 different symphony orchestras and ensembles, more than 900 soloists. The musician is one of the key figures in the cultural life of the Slavic countries of Europe. For 19 years (1972-1991) he worked in the Slovenian Philharmonic Orchestra: first as assistant conductor, and from 1978 as permanent conductor. Maestro headed the Chamber Orchestra of Slovenian Television and Radio "Radio Television of Slovenia" (1974-1976), was the main conductor of the Symphony Orchestra of the Croatian Broadcasting Company (1979-1981), the Belgrade Philharmonic Orchestra (2001-2005), the Slovenian Philharmonic Orchestra (2015-2017). In 1988, he founded the Slovenicum chamber orchestra, with whom he worked for 12 years, giving a lot of concerts in Ljubljana and throughout Slovenia. Among the new appointments - the post of artistic consultant and permanent guest conductor of the Zagreb Philharmonic Orchestra (2009). In 2015, the musician was chosen as the permanent guest conductor of the Sofia Philharmonic Orchestra, as well as the Shenzhen Symphony Orchestra in China.
Uros Lajovitz has a significant repertoire, which includes both symphonic music and operatic works. With his participation, 11 operas were staged, more than 1500 symphonic works were performed and about 80 works of contemporary composers were first presented to the public. He is the author of the transcription of Missa viennensis by Johann Baptist Dolar, the editor of the musical drama "Figaro" by Johann Baptist Nowak, the author of the processing of the opera "Black Masks" by Maria Kogoy.
Lajovitz devotes considerable attention to teaching. More than two decades, from 1989 to 2012, he was a professor at the Vienna University of Music and Performing Arts, raising about 300 young conductors from 58 countries. In 2011-2014 years. he was a professor at the Zagreb Music Academy. The master-classes of the conductor were held in Stockholm (Sweden, 2001), Vilnius (Lithuania, 2001), Constance (Romania, 2006), Shanghai (China, 2012), Hong Kong (China, 2009-2012, concerts and master classes), Dubrovnik (Croatia, 2016). The maestro toured throughout Europe, performed in the USA, Colombia (Bogota), Japan (Tokyo, Hiroshima), South Korea (Seoul), China (Shenzhen, Tianjin), Taiwan (Taipei).
The maestro is awarded numerous awards and various awards. Among the latter - the Austrian honorary sign "For Science and Art" (2013).