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 (41080,41090,42447,42491,42501,43831,43875,43885,45188,45231,45242,46537,46580,46590,47880,47923,47933,49217,49261,49271,50549,50592,50603,51873,51916,51926,53190,53233,53243,54503,54546,54556,55810,55853,55863,57177,57220,57230,59252,59295,59305,61321,61364,61374,63382,63425,63435,65434,65477,65487,67481,67524,67534,69527,69570,69580,71567,71610,71620,73643,73653,75668,75678,77682,77692,79691,79701,81695,81705,83693,83703,85683,85693,87665,87675,89638,89648,91605,91615,93558,93568,95512,95519,97457,97467,99393,99403,101328,103243,211800,211804,213333,213337,214871,214875,216404,216408,217935,217939,219460,219464,220981,220985,222498,222502,224010,224014,225518,225522,227030,228533,234030,236018,237998,239968,241931,243891,245849,358652,358653,358657,358659,358673,358674,360554,360555,360560,360562,360576,360577,360587,360588,360594,360595,360602,360603,362452,362453,362458,362459,362473,362474,362484,362485,362491,362492,362501,362502,364338,364339,364345,364346,364358,364359,364372,364373,364379,364380,364387,364388,366219,366220,366226,366227,366237,366238,366249,366250,366255,366256,366266,366267,368102,368103,368105,368109,368124,368125,368133,368134,368135,368136,368146,368147,369973,369974,369980,369981,369994,369995,370008,370009,370015,370016,370023,370024,371841,371842,371848,371849,371860,371861,371872,371873,371878,371879,371889,371890,373701,373702,373708,373709,373724,373725,373736,373737,373743,373744,373752,373753,375551,375552,375558,375559,375573,375574,375586,375587,375593,375594,375602,375603,377392,377393,377399,377400,377412,377413,377427,377428,377434,377435,377443,377444,379226,379227,379233,379234,379246,379247,379261,379262,379268,379269,379277,379278,381057,381058,381064,381065,381076,381077,381091,381092,381099,381100,381108,381109,382882,382883,382889,382890,382901,382902,382915,382916,382922,382923,382933,382935,384701,384702,384708,384709,384720,384721,384733,384734,384740,384741,384751,384752,386513,386514,386520,386521,386532,386533,386545,386546,386552,386553,386564,386565,388317,388318,388324,388326,388336,388337,388350,388351,388357,388358,388367,388368,390125,390126,390132,390134,390144,390145,390157,390158,390165,390166,390175,390176,391925,391926,391932,391934,391944,391945,391957,391958,391965,391966,391975,391976,393724,393725,393731,393733,393743,393744,393756,393757,393763,393764,393774,393775,395519,395520,395526,395528,395538,395539,395551,395552,395558,395559,395569,395570,397308,397309,397315,397317,397327,397328,397340,397341,397346,397347,397358,397360,399091,399096,399098,399100,399110,399111,399122,399123,399128,399129,399139,399141,400865,400866,400872,400874,400884,400885,400896,400897,400903,400904,400915,400917,402630,402631,402637,402639,402649,402650,402661,402662,402667,402668,402680,402682,404392,404393,404398,404399,404414,404415,404420,404421,404428,404429,404437,404439,406144,406145,406151,406153,406163,406164,406175,406176,406182,406183,406194,406195,407895,407896,407902,407904,407914,407915,407926,407927,407932,407933,407945,407946,409639,409640,409646,409648,409658,409659,409670,409671,409676,409677,409689,409690,411379,411380,411385,411388,411399,411400,411413,411414,411420,411421,411429,411430,413140,413141,413147,413149,413160,413161,413175,413176,413182,413183,413191,413192,414891,414892,414898,414900,414910,414911,414924,414925,414930,414931,414941,414942,416633,416634,416640,416642,416652,416653,416666,416667,416672,416673,416683,416684,418374,418375,418381,418383,418393,418394,418406,418407,418413,418414,418424,418425,420110,420111,420117,420119,420129,420130,420142,420143,420148,420149,420160,420161,421840,421841,421847,421849,421859,421860,421871,421872,421877,421878,421889,421890,423569,423570,423576,423578,423588,423589,423601,423602,423608,423609,423619,423620,425291,425292,425298,425300,425312,425313,425324,425325,425331,425332,425341,425342,427006,427007,427019,427020,427031,427032,427038,427039,427049,427050,428704,428705,428716,428717,428728,428729,428735,428736,428747,428748,430409,430410,430421,430422,430427,430428,430439,430441,432116,432117,432129,432130,432136,432137,432147,432149,433832,433833,433838,433839,433850,433852,435527,435528,435533,435534,435545,435547,437221,437222,437233,437235,438909,438911,440575,440577,477537,477545,479109,479117,480676,480684,481430,481438,482172,482181,482909,482918,483644,483652,484395,484403,485144,485152,485887,485895,486620,486629,487341,487346,488052,488060,488765,488772,489477,489484,490184,490191,490886,490895,491579,491586,492264,492271,492947,492954,493629,493636,494307,494316,494976,494985,495398,495637,495642,496046,496286,496295,496924,496933,498394,498403,499856,499865,501311,501320,502759,502768,504242,504249,505721,505730,507190,507197,508662,508669,510129,510136,511589,511596,513043,513048,514520,514527,515990,515997,517451,517458,518904,518909,520348,520357,521789,521794,523223,523232,524648,524657,526064,526069,527471,527476,528877,528882,530279,530286,531677,531684,533067,533074,534509,534518,535937,535944,537372,537380,538803,538812,540224,540233,541636,541645,543083,543091,544561,544570,546030,546039,547485,547493,548939,548948,550388,550397,551829,551838,553263,553271,554684,554692,556096,556104,557502,557510,558902,558910,560299,560307,561689,561697,563076,563084,564453,564461,565819,565828,567177,567186,568538,568546,569891,569899,571233,571242,572616,572624,573996,574004,575365,575373,576725,576733,578082,578090,579432,579440,579475,580771,580779,580812,582100,582108,582133,582141,583430,583438,583462,583471,584750,584758,584782,584791,586063,586071,586095,586104,587372,587380,587404,587413,588672,588681,588706,588715,590006,590016,590065,590075,591626,591636,591685,591695,593265,593275,593322,593334,594974,594985,595030,595041,596671,596682,596727,596738,598354,598364,598411,598423,600033,600044,600089,600100,601711,601721,601768,601781,603386,603397,603442,603453,605046,605057,605103,605116,606703,606714,606759,606770,608348,608359,608404,608415,609986,609997,610042,610053,611670,611681,611726,611737,613348,613359,613403,613414,615015,615026,615070,615081,616668,616678,616727,616737,618312,618323,618367,618378,619945,619956,620000,620011,621570,621580,621629,621639,623191,623202,623246,623257,624801,624812,624856,624867,626422,626433,626477,626488,628033,628044,628088,628099,629633,629644,629688,629699,631226,631237,631281,631292,632813,632824,632868,632879,634391,634402,634446,634457,635969,636013,636024,637527,637571,637582,639117,639128,640653,640664,642181,642191,643696,643708,645208,645219,646713,646724,648208,648219,649707,649718,651195,651206,652676,652687,654148,654159,655609,655620,657060,657071,658526,659969,712351,712357,712561,713482,713489,713695,714604,714610,714814,715713,715719,715923,716811,716817,717021,717899,717905,718109,718977,718983,719187,720043,720049,720253,720269,721098,721104,721308,721324,722156,722162,722366,722382,723218,723224,723428,723444,724270,724276,724480,724496,725313,725319,725523,725539,726346,726352,726556,726572,727371,727377,727582,727598,728388,728394,728599,728615,729395,729401,729606,729622,730395,730401,730606,730622,731387,731393,731598,731614,732374,732380,732585,732601,733368,733374,733579,733595,734355,734361,734566,734582,735334,735340,735545,735561,736301,736307,736512,736528,737273,737279,737484,737500,738237,738243,738448,738464,739192,739199,739404,739420,740142,740148,740349,740364,742110,742117,742318,742332,744083,744089,744291,744306,746048,746054,746255,746272,748009,748016,748217,748232,749991,749998,750199,750214,751973,751980,752181,752196,754852,754859,755061,755076,757725,757732,757934,757949,760591,760598,760801,760817,763456,763462,763668,763678,766315,766321,766527,766537,769166,769172,769374,769391,772012,772018,772220,772237,774852,774858,775059,775077,777687,777693,777894,777909,780518,780524,780725,780742,783354,783360,783566,783576,786183,786189,786390,786407,789009,789015,789216,789232,791831,791837,792038,792054,794650,794656,794852,794866,794944,797459,797465,797662,797675,797752,800264,800270,800467,800480,800557,803066,803072,803272,803282,803355,805860,805866,806064,806077,806153,808649,808655,808853,808866,808942,811432,811438,811635,811649,811725,814211,814218,814414,814428,814504,816985,816992,817188,817202,817278,819752,819759,819955,819969,820044,822512,822518,822719,822729,822802,825263,825270,825466,825480,825555,828009,828016,828213,828226,828300,830757,830954,830967,831041,833496,833693,833706,833780,836228,836429,836439,836512,839154,839168,839247,841879,841893,841971,844598,844612,844687,847337,847351,847426,850070,850084,850158,852799,852813,852887,855529,855543,855617,858254,858268,858342,860974,860988,861067,863687,863700,863779,866387,866401,866480,869077,869091,869170,871761,871775,871854,874449,874458,874539,877124,877137,877218,879807,879821,879902,882487,882501,882582,885170,885184,885265,887846,887856,887931,890506,890519,890600,893170,893179,893260,895823,895837,895918,898478,898488,898563,901118,901132,901213,903755,903769,903849,906378,906393,906473,908994,909009,909088,911611,911621,911696,911834,911836,911842,911846,914248,914258,914333,914471,914473,914479,914483,916953,916967,917044,917180,917181,917189,917190,919651,919667,919745,919873,919881,919882,919889,919891,922337,922352,922430,922559,922567,922568,922575,922577,925037,925051,925130,925259,925266,925267,925274,925276,927729,927746,927823,927951,927960,927961,927968,927971,930442,930459,930536,930664,930672,930673,930682,930684,933148,933164,933242,933372,933380,933381,933389,933390,935856,935873,935950,936080,936088,936090,936098,936099,938568,938583,938672,938810,938815,938817,938824,938826,941290,941307,941396,941533,941538,941540,941547,941548,944003,944021,944108,944244,944251,944252,944259,944261,946708,946727,946811,946947,946954,946955,946962,946963,949414,949427,949511,949656,949662,949664,949669,949673,952113,952129,952219,952363,952369,952370,952377,952378,954813,954826,954910,955055,955061,955063,955068,955072,957491,957509,957596,957739,957746,957747,957754,957755,960152,960170,960257,960399,960407,960408,960414,960415,962799,962816,962903,963045,963053,963054,963060,963061,965437,965454,965542,965682,965692,965693,965699,965700,968069,968086,968174,968317,968327,968328,968334,968335,970707,970720,970803,970951,970957,970959,970964,970968,973329,973342,973426,973574,973580,973582,973587,973591,975955,976041,976187,976195,976197,976202,976203,978568,978654,978807,978809,978814,978816,978824,981252,981404,981410,981411,981420,981422,983841,983993,983999,984000,984008,984010,986468,986620,986626,986627,986635,986637,989090,989242,989248,989249,989257,989259,991706,991854,991860,991862,991867,991871,994320,994467,994473,994474,994482,994484,996918,997065,997072,997073,997081,997083,999506,999652,999660,999661,999670,999671,1002088,1002124,1002131,1002234,1002242,1002243,1002252,1002253,1004664,1004702,1004708,1004812,1004818,1004820,1004825,1004829,1007233,1007271,1007277,1007381,1007387,1007389,1007394,1007398,1009800,1009836,1009843,1009942,1009952,1009953,1009959,1009962,1012348,1012386,1012392,1012496,1012502,1012504,1012509,1012513,1014923,1014960,1014966,1015066,1015074,1015075,1015082,1015086,1017474,1017512,1017518,1017622,1017628,1017630,1017635,1017639,1020021,1020059,1020065,1020169,1020175,1020177,1020182,1020186,1022569,1022605,1022612,1022714,1022722,1022723,1022731,1022732,1025142,1025148,1025253,1025259,1025261,1025266,1025270,1025297,1025304,1025308,1025316,1025322,1025329,1027673,1027679,1027788,1027794,1027796,1027801,1027805,1027832,1027839,1027843,1027851,1027857,1027864,1030198,1030205,1030313,1030323,1030325,1030332,1030333,1030364,1030365,1030377,1030378,1030389,1030390,1032709,1032715,1032826,1032832,1032834,1032840,1032844,1032871,1032878,1032883,1032891,1032897,1032904,1035204,1035210,1035321,1035327,1035329,1035335,1035339,1035366,1035373,1035378,1035386,1035392,1035399,1037692,1037698,1037704,1037710,1037711,1037806,1037815,1037817,1037823,1037825,1037856,1037857,1037870,1037871,1037882,1037883,1040177,1040183,1040189,1040195,1040196,1040291,1040300,1040302,1040308,1040310,1040341,1040342,1040355,1040356,1040367,1040368,1042661,1042667,1042673,1042674,1042769,1042779,1042785,1042787,1042795,1042817,1042819,1042832,1042833,1042845,1042846,1045138,1045143,1045144,1045248,1045255,1045256,1045265,1045266,1045287,1045289,1045301,1045303,1045314,1045316,1047611,1047612,1047708,1047715,1047716,1047726,1047727,1047758,1047759,1047771,1047772,1047774,1047785,1050159,1050166,1050167,1050176,1050177,1050209,1050210,1050221,1050222,1050234,1050235,1052594,1052602,1052603,1052611,1052612,1052643,1052644,1052655,1052656,1052668,1052669,1055019,1055025,1055027,1055033,1055037,1055064,1055071,1055076,1055084,1055090,1055097,1057445,1057451,1057453,1057459,1057463,1057490,1057497,1057502,1057510,1057516,1057523,1059864,1059870,1059872,1059878,1059882,1059909,1059916,1059921,1059929,1059935,1059942,1062272,1062280,1062281,1062288,1062289,1062322,1062323,1062334,1062335,1062346,1062347,1064666,1064672,1064674,1064680,1064684,1064711,1064718,1064723,1064731,1064737,1064744,1067050,1067060,1067061,1067067,1067068,1067099,1067100,1067113,1067114,1067126,1067127,1069430,1069438,1069439,1069446,1069447,1069479,1069480,1069491,1069492,1069503,1069504,1071799,1071806,1071807,1071816,1071817,1071849,1071850,1071862,1071863,1071874,1071875,1072124,1074189,1074198,1074199,1074206,1074207,1074235,1074237,1074249,1074250,1074262,1074264,1074525,1076578,1076584,1076586,1076592,1076596,1076623,1076630,1076635,1076643,1076649,1076656,1076912,1078954,1078960,1078962,1078968,1078972,1078999,1079006,1079011,1079019,1079025,1079032,1079288,1081324,1081331,1081332,1081339,1081340,1081372,1081373,1081384,1081385,1081397,1081398,1081649,1083674,1083682,1083683,1083690,1083691,1083723,1083724,1083734,1083735,1083747,1083748,1084001,1086012,1086019,1086020,1086027,1086028,1086058,1086059,1086069,1086070,1086083,1086084,1086339,1088334,1088341,1088342,1088350,1088351,1088381,1088382,1088391,1088392,1088403,1088404,1088664,1090667,1090673,1090675,1090681,1090685,1090712,1090719,1090724,1090732,1090738,1090745,1091000,1093000,1093002,1093009,1093011,1093041,1093043,1093052,1093053,1093065,1093066,1093324,1095323,1095327,1095354,1095361,1095366,1095374,1095380,1095387,1095642,1097654,1097661,1097666,1097674,1097680,1097687,1097942,1099947,1099948,1099960,1099961,1099972,1099973,1100221,1102219,1102220,1102232,1102233,1102244,1102245,1102493,1104489,1104490,1104500,1104501,1104751,1106735,1106737,1106988,1109203,1111398,1113575,1115738,1117879,1120013,1122145,1124283,1126478,1128689,1130903,1133099,1135291,1137499,1139698,1141894,1144076,1146256,1148420,1150575,1152726,1154868,1157011,1159177,1161332,1163473,1165604,1167742,1169870,1171991,1174109,1176255,1178390,1180518,1182637,1184747,1186853,1188960,1189315,1189325,1191059,1191414,1191424,1193147,1193502,1193512,1195225,1195581,1195591,1197301,1197657,1197667,1199372,1199725,1199736,1201433,1201786,1201797,1203483,1203848,1203858,1205536,1205897,1205908,1207573,1207934,1207945,1209602,1209976,1209986,1211637,1212014,1212026,1213672,1214047,1214058,1215694,1216069,1216080,1217703,1218078,1218089,1219697,1220072,1220083,1221680,1222055,1222066,1223656,1224031,1224042,1225627,1226002,1226013,1227620,1227995,1228006,1229634,1230012,1230023,1231644,1232017,1232029,1233640,1234018,1234029,1235628,1236000,1236013,1237608,1237985,1237996,1239576,1239953,1239964,1241909,1241920,1243892,1243903,1245862,1245874,1247824,1247835,1249810,1249821,1251788,1251799,1253769,1253780,1255742,1255754,1257713,1257724,1259673,1259684,1261620,1261631,1263554,1263565,1265479,1265490,1267409,1267420,1269329,1269340,1271238,1271249,1273136,1273147,1275020,1275031,1276883,1276894,1278744,1278755,1280597,1280608,1282436,1282447,1284274,1284285,1286098,1286109,1287909,1287920,1289703,1289714,1291488,1291499,1293298,1293309,1295100,1295111,1296895,1296906,1298681,1298692,1300452,1300463,1302207,1302219,1303960,1303971,1305708,1305719,1307448,1307459,1309178,1309189,1310896,1310907,1312815,1312826,1314732,1314743,1316666,1316677,1318593,1318604,1320512,1320523,1322421,1322432,1324323,1324334,1326210,1326221,1328078,1328088,1329939,1329950,1331826,1331837,1333703,1333714,1335570,1335581,1337426,1337437,1339271,1339282,1341101,1341112,1342918,1342929,1344727,1344738,1346534,1346545,1348331,1348342,1350121,1350132,1352026,1352037,1353918,1353929,1355799,1355810,1357670,1357681,1359531,1359542,1361383,1361394,1363226,1363237,1365058,1365069,1366877,1366888,1368686,1368697,1370490,1370501,1372283,1372294,1374063,1374074,1375923,1375934,1377766,1377777,1379595,1379606,1381413,1381424,1383229,1383240,1385047,1386851,1424008,1425697,1427371,1429035,1430685,1432325,1433956,1435572,1437177,1438798,1440406,1442007,1443601,1445185,1446758,1448322,1449874,1451414,1452944,1454464,1455973,1457475,1458966,1460445,1461911,1463367,1464813,1466245,1467667,1469076,1470470,1471851,1473219,1474578,1475924,1477275,1478623,1480007,1481379,1482740,1483043,1484096,1484399,1485440,1485743,1486775,1487078,1488099,1488402,1489405,1489708,1490700,1491003,1491986,1492289,1493300,1493603,1494605,1494908,1495902,1496205,1497194,1497502,1498497,1498805,1499790,1500098,1501073,1501381,1502349,1502657,1503617,1503925,1504878,1505186,1506131,1506439,1507378,1507686,1508615,1508923,1509843,1510151,1511065,1511382,1512290,1512607,1513518,1513835,1514739,1515056,1515962,1516279,1517177,1517494,1518383,1518700,1519582,1519903,1520778,1521099,1521968,1522289,1523151,1523472,1524326,1524647,1525494,1525815,1526655,1526976,1527810,1528131,1528959,1529280,1530104,1530425,1531245,1531566,1532380,1532704,1533512,1533836,1534640,1534964,1535764,1536088,1536883,1537207,1537996,1538320,1539133,1539457,1540263,1540587,1541388,1541712,1542507,1542831,1543618,1543942,1545047,1546145,1547230,1548303,1549366,1550421,1551469,1552508,1553549,1553585,1554584,1554620,1555611,1555647,1556629,1556665,1557639,1557675,1558647,1558683,1559645,1559681,1561003,1561039,1562352,1562388,1564195,1564231,1566028,1566064,1567852,1567885,1570770,1570810,1573664,1573703,1576548,1576584,1579420,1579454,1582282,1582318,1585129,1585165,1587967,1588000,1590802,1590838,1593627,1593663,1596484,1596520,1599355,1599391,1602214,1602246,1605063,1605099,1607903,1607934,1610737,1610769,1613563,1613594,1616378,1616417,1619185,1619221,1621971,1622010,1624751,1624787,1627520,1627556,1630278,1630309,1633024,1633056,1635822,1635862,1638653,1638689,1641494,1641530,1644320,1644353,1647134,1647167,1647301,1647302,1647311,1647312,1647323,1647324,1647347,1647348,1647363,1647365,1647387,1647390,1649943,1649982,1650114,1650115,1650121,1650124,1650133,1650135,1650155,1650156,1650170,1650171,1650195,1650196,1652812,1652851,1652981,1652983,1652989,1652991,1653000,1653003,1653023,1653026,1653039,1653040,1653063,1653064,1655676,1655712,1655842,1655843,1655853,1655854,1655863,1655864,1655885,1655886,1655898,1655899,1655923,1655924,1658524,1658560,1658690,1658691,1658701,1658702,1658711,1658712,1658733,1658734,1658746,1658747,1658771,1658772,1661361,1661397,1661527,1661528,1661538,1661539,1661548,1661549,1661570,1661571,1661583,1661584,1661608,1661609,1664184,1664220,1664350,1664351,1664361,1664362,1664371,1664372,1664393,1664394,1664406,1664407,1664431,1664432,1666997,1667032,1667162,1667163,1667176,1667177,1667187,1667188,1667199,1667200,1667218,1667219,1667241,1667242,1669803,1669839,1669969,1669970,1669980,1669981,1669990,1669991,1670012,1670013,1670025,1670026,1670050,1670051,1672662,1672698,1672828,1672829,1672839,1672840,1672849,1672850,1672871,1672872,1672884,1672885,1672909,1672910,1675514,1675550,1675680,1675681,1675691,1675692,1675701,1675702,1675723,1675724,1675736,1675737,1675761,1675762,1678360,1678394,1678529,1678530,1678541,1678542,1678550,1678551,1678564,1678577,1678583,1678584,1678606,1678608,1681200,1681229,1681361,1681362,1681370,1681371,1681380,1681381,1681401,1681402,1681422,1681423,1681444,1681445,1684027,1684059,1684190,1684191,1684201,1684202,1684211,1684212,1684238,1684239,1684257,1684258,1684281,1684282,1686842,1686878,1687023,1687024,1687037,1687038,1687049,1687050,1687075,1687076,1687092,1687093,1687123,1687124,1689697,1689730,1689883,1689884,1689894,1689895,1689904,1689905,1689932,1689935,1689954,1689956,1689986,1689988,1692551,1692587,1692732,1692733,1692746,1692747,1692758,1692759,1692784,1692785,1692801,1692802,1692832,1692833,1695319,1695355,1695497,1695499,1695507,1695509,1695520,1695521,1695546,1695549,1695568,1695569,1695599,1695600,1698078,1698114,1698259,1698260,1698274,1698275,1698286,1698287,1698312,1698313,1698329,1698330,1698360,1698361,1700831,1700867,1701012,1701013,1701027,1701028,1701039,1701040,1701065,1701066,1701082,1701083,1701113,1701114,1703575,1703611,1703756,1703757,1703771,1703772,1703783,1703784,1703809,1703810,1703826,1703827,1703857,1703858,1706313,1706344,1706493,1706495,1706507,1706509,1706519,1706520,1706546,1706548,1706568,1706569,1706599,1706600,1709084,1709115,1709264,1709266,1709278,1709280,1709290,1709291,1709316,1709318,1709339,1709340,1709370,1709371,1711846,1711882,1712027,1712028,1712042,1712043,1712054,1712055,1712080,1712081,1712097,1712098,1712128,1712129,1714630,1714666,1714811,1714812,1714826,1714827,1714838,1714839,1714864,1714865,1714881,1714882,1714912,1714913,1717405,1717441,1717586,1717587,1717601,1717602,1717613,1717614,1717639,1717640,1717656,1717657,1717687,1717688,1720203,1720348,1720349,1720363,1720364,1720375,1720376,1720401,1720402,1720418,1720419,1720449,1720450,1722951,1723094,1723096,1723105,1723107,1723119,1723120,1723146,1723148,1723166,1723167,1723199,1723200,1725691,1725836,1725837,1725851,1725852,1725863,1725864,1725889,1725890,1725906,1725907,1725937,1725938,1728426,1728571,1728572,1728586,1728587,1728598,1728599,1728624,1728625,1728641,1728642,1728672,1728673,1731152,1731297,1731298,1731312,1731313,1731324,1731325,1731350,1731351,1731367,1731368,1731398,1731399,1733860,1734005,1734006,1734020,1734021,1734032,1734033,1734058,1734059,1734075,1734076,1734106,1734107,1736559,1736704,1736705,1736719,1736720,1736731,1736732,1736757,1736758,1736774,1736775,1736805,1736806,1739392,1739393,1739407,1739408,1739419,1739420,1739445,1739446,1739462,1739463,1739493,1739494,1742066,1742067,1742081,1742082,1742093,1742094,1742119,1742120,1742136,1742137,1742167,1742168,1744730,1744731,1744745,1744746,1744757,1744758,1744783,1744784,1744800,1744801,1744831,1744832,1747388,1747389,1747403,1747404,1747415,1747416,1747441,1747442,1747458,1747459,1747489,1747490,1750037,1750038,1750052,1750053,1750064,1750065,1750090,1750091,1750107,1750108,1750138,1750139,1752679,1752680,1752694,1752695,1752706,1752707,1752732,1752733,1752749,1752750,1752780,1752781,1755312,1755313,1755327,1755328,1755339,1755340,1755365,1755366,1755382,1755383,1755413,1755414,1757937,1757938,1757950,1757951,1757961,1757962,1757987,1757988,1758010,1758011,1758043,1758044,1760546,1760547,1760560,1760561,1760571,1760572,1760595,1760597,1760620,1760622,1760653,1760654,1763148,1763149,1763162,1763163,1763174,1763175,1763198,1763199,1763218,1763219,1763249,1763250,1765748,1765749,1765763,1765764,1765775,1765776,1765801,1765802,1765818,1765819,1765849,1765850,1768341,1768342,1768356,1768357,1768368,1768369,1768394,1768395,1768411,1768412,1768442,1768443,1770926,1770927,1770941,1770942,1770953,1770954,1770979,1770980,1770996,1770997,1771027,1771028,1773502,1773503,1773517,1773518,1773529,1773530,1773555,1773556,1773572,1773573,1773603,1773604,1776076,1776077,1776091,1776092,1776103,1776104,1776129,1776130,1776146,1776147,1776177,1776178,1778635,1778636,1778650,1778651,1778662,1778663,1778688,1778689,1778705,1778706,1778736,1778737,1781184,1781185,1781199,1781200,1781211,1781212,1781237,1781238,1781254,1781255,1781285,1781286,1783726,1783727,1783741,1783742,1783753,1783754,1783779,1783780,1783796,1783797,1783827,1783828,1786258,1786259,1786273,1786274,1786285,1786286,1786311,1786312,1786328,1786329,1786359,1786360,1788763,1788764,1788778,1788779,1788790,1788791,1788816,1788817,1788833,1788834,1788864,1788865,1791257,1791258,1791272,1791273,1791284,1791285,1791310,1791311,1791327,1791328,1791358,1791359,1793733,1793734,1793748,1793749,1793760,1793761,1793786,1793787,1793803,1793804,1793834,1793835,1796190,1796191,1796205,1796206,1796217,1796218,1796243,1796244,1796260,1796261,1796291,1796292,1798635,1798636,1798647,1798648,1798662,1798663,1798692,1798693,1798712,1798713,1798744,1798745,1801093,1801094,1801108,1801109,1801120,1801121,1801146,1801147,1801163,1801164,1801194,1801195,1803553,1803554,1803565,1803566,1803591,1803592,1803608,1803609,1803639,1803640,1805990,1805991,1806016,1806017,1806033,1806034,1806064,1806065,1808433,1808434,1808453,1808454,1808471,1808472,1810822,1810823,1810842,1810843,1810874,1810875,1813197,1813198,1813228,1813229,1815546,1815547,1815577,1815578,1817909,1817910,1820216,1820217,2323316,2326454,2329584,2332695,2335797,2338893,2341989,2345096,2515120,2515126,2517970,2517976,2520813,2520819,2523645,2523651,2526465,2526471,2529278,2529284,2532086,2532092,2534887,2534893,2537681,2537687,2540475,2540481,2543259,2543265,2546032,2546038,2548798,2548804,2551603,2551609,2551652,2551667,2551673,2551689,2551695,2554399,2554405,2554448,2554463,2554469,2554485,2554491,2557210,2557216,2557259,2557274,2557280,2557296,2557302,2560013,2560019,2560062,2560077,2560083,2560099,2560105,2562802,2562808,2562851,2562866,2562872,2562888,2562894,2565582,2565583,2565628,2565646,2565647,2565670,2565671,2568348,2568349,2568394,2568412,2568413,2568436,2568437,2571174,2571180,2571223,2571238,2571244,2571260,2571266,2573996,2574002,2574045,2574060,2574066,2574082,2574088,2576810,2576816,2576859,2576874,2576880,2576896,2576902,2577021,2579612,2579618,2579662,2579679,2579687,2579705,2579711,2579830,2582409,2582415,2582459,2582476,2582484,2582502,2582508,2582627,2585191,2585197,2585241,2585258,2585266,2585284,2585290,2585409,2587962,2587968,2588012,2588029,2588037,2588055,2588061,2588180,2590730,2590736,2590780,2590797,2590805,2590823,2590829,2590948,2593489,2593495,2593539,2593556,2593564,2593582,2593588,2593707,2596240,2596246,2596290,2596307,2596315,2596333,2596339,2596458,2598982,2598988,2599032,2599049,2599057,2599075,2599081,2599200,2601711,2601717,2601761,2601778,2601786,2601804,2601810,2601929,2604427,2604433,2604477,2604494,2604502,2604520,2604526,2604645,2607134,2607140,2607184,2607201,2607209,2607227,2607233,2607352,2607375,2609837,2609843,2609887,2609904,2609912,2609930,2609936,2610055,2610078,2612531,2612537,2612581,2612598,2612606,2612624,2612630,2612749,2612772,2615255,2615261,2615305,2615322,2615330,2615348,2615354,2615473,2615496,2617972,2617978,2618022,2618039,2618047,2618065,2618071,2618190,2618213,2620679,2620685,2620729,2620746,2620754,2620772,2620778,2620897,2620920,2623371,2623377,2623421,2623438,2623446,2623464,2623470,2623589,2623612,2626052,2626058,2626102,2626119,2626127,2626145,2626151,2626270,2626293,2628733,2628739,2628783,2628800,2628808,2628826,2628832,2628951,2628974,2631398,2631404,2631448,2631465,2631473,2631491,2631497,2631616,2631639,2634065,2634071,2634115,2634132,2634140,2634158,2634164,2634283,2634306,2636711,2636717,2636761,2636778,2636786,2636804,2636810,2636929,2636952,2639345,2639351,2639395,2639412,2639420,2639438,2639444,2639563,2639586,2641966,2641972,2642016,2642033,2642041,2642059,2642065,2642184,2642207,2644575,2644581,2644625,2644642,2644650,2644668,2644674,2644793,2644816,2647176,2647182,2647226,2647243,2647251,2647269,2647275,2647394,2647417,2649764,2649770,2649814,2649831,2649839,2649857,2649863,2649982,2650005,2652343,2652349,2652393,2652410,2652418,2652436,2652442,2652561,2652584,2654910,2654916,2654960,2654977,2654985,2655003,2655009,2655128,2655151,2657512,2657529,2657537,2657555,2657561,2657680,2657703,2660046,2660063,2660071,2660089,2660095,2660214,2660237,2662561,2662578,2662586,2662604,2662610,2662729,2662752,2665062,2665079,2665087,2665105,2665111,2665230,2665253,2667566,2667574,2667592,2667598,2667717,2667740,2670029,2670037,2670055,2670061,2670180,2670203,2672506,2672512,2672631,2672654,2674937,2674943,2675062,2675085,2677474,2677497,2679866,2679889,2682242,2682265,2684609,2684632,2686971,2686994,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,2908403,2911020,2913618,2916206,2918796,2921369,2923934,2926488,2929024,2931543,2934052,2936552,2939060,2941563,2944057,2946535,2948997,2951444,2953891,2953898,2956380,2956387,2958859,2958866,2961328,2961335,2963777,2963784,2966208,2966215,2968626,2968633,2971042,2971049,2973442,2973449,2975831,2975838,2978208,2978215,2980598,2980605,2982974,2982981,2985343,2985350,2987727,2987734,2990105,2990112,2992481,2992488,2994844,2994851,2997194,2997201,2999528,2999535,3001851,3001858,3004166,3004173,3006456,3006463,3008682,3008689,3010870,3010877,3013038,3013045,3015190,3015197,3017334,3017341,3019522,3019529,3021598,3021604,3023075,3023081,3024544,3024550,3026000,3026006,3027446,3027452,3028884,3028890,3030316,3030322,3031738,3031744,3033150,3033156,3034748,3034754,3036334,3036340,3037909,3037915,3039476,3039482,3041035,3041041,3042585,3042591,3044127,3044133,3045662,3045668,3047185,3047191,3048697,3048703,3050202,3050208,3051710,3051716,3053208,3053214,3054693,3054699,3056169,3056175,3057634,3057640,3059087,3059093,3060532,3060538,3061969,3061975,3063704,3063710,3065430,3065436,3067145,3067151,3068847,3068853,3070540,3070546,3072224,3072230,3073899,3073905,3075564,3075570,3077222,3077228,3078883,3078889,3080535,3080541,3082178,3082184,3083810,3083816,3085432,3085438,3087080,3087086,3088719,3088725,3090347,3090353,3091963,3091969,3093569,3093575,3095167,3095173,3096757,3096763,3098338,3098344,3099915,3099921,3101481,3101487,3103032,3103038,3104574,3104580,3106108,3106114,3107663,3221505,3231385,3232998,3234600,3236187,3237762,3239331,3240894,3242492,3244078,3245654,3247245,3248822,3250390,3251954,3255839,3255852,3257854,3257867,3259855,3259868,3261843,3261856,3263825,3263838,3265804,3265815,3267594,3267792,3267803,3269646,3269844,3269855,3271729,3271934,3271946,3273844,3274049,3274061,3275943,3276148,3276160,3278033,3278238,3278250,3280120,3280345,3280358,3282250,3282475,3282488,3284374,3284599,3284612,3286494,3286718,3286734,3288858,3288874,3290981,3290997,3293090,3293106,3295193,3295209,3297289,3297305,3299377,3299393,3301456,3301472,3303523,3303539,3305578,3305594,3307625,3307641,3309669,3309685,3311705,3311721,3313727,3313743,3315741,3315757,3317745,3317761,3319739,3319755,3321725,3321741,3323708,3323724,3325852,3325868,3328121,3328137,3330504,3330520,3332874,3332890,3335231,3335247,3337581,3337597,3339927,3339943,3342266,3342282,3344627,3344643,3346979,3346995,3349322,3349338,3351650,3351666,3353971,3353987,3356289,3356305,3358637,3358653,3361002,3361018,3363359,3363375,3365703,3365719,3368039,3368055,3370367,3370383,3372688,3372704,3375002,3375018,3377311,3377327,3379611,3379627,3381894,3381910,3384159,3384175,3386449,3443894,3443911,3445865,3445882,3448016,3448033,3450159,3450176,3452294,3452311,3454418,3454435,3456537,3456554,3458661,3458678,3460797,3460814,3462927,3462944,3465077,3465094,3467221,3467238,3469394,3469411,3471556,3471573,3473710,3473727,3475866,3475883,3476254,3476260,3478016,3478033,3478404,3478410,3480158,3480175,3480546,3480552,3482290,3482307,3482673,3482681,3484417,3484434,3484800,3484808,3486535,3486552,3486918,3486926,3488645,3488662,3489028,3489036,3490778,3490795,3491161,3491169,3492904,3492921,3493287,3493295,3495024,3495041,3495407,3495415,3497181,3497198,3497564,3497572,3499328,3499345,3499711,3499719,3501468,3501485,3501851,3501859,3503601,3503617,3503984,3503992,3505729,3505745,3506112,3506120,3507852,3507868,3508235,3508243,3509968,3509984,3510351,3510359,3512080,3512096,3512463,3512471,3514182,3514198,3514565,3514573,3516276,3516292,3516659,3516667,3518351,3518363,3518379,3518746,3518754,3520449,3520465,3520828,3520836,3522523,3522539,3522902,3522910,3524591,3524607,3524975,3524983,3526647,3526663,3527031,3527039,3528728,3529096,3529104,3531148,3531156,3533190,3533198,3535230,3535238,3537264,3537272,3539290,3539298,3541329,3541337,3543391,3543399,3545439,3545447,3547477,3547485,3549466,3549470,3549482,3549512,3549520,3551508,3551511,3551522,3551552,3551561,3553545,3553548,3553559,3553589,3553598,3555586,3555589,3555600,3555630,3555639,3557616,3557619,3557630,3557660,3557669,3559634,3559637,3559648,3559678,3559687,3561643,3561646,3561657,3561687,3561696,3563646,3563649,3563660,3563690,3563699,3565666,3565669,3565680,3565710,3565719,3567682,3567685,3567696,3567726,3567735,3569705,3569708,3569719,3569749,3569758,3571713,3571718,3571730,3571760,3571769,3573733,3573738,3573750,3573780,3573789,3575641,3575646,3575658,3575688,3575697,3577548,3577553,3577565,3577595,3577604,3579451,3579456,3579468,3579498,3579507,3581350,3581355,3581367,3581397,3581406,3583209,3583216,3583226,3583258,3583265,3585069,3585076,3585086,3585118,3585125,3586926,3586933,3586943,3586975,3586982,3588780,3588787,3588797,3588829,3588836,3590632,3590639,3590649,3590681,3590688,3592481,3592488,3592498,3592530,3592537,3594432,3594439,3594449,3594481,3594488,3596428,3596435,3596445,3596477,3596484,3598410,3598417,3598427,3598459,3598466,3600377,3600384,3600394,3600426,3600433,3602329,3602336,3602346,3602378,3602385,3604272,3604279,3604289,3604321,3604328,3606203,3606210,3606220,3606252,3606259,3608126,3608133,3608143,3608175,3608182,3610039,3610046,3610056,3610088,3610095,3611940,3611947,3611957,3611989,3611996,3613869,3613876,3613886,3613918,3613925,3615786,3615793,3615803,3615835,3615842,3617696,3617703,3617713,3617745,3617752,3619600,3619607,3619617,3619649,3619656,3621503,3621510,3621520,3621552,3621559,3623398,3623405,3623415,3623447,3623454,3625281,3625288,3625298,3625330,3625337,3627153,3627160,3627170,3627202,3627209,3629017,3629024,3629034,3629066,3629073,3630877,3630884,3630894,3630926,3630933,3632731,3632738,3632748,3632780,3632787,3634577,3634584,3634594,3634626,3634633,3636416,3636423,3636433,3636465,3636472,3638245,3638252,3638262,3638294,3638301,3640061,3640068,3640078,3640110,3640117,3641867,3641874,3641884,3641916,3641923,3643665,3643672,3643682,3643714,3643721,3645455,3645462,3645472,3645504,3645511,3647238,3647245,3647255,3647287,3647294,3649013,3649020,3649030,3649062,3649069,3650775,3650782,3650792,3650824,3650831,3652526,3652533,3652543,3652575,3652582,3654269,3654276,3654286,3654318,3654325,3656005,3656012,3656022,3656054,3656061,3657731,3657738,3657748,3657780,3657787,3659456,3659463,3659473,3659505,3659512,3661187,3661194,3661204,3661236,3661243,3662905,3662912,3662922,3662954,3662961,3664613,3664620,3664630,3664662,3664669,3666315,3666322,3666332,3666364,3666371,3668010,3668017,3668027,3668059,3668066,3669700,3669710,3669742,3669749,3671376,3671386,3671418,3671425,3673057,3673089,3673096,3674716,3674748,3674755,3676397,3676404,3678039,3678046,3679676,3679683,3681311,3681318,3682940,3682947,3684563,3684570,3686174,3686181,3687776,3687783,3689374,3689381,3690975,3692562)) 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





	Maxim Paster (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Maxim Paster (Tenor)
			

																
Maxim Paster (Tenor)

														
				


        




    

        Born in Kharkov, in the Ukraine. In 1994, he graduated from the faculty of choral conducting of the Kharkov Music College. In 1998, he entered the vocal fac­ulty of the Kharkov Institute of the Arts (prof. L. Tsuran`s class; D. Gendelman`s class of cham­ber singing). 

From 2002-03, he was soloist with the Kharkov Theatre of Opera and Ballet. 



His repertory includes: Paolino (Domenico Cimarosa`s II matrimonio segreto), Lucentio (Vissarion Shebalin`s Taming of the Shrew), Chekalinsky (The Queen of Spades); solo parts in Mozart`s Requiem and Coronation Mass, in Verdi`s Requiem, Weber`s Requiem, Schubert`s Messas G-dur, Es-dur, Rossini`s Petite Messe solennelle and Stabat mater. 



Bolshoi Theatre



In 2003, he made his debut at the Bolshoi as Bayan (Mikhail Glinka`s Ruslan and Lyudmila). 

