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
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.
Sign in to our website using your Facebook or Google+ account.
Why Do You Need Our Travel Expert
Contact our experts, and they will help you to plan your best trip to Russia, with attention to every detail!
Our Experts have been in the travel industry for many years, guarantee to offer first class customer service, excellent value for money and unbiased advice. They are standing by to find and build your dream holiday to one of the world's most fascinating destinations - Russia. Your personal Travel Expert will guide you through each stage of the travel process, from choosing a program that fits you best to support during your trip.
Just tell us your e-mail, and we'll take care of everything!
Your tour request has been received. Thank you ! We have sent you the confirmation message to [email]
Please make sure that you receive this message (sometimes e-mail messages may go to the spam/junk mail). If you did not get this message, it means you will not get message with the tours' selection as well. If you use a Yahoo!, Gmail, AOL or Hotmail, we recommend to add request@uvisitrussia.comto your address book.
We recommend to leave your phone number. If we will not heard back that you received the e-mail with the tours' selection, we will contact you by phone. And you will not miss the best tour for you.
Thank you ! Your request for Travel Expert assistance has been sent. We will e-mail you within 1 hour.
Sorry, some changes needed
Add your E-mail
There was a problem with your request
Missing contact person. Please correct and try again.