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 (495394,579462,580800,582129,582137,583459,583467,584779,584786,586092,586099,587401,587408,588703,588710,590057,590071,591677,591691,593317,593329,595024,595037,596721,596734,598408,598417,600083,600096,601765,601774,603436,603449,605099,605109,606753,606766,608398,608411,610036,610049,611720,611733,613398,613410,615065,615077,616720,616733,618362,618374,619995,620007,621623,621635,623241,623253,624851,624863,626472,626484,628083,628095,629683,629695,631276,631288,632863,632875,634441,634453,636008,636020,637566,637578,639113,639123,640648,640660,642177,642186,643692,643703,645202,645213,646708,646720,648203,648215,649702,649714,651190,651202,652671,652683,654143,654155,655604,655616,657067,658522,712354,712555,712569,713486,713687,713702,714607,714808,714822,715716,715917,715931,716814,717015,717029,717902,718103,718117,718980,719181,719195,720046,720247,720261,721101,721302,721316,722159,722360,722374,723221,723422,723436,724273,724474,724488,725316,725517,725531,726349,726550,726564,727374,727576,727590,728391,728593,728607,729398,729600,729614,730398,730600,730614,731390,731592,731606,732377,732579,732593,733371,733573,733587,734358,734560,734574,735337,735539,735553,736304,736506,736520,737276,737478,737492,738240,738442,738456,739196,739397,739414,740144,740344,740358,742113,742313,742324,744086,744286,744297,746051,746250,746262,748014,748213,748224,749996,750195,750206,751978,752177,752188,754857,755056,755066,757730,757929,757939,760596,760795,760806,763460,763661,763676,766319,766520,766535,769171,769369,769382,772017,772215,772227,774857,775054,775066,777692,777889,777901,780523,780720,780733,783358,783559,783574,786188,786385,786398,789014,789211,789224,791836,792033,792047,794655,794847,794859,797464,797656,797668,800268,800461,800473,803070,803266,803280,805864,806058,806071,808653,808847,808859,811435,811631,811641,814214,814410,814420,816988,817184,817194,819754,819950,819961,822516,822713,822727,825265,825461,825472,828011,828207,828218,830752,830949,830959,833491,833688,833698,836423,836437,839150,839160,841874,841885,844594,844604,847332,847343,850065,850076,852794,852805,855524,855535,858249,858260,860970,860980,863681,863692,866382,866393,869072,869083,871756,871767,874443,874450,877118,877129,879803,879813,882486,882493,885165,885176,887840,887854,890501,890511,893164,893171,895818,895829,898472,898486,901113,901124,903750,903761,906373,906384,908989,909000,911605,911619,914242,914256,916948,916959,919646,919658,922332,922343,925032,925044,927724,927737,930437,930449,933143,933155,935851,935864,938564,938573,941287,941296,943998,944009,946704,946716,949408,949424,952107,952119,954807,954823,957485,957497,960146,960159,962793,962807,965431,965445,968063,968078,970701,970717,973339,975947,1072118,1072130,1074519,1074529,1076906,1076916,1079282,1079292,1081643,1081655,1083995,1084007,1086333,1086345,1088656,1088668,1090994,1091004,1093317,1093329,1095636,1095646,1097936,1097946,1100216,1100227,1102488,1102499,1104745,1104757,1106982,1106993,1109198,1109210,1111392,1111404,1113569,1113581,1115732,1115742,1117873,1117884,1120007,1120018,1122139,1122150,1124277,1124288,1126472,1126483,1128686,1128695,1130899,1130908,1133094,1133104,1135285,1135296,1137493,1137503,1139692,1139703,1141888,1141897,1144073,1144085,1146250,1146261,1148414,1148425,1150569,1150580,1152720,1152731,1154865,1154875,1157004,1157014,1159170,1159181,1161325,1161336,1163467,1163477,1165597,1165609,1167736,1167746,1169865,1169877,1171987,1171999,1174103,1174113,1176249,1176259,1178384,1178394,1180512,1180522,1182631,1182641,1184741,1184751,1186849,1186860,1188955,1188966,1189318,1189326,1191054,1191065,1191416,1191425,1193142,1193153,1193505,1193518,1195221,1195232,1195584,1195597,1197297,1197308,1197660,1197673,1199366,1199376,1199728,1199742,1201427,1201437,1201789,1201803,1203479,1203489,1203852,1203864,1205530,1205540,1205900,1205914,1207567,1207577,1207937,1207951,1209596,1209606,1209979,1209993,1211633,1211644,1212020,1212033,1213666,1213676,1214050,1214065,1215688,1215698,1216072,1216087,1217697,1217707,1218081,1218096,1219691,1219701,1220075,1220090,1221674,1221684,1222058,1222073,1223650,1223660,1224034,1224049,1225621,1225631,1226005,1226020,1227614,1227624,1227998,1228013,1229628,1229638,1230015,1230030,1231637,1231648,1232024,1232035,1233634,1233644,1234021,1234036,1235621,1235630,1236008,1236022,1237602,1237612,1237988,1238002,1239580,1239956,1239970,1241536,1241912,1241926,1243895,1243909,1245868,1245881,1247829,1247841,1249813,1249827,1251791,1251805,1253772,1253786,1255748,1255762,1257716,1257730,1259676,1259690,1261623,1261637,1263557,1263571,1265482,1265496,1267412,1267426,1269332,1269346,1271241,1271255,1273139,1273153,1275023,1275037,1276889,1276901,1278747,1278761,1280603,1280610,1282442,1282454,1284277,1284291,1286101,1286115,1287912,1287926,1289706,1289720,1291491,1291505,1293301,1293315,1295103,1295117,1296898,1296912,1298684,1298698,1300455,1300469,1302214,1302226,1303963,1303977,1305711,1305725,1307451,1307465,1309181,1309195,1310899,1310913,1312818,1312832,1314735,1314749,1316669,1316683,1318596,1318610,1320515,1320529,1322424,1322438,1324326,1324340,1326213,1326227,1328082,1328095,1329942,1329956,1331829,1331843,1333706,1333720,1335573,1335587,1337429,1337443,1339274,1339288,1341104,1341118,1342921,1342935,1344730,1344744,1346537,1346551,1348334,1348348,1350124,1350138,1352029,1352043,1353921,1353935,1355802,1355816,1357673,1357687,1359534,1359548,1361386,1361400,1363229,1363243,1365061,1365075,1366880,1366894,1368689,1368703,1370493,1370507,1372286,1372300,1374066,1374080,1375926,1375940,1377769,1377783,1379598,1379612,1381416,1381430,1383232,1383246,1385039,1385053,1386857,1388651,1424003,1424012,1425692,1425701,1427366,1427375,1429030,1429039,1430680,1430689,1432320,1432329,1433951,1433960,1435567,1435576,1437172,1437181,1438793,1438802,1440401,1440410,1442002,1442011,1443596,1443605,1445180,1445189,1446753,1446762,1448317,1448326,1449869,1449878,1451409,1451418,1452939,1452948,1454459,1454468,1455968,1455977,1457470,1457479,1458961,1458970,1460440,1460449,1461906,1461915,1463362,1463371,1464808,1464817,1466240,1466249,1467662,1467671,1469071,1469080,1470465,1470474,1471846,1471855,1473214,1473223,1474573,1474582,1475919,1475928,1477270,1477279,1478618,1478627,1480002,1480011,1481374,1481383,1482735,1482744,1483037,1483050,1484091,1484100,1484393,1484406,1485435,1485444,1485737,1485750,1486770,1486779,1487072,1487085,1488094,1488103,1488396,1488409,1489400,1489409,1489702,1489715,1490695,1490704,1490997,1491010,1491981,1491990,1492283,1492296,1493295,1493304,1493597,1493610,1494600,1494609,1494902,1494915,1495897,1495906,1496199,1496212,1497189,1497198,1497496,1497510,1498492,1498501,1498799,1498813,1499785,1499794,1500092,1500106,1501068,1501077,1501375,1501389,1502344,1502353,1502651,1502665,1503612,1503621,1503919,1503933,1504873,1504882,1505180,1505194,1506126,1506135,1506433,1506447,1507373,1507382,1507680,1507694,1508610,1508619,1508917,1508931,1509838,1509847,1510145,1510159,1511060,1511069,1511375,1511391,1512285,1512294,1512600,1512616,1513513,1513522,1513828,1513844,1514734,1514743,1515049,1515065,1515957,1515966,1516272,1516288,1517172,1517181,1517487,1517503,1518378,1518387,1518693,1518709,1519577,1519586,1519896,1519912,1520773,1520782,1521092,1521108,1521963,1521972,1522282,1522298,1523146,1523155,1523465,1523481,1524321,1524330,1524640,1524656,1525489,1525498,1525808,1525824,1526650,1526659,1526969,1526985,1527805,1527814,1528124,1528140,1528954,1528963,1529273,1529289,1530099,1530108,1530418,1530434,1531240,1531249,1531559,1531575,1532378,1532385,1532696,1532706,1533510,1533517,1533828,1533838,1534638,1534645,1534956,1534966,1535762,1535769,1536080,1536090,1536881,1536888,1537199,1537209,1537994,1538001,1538312,1538322,1539131,1539138,1539449,1539459,1540261,1540268,1540579,1540589,1541386,1541393,1541704,1541714,1542505,1542512,1542823,1542833,1543623,1543934,1543944,1544728,1545039,1545049,1546137,1546147,1547222,1547232,1548295,1548305,1549358,1549368,1550414,1550430,1551462,1551478,1552501,1552517,1553542,1553558,1553579,1553639,1554577,1554593,1554614,1554676,1555604,1555620,1555641,1555703,1556622,1556638,1556659,1556721,1557632,1557648,1557669,1557731,1558640,1558656,1558677,1558739,1559638,1559654,1559675,1559737,1560996,1561012,1561033,1561095,1562345,1562361,1562382,1562444,1564188,1564204,1564225,1564287,1566021,1566037,1566058,1566120,1567845,1567859,1567878,1567939,1570766,1570778,1570803,1570865,1573658,1573670,1573695,1573757,1576542,1576557,1576578,1576640,1579414,1579428,1579448,1579511,1582276,1582291,1582312,1582374,1585123,1585138,1585159,1585221,1587962,1587977,1587994,1588058,1590796,1590811,1590832,1590894,1593621,1593636,1593657,1593719,1596478,1596493,1596514,1596572,1599349,1599364,1599385,1599443,1602208,1602223,1602241,1602301,1605057,1605072,1605093,1605151,1607894,1607909,1607930,1607991,1610732,1610747,1610764,1610824,1613557,1613572,1613589,1613649,1616371,1616384,1616410,1616468,1619179,1619194,1619215,1619273,1621966,1621979,1622004,1622063,1624745,1624760,1624781,1624839,1627514,1627529,1627550,1627608,1630271,1630285,1630304,1630366,1633017,1633031,1633051,1633113,1635816,1635829,1635854,1635912,1638647,1638662,1638683,1638741,1641488,1641503,1641524,1641582,1644313,1644328,1644348,1644409,1647114,1647121,1647127,1647142,1647161,1647218,1647223,1647228,1647333,1647334,1647374,1647376,1649927,1649937,1649938,1649951,1649977,1650030,1650034,1650039,1650142,1650144,1650184,1650185,1652796,1652806,1652807,1652820,1652846,1652899,1652904,1652908,1653011,1653013,1653052,1653053,1655655,1655664,1655670,1655685,1655706,1655758,1655764,1655768,1655875,1655876,1655911,1655912,1658503,1658512,1658518,1658533,1658554,1658606,1658612,1658616,1658723,1658724,1658759,1658760,1661340,1661349,1661355,1661370,1661391,1661443,1661449,1661453,1661560,1661561,1661596,1661597,1664163,1664172,1664178,1664193,1664214,1664266,1664272,1664276,1664383,1664384,1664419,1664420,1666975,1666985,1666991,1667005,1667026,1667080,1667085,1667089,1667197,1667198,1667230,1667231,1669782,1669791,1669797,1669812,1669833,1669885,1669891,1669895,1670002,1670003,1670038,1670039,1672641,1672650,1672656,1672671,1672692,1672744,1672750,1672754,1672861,1672862,1672897,1672898,1675493,1675502,1675508,1675523,1675544,1675596,1675602,1675606,1675713,1675714,1675749,1675750,1678340,1678350,1678353,1678366,1678387,1678441,1678446,1678450,1678560,1678562,1678595,1678596,1681176,1681185,1681192,1681207,1681224,1681279,1681285,1681290,1681390,1681391,1681434,1681435,1684004,1684014,1684018,1684033,1684051,1684107,1684111,1684116,1684224,1684225,1684268,1684269,1686821,1686830,1686836,1686851,1686872,1686924,1686930,1686934,1687063,1687064,1687107,1687108,1689676,1689686,1689691,1689704,1689725,1689778,1689782,1689787,1689916,1689917,1689968,1689970,1692530,1692539,1692545,1692560,1692581,1692633,1692639,1692643,1692772,1692773,1692816,1692817,1695296,1695303,1695311,1695326,1695348,1695399,1695403,1695409,1695532,1695534,1695583,1695584,1698057,1698066,1698072,1698087,1698108,1698160,1698166,1698170,1698300,1698301,1698344,1698345,1700810,1700819,1700825,1700840,1700861,1700913,1700919,1700923,1701053,1701054,1701097,1701098,1703554,1703563,1703569,1703584,1703605,1703657,1703663,1703667,1703797,1703798,1703841,1703842,1706291,1706299,1706304,1706318,1706343,1706396,1706400,1706406,1706532,1706533,1706584,1706585,1709070,1709075,1709090,1709114,1709166,1709171,1709177,1709303,1709304,1709355,1709356,1711834,1711840,1711855,1711876,1711928,1711934,1711938,1712068,1712069,1712112,1712113,1714624,1714639,1714660,1714712,1714718,1714722,1714852,1714853,1714896,1714897,1717414,1717435,1717487,1717493,1717497,1717627,1717628,1717671,1717672,1720176,1720197,1720249,1720255,1720259,1720389,1720390,1720433,1720434,1722944,1722996,1723001,1723006,1723131,1723133,1723181,1723182,1725685,1725737,1725743,1725747,1725877,1725878,1725921,1725922,1728420,1728472,1728478,1728482,1728612,1728613,1728656,1728657,1731146,1731198,1731204,1731208,1731338,1731339,1731382,1731383,1733854,1733906,1733912,1733916,1734046,1734047,1734090,1734091,1736605,1736611,1736615,1736745,1736746,1736789,1736790,1739293,1739299,1739303,1739433,1739434,1739477,1739478,1741967,1741973,1741977,1742107,1742108,1742151,1742152,1744631,1744637,1744641,1744771,1744772,1744815,1744816,1747289,1747295,1747299,1747429,1747430,1747473,1747474,1749938,1749944,1749948,1750078,1750079,1750122,1750123,1752580,1752586,1752590,1752720,1752721,1752764,1752765,1755213,1755219,1755223,1755353,1755354,1755397,1755398,1757835,1757840,1757845,1757974,1757975,1758028,1758029,1760446,1760450,1760455,1760583,1760584,1760636,1760637,1763050,1763055,1763061,1763183,1763184,1763234,1763235,1765649,1765655,1765659,1765789,1765790,1765833,1765834,1768247,1768251,1768382,1768383,1768426,1768427,1770836,1770967,1770968,1771011,1771012,1773543,1773544,1773587,1773588,1776117,1776118,1776161,1776162,1778676,1778677,1778720,1778721,1781225,1781226,1781269,1781270,1783726,1783727,1783753,1783754,1783767,1783768,1783811,1783812,1786258,1786259,1786285,1786286,1786299,1786300,1786343,1786344,1788763,1788764,1788790,1788791,1788804,1788805,1788848,1788849,1791257,1791258,1791284,1791285,1791298,1791299,1791342,1791343,1793733,1793734,1793760,1793761,1793774,1793775,1793818,1793819,1796190,1796191,1796217,1796218,1796231,1796232,1796275,1796276,1798635,1798636,1798662,1798663,1798672,1798675,1798726,1798728,1801093,1801094,1801120,1801121,1801134,1801135,1801178,1801179,1803565,1803566,1803579,1803580,1803623,1803624,1805990,1805991,1806004,1806005,1806048,1806049,1808415,1808416,1808455,1808456,1810858,1810859,1813212,1813213,1815561,1815562,1817893,1817894,1836085,1838273,1840453,1842613,1844758,1846914,1849067,1851216,1853359,1855495,1857628,1859750,1861866,1863980,1866089,1868179,1870264,1872337,1874397,1876451,1878504,1880577,1882641,1884696,1886773,1888835,1890895,1892976,1895066,1897162,1899297,1901445,1903582,1905709,1907853,1910010,1912160,1914322,1916541,1918747,1920947,1923144,1925350,1927598,1929833,1932052,1934260,1936458,1938651,1940836,1943011,1945175,1947328,1949469,1951603,1953735,1955814,1957883,1959943,1961984,1964018,1966039,1968058,1970078,1972091,1974089,1976081,1978060,1980035,1982026,1984020,1986003,1987973,1989934,1991882,1993821,1995752,1997681,1999600,2001509,2094513,2096392,2098257,2100218,2102169,2104130,2106085,2108031,2109966,2110147,2110160,2111890,2112071,2112084,2113802,2113983,2113996,2115705,2115711,2115886,2115899,2115916,2117600,2117606,2117608,2117781,2117794,2117811,2119487,2119493,2119495,2119668,2119681,2119698,2121364,2121370,2121372,2121545,2121558,2121575,2123237,2123239,2123412,2123425,2123442,2125264,2125277,2125294,2127105,2127118,2127135,2128939,2128952,2128969,2130765,2130778,2130795,2132581,2132594,2132611,2134388,2134401,2134418,2136182,2136195,2136212,2137960,2137975,2137990,2139809,2139822,2139839,2141643,2141656,2141673,2143468,2143481,2143498,2145282,2145295,2145312,2147086,2147099,2147116,2148880,2148893,2148910,2150660,2150673,2150690,2152427,2152440,2152457,2154185,2154198,2154215,2155934,2155947,2155964,2157672,2157685,2157702,2159399,2159412,2159429,2161153,2161166,2161183,2162892,2162905,2162922,2164621,2164634,2164651,2166342,2166355,2166372,2168045,2168058,2168075,2169736,2169749,2169766,2170520,2170533,2170550,2171299,2171312,2171329,2172069,2172082,2172099,2172832,2172845,2172862,2173590,2173603,2173620,2174343,2174356,2174373,2175101,2175118,2175847,2175862,2177456,2177471,2179072,2180658,2216903,2216913,2218689,2218699,2220930,2220940,2223162,2223172,2225382,2225392,2227589,2227599,2229785,2229795,2231970,2231980,2234148,2234158,2236557,2236567,2239176,2239186,2242085,2242095,2245256,2245266,2248419,2248429,2251572,2251582,2254717,2254727,2257853,2257863,2260979,2260989,2264095,2264106,2267201,2267212,2270299,2270310,2273409,2273420,2276517,2276528,2279658,2279669,2282792,2282803,2285938,2285949,2289076,2289087,2292206,2292217,2295327,2295338,2298442,2298454,2301563,2301575,2304690,2304702,2307834,2307846,2311002,2311014,2314165,2314177,2317324,2317336,2320478,2320490,2323311,2323321,2323328,2323626,2323638,2326449,2326459,2326466,2326764,2326776,2329579,2329589,2329596,2329894,2329906,2332690,2332700,2332707,2333005,2333017,2335792,2335802,2335809,2336107,2336119,2338888,2338898,2338905,2339210,2339222,2341984,2341994,2342001,2342306,2342318,2345101,2345108,2345413,2345425,2348200,2348207,2348512,2348524,2351303,2351608,2351620,2354727,2354739,2357834,2357846,2360936,2360948,2364031,2364043,2367116,2367128,2370190,2370202,2373255,2373267,2376305,2376317,2379343,2379355,2382375,2382387,2385402,2385414,2388417,2388429,2391479,2391491,2394535,2394547,2397578,2397590,2400607,2400619,2403625,2403637,2406639,2406651,2409644,2409656,2412639,2412651,2415626,2415638,2418640,2418652,2421642,2421654,2424633,2424645,2427619,2427631,2430596,2430608,2433564,2433576,2436523,2436535,2439469,2439481,2442404,2442416,2445330,2445342,2445359,2448251,2448263,2448280,2451161,2451173,2451190,2454064,2454076,2454093,2456948,2456960,2456977,2459827,2459839,2459856,2462691,2462703,2462720,2465546,2465558,2465575,2468423,2468435,2468452,2471361,2471373,2471390,2474275,2474287,2474304,2477218,2477230,2477247,2480150,2480162,2480179,2483068,2483080,2483097,2485976,2485988,2486005,2488879,2488891,2488908,2491812,2491824,2491841,2494736,2494748,2494765,2497650,2497662,2497679,2500551,2500563,2500580,2503439,2503451,2503468,2506315,2506327,2506344,2509148,2509155,2509182,2509194,2509211,2512009,2512016,2512043,2512055,2512072,2514864,2514871,2514898,2514910,2514927,2515132,2515138,2517714,2517721,2517748,2517760,2517777,2517982,2517988,2520557,2520564,2520591,2520603,2520620,2520825,2520831,2523389,2523396,2523423,2523435,2523452,2523657,2523663,2526209,2526216,2526243,2526255,2526272,2526477,2526483,2529022,2529029,2529056,2529068,2529085,2529290,2529296,2531837,2531864,2531876,2531893,2532098,2532104,2534638,2534665,2534677,2534694,2534899,2534905,2537458,2537470,2537487,2537693,2537699,2540252,2540264,2540281,2540487,2540493,2543036,2543048,2543065,2543271,2543277,2545809,2545821,2545838,2546044,2546050,2548574,2548586,2548603,2548810,2548816,2551378,2551390,2551408,2551615,2551621,2551657,2551662,2551678,2551684,2551813,2554186,2554204,2554411,2554417,2554453,2554458,2554474,2554480,2554609,2556997,2557015,2557222,2557228,2557264,2557269,2557285,2557291,2557420,2559816,2560025,2560031,2560067,2560072,2560088,2560094,2560223,2562605,2562814,2562820,2562856,2562861,2562877,2562883,2563012,2565592,2565593,2565636,2565637,2565657,2565658,2565786,2568358,2568359,2568402,2568403,2568423,2568424,2568552,2571186,2571192,2571228,2571233,2571249,2571255,2571385,2574008,2574014,2574050,2574055,2574071,2574077,2574207,2576822,2576828,2576864,2576869,2576885,2576891,2577021,2579624,2579630,2579667,2579674,2579692,2579700,2579830,2582421,2582427,2582464,2582471,2582489,2582497,2582627,2585203,2585209,2585246,2585253,2585271,2585279,2585409,2587974,2587980,2588017,2588024,2588042,2588050,2588180,2590742,2590748,2590785,2590792,2590810,2590818,2590948,2593501,2593507,2593544,2593551,2593569,2593577,2593707,2596252,2596258,2596295,2596302,2596320,2596328,2596458,2598994,2599000,2599037,2599044,2599062,2599070,2599200,2601723,2601729,2601766,2601773,2601791,2601799,2601929,2604439,2604445,2604482,2604489,2604507,2604515,2604645,2607146,2607152,2607189,2607196,2607214,2607222,2607352,2609849,2609855,2609892,2609899,2609917,2609925,2610055,2612543,2612549,2612586,2612593,2612611,2612619,2612749,2615267,2615273,2615310,2615317,2615335,2615343,2615473,2617984,2617990,2618027,2618034,2618052,2618060,2618190,2620691,2620697,2620734,2620741,2620759,2620767,2620897,2623383,2623389,2623426,2623433,2623451,2623459,2623589,2626064,2626070,2626107,2626114,2626132,2626140,2626270,2628745,2628751,2628788,2628795,2628813,2628821,2628951,2631410,2631416,2631453,2631460,2631478,2631486,2631616,2634077,2634083,2634120,2634127,2634145,2634153,2634283,2636723,2636729,2636766,2636773,2636791,2636799,2636929,2639357,2639363,2639400,2639407,2639425,2639433,2639563,2641978,2641984,2642021,2642028,2642046,2642054,2642184,2644587,2644593,2644630,2644637,2644655,2644663,2644793,2647188,2647194,2647231,2647238,2647256,2647264,2647394,2649776,2649782,2649819,2649826,2649844,2649852,2649982,2652355,2652361,2652398,2652405,2652423,2652431,2652561,2654922,2654928,2654965,2654972,2654990,2654998,2655128,2657474,2657480,2657517,2657524,2657542,2657550,2657680,2660051,2660058,2660076,2660084,2660214,2662566,2662573,2662591,2662599,2662729,2665067,2665074,2665092,2665100,2665230,2667554,2667561,2667579,2667587,2667717,2670042,2670050,2670180,2672493,2672501,2672631,2675062,2677474,2679866,2682242,2684609,2686971,2689326,2689349,2691670,2691693,2693998,2694021,2696343,2696373,2699428,2699458,2702498,2702529,2705574,2705605,2708621,2708652,2711664,2711695,2714695,2714726,2717715,2717746,2720780,2720811,2723888,2723919,2726987,2727018,2730074,2730105,2733173,2733204,2736307,2739394,2742471,2745531,2908355,2908403,2910972,2911020,2913570,2913618,2916158,2916206,2918748,2918796,2921321,2921369,2923886,2923934,2926440,2926488,2928976,2929024,2931495,2931543,2934004,2934052,2936504,2936552,2939012,2939060,2941515,2941563,2944009,2944057,2946487,2946535,2948949,2948997,2951396,2951444,2953843,2953891,2953898,2956332,2956380,2956387,2958811,2958859,2958866,2961280,2961328,2961335,2963729,2963777,2963784,2966160,2966208,2966215,2968578,2968626,2968633,2970994,2971042,2971049,2973394,2973442,2973449,2975783,2975831,2975838,2978160,2978208,2978215,2980550,2980598,2980605,2982926,2982974,2982981,2985295,2985343,2985350,2987679,2987727,2987734,2990057,2990105,2990112,2992433,2992481,2992488,2994796,2994844,2994851,2997146,2997194,2997201,2999480,2999528,2999535,3001804,3001851,3001858,3004118,3004166,3004173,3006408,3006456,3006463,3008634,3008682,3008689,3010822,3010870,3010877,3012990,3013038,3013045,3015142,3015190,3015197,3017286,3017334,3017341,3019474,3019522,3019529,3021567,3021598,3021604,3023044,3023075,3023081,3024513,3024544,3024550,3025969,3026000,3026006,3027415,3027446,3027452,3028853,3028884,3028890,3030285,3030316,3030322,3031707,3031738,3031744,3033119,3033150,3033156,3034717,3034748,3034754,3036303,3036334,3036340,3037878,3037909,3037915,3039445,3039476,3039482,3041004,3041035,3041041,3042554,3042585,3042591,3044096,3044127,3044133,3045631,3045662,3045668,3047154,3047185,3047191,3048666,3048697,3048703,3050171,3050202,3050208,3051679,3051710,3051716,3053177,3053208,3053214,3054662,3054693,3054699,3056138,3056169,3056175,3057603,3057634,3057640,3059056,3059087,3059093,3060501,3060532,3060538,3061938,3061969,3061975,3063673,3063704,3063710,3065399,3065430,3065436,3067114,3067145,3067151,3068816,3068847,3068853,3070509,3070540,3070546,3072193,3072224,3072230,3073868,3073899,3073905,3075533,3075564,3075570,3077191,3077222,3077228,3078852,3078883,3078889,3080504,3080535,3080541,3082147,3082178,3082184,3083779,3083810,3083816,3085401,3085432,3085438,3087049,3087080,3087086,3088688,3088719,3088725,3090316,3090347,3090353,3091932,3091963,3091969,3093538,3093569,3093575,3095136,3095167,3095173,3096757,3096763,3098338,3098344,3099915,3099921,3101481,3101487,3103032,3103038,3104574,3104580,3106108,3106114,3107663,3234561,3234571,3234590,3236148,3236158,3236177,3237723,3237733,3237752,3239292,3239302,3239321,3240855,3240865,3240884,3242463,3242482,3244049,3244068,3245644,3247235)) 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





	Roman Muravitsky (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Roman Muravitsky (Tenor)
			

																
Roman Muravitsky (Tenor)

														
				


        




    

        Born in the town of Kiselyovsk, Kemerovo province. In 1989, he enrolled at the music faculty of Irkutsk Pedagogical Institute (bayan class) where, under the influence of his teacher, N. Vasileva, he began to study singing seriously. From 1989-92, he was a member of the chorus at the Irkutsk Music Theatre. 
In 1997, he completed his studies at the Moscow Conservatory (Evgeny Kibkalo`s class) and in the same year he was a diploma-winner at the 2nd Sergei Rachmaninov Competition. In 1996, he joined Moscow`s Stanislavsky and Nemirovich-Danchenko Theatre where he sang the following roles:

Title Role (Guiseppe Verdi`s Ernani)
Rodolfo (La Boheme)
Pinkerton (Madama Butterfly)
Nemorino (L`Elisir d`amore)
Jose (Carmen)
Nikeas (Jules Massenet`s Thais)
Eisenstein (Die Fledermaus)
Lensky (Eugene Onegin)
Vaudemont (Iolanta)
Gvidon (Nikolai Rimsky-Korsakov`s Tale of Tsar Saltan)
Bayan (Mikhail Glinka`s Ruslan and Lyudmila)
Antonio (Sergei Prokofiev`s Betrothal in a Monastery)

Bolshoi Theatre

In 2002, the Bolshoi Theatre invited Roman Muravitsky as guest artist to sing Golitsyn in the premiere performances of Khovanshchina (director Yuri Alexandrov) and Calaf at the premiere of Turandot (director Francesca Zambello). 
In 2003, Muravitsky joined the Bolshoi Opera Company. 
In 2004, at the premiere of the Bolshoi Theatre`s first production of Prokofiev`s opera The Fiery Angel he sang the part of Agrippa of Nettesheim (conductor Alexander Verdernikov, director Francesca Zambello, designer Georgy Tsypin).
In the same year, at the Bolshoi Theatre`s Russian premiere of the first version of Richard Wagner`s Der Fliegende Hollдnder, he sang the part of Eric (conductor Alexander Vedernikov, director Peter Konwitschny, designer Johannes Leiacker).
In November 2004, at the premiere performances of Dmitry Shostakovich`s Lady Macbeth of the Mtsensk, he sang the role of Sergei (conductor Zoltan Peshko, director Temur Chkheidze, designer Yuri Gegeshidze).
In 2005, at the world premiere of Leonid Desyatnikov`s The Children of Rosenthal he sang the role of Mozart (conductor Alexander Vedernikov, director Eimuntas Nekrosius, designer Marius Nekrosius).
In the same year, he sang the part of Pinkerton at the Bolshoi Theatre premiere of Robert Wilson`s production of Madama Butterfly.

Also in his repertoire at the Bolshoi

Andrei Khovansky (Khovanshchina)
The Pretender (Boris Godunov)
Herman (The Queen of Spades)
Vaudemont (Iolanta)
Mario Cavaradossi (Tosca)
Pierre Bezukhov (Sergei Profiev`s War and Peace)

Tours

From 1999-2001, he was a regular participant in the concert program of the Mosel Festival (Trier, Saarbruken); he sang the part of Lensky at the Week of Russian Culture Festival at Cannes; the part of Almerik (Iolanta, conductor Vladimir Fedoseyev) at the Klangbogen Festival in Vienna.
In 2003, he appeared as Jose (Carmen) at the Samara Spring Festival.
In 2004, he sang Radames at the premiere performances of Aida at Estonia National Opera (conductor Arvo Volmer, an Estonia National Opera and Malmo Theatre of Opera and Music co-production).
In 2005, he took part in a concert performance at the Big Hall of the Moscow Conservatory of Osip Kozlovsky`s opera Fingal (conductor Alexander Rudin); he sang the part of Eric at a Latvian National Opera production of Die Fliegende Hollaender; the title role of Camille Saint-Saens`s opera Samson et Dalila (conductor Arvo Volmer) at concert performances at Estonia National Opera and the Savonlinna Festival; in a new production of Boris Godunov at the Opera Bastille, he sang the role of The Pretender (conductor Alexander Vedernikov, director Francesca Zambello).
In 2006, he sang the role of Jose (Carmen) at the Savonlinna Festival.

He has an extensive concert program. The concert performances he has given in recent years include: appearances at the Tver Music Seasons Festival (2003), at the Russian National Orchestra`s Unknown Glinka concert project (Tchaikovsky Concert Hall, 2004); and at the Baltic Seasons Festival, Kaliningrad (2005). 
        

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy