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 (590152,590523,590560,590695,591772,592144,592181,592316,593411,593783,593820,593955,595118,595491,595526,595663,596815,597188,597223,597360,598504,598875,598910,599045,600177,600550,600585,600722,601861,602232,602267,602402,603530,603903,603938,604075,605196,605566,605602,605737,606847,607220,607255,607392,608492,608865,608900,609037,610130,610509,610546,610686,611814,612193,612230,612370,613491,613870,613907,614047,615158,615537,615574,615714,616812,617190,617229,617367,618455,618834,618871,619011,620088,620467,620504,620644,621714,622092,622131,622269,623334,623713,623750,623890,624944,625342,625379,625519,626565,626963,627000,627140,628176,628574,628611,628751,629776,630174,630211,630351,631369,631767,631804,631944,632956,633354,633391,633531,634534,634932,634969,635109,636101,636499,636536,636676,637659,638057,638094,638234,639208,639604,639641,639779,640741,641139,641176,641316,642272,642664,642700,642838,643789,644180,644216,644355,645298,645691,645728,645866,646801,647195,647231,647371,648296,648690,648726,648866,649795,650189,650225,650365,651283,651677,651713,651853,652764,653158,653194,653334,654236,654630,654666,654806,655697,656091,656127,656267,657148,657542,657578,657718,658603,658997,659033,659173,660045,660439,660476,660614,661478,661872,661908,662048,662902,663296,663332,663472,664319,664713,664749,664889,665729,666123,666159,666299,667169,667563,667600,667739,668600,668992,669028,669168,670041,670433,670469,670609,671473,671865,671901,672041,672897,673289,673325,673465,674308,674700,674736,674876,675710,676102,676138,676278,677103,677494,677530,677669,678482,678884,678935,679083,679883,680285,680336,680484,681275,681677,681728,681876,682657,683059,683110,683258,684029,684431,684482,684630,685388,685783,685834,685982,687123,687174,687322,688430,688481,688629,689729,689780,689928,691015,691066,691214,692291,692342,692490,693558,693609,693757,694813,694864,695012,696052,696103,696251,697278,697329,697477,698491,698542,698690,699693,699744,699892,700887,700938,701086,702077,702128,702283,703269,703320,703475,704450,704501,704656,705618,705667,705820,706768,706817,706970,707907,707956,708109,709034,709083,709236,710152,710201,710389,711300,711349,711537,712438,712487,712676,713572,713621,713807,714691,714740,714929,715800,715849,716038,716898,716947,717136,717986,718035,718224,719064,719113,719302,720130,720179,720368,721185,721234,721423,722243,722292,722481,723305,723354,723543,724357,724406,724595,725400,725449,725638,726433,726482,726671,727459,727508,727697,728476,728525,728714,729483,729532,729721,730483,730532,730721,731475,731524,731713,732462,732511,732700,733456,733505,733694,734443,734492,734681,735422,735471,735660,736389,736438,736627,737361,737410,737599,738325,738374,738563,739284,739332,739520,740230,740279,740468,742198,742249,742435,744171,744222,744408,746136,746186,746374,748097,748148,748343,750079,750130,750325,752061,752112,752307,754940,754991,755186,757813,757864,758059,760679,760730,760925,763543,763592,763789,766402,766451,766648,769254,769304,769502,772100,772150,772348,774940,774990,775188,777775,777824,778023,780606,780656,780855,783441,783490,783688,786271,786320,786520,789097,789146,789346,791919,791968,792168,794738,794787,794982,797548,797596,797788,800352,800401,800593,803152,803202,803395,805949,805998,806190,808738,808787,808979,811521,811570,811762,814300,814349,814541,817074,817123,817315,819841,819890,820082,822599,822649,822842,825352,825401,825593,828098,828147,828339,830839,830888,831080,833578,833627,833819,836309,836359,836552,839040,839089,839280,841764,841814,842005,844484,844533,844724,847223,847273,847463,849956,850006,850196,852685,852735,852925,855415,855465,855655,858140,858190,858380,860860,860910,861100,863572,863622,863812,866272,866323,866513,868962,869012,869203,871646,871697,871887,871906,874329,874379,874576,874591,877009,877059,877251,877270,879693,879743,879935,879954,882373,882423,882615,882634,882887,885056,885106,885298,885318,885570,887726,887776,887970,887990,888242,890391,890441,890633,890653,890905,893051,893100,893293,893312,893567,895709,895759,895951,895970,896223,898358,898408,898602,898622,898874,901005,901054,901246,901266,901517,903690,903883,903902,904155,906314,906507,906525,906779,908929,909122,909141,909392,911541,911735,911755,912006,912198,914178,914372,914392,914643,914835,916888,917082,917101,917353,917544,919587,919780,919800,920052,920242,922275,922469,922486,922738,922928,924975,925168,925186,925438,925628,927664,927858,927877,928128,928345,930377,930571,930590,930841,931059,933082,933278,933297,933552,933770,935987,936006,936261,936479,938709,938731,938995,939213,941434,941454,941719,941937,944147,944167,944432,944650,946850,946871,947139,947354,949554,949578,949847,950064,952259,952279,952550,952768,954953,954977,955246,955463,957636,957656,957928,958146,960297,960317,960589,960807,962944,962970,963238,963454,965585,965603,965874,966092,968219,968237,968509,968727,970848,970872,971142,971359,973471,973495,973765,973982,976088,976107,976379,976597,978701,978720,978994,979210,981299,981318,981592,981808,983888,983907,984179,984396,986516,986534,986806,987024,989138,989155,989428,989646,991751,991775,992044,992262,994362,994381,994653,994874,996961,996980,997252,997473,999548,999568,999840,1000061,1002130,1002150,1002422,1002643,1004709,1004733,1005002,1005223,1007278,1007302,1007571,1007794,1009842,1009862,1010135,1010357,1012393,1012417,1012686,1012942,1014965,1014984,1015257,1015512,1017519,1017543,1017812,1018068,1020066,1020090,1020359,1020615,1022611,1022630,1022906,1023161,1025149,1025173,1025444,1025700,1027680,1027704,1027979,1028235,1030206,1030225,1030509,1030765,1032716,1032740,1033020,1033276,1035211,1035235,1035515,1035771,1037700,1037720,1038003,1038262,1040185,1040205,1040488,1040748,1042663,1042683,1042966,1043228,1045153,1045437,1045699,1047616,1047898,1048160,1050066,1050349,1050611,1052784,1053047,1055213,1055475,1057639,1057901,1060058,1060314,1062462,1062719,1064860,1065116,1067248,1067503,1069621,1069878,1071988,1072250,1074386,1074648,1076772,1077034,1079148,1079410,1081513,1081775,1083865,1084127,1086203,1086464,1088526,1088787,1090861,1091122,1093188,1093449,1095503,1095764,1097803,1098064,1100086,1100347,1102358,1102619,1104616,1104876,1106854,1107114,1109070,1109330,1111266,1111525,1113442,1113702,1115599,1115860,1117741,1118001,1119876,1120135,1122006,1122270,1124144,1124408,1126339,1126603,1128537,1128831,1130750,1131044,1132947,1133240,1135135,1135436,1137340,1137643,1139542,1139841,1141736,1142036,1143924,1144222,1146100,1146397,1148264,1148561,1150419,1150715,1152570,1152866,1154718,1155012,1156852,1157151,1159022,1159318,1161177,1161473,1163317,1163612,1165449,1165745,1167586,1167881,1169716,1170012,1172134,1174248,1176394,1178529,1180657,1182776,1184886,1186999,1189104,1191203,1193291,1195370,1197446,1199511,1201572,1203627,1205675,1207712,1209740,1211780,1213810,1215832,1217841,1219835,1221818,1223794,1225765,1227758,1229772,1231782,1233778,1235764,1237746,1239714,1241670,1243653,1245627,1247589,1249571,1251549,1253530,1255506,1257474,1259434,1261381,1263315,1265240,1267170,1269090,1270999,1272897,1274781,1276649,1278505,1280360,1282202,1284035,1285859,1287670,1289464,1291249,1293059,1294861,1401577,1403319,1405052,1406776,1408496,1410233,1411960,1413729,1415489,1417237,1418974,1420701,1422418,1424121,1425810,1427484,1429148,1430798,1432438,1434069,1435685,1437302,1438923,1440531,1442133,1443727,1445311,1446884,1448448,1450000,1451540,1453070,1454590,1456108,1457613,1459105,1460584,1462050,1463506,1464952,1466384,1467806,1469215,1470609,1471990,1473358,1474717,1476063,1477414,1478762,1480146,1481518,1482879,1484235,1485579,1486914,1488238,1489544,1490839,1492125,1493439,1494744,1496041,1497336,1498639,1499932,1501215,1502491,1503759,1505020,1506273,1507520,1508757,1509985,1511207,1512432,1513660,1514881,1516104,1517319,1518525,1519724,1520920,1522110,1523293,1524468,1525636,1526797,1527952,1529101,1530246,1531387,1532524,1533656,1534784,1535908,1537027,1538140,1539277,1540407,1541532,1542651,1543762,1544867,1545965,1547050,1548123,1549186,1550242,1551290,1552329,1553370,1554405,1555432,1556450,1557460,1558468,1559466,1560824,1562173,1564016,1565849,1567675,1570595,1573488,1576370,1579246,1582104,1584951,1587792,1590624,1593449,1596306,1599177,1602039,1604885,1607725,1610561,1613386,1892842,1894914,1896997,1899132,1901280,1903417,1905543,1907687,1908493,1909846,1910650,1911995,1912798,1914156,1914965,1916376,1917181,1918582,1919388,1920782,1921587,1922979,1923784,1925185,1926036,1928284,1930519,1932738,1934945,1937143,1939337,1941520,1943696,1945860,1948017,1950157,1952291,1954421,1956500,1958569,1960628,1962671,1964701,1966727,1968748,1970761,1972774,1974779,1976772,1978750,1980748,1982744,1984733,1986715,1988689,1990650,1992598,1994537,1996470,1998396,2000315,2002224,2004120,2006003,2007890,2009779,2011663,2013533,2015378,2017210,2019028,2020838,2022643,2024440,2026438,2028433,2030418,2032390,2034352,2036311,2038263,2040206,2042135,2044053,2045957,2047851,2049739,2051617,2053486,2055444,2057483,2059522,2061553,2063577,2065592,2067599,2069597,2071596,2073583,2075558,2077527,2079531,2081527,2083514,2085446,2087368,2089280,2091187,2093088,2094978,2096857,2098722,2100683,2102634,2104595,2106550,2108494,2110429,2112353,2114265,2116168,2118063,2119950,2121827,2123694,2125546,2127387,2129221,2131047,2132863,2134670,2136466,2138248,2140091,2141925,2143750,2145564,2147368,2149162,2150942,2152709,2154467,2156216,2157954,2159681,2161435,2163174,2164903,2166620,2168323,2170014,2170798,2171577,2172347,2173110,2173868,2174621,2175366,2176115,2177724,2179325,2180911,2182484,2184045,2185596,2187138,2188677,2190209,2191728,2193240,2194740,2196269,2197794,2199314,2200843,2202391,2203926,2205453,2206978,2208500,2210011,2211510,2213215,2214910,2216595,2218381,2220622,2222854,2225076,2227283,2229479,2231664,2233842,2236254,2238873,2241781,2244952,2248115,2251268,2254413,2257549,2260675,2263792,2266898,2269996,2273093,2276202,2279343,2282477,2285623,2288761,2291891,2295012,2298129,2301250,2304377,2307521,2310689,2313852,2317011,2320165,2323314,2326452,2329582,2332693,2335795,2338891,2341987,2345094)) 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





	Vladimir Andropov (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Vladimir Andropov (Conductor)

Vladimir Andropov (Conductor)

Biography
Born in the town of Khmelnitsky, in the Ukraine. In 1968, he completed his studies at the orchestra faculty of the Lvov State Conservatoire. From 1968-71, he taught at the Byelorussian State Conservatoire. In 1974, he completed his studies with distinction at the opera-symphony conducting faculty of the Byelorussian Conservatoire. From 1974-76, he was probationer-conductor with the Byelorussian State Symphony Orchestra and conductor of an Opera Studio attached to the Conservatoire. In 1977, he finished with distinction his postgraduate work at the Byelorussian Conservatoire, conducting to great acclaim, a performance of Iolanta at the National Academic Bolshoi Theatre in Minsk. From 1976-78, he worked as music editor for Byelorusfilm Studios.

In 1978, Vladimir Andropov joined the Bolshoi Theatre as conductor and artistic director of the Theatre’s stage orchestra. His professional and organizational abilities, enabled him to create a first-class stage orchestra and to prepare with it an extensive concert repertoire of classical and contemporary works by a variety of different composers, and belonging to different ages and genres. In recent times, the Orchestra has performed with great success, giving independent concerts at the Bolshoi Theatre, as well as at many other concert venues in Russia and abroad.

From 2000-02, Vladimir Andropov was artistic director of the Bolshoi Theatre Opera Company.

He has a wide-ranging repertoire of operas and ballets which includes the operas: Oprichnik, Evgeny Onegin and Iolanta by Tchaikovsky, Dargomyzhsky’s Rusalka, Rimsky-Korsakov’s Mozart and Salieri and The Tsar’s Bride, Mussorgsky’s Boris Godunov, Paisello’s La Molinara, Verdi’s Nabucco and Forza del destino, Puccini’s Tosca, Prokofiev’s The Love of the Three Oranges; - and the ballets: The Hump-backed Horse by Rodion Shchedrin and Cipollino by Karen Khachaturyan.

At the Bolshoi Theatre he conducted the opera La Molinara and the ballets Sleeplessness by Sergei Zhukov and Roland Petit’s La Dame de Pique to music by Tchaikovsky and Passacaille to music by Anton von Webern.

In 1988, Andropov conducted the first ever recording of Evstignei Fomin’s opera The Americans.

Since 2003, Vladimir Andropov has been artistic director of the Astrakhan State Music Theatre.

In 2001, he was a recipient of the Order of Friendship.