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 (20155,21642,23096,24548,26033,26571,28058,30494,32001,33506,34980,36548,38106,39572,211800,211804,213333,213337,214871,214875,216404,216408,217935,217939,219460,219464,220981,220985,222498,222502,224010,224014,225518,225522,227030,228533,303490,305421,307351,309274,311192,313106,314985,314994,314995,315010,316897,316898,316916,318791,318792,318810,320694,322570,324439,326343,328247,330143,332031,360614,360620,360621,362511,362517,362518,364398,364403,364404,366279,366284,366285,368160,368166,368167,370034,370039,370040,371902,371907,371908,373763,373769,373770,375613,375619,375620,377453,377460,377461,379287,379294,379295,381118,381123,381124,382943,382948,382949,384762,384766,384767,386574,386578,386579,388378,388383,388384,390186,390191,390192,391986,391991,391992,393785,393790,393791,395580,395585,395586,397369,397373,397374,399154,399159,399160,400929,400930,400934,402694,402698,402699,404450,404455,404456,406208,406212,406213,407958,407963,407964,409702,409707,409708,411440,411446,411447,413202,413208,413209,414953,414959,414960,416695,416701,416702,418435,418440,418442,420171,420175,420176,421904,421905,421909,423630,423634,423635,425352,425357,425358,427060,427064,427065,428761,428765,428766,430453,430458,430459,432160,432165,432166,433863,433867,433868,435558,435562,435563,437245,437250,437251,438921,438926,438927,440585,440590,440591,442236,442241,442242,443874,443879,443880,445501,445505,445507,447130,447131,538784,538792,538889,538897,540205,540213,540310,540318,541619,541627,541722,541730,543068,543076,543171,543179,544546,544554,544646,544654,546012,546020,546105,546114,547467,547475,547560,547568,548922,548930,549014,549023,550371,550379,550463,550472,551812,551820,551904,551913,553244,553252,553337,553346,554665,554673,554758,554767,556077,556085,556170,556179,557482,557490,557575,557584,558882,558890,558974,558983,560279,560287,560371,560380,561669,561677,561761,561770,563056,563064,563148,563157,564436,564444,564525,564534,565802,565810,565892,565901,567160,567167,567253,567261,568520,568529,568611,568620,569873,569881,569964,569973,571216,571224,571311,571316,572599,572607,572694,572702,573979,573987,574074,574082,575348,575356,575443,575451,576708,576716,576803,576811,578065,578072,578160,578168,579415,579422,579510,579518,580753,580760,580848,580856,582082,582089,582177,582185,583412,583419,583506,583515,584732,584739,584825,584833,586045,586052,586138,586146,587354,587361,587447,587455,588655,588662,588749,588757,589978,589990,590125,590134,590478,591598,591610,591744,591754,592099,593237,593249,593382,593392,593738,594945,594958,595091,595100,595444,596642,596655,596788,596797,597141,598329,598341,598471,598481,598826,600004,600017,600150,600159,600503,601686,601698,601828,601838,602183,603357,603370,603503,603512,603856,605020,605032,605162,605172,605520,606674,606687,606820,606829,607173,608319,608332,608465,608474,608818,609957,609970,610103,610112,610459,611641,611654,611787,611796,612143,613319,613332,613464,613473,613820,614986,614999,615131,615140,615487,616639,616652,616781,616792,617142,618283,618296,618428,618437,618784,619916,619929,620061,620070,620417,621544,621556,621683,621694,622043,623162,623175,623307,623316,623663,624772,624785,624917,624926,625291,626406,626538,626547,626912,628017,628149,628158,628523,629749,629758,630123,631342,631351,631716,632929,632938,633303,634507,634516,634881,636074,636083,636448,637632,637641,638006,639177,639187,639552,640714,640723,641088,642240,642250,642616,643757,643767,644133,645270,645279,645646,646774,646783,647148,648269,648278,648643,649768,649777,650142,651256,651265,651630,652737,652746,653111,654209,654218,654583,655670,655679,656044,657121,657130,657495,658576,658585,658950,660017,660026,660394,661451,661460,661825,662875,662884,663249,664292,664301,664666,665702,665711,666076,667139,667150,667517,668573,668582,668945,670014,670023,670386,671446,671455,671818,672870,672879,673242,674281,674290,674653,675683,675692,676055,677071,677082,677450,678464,678827,679865,680228,681620,683002,684374,685727,687067,688374,689673,690959,692235,693501,694757,695996,697222,698435,699637,700831,702021,703213,704394,705564,706714,707853,708981,710099,711247,712354,712385,713486,713519,714607,714638,715716,715747,716814,716845,717902,717933,718980,719011,720046,720077,721101,721132,722159,722190,723221,723252,724273,724304,725316,725347,726349,726380,727374,727405,728391,728422,729398,729429,730398,730429,731390,731421,732377,732408,733371,733402,734358,734389,735337,735368,736304,736335,737276,737307,738240,738271,739196,739229,740144,740176,742113,742145,744086,744118,746051,746083,748014,748044,749996,750026,751978,752008,754857,754887,757730,757760,760596,760626,763460,763491,766319,766350,769171,769200,772017,772046,774857,774886,777692,777721,780523,780553,783358,783389,786188,786218,789014,789044,791836,791865,794655,794687,797464,797496,800268,800301,803070,803101,805864,805897,808653,808686,811435,811469,814214,814248,816988,817022,819754,819789,822516,822547,825265,825299,828011,828045,830752,830786,833491,833525,836257,838987,841710,844432,847171,849904,852633,855363,858088,860808,1055170,1055178,1057596,1057604,1060015,1060023,1062421,1062427,1064817,1064825,1067204,1067211,1069580,1069586,1071945,1071952,1071966,1071969,1071973,1071978,1074344,1074353,1074365,1074367,1074370,1074372,1076729,1076737,1076750,1076753,1076757,1076759,1079105,1079113,1079126,1079129,1079133,1079135,1081471,1081477,1081491,1081494,1081498,1081501,1083823,1083830,1083845,1083848,1083850,1083855,1086161,1086168,1086182,1086186,1086188,1086193,1088484,1088491,1088505,1088509,1088511,1088515,1090818,1090826,1090839,1090842,1090846,1090848,1093146,1093152,1093166,1093170,1093172,1093177,1095460,1095468,1095481,1095484,1095488,1095490,1097760,1097768,1097781,1097784,1097788,1097790,1100043,1100050,1100064,1100067,1100070,1100073,1102315,1102322,1102336,1102339,1102342,1102345,1104573,1104580,1104595,1104599,1104601,1104606,1106810,1106818,1106831,1106835,1106837,1106842,1109026,1109033,1109047,1109050,1109053,1109058,1111221,1111228,1111242,1111245,1111248,1111252,1113398,1113405,1113419,1113422,1113425,1113428,1115556,1115563,1115579,1115582,1115583,1115586,1117700,1117708,1117720,1117724,1117726,1117731,1119835,1119843,1119855,1119859,1119861,1119866,1121965,1121973,1121985,1121989,1121991,1121996,1124103,1124111,1124123,1124127,1124129,1124134,1126298,1126306,1126318,1126322,1126324,1126329,1128487,1128497,1128510,1128513,1128519,1128524,1130700,1130710,1130723,1130726,1130730,1130735,1132896,1132906,1132919,1132922,1132925,1132931,1135087,1135095,1135110,1135114,1135116,1135123,1135215,1135216,1137289,1137296,1137316,1137319,1137325,1137328,1137421,1137422,1139491,1139501,1139515,1139519,1139522,1139529,1139620,1139621,1141692,1141712,1141715,1141720,1141722,1141815,1141816,1143881,1143897,1143901,1143904,1143911,1144004,1144005,1146074,1146079,1146081,1146088,1146179,1146180,1148238,1148243,1148245,1148252,1148343,1148344,1150393,1150398,1150400,1150407,1150498,1150499,1152544,1152549,1152551,1152558,1152649,1152650,1154689,1154693,1154696,1154701,1154796,1154797,1156831,1156837,1156840,1156932,1156933,1159003,1159008,1159099,1159100,1161163,1161254,1161258,1163396,1163397,1165529,1165530,1167665,1167666,1169796,1169797,1171917,1171918,1174032,1174033,1176178,1176179,1178313,1178314,1180441,1180442,1182560,1182561,1184670,1184671,1186779,1186780,1188885,1188886,1189318,1189350,1190983,1190984,1191416,1191449,1193071,1193072,1193505,1193537,1195150,1195151,1195584,1195616,1197226,1197227,1197660,1197692,1199295,1199296,1199728,1199764,1201356,1201357,1201789,1201825,1203407,1203411,1203852,1203885,1205459,1205460,1205900,1205937,1207496,1207497,1207937,1207974,1209525,1209526,1209979,1210017,1211565,1211566,1212020,1212056,1214050,1214089,1216072,1216111,1218081,1218120,1220075,1220114,1222058,1222097,1224034,1224073,1226005,1226044,1227998,1228037,1230015,1230054,1232024,1232061,1234021,1234060,1236008,1236044,1237988,1238024,1239956,1239992,1241912,1243895,1245868,1247829,1249813,1251791,1253772,1255748,1257716,1259676,1261623,1263557,1265482,1267412,1269332,1271241,1273139,1275023,1276889,1278747,1280603,1282442,1284277,1286101,1287912,1289706,1291491,1293301,1295103,1296898,1298684,1300455,1302214,1303963,1305711,1307451,1307585,1309181,1309315,1310899,1311038,1312818,1312957,1314735,1314883,1316669,1316817,1318596,1318744,1320515,1320663,1322424,1322572,1324326,1324474,1326213,1326361,1328082,1328227,1329942,1330090,1331829,1331977,1333706,1333854,1335573,1335721,1337429,1337577,1339274,1339422,1341104,1341252,1342921,1343069,1344730,1344878,1346537,1346685,1348334,1348482,1350124,1350272,1352029,1352177,1353921,1354069,1355802,1355950,1357673,1357821,1359534,1359682,1361386,1361534,1363229,1363377,1365061,1365209,1366880,1367028,1368689,1368837,1370493,1370641,1372286,1372434,1374066,1374214,1375926,1376074,1377769,1377917,1379598,1379746,1381416,1381564,1383232,1383380,1385039,1385189,1386993,1388787,1390567,1392336,1394096,1395874,1397640,1399397,1401149,1402891,1404624,1406347,1408068,1409792,1411519,1413269,1415029,1416780,1418514,1420241,1421958,1423661,1424008,1424054,1424063,1425350,1425697,1425743,1425752,1427024,1427371,1427417,1427426,1428688,1429035,1429081,1429090,1430338,1430685,1430731,1430740,1431978,1432325,1432371,1432380,1433609,1433956,1434002,1434011,1435225,1435572,1435618,1435627,1436830,1437177,1437223,1437232,1438798,1438844,1438853,1440406,1440452,1440461,1442007,1442054,1442063,1443601,1443648,1443657,1445185,1445232,1445241,1446758,1446805,1446814,1448322,1448369,1448378,1449874,1449921,1449930,1451414,1451461,1451470,1452944,1452991,1453000,1454464,1454511,1454520,1455973,1456032,1456039,1457475,1457534,1457541,1458966,1459026,1459033,1460445,1460505,1460512,1461911,1461971,1461978,1463367,1463427,1463434,1464813,1464873,1464880,1466245,1466305,1466312,1467667,1467727,1467734,1469076,1469136,1469143,1470470,1470530,1470537,1471851,1471911,1471918,1473219,1473279,1473286,1474578,1474638,1474645,1475924,1475984,1475991,1477275,1477335,1477342,1478623,1478683,1478690,1480007,1480067,1480074,1481379,1481439,1481446,1482740,1482800,1482807,1483043,1484096,1484156,1484163,1484399,1485440,1485500,1485507,1485743,1486775,1486835,1486842,1487078,1488099,1488159,1488166,1488402,1489405,1489465,1489472,1489708,1490700,1490760,1490767,1491003,1491986,1492046,1492053,1492289,1493300,1493360,1493367,1493603,1494605,1494665,1494672,1494908,1495902,1495962,1495969,1496205,1497194,1497256,1497264,1497502,1498497,1498559,1498567,1498805,1499790,1499852,1499860,1500098,1501073,1501135,1501143,1501381,1502349,1502411,1502419,1502657,1503617,1503679,1503687,1503925,1504878,1504940,1504948,1505186,1506131,1506193,1506201,1506439,1507378,1507440,1507448,1507686,1508615,1508677,1508685,1508923,1509843,1509905,1509913,1510151,1511065,1511127,1511135,1511382,1512290,1512352,1512360,1512607,1513518,1513580,1513588,1513835,1514739,1514801,1514809,1515056,1515962,1516024,1516032,1516279,1517177,1517239,1517247,1517494,1518383,1518445,1518453,1518700,1519582,1519644,1519652,1519903,1520778,1520840,1520848,1521099,1521968,1522030,1522038,1522289,1523151,1523213,1523221,1523472,1524326,1524388,1524396,1524647,1525494,1525556,1525564,1525815,1526655,1526717,1526725,1526976,1527810,1527872,1527880,1528131,1528959,1529021,1529029,1529280,1530104,1530166,1530174,1530425,1531245,1531307,1531315,1531566,1532380,1532445,1532452,1532704,1533512,1533577,1533584,1533836,1534640,1534705,1534712,1534964,1535764,1535829,1535836,1536088,1536883,1536948,1536955,1537207,1537996,1538061,1538068,1538320,1539133,1539198,1539205,1539457,1540263,1540328,1540335,1540587,1541388,1541453,1541460,1541712,1542507,1542572,1542579,1542831,1543618,1543683,1543690,1543942,1544788,1544795,1545047,1545886,1545893,1546145,1546971,1546978,1547230,1548044,1548051,1548303,1549107,1549114,1549366,1550162,1550170,1550421,1551210,1551218,1551469,1552249,1552257,1552508,1553290,1553298,1553549,1554325,1554333,1554584,1555352,1555360,1555611,1556370,1556378,1556629,1557380,1557388,1557639,1558388,1558396,1558647,1559394,1559645,1560752,1561003,1562352,1564195,1566028,1567852,1570770,1573664,1576548,1579420,1582282,1585129,1587967,1590802,1593627,1596484,1599355,1602214,1605063,1607903,1610737,1613563,1616378,1619185,1621971,1624751,1627520,1630278,1633024,1635822,1638653,1641494,1644320,1647134,1647184,1649943,1649997,1652812,1652865,1655676,1655727,1658524,1658575,1661361,1661412,1664184,1664235,1666997,1667048,1669803,1669854,1672662,1672713,1675514,1675565,1678360,1678411,1681200,1681249,1684027,1684076,1686842,1686893,1689697,1689747,1692551,1692602,1695319,1695369,1698078,1698129,1700831,1700882,1703575,1703626,1706313,1706362,1709084,1709133,1711846,1711897,1714630,1714681,1717405,1717456,1720218,1722966,1725706,1728441,1731167,1733875,1736574,1739262,1741936,1744600,1846945,1847002,1847003,1849095,1849154,1849155,1851244,1851303,1851304,1853390,1853447,1853448,1855528,1855588,1855589,1857661,1857721,1857722,1859781,1859841,1859842,1861899,1861959,1861960,1864011,1864071,1864072,1866121,1866179,1866180,1868211,1868269,1868270,1870291,1870349,1870350,1872369,1872427,1872428,1874426,1874484,1874485,1876480,1876538,1876539,1878536,1878594,1878595,1880609,1880667,1880668,1882673,1882731,1882732,1884728,1884786,1884787,1886800,1886858,1886859,1888868,1888925,1888926,1890928,1890985,1890986,1893008,1893066,1893067,1895098,1895156,1895157,1897201,1897266,1897267,1899422,1899423,1901570,1901571,1903707,1903708,1905835,1905836,1907978,1907979,1910051,1910135,1910136,1912200,1912285,1912286,1914366,1914448,1914450,1914463,1914495,1916581,1916666,1916667,1916681,1916713,1918787,1918872,1918873,1918887,1918917,1920987,1921072,1921073,1921087,1921119,1923184,1923269,1923270,1923284,1923316,1925390,1925475,1925476,1925490,1925522,1927636,1927720,1927721,1927737,1927768,1929870,1929955,1929956,1929971,1930003,1932092,1932177,1932178,1932192,1932224,1934298,1934381,1934382,1934398,1934429,1936496,1936580,1936581,1936596,1936627,1938691,1938776,1938777,1938791,1938823,1940876,1940961,1940962,1940975,1941005,1943051,1943136,1943137,1943150,1943180,1945215,1945300,1945301,1945314,1945344,1947369,1947453,1947454,1947468,1947497,1949511,1949594,1949595,1949609,1949638,1951645,1951728,1951729,1951743,1951772,1953775,1953860,1953861,1953874,1953904,1955854,1955939,1955940,1955953,1955983,1957923,1958008,1958009,1958022,1958052,1959983,1960066,1960067,1960079,1960107,1962025,1962109,1962110,1962122,1962150,1964055,1964136,1964137,1964153,1964183,1966079,1966163,1966165,1966178,1966209,1968098,1968184,1968185,1968200,1968230,1970115,1970196,1970197,1970213,1970243,1972128,1972209,1972210,1972226,1972256,1974129,1974213,1974214,1974229,1974260,1976122,1976206,1976207,1976222,1976253,1978101,1978185,1978186,1978201,1978231,1980072,1980153,1980154,1980170,1980200,1982065,1982151,1982152,1982167,1982196,1984057,1984138,1984139,1984155,1984185,1986040,1986121,1986122,1986138,1986168,1988010,1988091,1988092,1988108,1988138,1989971,1990052,1990053,1990069,1990099,1991919,1992000,1992001,1992017,1992047,1993858,1993939,1993940,1993956,1993986,1995788,1995873,1995874,1995889,1995919,1997718,1997799,1997800,1997816,1997846,1999637,1999718,1999719,1999735,1999765,2001546,2001627,2001628,2001644,2001674,2003442,2003523,2003524,2003540,2003570,2005325,2005406,2005407,2005423,2005453,2007201,2007284,2007286,2007299,2007329,2009083,2009164,2009165,2009180,2009212,2010964,2011048,2011049,2011063,2011093,2012838,2012920,2012921,2012934,2012964,2014681,2014762,2014763,2014778,2014810,2016513,2016594,2016595,2016610,2016642,2018412,2018413,2018428,2018460,2020225,2020226,2020239,2020270,2022030,2022031,2022044,2022075,2023824,2023825,2023840,2023872,2025822,2025823,2025838,2025870,2027817,2027818,2027833,2027865,2029804,2029805,2029819,2029850,2031776,2031777,2031791,2031821,2033738,2033739,2033753,2033783,2035697,2035698,2035712,2035742,2037647,2037648,2037662,2037692,2039590,2039591,2039605,2039635,2041520,2041521,2041536,2041568,2043442,2043443,2043456,2043486,2045346,2045347,2045360,2045390,2047242,2047243,2047256,2047286,2049129,2049130,2049143,2049173,2051007,2051009,2051021,2051051,2052877,2052878,2052891,2052921,2054834,2054835,2054847,2054877,2056887,2056918,2058926,2058956,2060957,2060987,2063011,2065026,2067033,2069031,2071030,2073017,2074994,2323316,2323342,2326454,2326480,2329584,2329610,2332695,2332721,2335797,2335823,2338893,2338919,2341989,2342015,2345096,2345122,2348221,2348684,2351317,2351800,2354436,2354919,2357543,2358026,2360644,2361129,2363739,2364224,2367309,2370383,2373448,2376498,2379536,2382568,2385594,2388617,2391676,2394732,2397775,2400804,2403822,2406836,2409841,2412836,2415823,2418837,2421839,2424830,2427816,2430793,2433760,2436353,2436717,2439299,2439663,2442598,2445524,2448445,2451355,2454258,2457142,2460021,2462885,2465740,2468618,2471556,2474470,2477413,2480345,2483263,2486171,2489074,2492007,2494931,2497845,2500746,2503634,2506510,2509116,2509376,2511977,2512237,2515092,2517942,2520785,2523617,2526437,2529250,2532058,2532065,2534859,2534866,2537653,2537660,2540447,2540454,2543231,2543238,2546004,2546011,2548770,2548777,2551575,2551582,2551749,2551774,2554371,2554378,2554545,2554570,2557182,2557189,2557356,2557381,2559985,2559992,2560159,2560184,2562774,2562781,2562948,2562973,2565548,2565555,2565724,2565750,2568314,2568321,2568490,2568516,2571146,2571153,2571321,2571346,2573968,2573975,2574143,2574168,2576782,2576789,2576957,2576982,2579583,2579590,2579766,2579791,2582380,2582387,2582563,2582588,2585162,2585169,2585345,2585370,2587933,2587940,2588116,2588141,2590701,2590708,2590884,2590909,2593460,2593467,2593643,2593668,2596211,2596218,2596394,2596419,2598953,2598960,2599136,2599161,2601682,2601689,2601865,2601890,2604398,2604405,2604581,2604606,2607105,2607112,2607288,2607313,2609808,2609815,2609991,2610016,2612502,2612509,2612685,2612710,2615226,2615233,2615409,2615434,2617943,2617950,2618126,2618151,2620650,2620657,2620833,2620858,2623342,2623349,2623525,2623550,2626023,2626030,2626206,2626231,2628704,2628711,2628887,2628912,2631369,2631376,2631552,2631577,2634036,2634043,2634219,2634244,2636682,2636689,2636865,2636890,2639316,2639323,2639499,2639524,2641937,2641944,2642120,2642145,2644546,2644553,2644729,2644754,2647154,2647330,2647355,2649918,2649943,2652497,2652522,2655064,2655089,2657616,2657641,2660150,2660175,2662665,2662690,2665166,2665191,2667653,2667678,2670116,2670141,2672567,2672592,2674998,2675023,2677410,2677435,2679802,2679827,2682178,2682203,2684545,2684570,2686907,2686932,2689262,2689287,2691606,2691631,2693934,2693959,2696251,2696254,2696257,2696260,2696263,2696297,2696700,2696705,2696728,2696737,2699380,2699784,2699789,2699813,2699822,2702450,2702868,2702873,2702897,2702906,2705526,2705945,2705950,2705974,2705983,2708992,2708997,2709021,2709030,2712035,2712040,2712064,2712073,2715065,2715070,2715094,2715103,2718086,2718091,2718115,2718124,2721151,2721156,2721180,2721189,2724259,2724264,2724288,2724297,2727358,2727363,2727387,2727396,2730445,2730450,2730474,2730483,2733560,2733565,2733589,2733598,2736663,2736668,2736692,2736701,2736901,2739750,2739755,2739779,2739788,2739988,2742827,2742832,2742857,2742866,2743066,2745887,2745892,2745917,2745926,2746126,2748928,2748933,2748958,2748967,2749167,2751957,2751962,2751987,2751996,2752196,2754984,2754989,2755014,2755023,2755223,2758004,2758009,2758034,2758043,2758243,2761025,2761032,2761055,2761064,2761265,2764040,2764047,2764070,2764079,2764280,2767039,2767046,2767069,2767078,2767279,2770023,2770030,2770053,2770062,2770263,2772996,2773003,2773026,2773035,2773236,2775961,2775968,2775991,2776000,2776201,2778950,2778957,2778980,2778989,2779190,2781931,2781938,2781961,2781970,2782170,2785019,2785026,2785049,2785058,2785258,2788105,2788112,2788135,2788144,2788344,2791175,2791182,2791205,2791214,2791414,2794233,2794240,2794263,2794272,2794472,2797308,2797315,2797338,2797347,2797547,2800370,2800377,2800400,2800409,2800610,2800631,2800635,2803425,2803432,2803455,2803464,2803665,2803686,2803690,2806399,2806406,2806429,2806438,2806639,2806660,2806664,2809355,2809362,2809385,2809394,2809595,2809616,2809620,2812289,2812296,2812319,2812328,2812529,2812550,2812554,2815211,2815218,2815241,2815250,2815451,2815472,2815476,2818194,2818201,2818224,2818233,2818434,2818455,2818459,2821170,2821177,2821200,2821209,2821410,2821431,2821435,2824142,2824149,2824172,2824181,2824382,2824403,2824407,2827118,2827125,2827148,2827157,2827358,2827379,2827383,2830077,2830084,2830107,2830116,2830317,2830338,2830342,2833019,2833026,2833049,2833058,2833259,2833280,2833284,2835946,2835953,2835976,2835985,2836186,2836207,2836211,2838880,2838887,2838910,2838919,2839120,2839141,2839145,2841804,2841811,2841834,2841843,2842044,2842065,2842069,2850378,2850385,2850408,2850417,2850618,2850639,2850643,2863016,2863023,2863045,2863054,2863252,2863272,2863276,2865793,2865800,2865822,2865831,2866029,2866049,2866053,2880862,2880869,2880891,2880900,2881100,2881120,2881125,2883634,2883641,2883663,2883672,2883872,2883892,2883897,2886392,2886399,2886421,2886430,2886630,2886650,2886655,2889126,2889133,2889155,2889164,2889365,2889385,2889390,2891849,2891856,2891878,2891887,2892088,2892108,2892113,2894552,2894559,2894581,2894590,2894791,2894811,2894816,2897241,2897248,2897270,2897279,2897480,2897500,2897505,2899938,2899945,2899967,2899976,2900177,2900197,2900202,2902629,2902636,2902658,2902667,2902868,2902888,2902893,2905213,2905220,2905242,2905251,2905452,2905472,2905477,2907805,2907812,2907834,2907843,2908044,2908064,2908069,2910451,2910460,2910661,2910681,2910686,2913049,2913058,2913259,2913279,2913284,2915637,2915646,2915847,2915867,2915872,2918227,2918236,2918437,2918457,2918462,2920809,2921010,2921030,2921035,2923374,2923575,2923595,2923600,2926129,2926149,2926154,2928665,2928685,2928690,2931184,2931204,2931209,2933692,2933712,2933717,2936192,2936212,2936217,2938700,2938720,2938725,2941203,2941223,2941228,2943697,2943717,2943722,2946175,2946195,2946200,2948637,2948657,2948662,2951084,2951104,2951109,2953531,2953551,2953556,2956020,2956040,2956045,2958503,2958523,2958528,2960972,2960992,2960997,2963421,2963441,2963446,2965852,2965872,2965877,2968271,2968291,2968296,2970687,2970707,2970712,2973087,2973107,2973112,2975476,2975496,2975501,2977853,2977873,2977878,2980243,2980263,2980268,2982619,2982639,2982644,2984989,2985009,2985014,2987373,2987393,2987398,2989751,2989771,2989776,2992127,2992147,2992152,2994490,2994510,2994515,2996840,2996860,2996865,2999174,2999194,2999199,3001497,3001520,3001521,3003808,3003828,3003833,3006098,3006118,3006123,3008324,3008344,3008349,3010510,3010530,3010535,3012678,3012698,3012703,3014830,3014850,3014855,3016974,3016994,3016999,3019162,3019182,3019187,3021364,3021369,3022841,3022846,3024310,3024315,3096969,3096976,3098550,3098557,3100127,3100134,3101692,3101699,3103243,3103250,3104785,3104792,3106321,3106327,3107870,3107876,3109445,3109451,3111010,3111016,3112563,3112569,3114102,3114108,3114167,3114176,3114189,3115628,3115635,3115690,3115698,3115714,3117146,3117153,3117208,3117216,3117232,3118660,3118666,3118716,3118724,3118740,3120166,3120172,3120226,3120234,3120250,3121668,3121674,3121728,3121736,3121752,3123225,3123235,3123331,3123340,3123358,3124917,3124927,3125023,3125032,3125050,3126597,3126607,3126703,3126712,3126730,3128267,3128277,3128373,3128382,3128400,3129926,3129936,3130032,3130041,3130059,3131578,3131588,3131684,3131693,3131711,3133222,3133232,3133328,3133337,3133355,3134858,3134868,3134964,3134973,3134991,3136494,3136504,3136600,3136609,3136627,3138119,3138129,3138225,3138234,3138252,3139735,3139745,3139841,3139850,3139868,3141344,3141354,3141450,3141459,3141477,3142944,3142954,3143050,3143059,3143078,3144538,3144548,3144644,3144653,3144672,3146123,3146133,3146229,3146238,3146257,3150200,3150210,3150306,3150315,3150334,3151744,3151754,3151850,3151859,3151878,3153281,3153291,3153387,3153396,3153415,3154809,3154819,3154915,3154924,3154943,3156329,3156339,3156435,3156444,3156463,3157841,3157851,3157947,3157956,3157975,3159341,3159351,3159447,3159456,3159475,3160830,3160840,3160936,3160945,3160964,3162312,3162322,3162418,3162427,3162446,3163788,3163798,3163894,3163903,3163922,3165255,3165265,3165361,3165370,3165389,3166737,3166747,3166843,3166852,3166871,3168134,3168144,3168240,3168249,3168268,3169521,3169531,3169627,3169636,3169655,3170901,3170911,3171007,3171016,3171035,3172275,3172285,3172381,3172390,3172409,3173643,3173653,3173749,3173758,3173777,3175003,3175013,3175109,3175118,3175137,3176404,3176414,3176510,3176519,3176538,3177800,3177810,3177906,3177915,3177934,3179274,3179284,3179380,3179389,3179408,3180744,3180754,3180850,3180859,3180878,3182211,3182221,3182317,3182326,3182345,3183672,3183682,3183778,3183787,3183806,3185135,3185145,3185241,3185250,3185269,3186593,3186603,3186699,3186708,3186727,3188047,3188057,3188153,3188162,3188181,3189494,3189504,3189600,3189609,3189628,3190937,3190947,3191043,3191052,3191071,3192376,3192386,3192482,3192491,3192510,3194069,3194079,3194175,3194184,3194203,3195756,3195766,3195862,3195871,3195890,3197539,3197549,3197645,3197654,3197673,3199509,3199519,3199615,3199624,3199643,3201210,3201220,3201316,3201325,3201344,3202904,3202914,3203010,3203019,3203038,3204596,3204606,3204702,3204711,3204730,3206294,3206391,3206400,3206419,3207976,3208073,3208082,3208101,3209751,3209761,3209778,3211421,3211431,3211448,3213130,3213140,3213157,3214826,3214835,3214854,3216520,3216529,3216548,3218211,3218220,3218239,3219895,3219904,3219923,3221570,3221579,3221598,3223242,3223251,3223270,3224877,3224886,3224905,3226499,3226508,3226527,3228113,3228122,3228141,3229729,3229739,3229758,3231346,3231356,3231375,3231559,3231567,3231580,3232959,3232969,3232988,3233172,3233180,3233193,3234561,3234571,3234590,3234774,3234782,3234795,3236148,3236158,3236177,3236361,3236369,3236382,3237723,3237733,3237752,3237936,3237944,3237957,3239292,3239302,3239321,3239505,3239513,3239526,3240855,3240865,3240884,3241068,3241076,3241089,3242463,3242482,3242666,3242674,3242687,3244049,3244068,3244252,3244260,3244273,3245644,3245828,3245836,3245849,3247235,3247419,3247427,3247440,3248996,3249004,3249017,3250564,3250572,3250585,3252128,3252136,3252149,3253725,3253733,3253746,3255721,3255729,3255742,3255839,3255852,3255878,3257736,3257744,3257757,3257854,3257867,3257893,3259737,3259745,3259758,3259855,3259868,3259894,3261725,3261733,3261746,3261843,3261856,3261882,3263707,3263715,3263728,3263825,3263838,3263864,3265690,3265698,3265708,3265804,3265815,3265844,3267678,3267686,3267696,3267792,3267803,3267832,3269730,3269738,3269748,3269844,3269855,3269884,3271820,3271828,3271840,3271934,3271946,3271977,3273935,3273943,3273955,3274049,3274061,3274092,3276034,3276042,3276054,3276148,3276160,3276191,3278124,3278132,3278144,3278238,3278250,3278281,3280222,3280230,3280244,3280345,3280358,3280395,3282352,3282360,3282374,3282475,3282488,3282525,3284476,3284484,3284498,3284599,3284612,3284649,3286589,3286600,3286614,3286718,3286734,3286767,3288729,3288740,3288754,3288858,3288874,3288907,3290852,3290863,3290877,3290981,3290997,3291030,3292961,3292972,3292986,3293090,3293106,3293139,3295064,3295075,3295089,3295193,3295209,3295243,3297160,3297171,3297185,3297289,3297305,3297339,3299248,3299259,3299273,3299377,3299393,3299427,3301327,3301338,3301352,3301456,3301472,3301506,3303394,3303405,3303419,3303523,3303539,3303573,3305449,3305460,3305474,3305578,3305594,3305628,3307496,3307507,3307521,3307625,3307641,3307675,3309540,3309551,3309565,3309669,3309685,3309719,3311576,3311587,3311601,3311705,3311721,3311755,3313598,3313609,3313623,3313727,3313743,3313777,3315612,3315623,3315637,3315741,3315757,3315791,3317616,3317627,3317641,3317745,3317761,3317795,3319610,3319621,3319635,3319739,3319755,3319789,3321596,3321607,3321621,3321725,3321741,3321775,3323579,3323590,3323604,3323708,3323724,3323758,3325723,3325734,3325748,3325852,3325868,3325902,3326067,3327992,3328003,3328017,3328121,3328137,3328171,3328336,3330386,3330400,3330504,3330520,3330554,3330719,3332770,3332874,3332890,3332924,3333089,3335127,3335231,3335247,3335281,3335446,3337581,3337597,3337631,3337796,3339927,3339943,3339977,3340142,3342266,3342282,3342316,3342481,3344627,3344643,3344677,3344842,3346979,3346995,3347029,3347194,3349322,3349338,3349372,3349537,3351650,3351666,3351700,3351865,3353971,3353987,3354021,3354186,3356289,3356305,3356339,3356506,3356570,3356575,3356640,3356648,3356660,3358637,3358653,3358687,3358854,3358918,3358923,3358988,3358996,3359008,3361002,3361018,3361052,3361220,3361284,3361289,3361354,3361362,3361374,3363359,3363375,3363409,3363577,3363641,3363646,3363711,3363719,3363731,3365703,3365719,3365753,3365921,3365985,3365990,3366055,3366063,3366075,3368039,3368055,3368089,3368257,3368321,3368326,3368391,3368399,3368411,3370367,3370383,3370417,3370585,3370649,3370654,3370719,3370727,3370739,3372688,3372704,3372738,3372906,3372970,3372975,3373040,3373048,3373060,3375002,3375018,3375052,3375220,3375284,3375289,3375354,3375362,3375374,3377311,3377327,3377361,3377529,3377593,3377598,3377663,3377671,3377683,3379611,3379627,3379661,3379829,3379893,3379898,3379963,3379971,3379983,3381894,3381910,3381944,3382112,3382176,3382181,3382246,3382254,3382266,3384159,3384175,3384212,3384402,3384467,3384472,3384537,3384545,3384558,3386449,3386486,3386676,3386741,3386746,3386811,3386819,3386832,3388746,3388936,3389001,3389006,3389071,3389079,3389092,3391000,3391190,3391255,3391260,3391325,3391333,3391346,3393243,3393433,3393498,3393503,3393568,3393576,3393589,3395472,3395662,3395727,3395732,3395797,3395805,3395818,3397688,3397878,3397943,3397948,3398013,3398021,3398034,3400085,3400150,3400155,3400220,3400228,3400241,3402279,3402344,3402349,3402414,3402422,3402435,3404462,3404527,3404532,3404597,3404605,3404618,3406634,3406699,3406704,3406769,3406777,3406790,3408807,3408872,3408877,3408942,3408950,3408963,3410958,3411023,3411028,3411093,3411101,3411114,3413087,3413152,3413157,3413222,3413230,3413243,3415241,3415306,3415311,3415376,3415384,3415397,3417383,3417448,3417453,3417518,3417526,3417539,3419515,3419580,3419585,3419651,3419659,3419677,3421624,3421689,3421694,3421760,3421768,3421786,3423713,3423778,3423783,3423849,3423857,3423875,3425780,3425845,3425850,3425916,3425924,3425942,3427828,3427893,3427898,3427964,3427972,3427990,3429859,3429924,3429929,3429995,3430003,3430021,3431873,3431938,3431943,3432009,3432017,3432035,3433880,3433945,3433950,3434016,3434024,3434042,3435880,3435945,3435950,3436016,3436024,3436042,3437867,3437932,3437937,3438003,3438011,3438029,3439905,3439910,3439976,3439984,3440002,3441871,3441876,3441942,3441950,3441968,3443833,3443838,3443917,3443926,3443936,3443946,3444079,3444086,3444094,3445804,3445809,3445888,3445897,3445907,3445918,3446071,3446079,3446089,3447955,3447960,3448039,3448048,3448058,3448069,3448222,3448230,3448240,3450098,3450103,3450182,3450191,3450201,3450212,3450365,3450373,3450383,3452233,3452238,3452317,3452326,3452336,3452347,3452500,3452508,3452518,3454357,3454362,3454441,3454450,3454460,3454471,3454624,3454632,3454642,3456476,3456481,3456560,3456569,3456579,3456590,3456743,3456751,3456762,3458600,3458605,3458684,3458693,3458703,3458714,3458866,3458874,3458885,3460732,3460737,3460820,3460829,3460839,3460850,3461006,3461014,3461025,3462862,3462867,3462950,3462959,3462969,3462980,3463136,3463144,3463155,3465012,3465017,3465100,3465109,3465119,3465130,3465289,3465297,3465308,3467156,3467161,3467244,3467253,3467263,3467274,3467433,3467441,3467452,3469329,3469334,3469417,3469426,3469436,3469447,3469606,3469614,3469625,3471491,3471496,3471579,3471588,3471598,3471609,3471768,3471776,3471787,3473645,3473650,3473733,3473742,3473752,3473763,3473922,3473930,3473941,3475801,3475806,3475889,3475898,3475908,3475919,3476078,3476086,3476097,3476254,3476260,3476280,3477951,3477956,3478039,3478048,3478058,3478069,3478228,3478236,3478247,3478404,3478410,3478430,3480093,3480098,3480181,3480190,3480200,3480211,3480370,3480378,3480389,3480546,3480552,3480572,3482225,3482230,3482313,3482322,3482332,3482343,3482502,3482510,3482521,3482673,3482681,3482705,3484357,3484440,3484449,3484459,3484470,3484629,3484637,3484648,3484800,3484808,3484832,3486558,3486567,3486577,3486588,3486747,3486755,3486766,3486918,3486926,3486950,3488668,3488677,3488687,3488698,3488857,3488865,3488876,3489028,3489036,3489060,3490801,3490810,3490820,3490831,3490990,3490998,3491009,3491161,3491169,3491193,3492927,3492936,3492946,3492957,3493116,3493124,3493135,3493287,3493295,3493319,3495047,3495056,3495066,3495077,3495236,3495244,3495255,3495407,3495415,3495439,3497204,3497213,3497223,3497234,3497393,3497401,3497412,3497564,3497572,3497596,3499351,3499360,3499370,3499381,3499540,3499548,3499559,3499711,3499719,3499743,3501491,3501500,3501510,3501521,3501680,3501688,3501699,3501851,3501859,3501883,3503623,3503632,3503642,3503653,3503813,3503821,3503832,3503984,3503992,3504016,3505751,3505760,3505770,3505781,3505941,3505949,3505960,3506112,3506120,3506144,3507874,3507883,3507893,3507904,3508064,3508072,3508083,3508235,3508243,3508267,3509990,3509999,3510009,3510020,3510180,3510188,3510199,3510351,3510359,3510383,3512102,3512111,3512121,3512132,3512292,3512300,3512311,3512463,3512471,3512495,3514204,3514213,3514223,3514234,3514394,3514402,3514413,3514565,3514573,3514597,3516298,3516307,3516317,3516328,3516488,3516496,3516507,3516659,3516667,3516691,3518385,3518394,3518404,3518415,3518575,3518583,3518594,3518746,3518754,3518778,3520471,3520480,3520490,3520501,3520660,3520668,3520681,3520828,3520836,3520860,3522545,3522554,3522564,3522575,3522734,3522742,3522755,3522902,3522910,3522934,3524613,3524622,3524632,3524643,3524808,3524816,3524829,3524975,3524983,3525007,3526669,3526678,3526688,3526699,3526864,3526872,3526885,3527031,3527039,3527063,3528734,3528743,3528753,3528764,3528929,3528937,3528950,3529096,3529104,3529128,3530786,3530795,3530805,3530816,3530981,3530989,3531002,3531148,3531156,3531180,3532828,3532837,3532847,3532858,3533023,3533031,3533044,3533190,3533198,3533222,3534868,3534877,3534887,3534898,3535063,3535071,3535084,3535230,3535238,3535262,3536906,3536910,3536920,3536931,3537097,3537105,3537118,3537264,3537272,3537296,3538936,3538946,3538957,3539123,3539131,3539144,3539290,3539298,3539322,3540985,3540996,3541162,3541170,3541183,3541329,3541337,3541361,3543057,3543223,3543231,3543244,3543391,3543399,3543423,3545271,3545279,3545292,3545439,3545447,3545471,3547309,3547317,3547330,3547477,3547485,3547509,3549344,3549352,3549365,3549512,3549520,3549544,3551386,3551394,3551407,3551552,3551561,3551587,3553423,3553431,3553444,3553589,3553598,3553624,3555464,3555472,3555485,3555630,3555639,3555665,3557494,3557502,3557515,3557660,3557669,3557695,3559512,3559520,3559533,3559678,3559687,3559713,3561521,3561529,3561542,3561687,3561696,3561722,3563521,3563529,3563542,3563690,3563699,3563725,3565541,3565549,3565562,3565710,3565719,3565745,3567557,3567565,3567578,3567726,3567735,3567761,3569580,3569588,3569601,3569749,3569758,3569784,3571588,3571596,3571609,3571760,3571769,3571795,3573608,3573616,3573629,3573780,3573789,3573815,3575537,3575688,3575697,3575723,3577444,3577595,3577604,3577630,3579347,3579498,3579507,3579533,3581246,3581397,3581406,3581432,3583108,3583258,3583265,3583295,3584968,3585118,3585125,3585155,3586825,3586975,3586982,3587012,3588679,3588829,3588836,3588866,3590531,3590681,3590688,3590718,3592380,3592530,3592537,3592567,3594296,3594301,3594314,3594481,3594488,3594518,3596292,3596297,3596310,3596477,3596484,3596514,3598274,3598279,3598292,3598459,3598466,3598496,3600241,3600246,3600259,3600426,3600433,3600463,3602193,3602198,3602211,3602378,3602385,3602415,3604136,3604141,3604154,3604321,3604328,3604358,3606067,3606072,3606085,3606252,3606259,3606289,3607990,3607995,3608008,3608175,3608182,3608212,3609903,3609908,3609921,3610088,3610095,3610125,3611804,3611809,3611822,3611989,3611996,3612026,3613733,3613738,3613751,3613918,3613925,3613955,3615650,3615655,3615668,3615835,3615842,3615872,3617560,3617565,3617578,3617745,3617752,3617782,3619469,3619482,3619649,3619656,3619686,3621372,3621385,3621552,3621559,3621589,3623280,3623447,3623454,3623484,3625163,3625330,3625337,3625367,3627202,3627209,3627239,3629066,3629073,3629103,3630926,3630933,3630963,3632780,3632787,3632817,3634626,3634633,3634663,3636465,3636472,3636502,3638294,3638301,3638331,3640110,3640117,3640147,3641916,3641923,3641953,3643714,3643721,3643751,3645504,3645511,3645541,3647287,3647294,3647324,3649062,3649069,3649099,3650824,3650831,3650861,3652575,3652582,3652612,3654318,3654325,3654355,3656054,3656061,3656091,3657780,3657787,3657817,3659505,3659512,3659542,3661236,3661243,3661273,3662954,3662961,3662991,3664662,3664669,3664699,3666364,3666371,3666401,3668059,3668066,3668096,3669742,3669749,3669779,3671418,3671425,3671455,3673089,3673096,3673126,3674748,3674755,3674785,3676397,3676404,3676434,3678039,3678046,3678076,3679676,3679683,3679713,3681311,3681318,3681348,3682940,3682947,3682977,3684563,3684570,3684600,3686174,3686181,3686211,3687776,3687783,3687813,3689374,3689381,3689411,3690975,3691005,3692562,3692592,3694170,3695742,3697303,3698852,3700392,3701927)) 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





	Mikhail Kazakov (Bass) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Mikhail Kazakov (Bass)
			

																
