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 (590442,590454,590466,590470,590534,590627,590705,590756,590763,592063,592075,592087,592093,592155,592248,592326,592377,592384,593702,593714,593726,593731,593793,593887,593965,594016,594026,595409,595421,595432,595437,595500,595594,595671,595721,595730,597106,597118,597129,597134,597197,597291,597368,597418,597427,598792,598805,598815,598819,598882,598976,599055,599106,599115,600468,600480,600491,600496,600559,600653,600730,600780,600789,602149,602162,602172,602176,602240,602333,602412,602463,602472,603821,603833,603844,603849,603912,604006,604083,604133,604142,605484,605495,605508,605511,605575,605670,605747,605798,605807,607138,607150,607161,607166,607229,607323,607400,607450,607459,608783,608795,608806,608811,608874,608968,609045,609095,609104,610421,610433,610444,610450,610520,610615,610694,610745,610754,612105,612117,612128,612134,612204,612299,612378,612429,612438,613782,613794,613805,613811,613881,613976,614055,614106,614115,615449,615461,615472,615478,615548,615643,615722,615773,615782,617103,617116,617127,617134,617202,617298,617377,617430,617439,618746,618758,618769,618775,618845,618940,619019,619070,619079,620379,620391,620402,620408,620478,620573,620652,620703,620712,622005,622019,622029,622036,622106,622199,622279,622332,622341,623625,623637,623648,623654,623724,623819,623898,623949,623958,625238,625253,625269,625280,625353,625448,625527,625578,625587,626859,626874,626890,626901,626974,627069,627148,627199,627208,628470,628485,628501,628512,628585,628680,628759,628810,628819,630070,630085,630101,630112,630185,630280,630359,630410,630419,631663,631678,631694,631705,631778,631873,631952,632003,632012,633250,633265,633281,633292,633365,633460,633539,633590,633599,634828,634843,634859,634870,634943,635038,635117,635168,635177,636395,636410,636426,636437,636510,636605,636684,636735,636744,637953,637968,637984,637995,638068,638163,638242,638293,638302,639500,639513,639530,639541,639613,639711,639788,639839,639849,641035,641050,641066,641077,641150,641245,641324,641375,641384,642564,642580,642594,642605,642673,642770,642847,642898,642908,644081,644097,644111,644121,644190,644286,644364,644415,644424,645593,645607,645623,645634,645702,645799,645877,645928,645938,647095,647110,647126,647137,647206,647300,647379,647430,647439,648590,648605,648621,648632,648701,648795,648874,648925,648934,650089,650104,650120,650131,650200,650294,650373,650424,650433,651577,651592,651608,651619,651688,651782,651861,651912,651921,653058,653073,653089,653100,653169,653263,653342,653393,653402,654530,654545,654561,654572,654641,654735,654814,654865,654874,655991,656006,656022,656033,656102,656196,656275,656326,656335,657442,657457,657473,657484,657553,657647,657726,657777,657786,658897,658912,658928,658939,659008,659102,659181,659232,659241,660340,660354,660372,660380,660449,660546,660624,660674,660684,661772,661787,661803,661814,661883,661977,662056,662107,662116,663196,663211,663227,663238,663307,663401,663480,663531,663540,664613,664628,664644,664655,664724,664818,664897,664948,664957,666023,666038,666054,666065,666134,666228,666307,666358,666367,667464,667478,667496,667504,667573,667670,667747,667797,667807,668892,668907,668923,668934,669003,669097,669176,669227,669236,670333,670348,670364,670375,670444,670538,670617,670668,670677,671765,671780,671796,671807,671876,671970,672049,672100,672109,673189,673204,673220,673231,673300,673394,673473,673524,673533,674600,674615,674631,674642,674711,674805,674884,674935,674944,676002,676017,676033,676044,676113,676207,676286,676337,676346,677393,677409,677427,677435,677505,677598,677678,677731,677737,678774,678789,678805,678816,678896,679012,679091,679142,679151,680175,680190,680206,680217,680297,680413,680492,680543,680552,681567,681582,681598,681609,681689,681805,681884,681935,681944,682949,682964,682980,682991,683071,683187,683266,683317,683326,684321,684336,684352,684363,684443,684559,684638,684689,684698,685678,685695,685709,685719,685795,685911,685990,686041,686050,687018,687035,687049,687059,687135,687251,687330,687381,687390,688326,688341,688352,688364,688442,688558,688637,688688,688697,689625,689640,689651,689663,689741,689857,689936,689987,689996,690911,690926,690937,690949,691027,691143,691222,691273,691282,692187,692202,692213,692225,692303,692419,692498,692549,692558,693455,693469,693480,693491,693571,693686,693764,693817,693825,694709,694724,694735,694747,694825,694941,695020,695071,695080,695948,695963,695974,695986,696064,696180,696259,696310,696319,697174,697189,697200,697212,697290,697406,697485,697536,697545,698387,698402,698413,698425,698503,698619,698698,698749,698758,699589,699604,699615,699627,699705,699821,699900,699951,699960,700783,700798,700809,700821,700899,701015,701094,701145,701154,701970,701985,701996,702010,702089,702204,702293,702345,702354,703162,703177,703188,703202,703281,703396,703485,703537,703546,704343,704358,704369,704383,704462,704577,704666,704718,704727,705513,705528,705539,705553,705629,705741,705830,705882,705891,706663,706678,706689,706703,706779,706891,706980,707032,707041,707802,707817,707828,707842,707918,708030,708119,708171,708180,708930,708945,708956,708970,709045,709157,709246,709298,709307,710048,710063,710074,710088,710163,710295,710399,710451,710460,711196,711211,711222,711236,711311,711443,711547,711599,711608,712334,712349,712360,712374,712449,712581,712687,712743,712752,713469,713483,713495,713507,713583,713714,713821,713877,713885,714587,714602,714613,714627,714702,714834,714940,714996,715005,715696,715711,715722,715736,715811,715943,716049,716105,716114,716794,716809,716820,716834,716909,717041,717147,717203,717212,717882,717897,717908,717922,717997,718129,718235,718291,718300,718960,718975,718986,719000,719075,719207,719313,719369,719378,720026,720041,720052,720066,720141,720273,720379,720435,720444,721081,721096,721107,721121,721196,721328,721434,721490,721499,722139,722154,722165,722179,722254,722386,722492,722548,722557,723201,723216,723227,723241,723316,723448,723554,723610,723619,724253,724268,724279,724293,724368,724500,724606,724662,724671,725296,725311,725322,725336,725411,725543,725649,725705,725714,726329,726344,726355,726369,726444,726576,726682,726738,726747,727354,727369,727380,727394,727470,727602,727708,727764,727773,728371,728386,728397,728411,728487,728619,728725,728781,728790,729378,729393,729404,729418,729494,729626,729732,729788,729797,730378,730393,730404,730418,730494,730626,730732,730788,730797,731370,731385,731396,731410,731486,731618,731724,731780,731789,732357,732372,732383,732397,732473,732605,732711,732767,732776,733351,733366,733377,733391,733467,733599,733705,733761,733770,734338,734353,734364,734378,734454,734586,734692,734748,734757,735317,735332,735343,735357,735433,735565,735671,735727,735736,736284,736299,736310,736324,736400,736532,736638,736694,736703,737256,737271,737282,737296,737372,737504,737610,737666,737675,738220,738235,738246,738260,738336,738468,738574,738630,738639,739176,739194,739205,739217,739293,739425,739530,739588,739598,740127,740143,740152,740166,740243,740375,740482,740537,740545,742096,742111,742120,742133,742210,742343,742450,742505,742513,744069,744084,744093,744106,744183,744314,744424,744478,744486,746034,746049,746058,746071,746148,746279,746389,746443,746451,747995,748010,748020,748033,748109,748242,748364,748430,748439,749977,749992,750002,750015,750091,750224,750346,750412,750421,751959,751974,751984,751997,752073,752206,752328,752394,752403,754838,754853,754862,754875,754952,755085,755207,755273,755282,757711,757726,757735,757748,757825,757957,758080,758146,758155,760577,760592,760601,760614,760691,760823,760946,761012,761022,763439,763455,763466,763478,763555,763686,763807,763875,763884,766298,766314,766325,766337,766414,766545,766666,766734,766743,769151,769167,769176,769190,769267,769400,769521,769586,769596,771997,772013,772022,772036,772113,772246,772367,772432,772442,774836,774853,774862,774876,774953,775086,775207,775271,775281,777671,777688,777700,777711,777788,777921,778041,778106,778118,780503,780519,780528,780542,780619,780752,780875,780940,780954,783337,783353,783364,783376,783453,783584,783707,783776,783785,786167,786184,786193,786207,786284,786417,786540,786605,786619,788993,789010,789022,789033,789110,789243,789365,789431,789443,791815,791832,791844,791855,791931,792065,792187,792253,792265,794634,794651,794663,794674,794750,794876,795061,795070,797443,797460,797472,797483,797559,797685,797870,797879,800249,800265,800277,800288,800364,800489,800675,800684,803049,803065,803076,803088,803165,803289,803477,803485,805846,805861,805873,805884,805961,806086,806272,806281,808634,808650,808662,808673,808750,808875,809061,809070,811417,811433,811444,811456,811533,811658,811844,811853,814196,814212,814223,814235,814312,814437,814623,814632,816970,816986,816997,817009,817086,817211,817397,817406,819753,819763,819776,819853,819978,820164,820172,822511,822522,822534,822612,822736,822924,822932,825264,825274,825287,825364,825488,825675,825682,828010,828019,828033,828110,828234,828421,828428,830760,830773,830851,830975,831162,831169,833499,833512,833590,833714,833901,833908,836232,836244,836322,836446,836634,836642,838961,838974,839052,839176,839365,839368,841686,841699,841777,841901,842090,842093,844419,844496,844621,844808,844813,847158,847235,847359,847546,847552,849891,849968,850092,850279,850285,852697,852821,853008,853014,855427,855551,855739,855746,858152,858276,858464,858471,860872,860996,861184,861191,863584,863708,863899,863903,866285,866409,866600,866604,868975,869101,869290,869294,871659,871785,871975,871979,874343,874470,874661,874672,877021,877146,877337,877344,879705,879830,880021,880028,880216,882385,882510,882701,882708,882897,882961,885068,885193,885384,885391,885580,885644,887739,887864,888056,888065,888252,888316,890403,890528,890719,890726,890915,890979,893063,893188,893382,893386,893575,893639,895721,895846,896037,896044,896233,896297,898371,898496,898688,898697,898884,898948,901017,901141,901331,901338,901529,901592,903653,903777,903968,903981,904165,904228,906277,906404,906594,906604,906789,906851,908892,909019,909206,909220,909404,909466,911629,911820,911829,912016,912080,912360,914266,914457,914466,914653,914717,914997,916977,917168,917172,917363,917427,917706,919676,919867,919877,920061,920126,920405,922362,922553,922563,922747,922812,923091,925062,925253,925263,925447,925512,925790,927755,927942,927955,928145,928227,928506,930468,930655,930668,930858,930941,931220,933173,933363,933376,933569,933652,933931,935882,936071,936084,936278,936361,936640,938593,938793,938802,939010,939095,939375,941317,941517,941526,941734,941819,942099,944030,944229,944238,944447,944532,944812,946737,946933,946943,947152,947238,947516,949436,949646,949658,949862,949947,950226,952140,952348,952357,952565,952651,952930,954835,955045,955057,955261,955346,955625,957521,957725,957734,957946,958028,958307,960181,960389,960404,960607,960690,960970,962826,963037,963051,963251,963337,963615,965466,965674,965687,965891,965976,966255,968098,968310,968321,968526,968611,968890,970729,970941,970953,971157,971242,971521,973351,973564,973576,973780,973865,974144,975966,976180,976190,976395,976481,976760,978579,978792,978800,979007,979094,979372,981178,981390,981398,981605,981692,981970,983768,983979,983987,984193,984280,984558,986606,986614,986820,986908,987185,989228,989236,989442,989530,989807,991844,991856,992059,992145,992424,994452,994460,994667,994756,995035,997051,997058,997269,997354,997636,999639,999655,999857,999942,1000224,1002221,1002237,1002439,1002524,1002805,1004802,1004814,1005017,1005103,1005384,1007371,1007383,1007588,1007673,1007955,1009933,1009947,1010152,1010236,1010518,1012486,1012498,1012703,1012788,1013103,1015056,1015071,1015274,1015359,1015674,1017612,1017624,1017829,1017914,1018229,1020159,1020171,1020376,1020461,1020776,1022702,1022719,1022923,1023008,1023322,1025243,1025255,1025461,1025546,1025861,1027778,1027790,1027996,1028081,1028396,1030302,1030318,1030527,1030611,1030926,1032815,1032828,1033037,1033122,1033437,1035310,1035323,1035532,1035617,1035932,1037795,1037811,1038020,1038105,1038423,1040280,1040296,1040505,1040591,1040909,1042758,1042774,1042983,1043072,1043389,1045229,1045243,1045453,1045543,1045859,1047690,1047703,1047914,1048004,1048320,1050142,1050154,1050365,1050454,1050772,1052576,1052589,1052803,1052889,1053208,1055008,1055021,1055230,1055318,1055636,1057434,1057447,1057656,1057744,1058062,1059853,1059866,1060075,1060163,1060475,1062254,1062267,1062481,1062567,1062880,1064655,1064668,1064877,1064965,1065277,1067039,1067053,1067263,1067352,1067663,1069413,1069433,1069640,1069726,1070039,1071782,1071794,1072004,1072093,1072443,1074180,1074192,1074402,1074490,1074840,1076567,1076580,1076789,1076877,1077226,1078943,1078956,1079165,1079253,1079602,1081307,1081317,1081531,1081618,1081967,1083658,1083667,1083883,1083970,1084319,1085996,1086005,1086221,1086307,1086657,1088337,1088544,1088630,1088980,1090669,1090878,1090965,1091314,1093206,1093291,1093640,1095520,1095607,1095956,1097820,1097907,1098257,1100102,1100190,1100539,1102374,1102462,1102811,1104634,1104719,1105069,1106871,1106956,1107306,1109087,1109173,1109523,1111282,1111368,1111718,1113457,1113545,1113895,1115616,1115703,1116054,1117758,1117845,1118195,1119893,1119980,1120329,1122023,1122110,1122471,1124161,1124248,1124609,1126356,1126443,1126804,1128555,1128654,1129032,1130768,1130867,1131244,1132965,1133062,1133440,1135154,1135251,1135646,1137361,1137458,1137468,1137852,1139562,1139659,1139672,1140054,1141757,1141853,1141862,1142247,1143944,1144041,1144053,1144435,1146119,1146216,1146226,1146610,1148283,1148380,1148390,1148774,1150438,1150535,1150545,1150928,1152589,1152686,1152696,1153079,1154736,1154834,1154845,1155224,1156873,1156969,1156979,1157404,1159041,1159139,1159151,1159573,1161197,1161294,1161306,1161724,1163336,1163433,1163443,1163863,1165469,1165565,1165578,1165995,1167605,1167702,1167712,1168132,1169736,1169832,1169845,1170262,1171858,1171954,1171967,1172384,1173972,1174069,1174079,1174499,1176118,1176215,1176225,1176645,1178253,1178350,1178360,1178780,1180381,1180478,1180488,1180908,1182597,1182607,1183027,1184707,1184717,1185137,1186820,1186830,1187250,1188926,1188936,1189357,1191025,1191035,1191458,1193112,1193123,1193546,1195191,1195202,1195625,1197267,1197278,1197700,1199332,1199342,1199772,1201393,1201403,1201833,1203448,1203457,1203896,1205496,1205506,1205945,1207533,1207543,1207982,1209562,1209572,1210025,1211603,1211613,1212067,1213632,1213642,1214097,1215654,1215664,1216119,1217663,1217673,1218128,1219657,1219667,1220122,1221640,1221650,1222105,1223616,1223626,1224081,1225587,1225597,1226052,1227590,1228045,1229604,1230062,1232072,1234068,1236054,1238032,1240000,1241956,1243939,1245913,1247873,1249857,1251835,1253816,1255791,1257760,1259720,1261667,1263601,1265526,1267456,1269376,1271285,1273183,1275067,1276933,1278794,1280648,1282489,1284324,1286148,1287959,1289753,1291538,1293349,1295151,1296946,1298732,1300503,1302259,1304011,1305759,1307499,1309229,1310949,1312868,1314787,1316721,1318648,1320567,1322476,1324378,1326265,1328135,1329994,1331881,1333758,1335625,1337481,1339326,1341156,1342973,1344782,1346589,1348386,1350176,1352081,1353973,1355854,1357725,1359586,1361438,1363281,1365113,1366932,1368741,1370545,1372338,1374118,1375978,1377821,1379650,1381468,1383284,1385091,1385520,1386895,1387325,1388689,1389120,1390469,1390900,1392238,1392669,1393998,1394430,1395776,1396207,1396214,1397542,1397973,1397980,1397996,1398022,1399299,1399730,1399737,1399753,1399779,1399802,1401051,1401484,1401491,1401507,1401533,1401556,1402793,1403226,1403233,1403249,1403275,1403298,1404526,1404959,1404966,1404982,1405008,1405031,1406681,1406688,1406704,1406730,1406755,1408401,1408408,1408424,1408450,1408475,1410130,1410139,1410159,1410187,1410212,1411857,1411866,1411886,1411914,1411939,1413607,1413618,1413650,1413683,1413708,1415367,1415378,1415410,1415443,1415468,1417116,1417126,1417158,1417189,1417217,1418852,1418863,1418895,1418928,1418953,1420579,1420590,1420622,1420655,1420680,1422296,1422307,1422339,1422372,1422397,1423999,1424010,1424042,1424075,1424100,1425688,1425699,1425731,1425764,1425789,1427362,1427373,1427405,1427438,1427463,1429026,1429037,1429069,1429102,1429127,1430676,1430687,1430719,1430752,1430777,1432316,1432327,1432359,1432392,1432417,1433947,1433958,1433990,1434023,1434048,1435563,1435574,1435606,1435639,1435664,1437168,1437179,1437211,1437245,1437279,1438789,1438800,1438832,1438866,1438900,1440397,1440408,1440440,1440474,1440508,1441998,1442009,1442042,1442076,1442110,1443592,1443603,1443636,1443670,1443704,1445176,1445187,1445220,1445254,1445288,1446749,1446760,1446793,1446827,1446861,1448313,1448324,1448357,1448391,1448425,1449865,1449876,1449909,1449943,1449977,1451405,1451416,1451449,1451483,1451517,1452935,1452946,1452979,1453013,1453047,1453287,1454455,1454466,1454499,1454533,1454567,1454807,1454848,1455964,1455975,1456016,1456051,1456085,1456319,1456360,1456381,1457466,1457477,1457518,1457551,1457589,1457824,1457865,1457886,1458957,1458968,1459009,1459043,1459081,1459318,1459359,1459380,1460436,1460447,1460488,1460522,1460560,1460797,1460838,1460859,1461902,1461913,1461954,1461988,1462026,1462263,1462304,1462325,1463358,1463369,1463410,1463444,1463482,1463719,1463760,1463781,1464804,1464815,1464856,1464890,1464928,1465165,1465206,1465227,1466236,1466247,1466288,1466322,1466360,1466597,1466638,1466659,1467658,1467669,1467710,1467744,1467782,1468019,1468060,1468081,1469067,1469078,1469119,1469153,1469191,1469428,1469469,1469490,1470461,1470472,1470513,1470547,1470585,1470822,1470863,1470884,1471842,1471853,1471894,1471928,1471966,1472203,1472244,1472265,1473210,1473221,1473262,1473296,1473334,1473571,1473612,1473633,1474569,1474580,1474621,1474655,1474693,1474930,1474971,1474992,1475915,1475926,1475967,1476001,1476039,1476276,1476317,1476338,1477266,1477277,1477318,1477352,1477390,1477627,1477668,1477689,1478614,1478625,1478666,1478700,1478738,1479004,1479045,1479066,1479998,1480009,1480050,1480084,1480122,1480388,1480429,1480450,1481370,1481381,1481422,1481456,1481494,1481760,1481801,1481822,1482731,1482742,1482783,1482817,1482855,1483122,1483163,1483184,1484087,1484098,1484139,1484173,1484211,1484478,1484519,1484540,1485431,1485442,1485483,1485517,1485555,1485822,1485863,1485884,1486766,1486777,1486818,1486852,1486890,1487157,1487198,1487219,1488090,1488101,1488142,1488176,1488214,1488481,1488522,1488543,1489396,1489407,1489448,1489482,1489520,1489787,1489828,1489849,1490691,1490702,1490743,1490777,1490815,1491082,1491123,1491144,1491977,1491988,1492029,1492063,1492101,1492368,1492409,1492430,1493291,1493302,1493343,1493377,1493415,1493682,1493723,1493744,1494596,1494607,1494648,1494682,1494720,1494987,1495028,1495049,1495893,1495904,1495945,1495979,1496017,1496284,1496325,1496346,1497185,1497196,1497239,1497274,1497312,1497582,1497623,1497644,1498488,1498499,1498542,1498577,1498615,1498885,1498926,1498947,1499781,1499792,1499835,1499870,1499908,1500178,1500219,1500240,1501064,1501075,1501118,1501153,1501191,1501461,1501502,1501523,1502340,1502351,1502394,1502429,1502467,1502737,1502778,1502799,1503608,1503619,1503662,1503697,1503735,1504005,1504046,1504067,1504869,1504880,1504923,1504958,1504996,1505266,1505307,1505328,1506122,1506133,1506176,1506211,1506249,1506519,1506560,1506581,1507369,1507380,1507423,1507458,1507496,1507766,1507807,1507828,1508606,1508617,1508660,1508695,1508733,1509003,1509044,1509065,1509834,1509845,1509888,1509923,1509961,1510231,1510272,1510293,1511056,1511067,1511110,1511145,1511183,1511464,1511505,1511526,1512281,1512292,1512335,1512370,1512408,1512689,1512730,1512751,1513509,1513520,1513563,1513598,1513636,1513917,1513959,1513980,1514730,1514741,1514784,1514819,1514857,1515138,1515180,1515202,1515953,1515964,1516007,1516042,1516080,1516361,1516403,1516425,1517168,1517179,1517222,1517257,1517295,1517576,1517618,1517640,1518374,1518385,1518428,1518463,1518501,1518782,1518824,1518846,1519573,1519584,1519627,1519662,1519700,1519985,1520027,1520049,1520769,1520780,1520823,1520858,1520896,1521181,1521223,1521245,1521959,1521970,1522013,1522048,1522086,1522371,1522413,1522435,1523142,1523153,1523196,1523231,1523269,1523553,1523595,1523617,1524317,1524328,1524371,1524406,1524444,1524728,1524770,1524792,1525485,1525496,1525539,1525574,1525612,1525896,1525938,1525960,1526646,1526657,1526700,1526735,1526773,1527057,1527099,1527121,1527801,1527812,1527855,1527890,1527928,1528212,1528254,1528276,1528950,1528961,1529004,1529039,1529077,1529361,1529403,1529425,1530095,1530106,1530149,1530184,1530222,1530506,1530548,1530570,1531236,1531247,1531290,1531325,1531363,1531647,1531689,1531711,1532372,1532383,1532430,1532462,1532499,1532783,1532825,1532846,1533504,1533515,1533562,1533594,1533631,1533915,1533957,1533978,1534632,1534643,1534690,1534722,1534759,1535043,1535085,1535106,1535756,1535767,1535814,1535846,1535883,1536167,1536209,1536230,1536875,1536886,1536933,1536965,1537002,1537286,1537328,1537349,1537988,1537999,1538046,1538078,1538115,1538410,1538460,1538491,1539125,1539136,1539183,1539215,1539252,1539547,1539597,1539628,1540255,1540266,1540313,1540345,1540382,1540677,1540728,1540759,1541380,1541391,1541438,1541470,1541507,1541802,1541853,1541884,1542510,1542557,1542589,1542626,1542921,1542972,1543003,1543621,1543668,1543700,1543737,1544032,1544083,1544114,1544726,1544773,1544805,1544842,1545137,1545188,1545219,1545871,1545903,1545940,1546235,1546285,1546316,1546956,1546988,1547025,1547320,1547370,1547401,1548029,1548061,1548098,1548393,1548443,1548474,1549092,1549124,1549161,1549456,1549506,1549537,1550145,1550180,1550218,1550512,1550560,1550590,1551193,1551228,1551266,1551560,1551608,1551638,1552232,1552267,1552305,1552599,1552647,1552677,1553273,1553308,1553346,1553640,1553690,1553720,1554308,1554343,1554381,1554677,1554727,1554757,1555370,1555408,1555704,1555754,1555784,1556388,1556426,1556722,1556772,1556802,1557398,1557436,1557732,1557784,1557814,1558406,1558444,1558740,1558792,1558822,1559404,1559442,1559738,1559790,1559820,1560762,1560800,1561096,1561148,1561178,1562111,1562149,1562445,1562497,1562527,1563954,1563992,1564288,1564340,1564370,1565787,1565825,1566121,1566173,1566203,1567653,1567950,1567996,1568024,1570570,1570869,1570916,1570946,1573463,1573762,1573809,1573838,1576346,1576641,1576693,1576723,1579220,1579516,1579566,1579594,1582080,1582375,1582427,1582457,1584927,1585222,1585274,1585304,1587767,1588063,1588113,1588147,1590600,1590895,1590947,1590977,1593425,1593720,1593772,1593802,1596282,1596573,1596641,1596679,1599444,1599512,1599550,1602306,1602375,1602413,1605152,1605220,1605258,1607994,1608064,1608101,1610829,1610898,1610938,1613654,1613722,1613763,1616471,1616541,1616578,1619274,1619342,1619380,1622066,1622136,1622172,1624840,1624908,1624946,1627609,1627677,1627715,1630368,1630434,1630476,1633115,1633180,1633223,1635918,1635984,1636022,1638742,1638810,1638848,1641583,1641651,1641689,1644411,1644476,1644521,1647225,1647291,1647336,1650041,1650105,1650145,1652909,1652973,1653012,1655765,1655834,1655872,1658613,1658682,1658720,1661450,1661519,1661557,1664273,1664342,1664380,1667088,1667156,1667196,1669892,1669961,1669999,1672751,1672820,1672858,1675603,1675672,1675710,1678452,1678521,1678556,1681287,1681360,1681395,1684115,1684183,1684221,1686931,1687013,1687060,1689790,1689866,1689912,1692640,1692722,1692769,1695411,1695494,1695537,1698167,1698249,1698297,1700920,1701002,1701050,1703664,1703746,1703794,1706403,1706482,1706535,1709174,1709253,1709306,1711935,1712017,1712065,1714719,1714801,1714849,1717494,1717576,1717624,1720256,1720338,1720386,1723008,1723091,1723135,1725744,1725826,1725874,1728479,1728561,1728609,1731205,1731287,1731335,1733913,1733995,1734043,1736612,1736694,1736742,1739300,1739382,1739430,1741974,1742056,1742104,1744638,1744720,1744768,1747296,1747378,1747426,1749945,1750027,1750075,1752587,1752669,1752717,1755220,1755302,1755350,1757846,1757925,1757969,1760456,1760535,1760591,1763059,1763141,1763192,1765656,1765738,1765786,1768248,1768331,1768379,1770833,1770916,1770964,1773492,1773540,1776066,1776114,1778625,1778673,1781174,1781222,1783716,1783764,1786248,1786296,1788753,1788801,1791247,1791295,1793723,1793771,1796180,1796228,1798625,1798676,1801131,1803576,1806001,1808408,2342952,2342973,2346059,2346080,2349160,2349181,2352289,2352310,2355408,2355429,2358515,2358536,2361619,2361640,2364714,2364735,2367799,2367820,2370873,2370894,2373938,2373959,2376988,2377009,2380026,2380047,2383058,2383079,2386084,2386105,2389152,2389173,2392215,2392236,2395271,2395292,2398314,2398335,2401343,2401364,2404361,2404382,2407375,2407396,2410380,2410401,2413375,2413396,2416362,2416383,2419376,2419397,2422378,2422399,2425369,2425390,2428355,2428376,2431332,2431353,2434299,2434320,2437256,2437277,2440202,2440223,2443137,2443158,2446064,2446085,2448985,2449006,2451895,2451916,2454788,2454809,2457672,2457693,2460551,2460572,2463415,2463436,2466270,2466291,2469148,2469169,2472086,2472107,2475000,2475021,2477943,2477964,2480875,2480896,2483793,2483814,2486701,2486722,2489647,2489668,2492580,2492601,2495505,2495526,2498419,2498440,2501320,2501341,2504208,2504229,2507084,2507105,2509950,2509971,2512812,2512833,2515669,2515690,2518520,2518541,2521363,2521384,2524195,2524216,2527015,2527036,2529828,2529849,2532636,2532657,2535437,2535458,2538232,2538253,2541026,2541047,2543810,2543831,2546583,2546604,2549349,2549370,2552154,2552175,2554950,2554971,2557761,2557782,2560564,2560585,2563353,2563374,2566129,2566151,2568935,2568957,2571767,2571788,2574589,2574610,2577403,2577424,2580216,2580237,2583013,2583034,2585795,2585816,2588566,2588587,2591334,2591355,2594093,2594114,2596844,2596865,2599586,2599607,2602315,2602336,2605031,2605052,2607738,2607759,2610441,2610462,2613177,2613198,2615901,2615922,2618618,2618639,2621325,2621346,2624017,2624038,2626698,2626719,2629378,2629399,2632043,2632064,2634710,2634731,2637358,2637379,2639992,2640013,2642613,2642634,2645226,2645247,2647827,2647848,2650415,2650436,2652994,2653015,2655561,2655582,2658113,2658134,2660647,2660668,2663162,2663183,2665663,2665684,2668150,2668171,2670613,2670634,2673064,2673085,2675495,2675516,2677907,2677928,2680299,2680320,2682675,2682696,2685042,2685063,2687404,2687425,2689758,2689779,2692102,2692123,2694430,2694451,2696873,2696901,2699956,2699984,2703036,2703064,2706111,2706142,2709158,2709189,2712201,2712232,2715231,2715262,2718270,2718311,2721339,2721383,2724447,2724491,2727546,2727590,2730633,2730677,2733749,2733793,2736854,2736896,2739941,2739983,2743019,2743061,2746079,2746121,2749120,2749162,2752149,2752191,2755176,2755218,2758196,2758238,2761218,2761260,2764233,2764275,2767232,2767274,2770216,2770258,2773189,2773231,2776154,2776196,2779143,2779185,2782124,2782165,2785212,2785253,2788298,2788339,2791368,2791409,2794426,2794467,2797501,2797542,2800564,2800605,2803619,2803660,2806593,2806634,2809549,2809590,2812483,2812524,2815405,2815446,2818388,2818429,2821364,2821405,2824336,2824377,2827312,2827353,2830271,2830312,2833213,2833254,2836140,2836181,2839074,2839115,2841998,2842039,2850572,2850613,2863204,2863247,2865981,2866024,2881051,2881095,2883823,2883867,2886581,2886625,2889316,2889360,2892039,2892083,2894742,2894786,2897431,2897475,2900128,2900172,2902819,2902863,2905403,2905447,2907995,2908039,2910612,2910656,2913210,2913254,2915798,2915842,2918388,2918432,2920961,2921005,2923526,2923570,2926080,2926124,2928616,2928660,2931135,2931179,2933643,2933687,2936143,2936187,2938651,2938695,2941154,2941198,2943648,2943692,2946126,2946170,2948588,2948632,2951035,2951079,2953482,2953526,2955971,2956015,2958454,2958498,2960923,2960967,2963372,2963416,2965803,2965847,2968222,2968266,2970638,2970682,2973038,2973082,2975427,2975471,2977804,2977848,2980194,2980238,2982570,2982614,2984940,2984984,2987324,2987368,2989702,2989746,2992078,2992122,2994441,2994485,2996791,2996835,2999125,2999169,3001487,3003803,3006093,3008319,3010505,3012673,3014825,3016969)) 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





	The Russian National Orchestra (Orchestra) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters The Russian National Orchestra (Orchestra)
			

																
