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 (203516,203518,203520,203523,205188,205190,205192,205195,206892,206894,206896,206899,208586,208588,208590,208593,210244,210246,210248,210251,211808,211810,211813,211817,213341,213343,213346,213350,214879,214881,214884,214888,216412,216414,216417,216421,217943,217945,217948,217952,219468,219470,219473,219477,220989,220991,220994,220998,222506,222508,222511,222515,224018,224020,224023,224027,225526,225528,225531,225535,227034,227036,227039,227043,228537,228539,228542,228546,230034,230036,230039,230043,232018,232020,232023,232027,234012,234014,234017,234021,236002,236005,236009,237989,381195,381198,381202,383020,383023,383027,383028,384839,384842,384846,384847,386651,386654,386658,386659,388466,388468,388473,388475,390274,390276,390281,390283,392075,392077,392082,392084,393874,393876,393881,393883,395669,395671,395676,395678,397458,397460,397465,397467,399241,399245,399248,399252,401015,401017,401022,401024,402780,402782,402787,402789,404538,404542,404545,404546,406294,406296,406301,406303,408045,408047,408052,408054,409789,409791,409795,409798,411530,411533,411537,411538,413292,413295,413299,413300,415043,415046,415050,415051,416785,416788,416792,416793,418526,418529,418533,418534,420262,420265,420269,420270,421992,421994,421999,422000,423721,423724,423728,423729,425443,425446,425450,425451,427151,427154,427158,427159,428849,428851,428856,428857,430542,430544,430549,430550,432249,432252,432256,432257,433953,433955,433959,433961,435648,435650,435654,435656,437336,437338,437342,437344,439012,439014,439018,439020,440676,440678,440682,440684,442327,442329,442333,442335,443965,443967,443971,443973,445592,445594,445598,445600,447214,447216,447220,447222,448823,448824,448828,448831,450420,450421,450426,450428,452011,452012,452017,452019,453601,453602,453607,453609,455187,455188,455193,455195,456765,456766,456771,456773,458337,458338,458343,458346,459901,459902,459907,459910,461456,461457,461462,461465,463004,463005,463010,463012,464556,464557,464562,464564,466103,466104,466109,466111,467643,467644,467648,467651,469348,469349,469353,469356,471063,471064,471069,471072,472612,472613,472618,472621,474154,474157,474160,474162,475734,475737,475740,475742,477311,477315,477318,477322,478885,478888,478891,478893,480452,480455,480458,480460,481204,481208,481210,481215,481949,481952,481955,481957,482686,482689,482692,482694,483420,483423,483426,483428,484165,484167,484170,484172,484914,484916,484919,484921,485657,485659,485662,485664,486387,486388,486392,486394,487108,487109,487113,487115,487822,487823,487827,487829,488534,488535,488539,488541,489246,489247,489251,489253,489953,489954,489958,489960,490653,490654,490658,490660,491348,491349,491353,491355,492033,492034,492038,492040,492716,492717,492721,492723,493398,493399,493403,493405,494074,494075,494079,494081,494743,494744,494747,494750,495404,495405,495408,495412,496053,496054,496057,496061,496691,496692,496696,496699,498161,498162,498166,498170,499623,499624,499628,499632,501079,501083,501087,502533,541766,541770,541774,541779,543216,543220,543224,543230,544694,544698,544703,544708,546152,546156,546161,546165,547606,547610,547615,547619,549061,549065,549070,549074,550510,550514,550519,550523,551951,551955,551960,551964,553384,553388,553394,553398,554805,554809,554815,554821,556217,556221,556227,556233,557623,557627,557633,557639,559023,559027,559033,559039,560420,560425,560429,560436,561810,561815,561819,561826,563198,563202,563206,563213,564575,564579,564583,564589,565942,565946,565950,565956,567303,567308,567313,567319,568661,568665,568669,568675,570014,570018,570022,570028,571357,571361,571365,571371,572739,572743,572747,572753,574119,574124,574128,574134,575488,575492,575496,575503,576848,576852,576856,576863,578205,578209,578213,578219,579556,579560,579564,579569,580894,580898,580902,580907,582223,582227,582231,582237,583553,583557,583561,583567,584873,584877,584881,584886,586186,586190,586194,586199,587495,587500,587503,587508,588797,588802,588805,588810,590185,590190,590195,590203,591807,591811,591817,591824,593445,593449,593456,593462,595153,595158,595162,595170,596850,596855,596859,596867,598534,598538,598544,598551,600212,600217,600221,600229,601891,601895,601901,601909,603565,603570,603574,603582,605225,605230,605236,605242,606882,606887,606891,606899,608527,608532,608536,608544,610165,610170,610174,610182,611849,611854,611858,611866,613526,613531,613535,613543,615193,615198,615202,615210,616846,616852,616856,616864,618490,618495,618499,618507,620123,620128,620132,620140,621748,621753,621758,621764,623369,623374,623378,623386,624979,624984,624988,624996,626600,626605,626609,626617,628211,628216,628220,628228,629811,629816,629820,629828,631404,631409,631413,631421,632991,632996,633000,633008,634569,634574,634578,634586,636136,636141,636145,636153,637694,637699,637703,637711,639238,639243,639249,639255,640776,640781,640785,640793,642302,642307,642312,642319,643819,643824,643829,643834,645333,645337,645343,645348,646836,646841,646845,646853,648331,648336,648340,648348,649830,649835,649839,649847,651318,651323,651327,651335,652799,652804,652808,652816,654271,654276,654280,654288,655732,655737,655741,655749,657183,657188,657192,657200,658638,658643,658647,658655,660077,660082,660088,660091,661513,661518,661522,661530,662937,662942,662946,662954,664354,664359,664363,664371,665764,665769,665773,665781,667200,667205,667211,667216,668635,668640,668644,668652,670076,670081,670085,670093,671508,671513,671517,671525,672932,672937,672941,672949,674343,674348,674352,674360,675745,675750,675754,675762,677134,677139,677143,677148,678517,678522,678526,678534,679918,679923,679927,679935,681310,681315,681319,681327,682692,682697,682701,682709,684064,684069,684073,684081,685423,685428,685432,685440,686763,686768,686772,686780,688089,688094,688098,688106,689388,689393,689397,689405,690674,690679,690683,690691,691950,691955,691959,691967,693213,693218,693224,693229,694477,694481,694489,695720,695728,696954,786485,789311,792133,794947,797756,800561,803361,806158,808947,811730,814509,817283,820050,822808,825561,828307,831048,833787,836518,839249,841974,844693,847432,847656,847659,847661,847666,850165,850389,850392,850394,850399,852894,853124,853127,853129,853134,855624,855856,855859,855862,855866,858349,858581,858584,858587,858591,861069,861301,861304,861307,861311,863781,864013,864016,864019,864023,866482,866714,866717,866720,866724,869172,869405,869407,869411,869414,871856,872090,872092,872096,872099,874540,874776,874778,874782,874786,877190,877204,877212,877220,877464,877467,877471,877474,879875,879889,879895,879904,880148,880151,880155,880158,882555,882568,882575,882584,882828,882832,882834,882838,885239,885252,885258,885267,885511,885515,885517,885521,887904,887922,887927,887937,888181,888185,888188,888193,890573,890587,890594,890602,890847,890850,890854,890856,893232,893246,893254,893262,893507,893510,893514,893516,895890,895904,895912,895920,896165,896168,896172,896174,898536,898554,898559,898569,898813,898817,898820,898825,901186,901199,901207,901215,901459,901462,901466,901469,903822,903835,903843,903851,904095,904098,904102,904105,906446,906459,906467,906474,906720,906722,906726,906729,909061,909074,909082,909090,909335,909337,909341,909343,911669,911687,911692,911702,911945,911949,911952,911957,914306,914324,914329,914339,914582,914586,914589,914594,917019,917034,917039,917049,917292,917296,917298,917302,919718,919730,919739,919748,919991,919995,919998,920002,922405,922418,922425,922434,922677,922681,922683,922688,925106,925119,925126,925134,925377,925381,925383,925388,927798,927811,927818,927826,928070,928073,928077,928081,928208,928218,928221,930511,930524,930531,930539,930783,930786,930790,930794,930922,930932,930935,933217,933230,933234,933244,933489,933491,933495,933500,933633,933643,933646,935926,935939,935946,935953,936197,936200,936204,936209,936343,936352,936356,938644,938660,938667,938675,938927,938929,938934,938939,939080,939086,939089,941367,941385,941391,941399,941651,941653,941658,941663,941804,941811,941818,944080,944098,944104,944112,944364,944366,944371,944378,944517,944524,944531,946783,946801,946807,946816,947067,947070,947073,947078,947219,947228,947234,949481,949503,949508,949517,949776,949779,949783,949791,949928,949938,949940,952191,952208,952214,952222,952482,952484,952490,952495,952635,952642,952649,954880,954902,954907,954916,955175,955178,955182,955190,955327,955337,955339,957568,957585,957592,957600,957860,957862,957867,957875,958013,958020,958027,960230,960247,960253,960260,960520,960523,960528,960536,960673,960681,960688,962873,962889,962898,962908,963168,963171,963174,963177,963318,963327,963331,965514,965531,965538,965546,965805,965808,965812,965821,965959,965966,965973,968146,968164,968170,968180,968440,968443,968447,968456,968594,968601,968608,970773,970795,970800,970809,971071,971074,971078,971086,971223,971233,971235,973396,973418,973423,973432,973694,973697,973701,973709,973846,973856,973858,976017,976033,976040,976049,976310,976313,976317,976323,976464,976471,976473,978629,978647,978653,978663,978923,978926,978930,978935,979077,979084,979086,981228,981244,981251,981261,981521,981524,981528,981532,981675,981682,981684,983816,983833,983840,983850,984109,984112,984115,984120,984263,984270,984277,986443,986460,986467,986477,986736,986739,986741,986747,986891,986898,986905,989065,989082,989089,989099,989358,989361,989363,989369,989513,989520,989527,991676,991698,991703,991712,991973,991976,991980,991988,992126,992136,992138,994290,994308,994314,994324,994584,994586,994588,994594,994738,994745,994752,996889,996907,996912,996923,997183,997185,997187,997193,997336,997344,997351,999476,999494,999500,999511,999769,999773,999775,999780,999925,999932,999939,1002058,1002076,1002082,1002093,1002351,1002354,1002357,1002362,1002507,1002514,1002521,1004634,1004656,1004661,1004670,1004931,1004934,1004938,1004946,1005084,1005094,1005096,1007203,1007225,1007230,1007239,1007500,1007503,1007507,1007515,1007653,1007664,1007667,1009772,1009788,1009795,1009805,1010063,1010066,1010069,1010074,1010219,1010228,1010233,1012340,1012345,1012354,1012615,1012618,1012622,1012630,1012768,1012779,1012782,1012791,1014911,1014917,1014927,1015186,1015189,1015193,1015200,1015340,1015350,1015356,1015364,1017471,1017480,1017741,1017744,1017748,1017756,1017894,1017905,1017908,1017917,1020018,1020027,1020288,1020291,1020295,1020303,1020441,1020452,1020455,1020464,1022574,1022835,1022838,1022842,1022849,1022988,1022999,1023005,1023013,1025110,1025373,1025376,1025380,1025388,1025526,1025537,1025540,1025549,1027908,1027911,1027915,1027923,1028061,1028072,1028075,1028084,1030439,1030442,1030445,1030452,1030593,1030602,1030608,1030617,1032949,1032952,1032956,1032964,1033102,1033113,1033116,1033125,1035444,1035447,1035451,1035459,1035597,1035608,1035611,1035620,1037932,1037935,1037938,1037943,1038088,1038097,1038102,1038110,1040418,1040421,1040425,1040429,1040574,1040583,1040588,1040597,1042898,1042899,1042902,1042907,1043054,1043063,1043068,1043076,1045369,1045372,1045373,1045378,1045525,1045534,1045538,1045547,1047830,1047833,1047838,1047845,1047986,1047995,1047999,1048008,1050281,1050284,1050289,1050296,1050437,1050446,1050450,1050460,1052717,1052719,1052724,1052732,1052872,1052882,1052887,1052894,1055143,1055146,1055150,1055158,1055298,1055309,1055312,1055321,1057569,1057572,1057576,1057584,1057724,1057735,1057738,1057747,1059988,1059991,1059995,1060003,1060143,1060154,1060157,1060165,1062395,1062397,1062403,1062410,1062550,1062560,1062565,1062572,1064790,1064793,1064797,1064805,1064945,1064956,1064959,1064967,1067179,1067182,1067186,1067189,1067335,1067344,1067349,1067356,1069553,1069556,1069561,1069569,1069710,1069718,1069723,1069731,1071918,1071922,1071924,1071929,1072076,1072085,1072091,1072098,1074316,1074319,1074323,1074329,1074473,1074480,1074484,1074493,1076702,1076705,1076709,1076717,1076857,1076868,1076871,1076879,1079078,1079081,1079085,1079093,1079233,1079244,1079247,1079255,1081444,1081447,1081449,1081454,1081600,1081609,1081614,1081622,1083795,1083798,1083801,1083806,1083952,1083961,1083967,1083974,1086135,1086138,1086143,1086144,1086291,1086300,1086304,1086312,1088458,1088461,1088465,1088467,1088613,1088623,1088627,1088636,1090791,1090794,1090798,1090806,1090945,1090956,1090959,1090967,1093120,1093123,1093128,1093135,1093274,1093284,1093289,1093297,1095433,1095436,1095440,1095448,1095587,1095598,1095601,1095609,1097733,1097736,1097740,1097748,1097887,1097898,1097901,1097909,1100018,1100021,1100025,1100030,1100172,1100182,1100187,1100195,1102290,1102293,1102298,1102303,1102443,1102453,1102459,1102467,1104547,1104551,1104556,1104563,1104701,1104712,1104716,1104724,1106784,1106788,1106792,1106800,1106940,1106949,1106954,1106961,1109001,1109004,1109009,1109016,1109156,1109165,1109169,1109178,1111196,1111199,1111204,1111211,1111350,1111360,1111364,1111372,1113373,1113376,1113381,1113388,1113527,1113537,1113542,1113549,1115531,1115534,1115538,1115546,1115686,1115694,1115700,1115707,1117671,1117676,1117680,1117684,1117828,1117835,1117843,1117850,1119806,1119811,1119815,1119819,1119963,1119970,1119978,1119985,1121936,1121941,1121945,1121949,1122092,1122101,1122108,1122116,1124079,1124083,1124087,1124230,1124239,1124246,1124254,1126278,1126282,1126425,1126434,1126441,1126449,1128472,1128629,1128646,1128650,1128659,1130841,1130860,1130863,1130872,1133036,1133056,1133059,1133067,1135226,1135241,1135250,1135258,1137432,1137448,1137456,1137465,1139635,1139654,1139657,1139665,1141827,1141842,1141851,1141859,1144015,1144034,1144038,1144045,1146191,1146206,1146215,1146223,1148355,1148370,1148379,1148387,1150510,1150525,1150534,1150542,1152661,1152676,1152685,1152693,1154806,1154827,1154830,1154837,1156943,1156959,1156967,1156976,1159114,1159133,1159136,1159145,1161269,1161288,1161291,1161299,1163408,1163423,1163432,1163440,1165540,1165559,1165563,1165571,1167677,1167692,1167701,1167709,1169808,1169826,1169830,1169838,1171930,1171948,1171952,1171960,1174044,1174059,1174068,1174076,1176190,1176205,1176214,1176222,1178325,1178340,1178349,1178357,1180453,1180468,1180477,1180485,1182572,1182587,1182596,1182604,1184682,1184697,1184706,1184714,1186793,1186812,1186815,1186821,1188899,1188918,1188921,1188927,1190998,1191016,1191020,1191026,1193085,1193104,1193107,1193115,1195164,1195183,1195186,1195194,1197240,1197259,1197262,1197270,1199307,1199322,1199331,1199339,1201368,1201383,1201392,1201400,1203419,1203440,1203443,1203451,1205471,1205486,1205495,1205503,1207508,1207523,1207532,1207540,1209537,1209552,1209561,1209569,1211575,1211594,1211599,1211607,1213607,1213622,1213631,1213639,1215629,1215644,1215653,1215661,1217653,1217662,1217670,1219647,1219656,1219664,1221639,1221647,1223615,1223623,1225594,1227587,1302424,1302429,1302433,1302439,1302445,1304175,1304179,1304184,1304190,1304195,1305923,1305927,1305932,1305938,1305943,1307663,1307667,1307672,1307678,1307683,1309393,1309397,1309402,1309408,1309413,1311117,1311121,1311126,1311132,1311137,1313038,1313043,1313048,1313055,1313061,1314971,1314976,1314981,1314988,1314997,1316905,1316910,1316915,1316922,1316931,1318832,1318837,1318842,1318849,1318858,1320751,1320756,1320761,1320768,1320777,1322660,1322665,1322670,1322677,1322686,1324562,1324567,1324572,1324579,1324588,1326446,1326452,1326458,1326465,1326475,1328314,1328320,1328328,1328334,1328342,1330175,1330181,1330187,1330194,1330204,1332062,1332068,1332074,1332081,1332091,1333939,1333945,1333951,1333958,1333968,1335806,1335812,1335818,1335825,1335835,1337662,1337668,1337674,1337681,1337691,1339507,1339513,1339519,1339526,1339536,1341337,1341343,1341349,1341356,1341366,1343154,1343160,1343166,1343173,1343183,1344963,1344969,1344975,1344982,1344992,1346770,1346776,1346782,1346789,1346799,1348567,1348573,1348579,1348586,1348596,1350357,1350363,1350369,1350376,1350386,1352262,1352268,1352274,1352281,1352291,1354154,1354160,1354166,1354173,1354183,1356035,1356041,1356047,1356054,1356064,1357906,1357912,1357918,1357925,1357935,1359767,1359773,1359779,1359786,1359796,1361619,1361625,1361631,1361638,1361648,1363462,1363468,1363474,1363481,1363491,1365294,1365300,1365306,1365313,1365323,1367113,1367119,1367125,1367132,1367142,1368922,1368928,1368934,1368941,1368951,1370726,1370732,1370738,1370745,1370755,1372519,1372525,1372531,1372538,1372548,1374299,1374305,1374311,1374318,1374328,1376159,1376165,1376171,1376178,1376188,1378002,1378008,1378014,1378021,1378031,1379831,1379837,1379843,1379850,1379860,1381649,1381655,1381661,1381668,1381678,1383465,1383471,1383477,1383484,1383494,1385276,1385283,1385289,1385296,1385306,1387080,1387087,1387092,1387098,1387108,1388874,1388881,1388886,1388892,1388902,1390654,1390661,1390666,1390672,1390682,1392423,1392430,1392435,1392441,1392451,1394183,1394190,1394195,1394201,1394211,1395961,1395968,1395973,1395979,1395989,1397727,1397734,1397739,1397745,1397755,1399484,1399491,1399496,1399502,1399512,1401236,1401243,1401248,1401254,1401264,1402978,1402985,1402990,1402996,1403006,1404711,1404718,1404723,1404729,1404739,1406434,1406441,1406446,1406452,1406462,1408155,1408162,1408167,1408173,1408183,1409879,1409886,1409891,1409897,1409907,1411606,1411613,1411618,1411624,1411634,1413356,1413363,1413368,1413374,1413384,1415116,1415123,1415128,1415134,1415144,1416867,1416873,1416877,1416885,1416893,1418601,1418608,1418613,1418619,1418629,1420328,1420335,1420340,1420346,1420356,1422045,1422052,1422057,1422063,1422073,1423748,1423755,1423760,1423766,1423776,1424018,1424026,1424032,1425437,1425444,1425449,1425455,1425465,1425707,1425715,1425721,1427111,1427118,1427123,1427129,1427139,1427381,1427389,1427395,1428775,1428782,1428787,1428793,1428803,1429045,1429053,1429059,1430425,1430432,1430437,1430443,1430453,1430695,1430703,1430709,1432065,1432072,1432077,1432083,1432093,1432335,1432343,1432349,1433696,1433703,1433708,1433714,1433724,1433966,1433974,1433980,1435312,1435319,1435324,1435330,1435340,1435582,1435590,1435596,1436917,1436924,1436929,1436935,1436945,1437187,1437195,1437201,1438538,1438545,1438550,1438556,1438566,1438808,1438816,1438822,1440146,1440153,1440158,1440164,1440174,1440416,1440424,1440430,1441747,1441754,1441759,1441765,1441775,1442017,1442026,1442032,1443341,1443348,1443353,1443359,1443369,1443611,1443620,1443626,1444925,1444932,1444937,1444943,1444953,1445195,1445204,1445210,1446501,1446508,1446513,1446519,1446529,1446768,1446774,1446777,1446783,1448065,1448072,1448077,1448083,1448093,1448332,1448338,1448341,1448347,1449617,1449624,1449629,1449635,1449645,1449884,1449890,1449893,1449899,1451157,1451164,1451169,1451175,1451185,1451424,1451430,1451433,1451439,1452687,1452694,1452699,1452705,1452715,1452954,1452960,1452963,1452969,1454207,1454214,1454219,1454225,1454235,1454474,1454480,1454483,1454489,1455716,1455723,1455728,1455734,1455744,1455983,1455990,1455994,1456002,1457218,1457225,1457230,1457236,1457246,1457485,1457492,1457496,1457504,1458711,1458718,1458722,1458729,1458739,1458976,1458983,1458987,1458995,1460190,1460197,1460201,1460208,1460218,1460455,1460462,1460466,1460474,1461656,1461663,1461667,1461674,1461684,1461921,1461928,1461932,1461940,1463112,1463119,1463123,1463130,1463140,1463377,1463384,1463388,1463396,1464558,1464565,1464569,1464576,1464586,1464823,1464830,1464834,1464842,1465997,1466001,1466008,1466018,1466255,1466262,1466266,1466274,1467423,1467430,1467440,1467677,1467684,1467688,1467696,1468839,1468849,1469086,1469093,1469097,1469105,1470243,1470480,1470487,1470491,1470499,1471861,1471868,1471872,1471880,1473229,1473236,1473240,1473248,1474588,1474595,1474599,1474607,1475934,1475941,1475945,1475953,1477285,1477292,1477296,1477304,1478633,1478640,1478644,1478652,1480017,1480024,1480028,1480036,1481389,1481396,1481400,1481408,1482750,1482757,1482761,1482769,1484106,1484113,1484117,1484125,1485450,1485457,1485461,1485469,1486785,1486792,1486796,1486804,1488109,1488116,1488120,1488128,1489415,1489422,1489426,1489434,1490710,1490717,1490721,1490729,1491996,1492003,1492007,1492015,1493310,1493317,1493321,1493329,1494615,1494622,1494626,1494634,1495912,1495919,1495923,1495931,1497204,1497211,1497215,1497223,1498507,1498514,1498518,1498526,1499800,1499807,1499811,1499819,1501083,1501090,1501094,1501102,1502359,1502366,1502370,1502378,1503627,1503634,1503638,1503646,1504888,1504895,1504899,1504907,1506141,1506148,1506152,1506160,1507388,1507395,1507399,1507407,1508625,1508632,1508636,1508644,1509853,1509860,1509864,1509872,1511075,1511082,1511086,1511094,1512300,1512307,1512311,1512319,1513528,1513535,1513539,1513547,1514749,1514756,1514760,1514768,1515972,1515979,1515983,1515991,1517187,1517194,1517198,1517206,1518393,1518400,1518404,1518412,1519592,1519599,1519603,1519611,1520788,1520795,1520799,1520807,1521978,1521985,1521989,1521997,1523161,1523168,1523172,1523180,1524336,1524343,1524347,1524355,1525504,1525511,1525515,1525523,1526665,1526672,1526676,1526684,1527820,1527827,1527831,1527839,1528969,1528976,1528980,1528988,1530114,1530121,1530125,1530133,1531255,1531262,1531266,1531274,1532386,1532397,1532403,1532407,1533518,1533529,1533535,1533539,1534646,1534657,1534663,1534667,1535770,1535781,1535787,1535791,1536889,1536900,1536906,1536910,1538002,1538013,1538019,1538023,1539139,1539150,1539156,1539160,1540269,1540280,1540286,1540290,1541394,1541405,1541411,1541415,1542513,1542524,1542530,1542534,1543624,1543635,1543641,1543645,1544729,1544740,1544746,1544750,1545827,1545838,1545844,1545848,1546923,1546929,1546933,1548002,1548006,1549069,1550129,1639024,1639027,1639079,1639084,1639095,1639107,1641865,1641868,1641920,1641925,1641936,1641948,1644689,1644693,1644747,1644752,1644763,1644775,1647501,1647505,1647509,1647563,1647568,1647579,1647591,1650314,1650317,1650322,1650374,1650379,1650388,1650402,1653183,1653186,1653191,1653243,1653248,1653257,1653271,1656042,1656048,1656051,1656103,1656108,1656119,1656131,1658890,1658897,1658900,1658952,1658957,1658968,1658980,1661727,1661734,1661737,1661789,1661794,1661805,1661817,1664550,1664557,1664560,1664612,1664617,1664628,1664640,1667363,1667367,1667371,1667424,1667429,1667438,1667450,1670169,1670176,1670179,1670231,1670236,1670247,1670259,1673028,1673035,1673038,1673090,1673095,1673106,1673118,1675880,1675887,1675890,1675942,1675947,1675958,1675970,1678729,1678731,1678735,1678738,1678789,1678793,1678804,1678815,1681566,1681568,1681572,1681575,1681627,1681632,1681643,1681655,1684391,1684394,1684396,1684400,1684453,1684457,1684467,1684480,1687262,1687264,1687268,1687271,1687323,1687328,1687339,1687352,1690118,1690120,1690124,1690129,1690182,1690187,1690198,1690211,1692971,1692974,1692978,1692982,1693028,1693033,1693045,1693052,1695739,1695741,1695746,1695749,1695794,1695799,1695812,1695818,1698499,1698502,1698506,1698510,1698556,1698561,1698573,1698580,1701252,1701255,1701259,1701263,1701309,1701314,1701326,1701333,1703996,1703999,1704003,1704007,1704053,1704058,1704070,1704077,1706735,1706737,1706740,1706746,1706791,1706797,1706809,1706815,1709506,1709508,1709511,1709517,1709562,1709568,1709580,1709586,1712267,1712270,1712274,1712278,1712325,1712330,1712342,1712349,1715051,1715054,1715058,1715062,1715109,1715114,1715126,1715133,1717826,1717829,1717833,1717837,1717884,1717889,1717901,1717908,1720588,1720591,1720595,1720599,1720646,1720651,1720663,1720670,1723337,1723339,1723344,1723347,1723393,1723398,1723411,1723417,1726076,1726079,1726084,1726088,1726136,1726141,1726153,1726160,1728811,1728814,1728819,1728823,1728871,1728876,1728888,1728895,1731537,1731540,1731545,1731549,1731590,1731595,1731605,1731610,1734245,1734248,1734253,1734257,1734298,1734303,1734313,1734318,1736944,1736947,1736952,1736956,1736997,1737002,1737012,1737017,1739632,1739635,1739640,1739644,1739685,1739690,1739700,1739705,1742306,1742309,1742314,1742318,1742359,1742364,1742374,1742379,1744970,1744973,1744978,1744982,1745023,1745028,1745038,1745043,1747628,1747631,1747636,1747640,1747681,1747686,1747696,1747701,1750277,1750280,1750285,1750289,1750330,1750335,1750345,1750350,1752919,1752922,1752927,1752931,1752973,1752978,1752988,1752993,1755552,1755555,1755560,1755564,1755606,1755611,1755621,1755626,1758175,1758179,1758183,1758189,1758228,1758234,1758246,1758249,1760786,1760790,1760794,1760799,1760839,1760845,1760857,1760860,1763390,1763392,1763397,1763403,1763442,1763447,1763457,1763462,1765987,1765990,1765995,1765999,1766041,1766046,1766056,1766061,1768580,1768583,1768588,1768592,1768634,1768639,1768649,1768654,1771165,1771168,1771173,1771177,1771219,1771224,1771234,1771239,1773741,1773744,1773749,1773753,1773795,1773800,1773810,1773815,1776315,1776318,1776323,1776327,1776369,1776374,1776384,1776389,1778874,1778877,1778882,1778886,1778928,1778933,1778943,1778948,1781423,1781426,1781431,1781435,1781477,1781482,1781492,1781497,1783965,1783968,1783973,1783977,1784019,1784024,1784034,1784039,1786497,1786500,1786505,1786509,1786551,1786556,1786566,1786571,1789002,1789005,1789010,1789014,1789056,1789061,1789071,1789076,1791496,1791499,1791504,1791508,1791550,1791555,1791565,1791570,1793972,1793975,1793980,1793984,1794026,1794031,1794041,1794046,1796429,1796432,1796437,1796441,1796483,1796488,1796498,1796503,1798872,1798875,1798880,1798885,1798925,1798930,1798941,1798945,1801332,1801335,1801340,1801344,1801386,1801391,1801401,1801406,1803777,1803780,1803785,1803789,1803831,1803836,1803846,1803851,1806202,1806205,1806210,1806214,1806256,1806261,1806271,1806276,1808611,1808614,1808617,1808624,1808664,1808670,1808680,1808685,1811002,1811005,1811008,1811015,1811055,1811061,1811073,1811076,1813366,1813369,1813374,1813378,1813420,1813425,1813435,1813440,1815715,1815718,1815723,1815727,1815769,1815774,1815784,1815789,1818047,1818050,1818055,1818059,1818101,1818106,1818116,1818121,1820354,1820357,1820361,1820366,1820411,1820418,1820426,1820429,1822635,1822638,1822642,1822647,1822692,1822699,1822707,1822710,1824891,1824894,1824898,1824903,1824948,1824955,1824963,1824966,1827124,1827127,1827131,1827136,1827181,1827188,1827196,1827199,1829336,1829337,1829343,1829345,1829392,1829399,1829407,1829410,1831528,1831531,1831535,1831540,1831585,1831592,1831600,1831603,1833714,1833717,1833721,1833726,1833771,1833778,1833786,1833789,1835912,1835915,1835918,1835922,1835968,1835976,1835982,1835986,1838102,1838105,1838109,1838115,1838158,1838163,1838172,1838176,1840282,1840285,1840289,1840295,1840338,1840343,1840352,1840356,1842442,1842445,1842449,1842455,1842497,1842502,1842512,1842516,1844586,1844589,1844592,1844597,1844642,1844648,1844659,1844661,1846726,1846729,1846733,1846738,1846784,1846791,1846803,1846806,1848880,1848883,1848887,1848893,1848936,1848941,1848953,1848959,1851029,1851032,1851036,1851042,1851085,1851090,1851102,1851108,1853171,1853174,1853178,1853183,1853229,1853236,1853248,1853251,1855307,1855310,1855314,1855319,1855365,1855372,1855384,1855387,1857440,1857443,1857447,1857452,1857498,1857505,1857517,1857520,1859563,1859565,1859568,1859575,1859621,1859627,1859641,1859642,1861678,1861681,1861685,1861690,1861736,1861743,1861755,1861758,1863793,1863795,1863798,1863805,1863850,1863857,1863871,1863872,1865901,1865904,1865908,1865913,1865959,1865966,1865978,1865981,1867991,1867994,1867998,1868003,1868049,1868056,1868068,1868071,1870075,1870078,1870081,1870086,1870132,1870138,1870151,1870155,1872149,1872152,1872156,1872161,1872207,1872214,1872226,1872229,1874210,1874213,1874216,1874222,1874268,1874274,1874286,1874290,1876264,1876267,1876270,1876276,1876322,1876328,1876340,1876344,1878316,1878319,1878323,1878328,1878374,1878381,1878393,1878396,1880392,1880396,1880401,1880447,1880454,1880466,1880469,1882460,1882465,1882511,1882518,1882530,1882533,1884520,1884566,1884573,1884585,1884588,1886642,1886648,1886660,1886664,1888707,1888714,1888727,1888729,1890767,1890774,1890787,1890789,1892837,1892846,1892861,1892866,1894909,1894918,1894933,1894938,1896992,1897001,1897016,1897021,1899127,1899136,1899151,1899156,1901275,1901284,1901299,1901304,1903412,1903421,1903436,1903441,1905542,1905551,1905567,1905570,1907684,1907694,1907710,1907714,1909841,1909850,1909867,1909871,1911990,1911999,1912014,1912019,1914155,1914164,1914174,1914182,1916371,1916380,1916395,1916400,1918577,1918586,1918601,1918607,1920777,1920786,1920801,1920806,1922974,1922983,1922998,1923003,1925189,1925204,1925209,1925748,1925752,1925757,1925761,1927437,1927454,1927457,1927992,1927996,1928001,1928005,1929689,1929692,1930227,1930231,1930236,1930240,1931906,1931911,1932450,1932454,1932459,1932463,1934118,1934655,1934658,1934664,1934668,1936316,1936853,1936856,1936862,1936866,1939049,1939053,1939058,1939062,1941232,1941236,1941241,1941245,1943408,1943412,1943417,1943421,1945572,1945576,1945581,1945585,1947724,1947728,1947733,1947738,1949865,1949869,1949874,1949879,1951999,1952003,1952008,1952013,1954133,1954137,1954142,1954146,1956212,1956216,1956221,1956225,1958281,1958285,1958290,1958294,1960336,1960340,1960345,1960349,1962379,1962383,1962388,1962392,1964410,1964414,1964418,1964424,1966436,1966440,1966445,1966451,1968459,1968460,1968464,1968469,1970470,1970474,1970478,1970484,1972483,1972487,1972491,1972497,1974489,1974493,1974498,1974499,1976482,1976486,1976491,1976495,1978461,1978465,1978470,1978474,1980427,1980431,1980435,1980441,1982424,1982427,1982431,1982436,1984412,1984416,1984420,1984426,1986395,1986399,1986403,1986409,1988367,1988372,1988376,1988382,1990328,1990333,1990337,1990343,1992276,1992281,1992285,1992291,1994215,1994220,1994224,1994230,1996150,1996154,1996160,1996164,1998075,1998080,1998084,1998090,1999994,1999999,2000003,2000009,2001903,2001908,2001912,2001918,2003799,2003804,2003808,2003814,2005682,2005687,2005691,2005697,2007564,2007570,2007576,2007581,2009445,2009451,2009456,2009464,2011329,2011334,2011340,2011346,2013201,2013206,2013209,2013215,2015043,2015049,2015054,2015062,2016875,2016881,2016886,2016894,2018693,2018699,2018704,2018712,2020506,2020511,2020517,2020522,2022311,2022316,2022322,2022328,2024105,2024111,2024116,2024124,2026103,2026109,2026114,2026122,2028098,2028104,2028109,2028117,2030085,2030091,2030095,2030103,2032057,2032063,2032067,2032074,2034019,2034025,2034029,2034036,2035978,2035984,2035988,2035995,2037927,2037934,2037938,2037945,2039870,2039877,2039881,2039887,2041801,2041807,2041812,2041820,2043723,2043729,2043733,2043738,2045627,2045633,2045637,2045642,2047523,2047529,2047533,2047538,2049409,2049414,2049419,2049425,2051287,2051292,2051297,2051303,2053158,2053164,2053168,2053173,2055113,2055119,2055124,2055129,2057153,2057158,2057162,2057168,2059194,2059200,2059204,2059209,2061225,2061231,2061235,2061240,2063249,2063255,2063259,2063264,2065264,2065270,2065274,2065279,2067271,2067277,2067281,2067286,2069269,2069275,2069280,2069286,2071268,2071274,2071279,2071285,2073255,2073261,2073266,2073272,2075232,2075238,2075243,2075249,2077201,2077207,2077212,2077218,2079205,2079211,2079216,2079222,2081201,2081207,2081212,2081218,2083188,2083194,2083199,2083205,2085120,2085126,2085131,2085137,2087042,2087048,2087053,2087059,2088953,2088959,2088964,2088970,2090860,2090866,2090871,2090877,2092761,2092767,2092772,2092778,2094651,2094657,2094662,2094668,2096530,2096536,2096541,2096547,2098395,2098401,2098406,2098412,2100356,2100362,2100367,2100373,2102307,2102313,2102318,2102324,2104268,2104274,2104279,2104285,2106223,2106229,2106234,2106240,2108169,2108174,2108179,2108185,2110104,2110109,2110114,2110120,2112028,2112033,2112038,2112044,2113940,2113945,2113950,2113956,2115843,2115848,2115853,2115859,2117738,2117743,2117748,2117754,2119625,2119630,2119635,2119641,2121502,2121507,2121512,2121518,2123369,2123374,2123379,2123385,2125221,2125226,2125231,2125237,2127062,2127067,2127072,2127078,2128896,2128901,2128906,2128912,2130722,2130727,2130732,2130738,2132538,2132543,2132548,2132554,2134345,2134350,2134355,2134361,2136139,2136144,2136149,2136155,2137918,2137924,2137929,2137934,2139766,2139771,2139776,2139782,2141600,2141605,2141610,2141616,2143425,2143430,2143435,2143441,2145239,2145244,2145249,2145255,2147043,2147048,2147053,2147059,2148837,2148842,2148847,2148853,2150617,2150622,2150627,2150633,2152384,2152389,2152394,2152400,2154142,2154147,2154152,2154158,2155891,2155896,2155901,2155907,2157629,2157634,2157639,2157645,2159356,2159361,2159366,2159372,2161110,2161115,2161120,2161126,2162849,2162854,2162859,2162865,2164578,2164583,2164588,2164594,2166299,2166304,2166309,2166315,2168002,2168007,2168012,2168018,2169698,2169703,2169709,2170487,2170493,2171272)) 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





	William Lacey (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters William Lacey (Conductor)

William Lacey (Conductor)

Conductor William Lacey was born in London in 1973. His wide opera and concert repertoire is equally weighted between the 18th, 19th and 20th centuries, and also includes some works from the 17th and 21st centuries. From 2010 to 2013 he was Erster Kapellmeister at the Oper Leipzig where he conducted over one hundred performances with the Leipzig Gewandhaus Orchestra. His Leipzig repertoire included Mahagonny, The Cunning Little Vixen, Hänsel und Gretel, Die Fledermaus, La bohème, La Rondine, Macbeth, La Traviata, Il Barbiere di Siviglia, Il Turco in Italia, Don Giovanni, Cosi fan tutte, and Die Zauberflöte; ballets Cinderella (Prokofiev), Eine Weihnachtsgeschichte, Chaplin, Bach Tanzt!, Grosse Messe (Mozart), and Ein Liebestraum (Mahler and Wagner); the Leipziger Opernball (Johann Strauss); and Leipzig Opera House’s special 50th Anniversary concert.

Another highlight of his recent activities has been his regular performances with Plácido Domingo, including Handel’s Tamerlano in Barcelona, Washington, and Los Angeles, and Gluck’s Iphigénie en Tauride in Washington. In 2012 he conducted the world premiere of Jonathan Dove’s Life is a Dream in a production by Graham Vick with the Birmingham Opera Company, and Britten’s A Midsummer Night’s Dream at the Stanislavsky and Nemirovich-Danchenko Moscow Music Theatre. In June 2013 he made a very successful debut at Garsington Opera conducting Mozart’s Die entführung aus dem Serail, and in November he conducted Netia Jones’ highly acclaimed production of Britten’s Curlew River starring Ian Bostridge at the Barbican Centre in London.

In 2014 he returned to Moscow for his debut at the Bolshoi (concert performances of Le nozze di Figaro), a new production of Don Giovanni at the Stanislavsky Theatre, his debut concert at the Tchaikovsky Concert Hall, and two concerts with the Bolshoi Orchestra in both Moscow and St Petersburg.

He most recently made his debut for Scottish opera conducting La cenerentola.

In North America, William Lacey has conducted regularly at many of the leading opera companies, including San Francisco Opera (where he was Staff Conductor from 1998 to 2001), Houston Grand Opera, Los Angeles Opera, Santa Fe Opera, Washington National Opera, the Canadian Opera Company in Toronto, New York City Opera, Utah Opera, and Glimmerglass Opera. His guest appearances in Europe have included the Gran Teatre del Liceu in Barcelona, the Opéra Comique in Paris (with l’Orchestre de Paris), the Royal Opera in Stockholm, Norwegian National Opera, Greek National Opera, The Netherland’s Nationale Reisopera, Cologne Opera, English National Opera, Opera North, and Birmingham Opera Company.

William Lacey is increasingly in demand as a concert conductor, and has already appeared with the Scottish Chamber Orchestra, the Royal Scottish National Orchestra, the Ulster Orchestra, the Houston Symphony Orchestra, the Pacific Symphony Orchestra, the Israel Camerata, the Hong Kong Philharmonic Orchestra, the Youth Orchestra of Bolivia Clasica (La Paz), the Collegium Musicum of Copenhagen, the Deutsche Staatsphilharmonie Rheinland-Pfalz, the Real Filharmonia de Galicia, the Orquesta Sinfonica de Navarra, l’Orchestre de Bretagne, the Haydn Orchestra of Bolzano, the Remix Orchestra (Porto), the Tiroler Festspiele Orchester, and the Orchestra of the Teatro Massimo Bellini in Catania. He made his debut with the Munich Radio Orchestra in 2011 and was re-invited for 2012. Notable recent concerts have included Mahler’s 5th Symphony at the Tiroler Festspiele, and Mahler’s 1st Symphony in Catania.