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 (37207,37212,37217,38759,38765,38769,40207,40213,40217,107669,107675,109556,109562,111433,111438,113302,113307,115163,115168,117039,117044,118914,118919,120785,120790,122651,122656,124509,124514,126358,126363,128202,128207,130031,130036,131860,131865,133693,133698,135518,135523,137339,137344,139157,139162,140966,140972,142767,142773,144557,144563,146337,146343,148107,148114,149864,149871,151614,151620,153354,153360,155085,155091,156806,156812,158517,158523,160243,160249,161970,161976,163693,163701,165435,165443,167166,167173,168887,168894,170599,170606,172303,172310,173997,174004,175680,175687,177360,198567,199884,201201,202883,204555,206262,207960,209648,211311,212844,214383,215919,217450,218979,220502,222021,223535,225044,226555,228060,229559,231544,233539,235529,237514,239488,241454,243415,245376,247328,249275,251219,253202,255176,257141,259114,261081,263041,265007,266967,268918,270859,272798,274731,276664,278591,280468,282336,284195,286052,287907,289752,291654,293550,295439,297319,299196,301092,302981,304872,306804,308728,310646,312560,314469,316374,318272,320162,322041,323911,325816,327721,329622,331515,333401,335276,337142,339023,340953,342877,344801,346724,348631,350520,352398,354275,356158,358035,359942,361843,363734,365617,367499,369374,371247,373111,374966,376811,378646,380479,382307,384127,385943,387750,389562,391361,393161,394956,396747,398532,400311,402081,403839,405597,407349,409096,410836,412603,414360,416103,417846,419586,421318,423048,424772,426487,428186,429880,431593,433307,435005,436698,438381,440049,441707,443348,444978,446604,448218,449820,451412,453002,454590,456170,457744,459313,460869,462417,463968,465516,467058,468765,470483,472033,473575,475155,476732,477966,477969,477973,477976,478307,479533,479538,479541,479549,479878,481101,481104,481108,481111,481848,481851,481856,481860,482586,482589,482594,482598,483320,483323,483327,483330,484059,484064,484067,484075,484809,484815,484818,484826,485555,485560,485563,485571,486292,486298,486301,486309,487017,487022,487025,487033,487735,487737,487742,487747,488446,488449,488453,488456,489162,489167,489172,489875,489879,490580,497652,499116,500572,502026,503515,504997,506468,507939,509410,510873,512328,513812,515284,516749,518203,519647,521089,522525,523953,525374,526780,528187,529590,530992,532384,533770,535206,536628,538058,539482,540900,542333,543797,543802,545268,545272,546722,546726,548178,548182,549629,549633,551071,551075,552505,552510,553928,553932,555344,555348,556754,556759,558155,558161,559553,559558,560946,560951,562333,562338,563714,563718,565083,565087,566444,566448,567803,567807,569157,569161,570505,570509,571847,571848,573224,573230,574596,574601,575956,575961,577314,577319,578665,578670,580006,580011,581339,581344,582665,582669,583988,583992,585301,585305,586612,586616,587915,587919,589211,589215,590856,590859,592469,592473,594102,594107,595802,595807,597491,597496,599172,599177,600845,600850,602522,602526,604189,604193,605847,605851,607495,607499,609134,609138,610821,610825,612502,612506,614178,693912,693917,695160,695165,696388,696395,697607,697614,698821,959016,961671,964311,966947,969579,972207,974827,977439,980046,982638,1915718,1917931,1920132,1922330,1924523,1926770,1929011,1931240,1933454,1935653,1937849,1940038,1942217,1944388,1946549,1948698,1950833,1952965,1955087,1957163,1959228,1961281,1963319,1965345,1967366,1969385,1971396,1973406,1975403,1977390,1979360,1981359,1983351,1985335,1987312,1989282,1991237,1993177,1995115,1997043,1998965,2000879,2002782,2004672,2006548,2008433,2010318,2012195,2014059,2015899,2017730,2019536,2021343,2023144,2024937,2026930,2028920,2030899,2032863,2034823,2036778,2038723,2040661,2042587,2044498,2046395,2048285,2050167,2052041,2053905,2055856,2057891,2059924,2061951,2063971,2065981,2067983,2069989,2071986,2073964,2075936,2077895,2176928,2176932,2177007,2177011,2177012,2177078,2177081,2177084,2177128,2177131,2178534,2178538,2178614,2178618,2178619,2178686,2178689,2178692,2178735,2178739,2180131,2180135,2180210,2180214,2180215,2180281,2180284,2180287,2180331,2180334,2181711,2181715,2181791,2181794,2181795,2181861,2181864,2181867,2181910,2181913,2183277,2183281,2183356,2183360,2183361,2183427,2183430,2183433,2183477,2183480,2184831,2184835,2184910,2184914,2184915,2184982,2184985,2184988,2185031,2185035,2186376,2186380,2186456,2186460,2186461,2186527,2186530,2186533,2186577,2186580,2187918,2187922,2187998,2188002,2188003,2188068,2188072,2188075,2188116,2188121,2189455,2189459,2189535,2189539,2189540,2189606,2189609,2189612,2189656,2189659,2190979,2190983,2191059,2191063,2191064,2191130,2191133,2191136,2191180,2191184,2192495,2192499,2192575,2192579,2192580,2192645,2192649,2192652,2192693,2192698,2194002,2194006,2194082,2194085,2194086,2194152,2194155,2194158,2194202,2194205,2195535,2195539,2195615,2195618,2195619,2195685,2195688,2195691,2195734,2195737,2197061,2197065,2197141,2197145,2197146,2197213,2197216,2197219,2197263,2197266,2198588,2198592,2198668,2198671,2198672,2198739,2198742,2198745,2198788,2198791,2200105,2200109,2200195,2200201,2200202,2200273,2200276,2200279,2200322,2200325,2201627,2201631,2201716,2201722,2201723,2201815,2201819,2201823,2201877,2201880,2203165,2203169,2203255,2203261,2203262,2203354,2203358,2203362,2203416,2203420,2204696,2204700,2204786,2204792,2204793,2204885,2204889,2204893,2204948,2204951,2206220,2206224,2206310,2206316,2206317,2206408,2206412,2206417,2206475,2206479,2207747,2207751,2207836,2207842,2207843,2207935,2207939,2207943,2208002,2208006,2209262,2209266,2209351,2209357,2209358,2209450,2209454,2209458,2209517,2209521,2210766,2210770,2210855,2210859,2210860,2210954,2210958,2210962,2211021,2211025,2212258,2212262,2212347,2212351,2212352,2212446,2212450,2212454,2212513,2212517,2213958,2213962,2214047,2214051,2214052,2214146,2214150,2214154,2214213,2214217,2215645,2215649,2215735,2215739,2215740,2215833,2215838,2215842,2215901,2215905,2217328,2217332,2217418,2217422,2217423,2217516,2217521,2217525,2217584,2217588,2219107,2219111,2219197,2219201,2219202,2219296,2219300,2219304,2219362,2219366,2221345,2221349,2221435,2221441,2221442,2221533,2221537,2221542,2221599,2221603,2223569,2223573,2223659,2223665,2223666,2223758,2223762,2223766,2223825,2223829,2225782,2225786,2225872,2225876,2225877,2225969,2225974,2225978,2226035,2226040,2227984,2227988,2228074,2228078,2228079,2228173,2228177,2228181,2228240,2228244,2230172,2230176,2230262,2230268,2230269,2230361,2230365,2230369,2230427,2230431,2232352,2232356,2232442,2232446,2232447,2232541,2232545,2232549,2232607,2232611,2234769,2234773,2234859,2234865,2234866,2234957,2234962,2234966,2235023,2235028,2237391,2237395,2237481,2237486,2237487,2237580,2237584,2237588,2237644,2237650,2240302,2240306,2240393,2240399,2240400,2240491,2240495,2240500,2240555,2240561,2243479,2243483,2243569,2243573,2243574,2243668,2243672,2243676,2243732,2243738,2246646,2246650,2246737,2246742,2246743,2246835,2246839,2246843,2246899,2246905,2249805,2249809,2249894,2249900,2249901,2249993,2249997,2250001,2250057,2250062,2252949,2252953,2253042,2253048,2253049,2253136,2253141,2253145,2253206,2253210,2256089,2256093,2256180,2256185,2256186,2256279,2256284,2256288,2256343,2256349,2259218,2259222,2259310,2259316,2259317,2259407,2259412,2259416,2259476,2259480,2262341,2262345,2262431,2262437,2262438,2262530,2262535,2262539,2262594,2262599,2265454,2265458,2265543,2265549,2265550,2265640,2265645,2265649,2265708,2265712,2268556,2268560,2268645,2268651,2268652,2268742,2268747,2268751,2268810,2268814,2271645,2271649,2271737,2271743,2271744,2271834,2271839,2271843,2271902,2271906,2274757,2274761,2274849,2274856,2274857,2274947,2274953,2274956,2275015,2275019,2277902,2277906,2277994,2278000,2278001,2278091,2278096,2278100,2278159,2278164,2281042,2281046,2281131,2281136,2281138,2281231,2281236,2281240,2281294,2281299,2284189,2284193,2284281,2284285,2284286,2284381,2284386,2284389,2284443,2284449,2287333,2287337,2287423,2287429,2287430,2287523,2287528,2287532,2287585,2287591,2290466,2290470,2290556,2290562,2290563,2290656,2290661,2290665,2290718,2290724,2293588,2293592,2293681,2293687,2293688,2293777,2293782,2293787,2293846,2293850,2296709,2296713,2296800,2296806,2296807,2296900,2296905,2296908,2296962,2296968,2299833,2299836,2299922,2299926,2299927,2300023,2300029,2300032,2300086,2300091,2302962,2302966,2303053,2303059,2303060,2303153,2303158,2303161,2303215,2303221,2306108,2306112,2306201,2306207,2306208,2306298,2306304,2306307,2306366,2306370,2309277,2309281,2309370,2309375,2309376,2309466,2309472,2309476,2309535,2309539,2312445,2312449,2312534,2312540,2312541,2312634,2312639,2312643,2312697,2312702,2315603,2315607,2315696,2315701,2315702,2315792,2315797,2315801,2315861,2315865,2318760,2318764,2318849,2318853,2318854,2318950,2318956,2318959,2319013,2319018,2321911,2321915,2322000,2322004,2322005,2322101,2322107,2322110,2322164,2322169,2325057,2325061,2325146,2325153,2325154,2325241,2325246,2325251,2325309,2325313,2328188,2328192,2328280,2328287,2328288,2328375,2328380,2328385,2328443,2328447,2331321,2331406,2331413,2331414,2331505,2331509,2331514,2331569,2331573,2334513,2334520,2334521,2334612,2334616,2334621,2334675,2334680,2337611,2337616,2337617,2337710,2337715,2337719,2337772,2337777,2340708,2340712,2340713,2340806,2340812,2340816,2340870,2340874,2343822,2343828,2343829,2343919,2343924,2343928,2343982,2343987,2346925,2346931,2346932,2347023,2347027,2347032,2347086,2347091,2350022,2350028,2350029,2350120,2350124,2350129,2350185,2350190,2353147,2353153,2353154,2353245,2353250,2353254,2353310,2353315,2356260,2356266,2356267,2356355,2356361,2356364,2356425,2356429,2359363,2359369,2359370,2359458,2359464,2359467,2359528,2359532,2362459,2362463,2362465,2362558,2362563,2362567,2362624,2362628,2365551,2365557,2365559,2365650,2365654,2365660,2365717,2365721,2368632,2368637,2368638,2368730,2368735,2368739,2368796,2368801,2371701,2371704,2371705,2371799,2371804,2371808,2371866,2371871,2371873,2371935,2371937,2374761,2374762,2374763,2374857,2374862,2374865,2374923,2374928,2374931,2374991,2374994,2377805,2377806,2377812,2377901,2377906,2377909,2377967,2377971,2377975,2378035,2378038,2380836,2380840,2380841,2380935,2380940,2380944,2381002,2381007,2381009,2381071,2381073,2383865,2383869,2383870,2383964,2383969,2383972,2384031,2384036,2384038,2384099,2384102,2386886,2386892,2386893,2386986,2386990,2386995,2387053,2387057,2387060,2387120,2387122,2389949,2389955,2389956,2390045,2390051,2390054,2390115,2390119,2390122,2390181,2390185,2393007,2393011,2393012,2393106,2393111,2393114,2393173,2393178,2393180,2393243,2393246,2396068,2396069,2396157,2396162,2396166,2396227,2396230,2396234,2396294,2396297,2399197,2399201,2399202,2399262,2399266,2399270,2399329,2399333,2402215,2402219,2402223,2402281,2402286,2402290,2402352,2402355,2405230,2405233,2405240,2405296,2405300,2405305,2405367,2405369,2408242,2408245,2408252,2408308,2408311,2408316,2408378,2408380,2411240,2411244,2411248,2411306,2411310,2411314,2411377,2411380,2414232,2414235,2414239,2414299,2414303,2414307,2414369,2414372,2417213,2417217,2417221,2417281,2417286,2417288,2417378,2417383,2420221,2420225,2420229,2420288,2420293,2420296,2420387,2420391,2423218,2423222,2423227,2423284,2423287,2423292,2423382,2423385,2426204,2426208,2426212,2426274,2426277,2426282,2426370,2426373,2429186,2429190,2429194,2429254,2429258,2429262,2429353,2429356,2432161,2432165,2432166,2432229,2432232,2432237,2432325,2432328,2435121,2435125,2435129,2435192,2435195,2435200,2435287,2435291,2438076,2438080,2438085,2438144,2438147,2438152,2438241,2438246,2441013,2441017,2441023,2441082,2441085,2441090,2441180,2441183,2443940,2443945,2443950,2444010,2444013,2444018,2444108,2444111,2446864,2446868,2446873,2446933,2446936,2446941,2447032,2447035,2449779,2449784,2449788,2449849,2449852,2449857,2449947,2449952,2452687,2452691,2452751,2452755,2452759,2452851,2452855,2455582,2455643,2455646,2455651,2455741,2455745,2458519,2458523,2458527,2458619,2458623,2461392,2461396,2461400,2461490,2461494,2464250,2464253,2464257,2464346,2464350,2467102,2467105,2467109,2467200,2467204,2469974,2469979,2469983,2470071,2470075,2472905,2472910,2472914,2473007,2473011,2475815,2475820,2475824,2475914,2475918,2478754,2478757,2478762,2478854,2478857,2481677,2481681,2481686,2481777,2481780,2484587,2484591,2484597,2484687,2484690,2487493,2487497,2487501,2487593,2487596,2490442,2490443,2490534,2490538,2493373,2493463,2493467,2496383,2496387,2499292,2499296,2502187,2502191,2505067,2505071,2507935,2507939,2510799,2510802,2513659,2513663,2516513,2516517,2519363,2519367,2522202,2522206,2525026,2525030,2527842,2527846,2530651,2530655,2533458,2533459,2536252,2536256,2539042,2539046,2541836,2541840,2544613,2544617,2547379,2547383,2550143,2550147,2552943,2552947,2555742,3449565,3449569,3451705,3451708,3453835,3453839,3455954,3455958,3458082,3458083,3460206,3460209,3462340,3462344,3464466,3464470,3466616,3466620,3468798,3468800,3470963,3470967,3473120,3473123,3475277,3475279,3477429,3477433,3479574,3479578,3481709,3481712,3483843,3483845,3485963,3485966,3488073,3488077,3490183,3490186,3492310,3492314,3494435,3494437,3496550,3496552,3498703,3498705,3500847,3500849,3502982,3502984,3505112,3505115,3507237,3507240,3509279,3509281,3509358,3509361,3511393,3511395,3513499,3513503,3515596,3515601,3517685,3517689,3519770,3519773,3521847,3521852,3523920,3523923,3525978,3525982,3528030,3528036,3530092,3530095,3532137,3532139,3534177,3534179,3536214,3536220,3538249)) 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
Karen Durgarian (Conductor) - uVisitRussia
Born in Yerevan (Armenia). In 1994 graduated from the Yerevan State Conservatory. 1997 — A one-year course with Prof. Mousin at Saint Petersburg Conservatory. 1995 — Associate Conductor of the Armenian Philharmonic Orchestra and used to be the Resident Conductor of the Yerevan Symphony Orchestra. 1996 — Music Director of «Britten and Armenia» Music Festival in Yerevan. Since 1997 — Music director and conductor of the Yerevan State Music Chamber Theater. In 1997 he performed at the Aldeburgh Festival, Great Britain. 2001 — Principal Conductor of the Armenian National State Opera and Ballet Theatre. In 2001-2002 he made productions of the operas Carmen by Georges Bizet and Norma by Vincenzo Bellini.
In September-October 2002 he gave five concerts with the Symphony Orchestra of Cagliary Lyric Theater (Italy). In January 2003 being the assisting conductor to Maestro G.Rojdestvensky he performed the opera Oprichnik by P. Tchaikovsky at the Cagliary Lyric Theatre. In March 2003 he performed with the Orchestra del Teatro Regio in Torino (Italy). In May 2003 he made the production and has conducted 6 performances of Don Giovanni by W.A. Mozart at the Opera Thessaloniki (Greece). In October 2003 he has performed the Beethoven's masterpieces with the Portuguese Symphony Orchestra and the Sao Carlos National Opera Company Choir in Lisbon (Portugal).
In November 2003 he made the production and has conducted three performances of the opera Evgeny Onegin by P. Tchaikovsky at the Teatro Verdi, Sassari (Italy). Since March 2002 he is in the position of resident conductor of the Armenian Radio Symphony Orchestra.
Since 2000 he conducts major performances of Fairuz, the greatest singer of Arabic world. Under his baton Fairuz accompanied by international symphony orchestra has performed works of outstanding Lebanese composer Ziad Rahbani at the Beiteddine Festival's three editions (2000, 2001 and 2003). The Beiteddine concerts were followed by performances with Fairuz in the UAE (2001, 2002, 2003, 2006); Kuwait (2001); Basel (Switzerland, 2001); Paris (France, 2002); Mohegan Sun, Los Angeles, Detroit (USA, 2003); Amman (Jordan, 2004); Montreal (Canada, 2005).
In June 2005 at the Ataturk Culture Centre of Istanbul maestro Durgarian has conducted the Gayaneh ballet by Aram Khachaturian during the Armenian National Opera and Ballet Theatre's tour in Turkey. On 24th June 2005 he has performed program of Sergei Prokofiev's music at the Ravenna Festival (Italy) with the Luigi Cherubini Orchestra (Artistic Director — Riccardo Muti) and the Toradze Piano Studio's soloists, including Alexander Toradze. On 26th May 2006 in Russia maestro Durgarian has opened the XI International Musical Olympus Festival with the St. Petersburg Philharmonic Orchestra. On 29th October 2006 under the baton of Karen Durgarian the Orchestra of Opera de Marseille has performed in the Dome (one of the biggest and best venues in Marseille, France) an enchanting concert with internationally known Armenian composer Ara Gevorgian. On 10th and 11th March 2007 maestro Durgarian conducted another two concerts of Ara Gevorgian and the Silantiev State Grand Academic Orchestra (Moscow, Russia) in the Moscow Kremlin Grand Hall. On 18th May 2007 Karen Durgarian with the Orchestra del Teatro Carlo Felice has performed masterpieces by Prokofiev, Shostakovich and Arutyunian in Genoa, Italy. In 2008 Karen Durgarian was invited to the Mikhailovsky Theatre, where he became musical director of two ballet productions — Spartacus by Aram Khachaturian and Romeo and Juliet by Sergey Prokofiev.
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.