Mikhail Kazakov (Bass)

														
				


        




    

        Born in Dmitrovgrad, Ulyanovsk region. In 200l, he completed his studies at the Kazan Conservatory (Galina Lastovka‘s class). While still a second-year student, he took part in a performance of Giuseppe Verdi‘s Requiem at the Tartar Theatre of Opera and Ballet.

In 2001, he joined the Bolshoi Theatre Opera Company as soloist.


Repertory at the Bolshoi Theatre 


King Rene (Iolanta)

Khan Konchak (Igor Borodin‘s Prince Igor)

Title Role (Boris Godunov)

Zaccaria (Nabucco)

Gremin (Eugene Onegin)

Banquo (Macbeth)

Dosifey (Khovanshchina)


Also in his repertory are:

Don Basilio (Il barbiere di Siviglia)

Grand Inquisitor (Don Carlos)

Dosifey, Ivan Khovansky (Khovanshchina)

The Miller (Alexander Dargomyzhsky‘s Rusalka)

Sobakin (Nikolai Rimsky-Korsakov‘s The Tsar‘s Bride)

Old Gypsy (Sergei Rakhmaninov‘s Aleko)

Colline (La Boheme)

Title Role (Giuseppe Verdi‘s Attila)

Monterone, Sparafucile (Rigoletto)

