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.id IN (374411,376256,378091,379924,381752,383575,385387,387199,389007,390811,392611,394405,396197,397982,457333,458898,638528,640068,641598,643118,644628,646134,647635,649125,650619,652101,653577,655043,656498,657949,659398,660835,662262,663681,665094,666502,667937,669357,670796,672220,673639,675044,676443,677829,679232,680630,682016,683391,1412309,1412310,1414072,1414073,1415826,1415828,1417569,1417570,1419300,1419301,1421020,1421021,1422730,1422731,1424426,1424427,1426109,1426110,1427777,1427778,1971145,1971167,1971169,1971172,1973156,1973178,1973179,1973181,1975152,1975174,1975176,1975179,1977139,1977159,1977160,1977164,1979109,1979131,1979133,1979136,1981108,1981128,1981129,1981133,1983100,1983118,1983119,1983125,1985106,1985108,1985111,1987080,1987083,1987088,1989050,1989054,1989058,1991005,1991009,1991013,1992953)) ORDER BY date ASC, ves DESC, time ASC LIMIT 10
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





	Nikolai Znaider (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Nikolai Znaider (Conductor)

Nikolai Znaider (Conductor)

Not just an outstanding technique, but also a dynamic expertise of unique expressiveness" - these qualities were attributed to violinist Nikolai Znaider for his latest CD recording featuring the concertos of Max Bruch and Carl Nielsen. His violin playing, said the magazine "Strad", is "reminiscent of the good old days of great violin artistry". Born in 1975 as the son of Polish-Israeli parents in Denmark, he began his studies with Milan Vitek at the Royal Danish Conservatory. After winning the first prize at the 1992 Carl Nielsen Competition, he perfected his training with Dorothy DeLay at the Juilliard School of Music in New York. Above and beyond this, Nikolai Znaider has studied since 1994 with the renowned violin teacher Boris Kuschnir at the Vienna Conservatory. He first attracted international notice in 1997 when he won the first prize at the Queen Elisabeth Competition in Brussels. Since then, the artist described by Lord Yehudi Menuhin as "the successor to Ysaye" is in great demand world-wide as a soloist and chamber musician. In February of this year a tour with the London Symphony Orchestra under Mstislav Rostropovitch took him to Japan. Further highlights in his career have included appearances with major international orchestras such as the Berlin Philharmonic, the London Philharmonic Orchestra, the Koninklijke Concertgebouw Orkest ub Ansterdam, the Chicago Symphony, the Cleveland Orchestra and the New York Philharmonic Symphony Orchestra, the Gewandhaus Orchestra in Leipzig, the Munich and St. Petersburg Philharmonic Orchestras as well as the Philhadelphia Orchestra, with which he made his debut in New Yorkґs Carnegie Hall. His musical partners have included such luminaries as Daniel Barenboim, Zubin Mehta, Lorin Maazel, Herbert Blomstedt, Sir Colin Davis, Neeme Jarvi, Kurt Masur, Mstislaw Rostropovitch, Mariss Jansons and Yuri Temirkanov. Nikolaj Znajder plays a violin built by Giuseppe Guarneri del Gesu in 1732, placed at his disposal by Machold Rare Violins. The artist was most recently heard at a special benefit concert for the Orchestra Academy with Prokofiev’s Second Violin Concerto as guest of the Bavarian Radio Symphony Orchestra. He also recorded this concerto with the Symphony Orchestra under the direction of Mariss Jansons along with the Glazunov Violin Concerto and Tchaikovsky‘s Meditation Opus 42 on a CD which is soon to be released. Nikolai Znaider is an exclusive BMG/RCA Victor Red Seal Artist.