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
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.
Sign in to our website using your Facebook or Google+ account.
Why Do You Need Our Travel Expert
Contact our experts, and they will help you to plan your best trip to Russia, with attention to every detail!
Our Experts have been in the travel industry for many years, guarantee to offer first class customer service, excellent value for money and unbiased advice. They are standing by to find and build your dream holiday to one of the world's most fascinating destinations - Russia. Your personal Travel Expert will guide you through each stage of the travel process, from choosing a program that fits you best to support during your trip.
Just tell us your e-mail, and we'll take care of everything!
Your tour request has been received. Thank you ! We have sent you the confirmation message to [email]
Please make sure that you receive this message (sometimes e-mail messages may go to the spam/junk mail). If you did not get this message, it means you will not get message with the tours' selection as well. If you use a Yahoo!, Gmail, AOL or Hotmail, we recommend to add request@uvisitrussia.comto your address book.
We recommend to leave your phone number. If we will not heard back that you received the e-mail with the tours' selection, we will contact you by phone. And you will not miss the best tour for you.
Thank you ! Your request for Travel Expert assistance has been sent. We will e-mail you within 1 hour.
Sorry, some changes needed
Add your E-mail
There was a problem with your request
Missing contact person. Please correct and try again.