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 (41008,41080,42419,42491,43804,43875,45161,45231,46510,46580,47853,47923,49190,49261,50592,51916,53233,54546,55853,57220,59295,61364,63425,65477,67524,69570,71610,73643,75668,77682,79691,81695,83693,85683,87665,89638,91605,93558,95512,97457,99393,211800,211804,213333,213337,214871,214875,216404,216408,217935,217939,219460,219464,220981,220985,222498,222502,224010,224014,225518,225522,227030,228533,358652,358653,358657,358659,358664,358665,358673,358674,360554,360555,360560,360562,360566,360567,360576,360577,360587,360588,360594,360595,360597,360598,360602,360603,362452,362453,362458,362459,362466,362467,362473,362474,362484,362485,362491,362492,362495,362496,362501,362502,364338,364339,364345,364346,364350,364351,364358,364359,364372,364373,364379,364380,364382,364383,364387,364388,366219,366220,366226,366227,366230,366231,366237,366238,366249,366250,366255,366256,366262,366263,366266,366267,368102,368103,368105,368109,368115,368116,368124,368125,368133,368134,368135,368136,368142,368143,368146,368147,369973,369974,369980,369981,369987,369988,369994,369995,370008,370009,370015,370016,370018,370019,370023,370024,371841,371842,371848,371849,371853,371854,371860,371861,371872,371873,371878,371879,371885,371886,371889,371890,373701,373702,373708,373709,373715,373716,373724,373725,373736,373737,373743,373744,373747,373748,373752,373753,375551,375552,375558,375559,375565,375566,375573,375574,375586,375587,375593,375594,375597,375598,375602,375603,377392,377393,377399,377400,377405,377406,377412,377413,377427,377428,377434,377435,377438,377439,377443,377444,379226,379227,379233,379234,379238,379239,379246,379247,379261,379262,379268,379269,379272,379273,379277,379278,381057,381058,381064,381065,381069,381070,381076,381077,381091,381092,381099,381100,381103,381104,381108,381109,382882,382883,382889,382890,382894,382895,382901,382902,382915,382916,382922,382923,382928,382929,382933,382935,384701,384702,384708,384709,384713,384714,384720,384721,384733,384734,384740,384741,384745,384746,384751,384752,386513,386514,386520,386521,386525,386526,386532,386533,386545,386546,386552,386553,386558,386559,386564,386565,388317,388318,388324,388326,388329,388330,388336,388337,388350,388351,388357,388358,388362,388363,388367,388368,390125,390126,390132,390134,390137,390138,390144,390145,390157,390158,390165,390166,390170,390171,390175,390176,391925,391926,391932,391934,391937,391938,391944,391945,391957,391958,391965,391966,391970,391971,391975,391976,393724,393725,393731,393733,393736,393737,393743,393744,393756,393757,393763,393764,393769,393770,393774,393775,395519,395520,395526,395528,395531,395532,395538,395539,395551,395552,395558,395559,395564,395565,395569,395570,397308,397309,397315,397317,397320,397321,397327,397328,397340,397341,397346,397347,397353,397354,397358,397360,399091,399096,399098,399100,399103,399104,399110,399111,399122,399123,399128,399129,399135,399136,399139,399141,400865,400866,400872,400874,400877,400878,400884,400885,400896,400897,400903,400904,400910,400911,400915,400917,402630,402631,402637,402639,402642,402643,402649,402650,402661,402662,402667,402668,402675,402676,402680,402682,404392,404393,404398,404399,404405,404406,404414,404415,404420,404421,404428,404429,404433,404434,404437,404439,406144,406145,406151,406153,406156,406157,406163,406164,406175,406176,406182,406183,406189,406190,406194,406195,407895,407896,407902,407904,407907,407908,407914,407915,407926,407927,407932,407933,407940,407941,407945,407946,409639,409640,409646,409648,409651,409652,409658,409659,409670,409671,409676,409677,409684,409685,409689,409690,411379,411380,411385,411388,411392,411393,411399,411400,411413,411414,411420,411421,411424,411425,411429,411430,413140,413141,413147,413149,413153,413154,413160,413161,413175,413176,413182,413183,413186,413187,413191,413192,414891,414892,414898,414900,414903,414904,414910,414911,414924,414925,414930,414931,414936,414937,414941,414942,416633,416634,416640,416642,416645,416646,416652,416653,416666,416667,416672,416673,416678,416679,416683,416684,418374,418375,418381,418383,418386,418387,418393,418394,418406,418407,418413,418414,418419,418420,418424,418425,420110,420111,420117,420119,420122,420123,420129,420130,420142,420143,420148,420149,420155,420156,420160,420161,421840,421841,421847,421849,421852,421853,421859,421860,421871,421872,421877,421878,421884,421885,421889,421890,423569,423570,423576,423578,423581,423582,423588,423589,423601,423602,423608,423609,423614,423615,423619,423620,425291,425292,425298,425300,425304,425305,425312,425313,425324,425325,425331,425332,425336,425337,425341,425342,427006,427007,427011,427012,427019,427020,427031,427032,427038,427039,427044,427045,427049,427050,428704,428705,428709,428710,428716,428717,428728,428729,428735,428736,428742,428743,428747,428748,430402,430403,430409,430410,430421,430422,430427,430428,430435,430436,430439,430441,432116,432117,432129,432130,432136,432137,432142,432143,432147,432149,433832,433833,433838,433839,433846,433847,433850,433852,435527,435528,435533,435534,435541,435542,435545,435547,437221,437222,437229,437230,437233,437235,438904,438906,438909,438911,440575,440577,477540,477548,479113,479122,480680,480689,481433,481441,482176,482186,482913,482923,483648,483657,484399,484408,485148,485157,485891,485900,486623,486631,487342,487351,488056,488065,488768,488778,489480,489490,490187,490197,490890,490896,491582,491592,492267,492277,492950,492960,493632,493642,494311,494317,494980,494988,495394,495638,495648,496290,496298,496928,496934,498397,498406,499859,499868,501314,501323,502763,502771,504245,504254,505725,505731,507193,507202,508665,508674,510132,510141,511592,511601,513047,513053,514523,514532,515993,516002,517454,517463,518905,518914,520351,520359,521790,521799,523226,523234,524651,524659,526065,526074,527472,527481,528878,528887,530283,530291,531681,531690,533070,533080,534513,534521,535940,535950,537376,537384,538808,538813,540228,540235,541640,541647,543087,543095,544565,544572,546034,546040,547489,547494,548943,548950,550392,550399,551833,551840,553267,553273,554688,554693,556100,556105,557506,557511,558906,558911,560303,560308,561693,561699,563080,563086,564457,564463,565824,565830,567182,567188,568542,568548,569895,569901,571238,571244,572620,572626,574000,574006,575369,575375,576729,576735,578086,578092,579436,579442,579462,580775,580781,580800,582104,582110,582129,582137,583434,583440,583459,583467,584754,584760,584779,584786,586067,586073,586092,586099,587376,587382,587401,587408,588676,588683,588703,588710,590011,590022,590057,590071,591631,591642,591677,591691,593270,593281,593317,593329,594979,594989,595024,595037,596676,596686,596721,596734,598360,598370,598408,598417,600038,600048,600083,600096,601717,601727,601765,601774,603391,603401,603436,603449,605052,605063,605099,605109,606708,606718,606753,606766,608353,608363,608398,608411,609991,610001,610036,610049,611675,611685,611720,611733,613353,613363,613398,613410,615020,615030,615065,615077,616673,616684,616720,616733,618317,618327,618362,618374,619950,619960,619995,620007,621575,621586,621623,621635,623196,623206,623241,623253,624806,624816,624851,624863,626427,626437,626472,626484,628038,628048,628083,628095,629638,629648,629683,629695,631231,631241,631276,631288,632818,632828,632863,632875,634396,634406,634441,634453,635963,635973,636008,636020,637531,637566,637578,639076,639113,639123,640648,640660,642177,642186,643692,643703,645202,645213,646708,646720,648203,648215,649702,649714,651190,651202,652671,652683,654143,654155,655604,655616,657067,658522,712351,712357,712561,713482,713489,713695,714604,714610,714814,715713,715719,715923,716811,716817,717021,717899,717905,718109,718977,718983,719187,720043,720049,720253,720269,721098,721104,721308,721324,722156,722162,722366,722382,723218,723224,723428,723444,724270,724276,724480,724496,725313,725319,725523,725539,726346,726352,726556,726572,727371,727377,727582,727598,728388,728394,728599,728615,729395,729401,729606,729622,730395,730401,730606,730622,731387,731393,731598,731614,732374,732380,732585,732601,733368,733374,733579,733595,734355,734361,734566,734582,735334,735340,735545,735561,736301,736307,736512,736528,737273,737279,737484,737500,738237,738243,738448,738464,739192,739199,739404,739420,740142,740148,740349,740364,742110,742117,742318,742332,744083,744089,744291,744306,746048,746054,746255,746272,748009,748016,748217,748232,749991,749998,750199,750214,751973,751980,752181,752196,754852,754859,755061,755076,757725,757732,757934,757949,760591,760598,760801,760817,763456,763462,763668,763678,766315,766321,766527,766537,769166,769172,769374,769391,772012,772018,772220,772237,774852,774858,775059,775077,777687,777693,777894,777909,780518,780524,780725,780742,783354,783360,783566,783576,786183,786189,786390,786407,789009,789015,789216,789232,791831,791837,792038,792054,794650,794656,794852,794866,797459,797465,797662,797675,800264,800270,800467,800480,803066,803072,803272,803282,805860,805866,806064,806077,808649,808655,808853,808866,811432,811438,811635,811649,814211,814218,814414,814428,816985,816992,817188,817202,819752,819759,819955,819969,822512,822518,822719,822729,825263,825270,825466,825480,828009,828016,828213,828226,830757,830954,830967,833496,833693,833706,836228,836429,836439,839154,839168,841879,841893,844598,844612,847337,847351,850070,850084,852799,852813,855529,855543,858254,858268,860974,860988,863687,863700,866387,866401,869077,869091,871761,871775,874449,874458,877124,877137,879807,879821,882487,882501,885170,885184,887846,887856,890506,890519,893170,893179,895823,895837,898478,898488,901118,901132,903755,903769,906378,906393,908994,909009,911611,911621,911834,911836,911842,911846,911853,911860,914248,914258,914471,914473,914479,914483,914490,914497,916953,916967,917180,917181,917189,917190,917201,917203,919651,919667,919873,919881,919882,919889,919891,919899,919901,922337,922352,922559,922567,922568,922575,922577,922585,922587,925037,925051,925259,925266,925267,925274,925276,925284,925286,927729,927746,927951,927960,927961,927968,927971,927978,927980,930442,930459,930664,930672,930673,930682,930684,930691,930693,933148,933164,933372,933380,933381,933389,933390,933398,933400,935856,935873,936080,936088,936090,936098,936099,936107,936109,938568,938583,938810,938815,938817,938824,938826,938837,938840,941290,941307,941533,941538,941540,941547,941548,941560,941562,944003,944021,944244,944251,944252,944259,944261,944270,944273,946708,946727,946947,946954,946955,946962,946963,946976,946977,949414,949427,949656,949662,949664,949669,949673,949680,949689,952113,952129,952363,952369,952370,952377,952378,952388,952392,954813,954826,955055,955061,955063,955068,955072,955079,955088,957491,957509,957739,957746,957747,957754,957755,957764,957768,960152,960170,960399,960407,960408,960414,960415,960425,960428,962799,962816,963045,963053,963054,963060,963061,963073,963074,965437,965454,965682,965692,965693,965699,965700,965709,965711,968069,968086,968317,968327,968328,968334,968335,968343,968346,970707,970720,970951,970957,970959,970964,970968,970975,970984,973329,973342,973574,973580,973582,973587,973591,973598,973607,975955,976187,976195,976197,976202,976203,976215,976216,978568,978807,978809,978814,978816,978824,978826,978839,981404,981410,981411,981420,981422,981435,981437,983993,983999,984000,984008,984010,984024,984026,986620,986626,986627,986635,986637,986650,986652,989242,989248,989249,989257,989259,989271,989273,991854,991860,991862,991867,991871,991878,991887,994467,994473,994474,994482,994484,994495,994497,997065,997072,997073,997081,997083,997093,997095,999652,999660,999661,999670,999671,999682,999683,1002234,1002242,1002243,1002252,1002253,1002264,1002265,1004812,1004818,1004820,1004825,1004829,1004836,1004845,1007381,1007387,1007389,1007394,1007398,1007405,1007414,1009942,1009952,1009953,1009959,1009962,1009971,1009974,1012496,1012502,1012504,1012509,1012513,1012520,1012529,1015066,1015074,1015075,1015082,1015086,1015095,1015098,1017622,1017628,1017630,1017635,1017639,1017646,1017655,1020169,1020175,1020177,1020182,1020186,1020193,1020202,1022714,1022722,1022723,1022731,1022732,1022744,1022746,1025253,1025259,1025261,1025266,1025270,1025277,1025286,1025297,1025304,1025308,1025316,1025322,1025329,1027788,1027794,1027796,1027801,1027805,1027812,1027821,1027832,1027839,1027843,1027851,1027857,1027864,1030313,1030323,1030325,1030332,1030333,1030344,1030345,1030364,1030365,1030377,1030378,1030389,1030390,1032826,1032832,1032834,1032840,1032844,1032851,1032860,1032871,1032878,1032883,1032891,1032897,1032904,1035321,1035327,1035329,1035335,1035339,1035346,1035355,1035366,1035373,1035378,1035386,1035392,1035399,1037806,1037815,1037817,1037823,1037825,1037834,1037836,1037856,1037857,1037870,1037871,1037882,1037883,1040291,1040300,1040302,1040308,1040310,1040319,1040321,1040341,1040342,1040355,1040356,1040367,1040368,1042769,1042779,1042785,1042787,1042795,1042796,1042798,1042817,1042819,1042832,1042833,1042845,1042846,1045248,1045255,1045256,1045265,1045266,1045267,1045281,1045287,1045289,1045301,1045303,1045314,1045316,1047708,1047715,1047716,1047726,1047727,1047741,1047742,1047758,1047759,1047771,1047772,1047774,1047785,1050159,1050166,1050167,1050176,1050177,1050189,1050190,1050209,1050210,1050221,1050222,1050234,1050235,1052594,1052602,1052603,1052611,1052612,1052623,1052624,1052643,1052644,1052655,1052656,1052668,1052669,1055019,1055025,1055027,1055033,1055037,1055044,1055053,1055064,1055071,1055076,1055084,1055090,1055097,1057445,1057451,1057453,1057459,1057463,1057470,1057479,1057490,1057497,1057502,1057510,1057516,1057523,1059864,1059870,1059872,1059878,1059882,1059889,1059898,1059909,1059916,1059921,1059929,1059935,1059942,1062272,1062280,1062281,1062288,1062289,1062301,1062302,1062322,1062323,1062334,1062335,1062346,1062347,1064666,1064672,1064674,1064680,1064684,1064691,1064700,1064711,1064718,1064723,1064731,1064737,1064744,1067050,1067060,1067061,1067067,1067068,1067081,1067083,1067099,1067100,1067113,1067114,1067126,1067127,1069430,1069438,1069439,1069446,1069447,1069458,1069459,1069479,1069480,1069491,1069492,1069503,1069504,1071799,1071806,1071807,1071816,1071817,1071831,1071832,1071849,1071850,1071862,1071863,1071874,1071875,1072124,1074189,1074198,1074199,1074206,1074207,1074219,1074220,1074235,1074237,1074249,1074250,1074262,1074264,1074525,1076578,1076584,1076586,1076592,1076596,1076603,1076612,1076623,1076630,1076635,1076643,1076649,1076656,1076912,1078954,1078960,1078962,1078968,1078972,1078979,1078988,1078999,1079006,1079011,1079019,1079025,1079032,1079288,1081324,1081331,1081332,1081339,1081340,1081352,1081353,1081372,1081373,1081384,1081385,1081397,1081398,1081649,1083674,1083682,1083683,1083690,1083691,1083703,1083704,1083723,1083724,1083734,1083735,1083747,1083748,1084001,1086012,1086019,1086020,1086027,1086028,1086039,1086040,1086058,1086059,1086069,1086070,1086083,1086084,1086339,1088334,1088341,1088342,1088350,1088351,1088362,1088363,1088381,1088382,1088391,1088392,1088403,1088404,1088664,1090667,1090673,1090675,1090681,1090685,1090692,1090701,1090712,1090719,1090724,1090732,1090738,1090745,1091000,1093000,1093002,1093009,1093011,1093020,1093021,1093041,1093043,1093052,1093053,1093065,1093066,1093324,1095323,1095327,1095334,1095343,1095354,1095361,1095366,1095374,1095380,1095387,1095642,1097634,1097643,1097654,1097661,1097666,1097674,1097680,1097687,1097942,1099947,1099948,1099960,1099961,1099972,1099973,1100221,1102219,1102220,1102232,1102233,1102244,1102245,1102493,1104489,1104490,1104500,1104501,1104751,1106735,1106737,1106988,1109203,1111398,1113575,1115738,1117879,1120013,1122145,1124283,1126478,1128689,1130903,1133099,1135291,1137499,1139698,1141894,1144076,1146256,1148420,1150575,1152726,1154868,1157011,1159177,1161332,1163473,1165604,1167742,1169870,1171991,1174109,1176255,1178390,1180518,1182637,1184747,1186853,1188960,1189318,1189326,1191059,1191416,1191425,1193147,1193505,1193518,1195225,1195584,1195597,1197301,1197660,1197673,1199372,1199728,1199742,1201433,1201789,1201803,1203483,1203852,1203864,1205536,1205900,1205914,1207573,1207937,1207951,1209602,1209979,1209993,1211637,1212020,1212033,1213672,1214050,1214065,1215694,1216072,1216087,1217703,1218081,1218096,1219697,1220075,1220090,1221680,1222058,1222073,1223656,1224034,1224049,1225627,1226005,1226020,1227620,1227998,1228013,1229634,1230015,1230030,1231644,1232024,1232035,1233640,1234021,1234036,1235628,1236008,1236022,1237608,1237988,1238002,1239576,1239956,1239970,1241912,1241926,1243895,1243909,1245868,1245881,1247829,1247841,1249813,1249827,1251791,1251805,1253772,1253786,1255748,1255762,1257716,1257730,1259676,1259690,1261623,1261637,1263557,1263571,1265482,1265496,1267412,1267426,1269332,1269346,1271241,1271255,1273139,1273153,1275023,1275037,1276889,1276901,1278747,1278761,1280603,1280610,1282442,1282454,1284277,1284291,1286101,1286115,1287912,1287926,1289706,1289720,1291491,1291505,1293301,1293315,1295103,1295117,1296898,1296912,1298684,1298698,1300455,1300469,1302214,1302226,1303963,1303977,1305711,1305725,1307451,1307465,1309181,1309195,1310899,1310913,1312818,1312832,1314735,1314749,1316669,1316683,1318596,1318610,1320515,1320529,1322424,1322438,1324326,1324340,1326213,1326227,1328082,1328095,1329942,1329956,1331829,1331843,1333706,1333720,1335573,1335587,1337429,1337443,1339274,1339288,1341104,1341118,1342921,1342935,1344730,1344744,1346537,1346551,1348334,1348348,1350124,1350138,1352029,1352043,1353921,1353935,1355802,1355816,1357673,1357687,1359534,1359548,1361386,1361400,1363229,1363243,1365061,1365075,1366880,1366894,1368689,1368703,1370493,1370507,1372286,1372300,1374066,1374080,1375926,1375940,1377769,1377783,1379598,1379612,1381416,1381430,1383232,1383246,1385039,1385053,1386857,1388651,1553585,1553632,1553644,1554620,1554669,1554681,1555647,1555696,1555708,1556665,1556714,1556726,1557675,1557724,1557736,1558683,1558732,1558744,1559681,1559730,1559742,1561039,1561088,1561100,1562388,1562437,1562449,1564231,1564280,1564292,1566064,1566113,1566125,1567885,1567934,1567945,1570810,1570859,1570871,1573703,1573752,1573764,1576584,1576633,1576645,1579454,1579505,1579517,1582318,1582367,1582379,1585165,1585214,1585226,1588000,1588052,1588062,1590838,1590887,1590899,1593663,1593712,1593724,1596520,1596566,1596576,1599391,1599437,1599447,1602246,1602297,1602305,1605099,1605145,1605155,1607934,1607986,1607996,1610769,1610820,1610828,1613594,1613644,1613653,1616417,1616463,1616473,1619221,1619267,1619277,1622010,1622058,1622068,1624787,1624833,1624843,1627556,1627602,1627612,1630309,1630361,1630371,1633056,1633108,1633118,1635862,1635908,1635917,1638689,1638735,1638745,1641530,1641576,1641586,1644353,1644404,1644414,1647167,1647218,1647223,1647228,1647333,1647334,1647374,1647376,1647387,1647390,1649982,1650030,1650034,1650039,1650142,1650144,1650184,1650185,1650195,1650196,1652851,1652899,1652904,1652908,1653011,1653013,1653052,1653053,1653063,1653064,1655712,1655758,1655764,1655768,1655875,1655876,1655911,1655912,1655923,1655924,1658560,1658606,1658612,1658616,1658723,1658724,1658759,1658760,1658771,1658772,1661397,1661443,1661449,1661453,1661560,1661561,1661596,1661597,1661608,1661609,1664220,1664266,1664272,1664276,1664383,1664384,1664419,1664420,1664431,1664432,1667032,1667080,1667085,1667089,1667197,1667198,1667230,1667231,1667241,1667242,1669839,1669885,1669891,1669895,1670002,1670003,1670038,1670039,1670050,1670051,1672698,1672744,1672750,1672754,1672861,1672862,1672897,1672898,1672909,1672910,1675550,1675596,1675602,1675606,1675713,1675714,1675749,1675750,1675761,1675762,1678394,1678441,1678446,1678450,1678560,1678562,1678595,1678596,1678606,1678608,1681229,1681279,1681285,1681290,1681390,1681391,1681434,1681435,1681444,1681445,1684059,1684107,1684111,1684116,1684224,1684225,1684268,1684269,1684281,1684282,1686878,1686924,1686930,1686934,1687063,1687064,1687107,1687108,1687123,1687124,1689730,1689778,1689782,1689787,1689916,1689917,1689968,1689970,1689986,1689988,1692587,1692633,1692639,1692643,1692772,1692773,1692816,1692817,1692832,1692833,1695355,1695399,1695403,1695409,1695532,1695534,1695583,1695584,1695599,1695600,1698114,1698160,1698166,1698170,1698300,1698301,1698344,1698345,1698360,1698361,1700867,1700913,1700919,1700923,1701053,1701054,1701097,1701098,1701113,1701114,1703611,1703657,1703663,1703667,1703797,1703798,1703841,1703842,1703857,1703858,1706344,1706396,1706400,1706406,1706532,1706533,1706584,1706585,1706599,1706600,1709115,1709166,1709171,1709177,1709303,1709304,1709355,1709356,1709370,1709371,1711882,1711928,1711934,1711938,1712068,1712069,1712112,1712113,1712128,1712129,1714666,1714712,1714718,1714722,1714852,1714853,1714896,1714897,1714912,1714913,1717441,1717487,1717493,1717497,1717627,1717628,1717671,1717672,1717687,1717688,1720203,1720249,1720255,1720259,1720389,1720390,1720433,1720434,1720449,1720450,1722951,1722996,1723001,1723006,1723131,1723133,1723181,1723182,1723199,1723200,1725691,1725737,1725743,1725747,1725877,1725878,1725921,1725922,1725937,1725938,1728426,1728472,1728478,1728482,1728612,1728613,1728656,1728657,1728672,1728673,1731152,1731198,1731204,1731208,1731338,1731339,1731382,1731383,1731398,1731399,1733860,1733906,1733912,1733916,1734046,1734047,1734090,1734091,1734106,1734107,1736559,1736605,1736611,1736615,1736745,1736746,1736789,1736790,1736805,1736806,1739293,1739299,1739303,1739433,1739434,1739477,1739478,1739493,1739494,1741967,1741973,1741977,1742107,1742108,1742151,1742152,1742167,1742168,1744631,1744637,1744641,1744771,1744772,1744815,1744816,1744831,1744832,1747289,1747295,1747299,1747429,1747430,1747473,1747474,1747489,1747490,1749938,1749944,1749948,1750078,1750079,1750122,1750123,1750138,1750139,1752580,1752586,1752590,1752720,1752721,1752764,1752765,1752780,1752781,1755213,1755219,1755223,1755353,1755354,1755397,1755398,1755413,1755414,1757835,1757840,1757845,1757974,1757975,1758028,1758029,1758043,1758044,1760446,1760450,1760455,1760583,1760584,1760636,1760637,1760653,1760654,1763050,1763055,1763061,1763183,1763184,1763234,1763235,1763249,1763250,1765649,1765655,1765659,1765789,1765790,1765833,1765834,1765849,1765850,1768247,1768251,1768382,1768383,1768426,1768427,1768442,1768443,1770836,1770967,1770968,1771011,1771012,1771027,1771028,1773543,1773544,1773587,1773588,1773603,1773604,1776117,1776118,1776161,1776162,1776177,1776178,1778676,1778677,1778720,1778721,1778736,1778737,1781225,1781226,1781269,1781270,1781285,1781286,1783767,1783768,1783811,1783812,1783827,1783828,1786299,1786300,1786343,1786344,1786359,1786360,1788804,1788805,1788848,1788849,1788864,1788865,1791298,1791299,1791342,1791343,1791358,1791359,1793774,1793775,1793818,1793819,1793834,1793835,1796231,1796232,1796275,1796276,1796291,1796292,1798672,1798675,1798726,1798728,1798744,1798745,1801134,1801135,1801178,1801179,1801194,1801195,1803579,1803580,1803623,1803624,1803639,1803640,1806004,1806005,1806048,1806049,1806064,1806065,1808415,1808416,1808455,1808456,1808471,1808472,1810858,1810859,1810874,1810875,1813212,1813213,1813228,1813229,1815561,1815562,1815577,1815578,1817893,1817894,1817909,1817910,1820216,1820217,1846921,1849074,1851223,1853366,1855502,1857635,1859757,1861873,1863987,1866095,1868185,1870270,1872343,1874404,1876458,1878510,1880583,1882647,1884702,1886779,1888842,1890902,1892982,1895072,1897169,1899304,1901452,1903589,1905716,1907861,1910018,1912167,1914330,1916548,1918755,1920954,1923151,1925357,1927606,1929841,1932059,1934268,1936466,1938658,1940843,1943018,1945182,1947336,1949477,1951611,1953742,1955821,1957890,1959950,1961991,1964025,1966046,1968065,1970085,1972098,1974096,1976089,1978067,1980042,1982033,1984027,1986010,1987980,1989941,1991889,1993828,1995759,1997688,1999607,2001516,2003412,2094513,2096392,2098257,2100218,2102169,2104130,2106085,2108031,2109966,2111890,2113802,2115705,2115711,2117600,2117606,2117608,2119487,2119493,2119495,2121364,2121370,2121372,2123237,2123239,2515120,2515126,2517970,2517976,2520813,2520819,2523645,2523651,2526465,2526471,2529278,2529284,2532086,2532092,2534887,2534893,2537681,2537687,2540475,2540481,2543259,2543265,2546032,2546038,2548798,2548804,2551603,2551609,2551652,2551667,2551673,2551689,2551695,2554399,2554405,2554448,2554463,2554469,2554485,2554491,2557210,2557216,2557259,2557274,2557280,2557296,2557302,2560013,2560019,2560062,2560077,2560083,2560099,2560105,2562802,2562808,2562851,2562866,2562872,2562888,2562894,2565582,2565583,2565628,2565646,2565647,2565670,2565671,2568348,2568349,2568394,2568412,2568413,2568436,2568437,2571174,2571180,2571223,2571238,2571244,2571260,2571266,2573996,2574002,2574045,2574060,2574066,2574082,2574088,2576810,2576816,2576859,2576874,2576880,2576896,2576902,2579612,2579618,2579662,2579679,2579687,2579705,2579711,2582409,2582415,2582459,2582476,2582484,2582502,2582508,2585191,2585197,2585241,2585258,2585266,2585284,2585290,2587962,2587968,2588012,2588029,2588037,2588055,2588061,2590730,2590736,2590780,2590797,2590805,2590823,2590829,2593489,2593495,2593539,2593556,2593564,2593582,2593588,2596240,2596246,2596290,2596307,2596315,2596333,2596339,2598982,2598988,2599032,2599049,2599057,2599075,2599081,2601711,2601717,2601761,2601778,2601786,2601804,2601810,2604427,2604433,2604477,2604494,2604502,2604520,2604526,2607134,2607140,2607184,2607201,2607209,2607227,2607233,2609837,2609843,2609887,2609904,2609912,2609930,2609936,2612531,2612537,2612581,2612598,2612606,2612624,2612630,2615255,2615261,2615305,2615322,2615330,2615348,2615354,2617972,2617978,2618022,2618039,2618047,2618065,2618071,2620679,2620685,2620729,2620746,2620754,2620772,2620778,2623371,2623377,2623421,2623438,2623446,2623464,2623470,2626052,2626058,2626102,2626119,2626127,2626145,2626151,2628733,2628739,2628783,2628800,2628808,2628826,2628832,2631398,2631404,2631448,2631465,2631473,2631491,2631497,2634065,2634071,2634115,2634132,2634140,2634158,2634164,2636711,2636717,2636761,2636778,2636786,2636804,2636810,2639345,2639351,2639395,2639412,2639420,2639438,2639444,2641966,2641972,2642016,2642033,2642041,2642059,2642065,2644575,2644581,2644625,2644642,2644650,2644668,2644674,2647176,2647182,2647226,2647243,2647251,2647269,2647275,2649764,2649770,2649814,2649831,2649839,2649857,2649863,2652343,2652349,2652393,2652410,2652418,2652436,2652442,2654910,2654916,2654960,2654977,2654985,2655003,2655009,2657512,2657529,2657537,2657555,2657561,2660046,2660063,2660071,2660089,2660095,2662561,2662578,2662586,2662604,2662610,2665062,2665079,2665087,2665105,2665111,2667566,2667574,2667592,2667598,2670029,2670037,2670055,2670061,2672506,2672512,2674937,2674943,2689353,2691697,2694025,2696377,2699462,2702533,2705609,2708656,2711699,2714730,2717750,2720815,2723923,2727022,2730109,2733208,2736311,2739398,2742475,2745535,2748576,2751605,2908410,2911027,2913625,2916213,2918803,2921376,2923941,2926495,2929031,2931550,2934059,2936559,2939067,2941570,2944064,2946542,2949004,2951451,2953898,2956387,2958866,2961335,2963784,2966215,2968633,2971049,2973449,2975838,2978215,2980605,2982981,2985350,2987734,2990112,2992488,2994851,2997201,2999535,3001858,3004173,3006463,3008689,3010877,3013045,3015197,3017341,3019529,3021604,3023081,3024550,3026006,3027452,3028890,3030322,3031744,3033156,3034754,3036340,3037915,3039482,3041041,3042591,3044133,3045668,3047191,3048703,3050208,3051716,3053214,3054699,3056175,3057640,3059093,3060538,3061975,3063710,3065436,3067151,3068853,3070546,3072230,3073905,3075570,3077228,3078889,3080541,3082184,3083816,3085438,3087086,3088725,3090353,3091969,3093575,3095173,3096763,3098344,3099921,3101487,3103038,3104580,3106114,3107663,3267859,3267870,3267882,3269911,3269922,3269934,3272004,3272015,3272027,3274119,3274130,3274142,3276218,3276229,3276241,3278308,3278319,3278331,3280423,3280435,3280447,3282553,3282565,3282577,3284677,3284689,3284701,3286787,3286799,3286811,3288927,3288939,3288951,3291050,3291062,3291074,3293159,3293171,3293183,3295263,3295275,3295287,3297359,3297371,3297383,3299447,3299459,3299471,3301526,3301538,3301550,3303593,3303605,3303617,3305648,3305660,3305672,3307695,3307707,3307719,3309739,3309751,3309763,3311775,3311787,3311799,3313797,3313809,3313821,3315811,3315823,3315835,3317815,3317827,3317839,3319809,3319821,3319833,3321795,3321807,3321819,3323778,3323790,3323802,3325922,3325934,3325946,3328191,3328203,3328215,3330574,3330586,3330598,3332944,3332956,3332968,3335301,3335313,3335325,3337651,3337663,3337675,3339997,3340009,3340021,3340066,3340079,3340093,3340116,3340127,3342336,3342348,3342360,3342405,3342418,3342432,3342455,3342466,3344697,3344709,3344721,3344766,3344779,3344793,3344816,3344827,3347049,3347061,3347073,3347118,3347131,3347145,3347168,3347179,3349392,3349404,3349416,3349461,3349474,3349488,3349511,3349522,3351720,3351732,3351744,3351789,3351802,3351816,3351839,3351850,3354041,3354053,3354065,3354110,3354123,3354137,3354160,3354171,3356359,3356371,3356383,3356428,3356441,3356455,3356478,3356489,3358707,3358719,3358731,3358776,3358789,3358803,3358826,3358837,3361072,3361084,3361096,3361142,3361155,3361169,3361192,3361203,3363429,3363441,3363453,3363499,3363512,3363526,3363549,3363560,3365773,3365785,3365797,3365843,3365856,3365870,3365893,3365904,3368109,3368121,3368133,3368179,3368192,3368206,3368229,3368240,3370437,3370449,3370461,3370507,3370520,3370534,3370557,3370568,3372758,3372770,3372782,3372828,3372841,3372855,3372878,3372889,3375072,3375084,3375096,3375142,3375155,3375169,3375192,3375203,3377381,3377393,3377405,3377451,3377464,3377478,3377501,3377512,3379681,3379693,3379705,3379751,3379764,3379778,3379801,3379812,3381964,3381976,3381988,3382034,3382047,3382061,3382084,3382095,3384240,3384254,3384268,3384320,3384333,3384347,3384370,3384382,3386514,3386528,3386542,3386594,3386607,3386621,3386644,3386656,3388774,3388788,3388802,3388854,3388867,3388881,3388904,3388916,3391028,3391042,3391056,3391108,3391121,3391135,3391158,3391170,3393271,3393285,3393299,3393351,3393364,3393378,3393401,3393413,3395500,3395514,3395528,3395580,3395593,3395607,3395630,3395642,3397716,3397730,3397744,3397796,3397809,3397823,3397846,3397858,3399923,3399937,3399951,3400003,3400016,3400030,3400053,3400065,3402117,3402131,3402145,3402197,3402210,3402224,3402247,3402259,3404300,3404314,3404328,3404380,3404393,3404407,3404430,3404442,3406472,3406486,3406500,3406552,3406565,3406579,3406602,3406614,3408659,3408673,3408725,3408738,3408752,3408775,3408787,3410824,3410876,3410889,3410903,3410926,3410938,3413005,3413018,3413032,3413055,3413067,3415159,3415172,3415186,3415209,3415221,3417301,3417314,3417328,3417351,3417363,3419433,3419446,3419460,3419483,3419495,3421555,3421569,3421592,3421604,3423658,3423681,3423693,3425748,3425760,3427796,3427808,3429839,3443894,3443911,3445865,3445882,3448016,3448033,3450159,3450176,3452294,3452311,3454418,3454435,3456537,3456554,3458661,3458678,3460797,3460814,3462927,3462944,3465077,3465094,3467221,3467238,3469394,3469411,3471556,3471573,3473710,3473727,3475866,3475883,3478016,3478033,3480158,3480175,3482290,3482307,3484417,3484434,3486535,3486552,3488645,3488662,3490773,3490778,3490784,3490795,3492899,3492904,3492910,3492921,3495019,3495024,3495030,3495041,3497176,3497181,3497187,3497198,3499323,3499328,3499334,3499345,3501463,3501468,3501474,3501485,3503596,3503601,3503607,3503617,3505724,3505729,3505735,3505745,3507847,3507852,3507858,3507868,3509963,3509968,3509974,3509984,3512075,3512080,3512086,3512096,3514177,3514182,3514188,3514198,3516271,3516276,3516282,3516292,3518358,3518363,3518369,3518379,3520444,3520449,3520455,3520465,3522518,3522523,3522529,3522539,3524586,3524591,3524597,3524607,3526647,3526653,3526663,3528728)) 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





	Andrei Grigoriev (Baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Andrei Grigoriev (Baritone)
			

																
Andrei Grigoriev (Baritone)

														
				


        




    

        He were borne in Irkutsk. In 1987 graduated from the musical school of the name Of p. i.Chaykovskiy in Sverdlovsk (now Ekaterinburg), in 92nd g. - the state musical- pedagogical institute (now Russian academy of music) of name Gnesinykh according to the class Nataliya shpillers. In 1990-95 yr. he was the soloist of the Ekaterinburg state academic theater of opera and ballet. In 1995-96 yr. came out in the Moscow theater new opera under the government of Yevgeny Kolobova. 
 in 1996 was accepted in the operatic company of the large of teatra.
 
 Repertoire in the the large of teatre
 
 Georges zhermon ("Traviata" G. Verdi) 
 Yelets ("Queen of Spades" P. Tschaikovsky) 
 Robert ("P. Tschaikovsky‘s Iolanta") 
 trousers ("love for three oranges" S. Prokofiev) 
 tsarevich afron ("gold cockerel" N. Roman -Korsakova) 
 the shadow Of vergiliya ("Franceska yes Rimini" S. Rakhmaninoff) 
 Andrey shchelkalov ("Boris Godunov" M. musorgskogo) 
 Mizgir‘ ("the snow maiden" Of n. rimskogo-Korsakov -Korsakova) 
 Marseille ("Bohemia" J. puchchini) 
 Yevgeny Onegin ("Yevgeny Onegin" P. Tschaikovsky) 
 Sharples ("Madame is butterfly" J. puchchini)
 
 Also in the repertoire: 
 rhenate ("Ball- masquerade" G. Verdi) 
 bolero ("Hispalensis barber" J. Rossini) 
 graph the di Moon ("troubadour" G. Verdi) 
 the Valentinas ("Faust" Sh. Gounod) 
 Silvio ("clowns" R. leonkavallo) 
 Ferdinand ("betrothal in the monastery" S. Prokofiev) 
 
 Tours 
 
 It came out in Austria, Germany, Italy, South Korea, Japan, USA. 
 in 2001 is ripe the party of Robert in the opera Of "iolanta" (conductor Vladimir Fedoseev) in the large hall of Moscow conservatory. 
 repeatedly came out at the festival "Irina arkhipova it represents". It participated in the tours of the Bolshoi theater in London, Rome, Seoul, Hong Kong, Ljubljana, Trieste, Warsaw. It sang in the Washington national opera. 
 
 Rewards 
 
 In 1992 THE III reward of the international competition of young operatic singers in Barcelona was obtained. 
 in 1993. - THE II reward of the international competition of the name of Louise toddi in Lisbon. 
 in 1994. - THE III reward of the international competition of the vocalists of name To miriam Of khelin in Helsinki and of competition in g. of perpel‘yan (France). 
 in 1995 was obtained THE III reward of the international competition of young operatic singers in Marseille. 
 in 1997 became the laureate of television competition Irina arkhipovoy "the large prize Of moskvy".
 in 1998. - THE III reward of the international competition of the vocalists of name Stanislav monyushko into Varshave.
 in 2005 was honored title "deserved artist of Russia". 
        

    

    

            


			

		





	


	

	

		


			

				

					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