At the Russian premiere, at the Bolshoi Theatre in June 2004, of the first version of Richard Wagner`s Der Fliegende Hollaender, he sang The Steersman (conductor Alexander Vedernikov, director Peter Konwitschny, designer Johannes Leiacher).

In 2005, he sang the role of Tchaikovsky in the world premiere of  The Children of Rosenthal, an opera  written to a  Bolshoi Theatre commission  by the Petersburgian composer Leonid Desyatnikov.



He has worked with the world-famous directors: Robert Wilson, Eimuntas Nekrosius, Robert Sturua, Francesca Zambello, Temur Chkheidze.



Also in his Repertory at the Bolshoi

 

Macduff (Macbeth)

Andrei (Mazeppa)

Mephistopheles (Sergei Prokofiev`s The Fiery Angel) 

Shuisky (Boris Godunov)

Zinovy Borisovich (The Lady Macbeth of Mtsensk)

Pinkerton (Madama Butterfly)



Tours



In 2004, he sang the part of  the Prince in a concert performance of Antonin Dvorzhak`s Rusalka (Big Hall of the Moscow Conservatory, conductor Valery Polyansky).

In 2005, he toured the cities of Germany with the Bolshoi Theatre Children`s Chorus, under the leadership of chorus master Julia Molchanova.