The Russian National Orchestra (Orchestra)

														
				


        




    

        Founder and artistic leader - Mikhail Pletnev.
Russian National Orchestra
"They played with such captivating beauty that the audience let out an involuntary sigh of pleasure."
— Evening Standard, London

"...as close to perfect as one could hope for."
— Trinity Mirror

"breathtakingly beautiful."
— Classic CD 

"[The RNO is] easily the greatest Russian orchestra of today."
— The Journal, Newcastle

"...an awe-inspiring experience. Should human beings be able to play like this?"
— Gramophone

 The Russian National Orchestra has been in demand throughout the music world ever since its 1990 Moscow premiere. Of the orchestra's 1996 debut at the BBC Proms in London, the Evening Standard wrote, "They played with such captivating beauty that the audience gave an involuntary sigh of pleasure." More recently, they were described as "a living symbol of the best in Russian art" (Miami Herald) and "as close to perfect as one could hope for" (Trinity Mirror).

The first Russian orchestra to perform at the Vatican and in Israel, the RNO maintains an active international tour schedule, appearing in Europe, Asia and the Americas. Guest artists performing with the RNO on tour include conductors Vladimir Jurowski, Nicola Luisotti, Antonio Pappano, Alan Gilbert, Carlo Ponti and Patrick Summers, and soloists Martha Argerich, Yefim Bronfman, Lang Lang, Pinchas Zukerman, Sir James Galway, Joshua Bell, Itzhak Perlman, Steven Isserlis, Dmitri Hvorostovsky, Simone Kermes and Renee Fleming, among many others. Popular with radio audiences worldwide, RNO concerts are regularly aired by National Public Radio in the United States and by the European Broadcasting Union.