Ramfis (Aida)

Philip (Don Carlos)

Title Role (Arrigo Boito‘s Mefistofele); 


Tours


Mikhail Kazakov has an active concert life; he has appeared at the following, among other, prestigious venues in Russia and Europe: the Saint-Petersburg Philharmonia, the Maryinsky Theatre, the Big Hall of the Moscow Conservatory, the Koncertgebau and Karee Hall (Amsterdam), the Megaron Concert Hall (Athens), the UNESCO Concert Hall (Paris), the Concert Hall of the European Parliament (Strasbourg).
In 2003, he sang the part of Zaccaria (Nabucco) at New Israel Opera, Tel-Aviv.
In 2004, he made his Vienna Staatsoper debut as the Comendatore in Don Giovanni (conductor Seiji Ozawa).
In September 2004, he sang the Grand Inquisitor (Don Carlos) at Dresden Staatsoper.

In November 2004, at the invitation of Placido Domingo, he sang Ferrando in Il Trovatore at Washington National Opera.
In December 2004, he sang Gremin (Eugene Onegin) and in May-June 2005 - Ramfis (Aida) at the Deutsche Oper am Rhein (Dusseldorf).


Awards


From 1999-2002, he was a prize-winner at several international competitions: the Elena Obraztsova Competition of Young Opera Singers (2nd prize), the Glinka Competition (Grand Prix), the Competition for Singers in Toulouse (Grand Prix), the Maria Callas Competition of Singers in Athens (2nd prize), the Tchaikovsky Competition (1st prize), Opera Singers Competition in Peking (1st prize). In 2002, he won the Irina Arkhipova Fund prize.

In 2003, he was awarded the title of People‘s Artist of the Republic of Tatarstan.


Discography


In 2004, he recorded the disc Tchaikovsky Romances (piano - A. Mikhailov) State Radio and Television Company Kultura.        

    

    

            


			

		





	


	

	

		


			

				

					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