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 (590431,590532,592052,592153,593693,593792,595397,595498,597094,597195,598782,598881,600456,600557,602139,602238,603809,603910,605474,605573,607126,607227,608771,608872,610409,610518,612093,612202,613770,613879,615437,615546,617092,617201,618734,618843,620367,620476,621994,622103,623613,623722,625223,625351,626844,626972,628455,628583,630055,630183,631648,631776,633235,633363,634813,634941,636380,636508,637938,638066,639487,639611,641020,641148,642551,642671,644068,644189,645577,645701,647080,647204,648575,648699,650074,650198,651562,651686,653043,653167,654515,654639,655976,656100,657427,657551,658882,659006,660326,660448,661757,661881,663181,663305,664598,664722,666008,666132,667449,667571,668877,669001,670318,670442,671750,671874,673174,673298,674585,674709,675987,676111,677380,677503,678759,678894,680160,680295,681552,681687,682934,683069,684306,684441,685665,685793,687005,687133,688313,688440,689612,689739,690898,691025,692174,692301,693444,693567,694696,694823,695935,696062,697161,697288,698374,698501,699576,699703,700770,700897,701957,702087,703149,703279,704330,704460,705500,705628,706650,706778,707789,707917,708917,709044,710035,710162,711183,711310,712321,712448,713454,713580,714574,714701,715683,715810,716781,716908,717869,717996,718947,719074,720013,720140,721068,721195,722126,722253,723188,723315,724240,724367,725283,725410,726316,726443,727341,727469,728358,728486,729365,729493,730365,730493,731357,731485,732344,732472,733338,733466,734325,734453,735304,735432,736271,736399,737243,737371,738207,738335,739166,739292,740116,740241,742083,742209,744056,744182,746022,746147,747982,748108,749964,750090,751946,752072,754825,754951,757698,757824,760564,760690,763427,763553,766286,766412,769140,769265,771986,772111,774826,774950,777661,777785,780492,780617,783325,783451,786157,786281,788983,789107,791805,791929,794624,794748,797433,797557,800238,800362,803036,803163,805834,805959,808748,811531,814310,817084,819852,822610,825363,828109,830850,833589,836320,839051,841776,844495,847234,849967,852696,855426,858151,860871,863583,866284,868974,871658,872018,874340,874704,877020,877383,879704,880067,882384,882743,882975,885067,885426,885658,887737,888098,888330,890402,890763,890993,893062,893423,893656,895720,896081,896311,898369,898730,898962,901015,901375,901605,903651,904011,904241,906274,906635,906868,909250,909480,911862,912094,914499,914731,917202,917442,919908,920141,922594,922825,925292,925526,927987,928241,930700,930955,933407,933666,936116,936376,938836,939109,941559,941833,944268,944546,946974,947250,949691,949961,952389,952665,955090,955360,957767,958044,960430,960705,963083,963352,965713,965989,968348,968623,970986,971256,973609,973879,976218,976493,978828,979109,981425,981707,984014,984295,986640,986923,989261,989545,991889,992159,994500,994773,997098,997372,999687,999960,1002269,1002542,1004847,1005120,1007416,1007690,1009979,1010253,1012531,1012811,1015103,1015383,1017657,1017937,1020204,1020484,1022751,1023032,1025288,1025569,1027823,1028104,1030351,1030634,1032862,1033145,1035357,1035640,1037842,1038128,1040327,1040614,1042804,1043094,1045274,1045566,1047734,1048027,1050183,1050478,1052618,1052912,1055055,1055341,1057481,1057767,1059900,1060185,1062297,1062589,1064702,1064987,1067082,1067374,1069453,1069747,1071827,1072115,1074223,1074510,1076614,1076899,1078990,1079275,1081349,1081640,1083700,1083992,1086035,1086330,1088360,1088653,1090703,1090987,1093018,1093314,1095345,1095629,1097645,1097929,1100211,1102483,1104740,1106977,1109196,1111391,1113568,1115726,1117867,1120002,1122134,1124272,1126467,1128683,1130896,1133092,1135282,1137489,1139690,1141884,1144071,1146247,1148411,1150566,1152717,1154863,1157000,1159169,1161324,1163464,1165596,1167733,1169863,1171985,1174100,1176246,1178381,1180509,1182628,1184738,1186848,1188954,1191053,1193141,1195220,1197296,1199363,1201424,1203477,1205527,1207564,1209593,1211632,1213663,1215685,1217694,1219688,1221671,1223647,1225618,1227611,1229625,1231634,1233631,1235617,2188796,2190328,2191847,2193359,2194859,2196388,2197915,2198204,2199435,2199724,2200964,2201253,2202512,2202801,2204047,2204336,2205573,2205862,2207099,2207389,2208621,2208911,2210132,2210422,2211631,2211921,2213335,2213624,2215030,2215319,2216715,2217004,2218501,2218790,2220742,2221031,2222974,2223263,2225197,2225483,2227404,2227690,2229600,2229886,2231785,2232071,2233963,2234249,2236374,2236659,2238993,2239278,2241901,2242189,2245072,2245358,2248235,2248521,2251388,2251674,2254533,2254819,2257669,2257955,2260795,2261081,2263912,2264198,2267018,2267304,2270116,2270402,2273218,2273512,2276327,2276633,2279468,2279774,2282602,2282908,2285748,2286054,2288886,2289192,2292016,2292322,2295137,2295443,2298254,2298558,2301375,2301679,2304502,2304806,2307646,2307950,2310814,2311118,2313977,2314281,2317136,2317440,2320290,2320594,2323439,2323742,2326577,2326880,2329707,2330010,2332818,2333121,2335920,2336223,2339016,2339327,2342112,2342418,2345219,2345525,2348318,2348624,2351414,2351723,2354533,2354842,2357640,2357949,2360741,2361052,2363836,2364147,2366921,2367232,2369995,2370306,2373060,2373371,2376110,2376421,2379148,2379459,2382180,2382491,2385207,2385517,2388222,2388538,2391284,2391599,2394340,2394655,2397383,2397698,2400412,2400727,2403430,2403745,2406444,2406759,2409449,2409764,2412444,2412759,2415430,2415746,2418444,2418760,2421446,2421762,2424437,2424753,2427739,2430716,2433683,2436642,2439588,2442523,2445449,2448370,2451280,2454180,2457064,2459943,2462807,2465662,2468539,2471477,2474391,2477334,2480266,2483184,2486092,2488995,2491928,2494852,2497766,2500667,2503555,2506431,2509297,2512158,2515013,2517863,2520706,2523538,2526358,2529171,2531979,2534780,2537574,2540368,2543152,2545925,2548691,2551496,2554292,2557103,2559904,2562693,2565467,2568233,2571065,2573889,2576703,2579504,2582301,2585083,2587854,2590622,2593381,2596132,2598874,2601603,2604319,2607026,2609729,2612423,2696380,2699465,2702536,2705612,2708659,2711702,2714733,2717753,2720818,2723926,2727025,2730112,2733211,2736314,2739401,2742478,2745538,2748579,2751608,2754634)) 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
Maestro Yuri Bashmet (GRAMMY WINNER 2007 "Best Small Ensemble Performance - Best Conductor") (Conductor) - uVisitRussia
Yuri Bashmet was born in 1953 in Rostov-on-Don in Russia and spent his childhood in Lvov in the Ukraine. He began studying at the Moscow Conservatoire at the age of eighteen, first with Vadim Borisovsky, violist of the Beethoven Quartet, and later with Feodor Druzhinin. He subsequently became the youngest person ever to be appointed to a professorship at the Moscow Conservatoire. In 1976, Bashmet won first prize at the International Viola Competition in Munich, which launched his international career. Sony Classical released his first recording for the label this past autumn- an arrangement for viola and string orchestra of Brahms‘ Clarinet Quintet and Shostakovich‘s Quartet No.13 performed with the Moscow Soloists (SK 60550).
Yuri Bashmet has inspired many composers to write for him. He enjoyed an especially close and productive relationship with Alfred Schnittke, and premiered the composer‘s Viola Concerto at the Concertgebouw in Amsterdam in 1986. The work has since become firmly established in the repertoire.
Other works written for Bashmet include Georgian composer Giya Kancheli‘s Viola Concerto, which the violist premiered at the Berlin Festival, The Myrrh Bearer by John Tavener, a concerto by Poul Ruders and Sofia Gubaidulina‘s Viola Concerto, which he premiered with the Chicago Symphony Orchestra and Kent Nagano in April 1997. Bashmet also gave the world premiere of Benjamin Britten‘s recently edited Double Concerto for violin and viola with Gidon Kremer and the Hallй Orchestra conducted by Kent Nagano in Manchester in February 1998.
In 1992 Bashmet began working with a new group, Moscow Soloists, which he directs himself. This group is composed of musicians nominated by professors at the Moscow Conservatoire as the cream of the new generation of string players. The Moscow Soloists have been rapturously received in Moscow, Athens, Amsterdam, Paris and at the BBC Promenade Concerts in London.
In a number of major concert halls, including La Scala in Milan and the Concertgebouw in Amsterdam, Bashmet has been the first violist ever to give a solo recital. He has appeared on many occasions with Sviatoslav Richter and has performed chamber music with many other leading artists, including Natalia Gutman, the Borodin Quartet, Gidon Kremer, Viktoria Mullova, Mstislav Rostropovich and Maxim Vengerov.
He has appeared with nearly all the world‘s leading orchestras, including the Berlin Philharmonic, Royal Concertgebouw, Boston Symphony, Chicago Symphony, Montreal Symphony and Los Angeles Philharmonic and London‘s Philharmonia Orchestra. The London Symphony Orchestra presented a four-concert Yuri Bashmet festival in 1993 at the Barbican. Bashmet will be "International Artist in Residence" for the 1998 Bath International Festival.
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.