Gramophone magazine called the first RNO CD (1991) "an awe-inspiring experience; should human beings be able to play like this?" and listed it as the best recording of Tchaikovsky's Pathetique in history. Since then, the orchestra has made more than 60 recordings for Deutsche Grammophon and PentaTone Classics, distinguishing the RNO as the only Russian ensemble with long-standing relationships with these prestigious labels, as well as additional discs with many other record companies. Conductors represented in the RNO discography include Founder and Music Director Mikhail Pletnev, Principal Guest Conductor Vladimir Jurowski, Kent Nagano, Alexander Vedernikov and Paavo Berglund.

The RNO's recording of Prokofiev's Peter and the Wolf and Beintus's Wolf Tracks, conducted by Kent Nagano and narrated by Sophia Loren, Bill Clinton and Mikhail Gorbachev, received a 2004 Grammy Award, making the RNO the first Russian orchestra to win the recording industry's highest honor. A Spanish language version narrated by Antonio Banderas was released in 2007, following a Russian version narrated by actors Oleg Tabakov and Sergei Bezrukov, with Mandarin and other editions to follow.

The orchestra's Shostakovich cycle on PentaTone Classics is widely acclaimed as “the most exciting cycle of the Shostakovich symphonies to be put down on disc, and easily the best recorded.” (SACD.net)

A regular visitor to the Schleswig-Holstein, Gstaad and Rheingau festivals, the RNO is also the founding orchestra of Napa Valley Festival del Sole, Festival of the Arts BOCA in Florida, and the Singapore Sun Festival, and resident orchestra for multiple seasons of the Tuscan Sun Festival in Cortona, Italy. The RNO will launch its own annual festival in 2009, which will be held at Moscow's Bolshoi Theater.

The RNO is unique among the principal Russian ensembles as a private institution funded with the support of individuals, corporations and foundations in Russia and throughout the world. In recognition of both its artistry and path-breaking structure, the Russian Federation recently awarded the RNO the first ever grant to a non-government orchestra.
        

    

    

            


			

		





	


	

	

		


			

				

					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