Also in 2005, he took part in a performance of Igor Stravinsky`s Pulcinella, and Sergei Prokofiev`s They are Seven Cantata (Big Hall of the Moscow Conservatory, conductor Gennadi Rozhdestvensky), and in a performance of Anton Bruckner`s Symphony No. 9 and Te Deum (Big Hall, Moscow Conservatory, conductor Gunther Herbig).

In 2006, he took part in a performance of Schubert`s Mass in E flat major  at the Teatro di San Carlo (Naples) and of Stravinsky`s The Wedding and Mendelssohn`s Die erste Walpurgisnacht in Weimar and Leipzig.

He participates in the Parade of Tenors project (Tenors of the 21st Century) under whose auspices he tours in Russia and the SNG countries. 



Awards



Award-winner at the XXXVth Antonin Dvorzhak Competition (2nd prizes in the opera and chamber music sec­tions; Karlovy Vary, 2000); Vth Amber Nightingale Chamber Singing Competition (1st prize, Kaliningrad, 2002); 2nd A. Solovyanenko Nightingale Fair Competition (Grand Prix, Donetsk, 2002). Diploma-win­ner at the Xllth Pyotr Ilych Tchaikovsky Competition (Moscow, 2002) and the Nikolai Lysenko Competition (Kiev, 2002). Grant-holder of the Nikolai Manoylo prize (2002). 
        

    

    

            


			

		





	


	

	

		


			

				

					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