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 (20068,20139,20143,21555,21626,21630,23009,23080,23084,24461,24534,24539,25945,26019,26024,26385,26539,26551,27818,28017,28033,30406,30480,30485,31903,31984,31989,33408,33490,33495,34882,34964,34969,36532,36538,38090,38096,38157,38162,39557,39563,39624,39629,41015,41019,42426,42430,42447,43811,43815,43831,45168,45172,45188,46517,46521,46537,47860,47864,47880,49197,49201,49217,50529,50533,50549,51853,51857,51873,53170,53174,53190,54487,54503,54570,54577,54588,54595,55794,55810,55875,55884,55894,55902,57177,57242,57251,57261,57268,59252,59317,59326,59336,59343,61321,61386,61395,61405,61411,63382,63447,63456,63466,63473,65434,65499,65509,65518,65525,67481,67546,67556,67565,67571,69527,69592,69602,69611,69618,71567,71632,71642,71651,71658,73665,73675,73684,73691,75690,75700,75709,75716,77704,77714,77723,77730,79713,79723,79732,79739,81717,81727,81736,81743,83715,83725,83734,83741,85705,85715,85724,85731,87687,87697,87706,87713,89660,89670,89679,89686,91624,91634,91643,91649,93580,93590,93599,93606,95531,95540,95550,95557,97475,97484,97495,97502,99411,99420,99432,99439,101336,101345,101357,101364,103251,103260,103272,103279,105156,105165,105177,105184,107053,107062,107074,107081,108947,108956,108968,108975,110831,110840,110852,110859,112712,112724,112730,114579,114590,114597,116447,116454,118319,118326,120192,120199,122062,122069,123932,125787,211800,211802,211804,213333,213335,213337,214871,214873,214875,216404,216406,216408,217935,217937,217939,219460,219462,219464,220981,220983,220985,222498,222500,222502,224010,224012,224014,225518,225520,225522,227028,227030,228533,234030,234033,234043,234047,234055,236018,236021,236031,236035,236043,237998,238001,238011,238015,238023,239968,239971,239981,239985,239993,241931,241934,241944,241948,241956,243891,243893,243903,243907,243915,245849,245852,245861,245866,245874,247802,247811,247816,247824,249748,249757,249762,249770,251700,251704,251712,253680,253684,253692,255652,255656,255664,257616,257620,257628,259587,259591,259599,261556,261564,263514,263522,265486,267442,288461,290304,292205,294099,295986,297864,299739,301635,303523,305454,307384,309307,311225,313139,315047,316949,318843,320727,322603,324472,326376,328280,330176,332067,333948,335819,337684,339564,341492,343416,345336,347254,349155,351042,352920,354796,356676,477483,477490,477498,477507,477537,477540,477545,477548,479057,479064,479073,479082,479109,479113,479117,479122,480625,480632,480640,480649,480676,480680,480684,480689,481377,481384,481391,481400,481430,481433,481438,481441,482123,482130,482137,482146,482172,482176,482181,482186,482860,482867,482874,482883,482909,482913,482918,482923,483594,483601,483609,483618,483644,483648,483652,483657,484346,484353,484360,484369,484395,484399,484403,484408,485095,485102,485109,485118,485144,485148,485152,485157,485838,485845,485852,485861,485887,485891,485895,485900,486568,486575,486582,486591,486620,486623,486629,486631,487289,487296,487303,487312,487341,487342,487346,487351,488003,488010,488017,488026,488052,488056,488060,488065,488716,488723,488731,488739,488765,488768,488772,488778,489428,489435,489444,489452,489477,489480,489484,489490,490135,490142,490151,490159,490184,490187,490191,490197,490835,490842,490850,490858,490886,490890,490895,490896,491530,491537,491545,491553,491579,491582,491586,491592,492215,492222,492231,492239,492264,492267,492271,492277,492898,492905,492914,492922,492947,492950,492954,492960,493580,493587,493596,493604,493629,493632,493636,493642,494256,494263,494272,494280,494307,494311,494316,494317,494925,494932,494941,494949,494976,494980,494985,494988,495394,495398,495586,495593,495602,495610,495637,495638,495642,495648,496046,496235,496242,496251,496259,496286,496290,496295,496298,496873,496880,496889,496897,496924,496928,496933,496934,498343,498350,498359,498367,498394,498397,498403,498406,499805,499812,499820,499829,499856,499859,499865,499868,501260,501267,501275,501284,501311,501314,501320,501323,502707,502714,502723,502731,502759,502763,502768,502771,504192,504199,504209,504217,504242,504245,504249,504254,505669,505676,505686,505694,505721,505725,505730,505731,507140,507147,507157,507165,507190,507193,507197,507202,508612,508619,508629,508637,508662,508665,508669,508674,510079,510086,510096,510104,510129,510132,510136,510141,511539,511546,511556,511564,511589,511592,511596,511601,512991,512998,513008,513016,513043,513047,513048,513053,514471,514478,514487,514495,514520,514523,514527,514532,515941,515948,515957,515965,515990,515993,515997,516002,517402,517409,517418,517426,517451,517454,517458,517463,518853,518860,518869,518877,518904,518905,518909,518914,520297,520304,520312,520320,520348,520351,520357,520359,521738,521745,521754,521762,521789,521790,521794,521799,523172,523179,523187,523195,523223,523226,523232,523234,524597,524604,524612,524620,524648,524651,524657,524659,526013,526020,526029,526037,526064,526065,526069,526074,527420,527427,527436,527444,527471,527472,527476,527481,528826,528833,528842,528850,528877,528878,528882,528887,530230,530237,530246,530254,530279,530283,530286,530291,531628,531635,531644,531652,531677,531681,531684,531690,533018,533025,533034,533042,533067,533070,533074,533080,534457,534465,534473,534481,534509,534513,534518,534521,535888,535895,535904,535912,535937,535940,535944,535950,537318,537326,537336,537344,537372,537376,537380,537384,538746,538755,538765,538773,538803,538808,538812,538813,540167,540176,540186,540195,540224,540228,540233,540235,541579,541588,541597,541606,541636,541640,541645,541647,543029,543037,543047,543056,543083,543087,543091,543095,544504,544513,544521,544531,544561,544565,544570,544572,545973,545982,545992,546001,546030,546034,546039,546040,547427,547436,547446,547455,547485,547489,547493,547494,548882,548891,548900,548909,548939,548943,548948,548950,550331,550340,550350,550359,550388,550392,550397,550399,551772,551781,551791,551800,551829,551833,551838,551840,553205,553214,553224,553233,553263,553267,553271,553273,554626,554635,554645,554654,554684,554688,554692,554693,556039,556047,556057,556066,556096,556100,556104,556105,557445,557453,557463,557472,557502,557506,557510,557511,558845,558853,558863,558872,558902,558906,558910,558911,560242,560250,560260,560269,560299,560303,560307,560308,561631,561640,561650,561659,561689,561693,561697,561699,563018,563026,563037,563046,563076,563080,563084,563086,564395,564403,564412,564422,564453,564457,564461,564463,565762,565770,565778,565788,565819,565824,565828,565830,567121,567129,567137,567146,567177,567182,567186,567188,568480,568488,568496,568506,568538,568542,568546,568548,569834,569842,569850,569860,569891,569895,569899,569901,571177,571185,571193,571203,571233,571238,571242,571244,572560,572568,572576,572585,572616,572620,572624,572626,573940,573948,573956,573966,573996,574000,574004,574006,575309,575317,575325,575334,575365,575369,575373,575375,576669,576677,576685,576694,576725,576729,576733,576735,578026,578034,578042,578051,578082,578086,578090,578092,579376,579384,579392,579401,579432,579436,579440,579442,579462,579475,580715,580723,580730,580739,580771,580775,580779,580781,580800,580812,582044,582049,582052,582054,582059,582068,582100,582104,582108,582110,582129,582133,582137,582141,583374,583379,583382,583384,583389,583398,583430,583434,583438,583440,583459,583462,583467,583471,584693,584698,584702,584704,584709,584718,584750,584754,584758,584760,584779,584782,584786,584791,586006,586011,586015,586017,586022,586031,586063,586067,586071,586073,586092,586095,586099,586104,587315,587320,587324,587326,587331,587340,587372,587376,587380,587382,587401,587404,587408,587413,588616,588621,588625,588627,588632,588641,588672,588676,588681,588683,588703,588706,588710,588715,589916,589922,589929,589934,589948,589961,590006,590011,590016,590022,590057,590065,590071,590075,591536,591542,591549,591553,591568,591580,591626,591631,591636,591642,591677,591685,591691,591695,593176,593182,593188,593192,593207,593219,593265,593270,593275,593281,593317,593322,593329,593334,594882,594887,594894,594898,594913,594926,594974,594979,594985,594989,595024,595030,595037,595041,596579,596584,596591,596595,596610,596623,596671,596676,596682,596686,596721,596727,596734,596738,598264,598270,598276,598280,598296,598307,598354,598360,598364,598370,598408,598411,598417,598423,599941,599946,599953,599957,599972,599985,600033,600038,600044,600048,600083,600089,600096,600100,601622,601629,601633,601637,601653,601664,601711,601717,601721,601727,601765,601768,601774,601781,603299,603306,603310,603325,603338,603386,603391,603397,603401,603436,603442,603449,603453,604969,604973,604988,604999,605046,605052,605057,605063,605099,605103,605109,605116,606627,606642,606655,606703,606708,606714,606718,606753,606759,606766,606770,608287,608300,608348,608353,608359,608363,608398,608404,608411,608415,609925,609938,609986,609991,609997,610001,610036,610042,610049,610053,611609,611622,611670,611675,611681,611685,611720,611726,611733,611737,613287,613300,613348,613353,613359,613363,613398,613403,613410,613414,614967,615015,615020,615026,615030,615065,615070,615077,615081,616622,616668,616673,616678,616684,616720,616727,616733,616737,618312,618317,618323,618327,618362,618367,618374,618378,619945,619950,619956,619960,619995,620000,620007,620011,621570,621575,621580,621586,621623,621629,621635,621639,623191,623196,623202,623206,623241,623246,623253,623257,624801,624806,624812,624816,624851,624856,624863,624867,626422,626427,626433,626437,626472,626477,626484,626488,628033,628038,628044,628048,628083,628088,628095,628099,629633,629638,629644,629648,629683,629688,629695,629699,631226,631231,631237,631241,631276,631281,631288,631292,632813,632818,632824,632828,632863,632868,632875,632879,634391,634396,634402,634406,634441,634446,634453,634457,635963,635969,635973,636008,636013,636020,636024,637527,637531,637566,637571,637578,637582,639076,639113,639117,639123,639128,640648,640653,640660,640664,642177,642181,642186,642191,643692,643696,643703,643708,645202,645208,645213,645219,646708,646713,646720,646724,648203,648208,648215,648219,649702,649707,649714,649718,651190,651195,651202,651206,652671,652676,652683,652687,654143,654148,654155,654159,655604,655609,655616,655620,657060,657067,657071,658522,658526,659969,703315,703318,704496,704499,705662,705665,706812,706815,707951,707954,709078,709081,710196,710199,711344,711347,712351,712354,712357,712482,712485,712555,712561,712569,713482,713486,713489,713614,713618,713687,713695,713702,714604,714607,714610,714735,714738,714808,714814,714822,715713,715716,715719,715844,715847,715917,715923,715931,716811,716814,716817,716942,716945,717015,717021,717029,717899,717902,717905,718030,718033,718103,718109,718117,718977,718980,718983,719108,719111,719181,719187,719195,720043,720046,720049,720174,720177,720247,720253,720261,720269,721098,721101,721104,721229,721232,721302,721308,721316,721324,722156,722159,722162,722287,722290,722360,722366,722374,722382,723218,723221,723224,723349,723352,723422,723428,723436,723444,724270,724273,724276,724401,724404,724474,724480,724488,724496,725313,725316,725319,725444,725447,725517,725523,725531,725539,726346,726349,726352,726477,726480,726550,726556,726564,726572,727371,727374,727377,727503,727506,727576,727582,727590,727598,728388,728391,728394,728520,728523,728593,728599,728607,728615,729395,729398,729401,729527,729530,729600,729606,729614,729622,730395,730398,730401,730527,730530,730600,730606,730614,730622,731387,731390,731393,731519,731522,731592,731598,731606,731614,732374,732377,732380,732506,732509,732579,732585,732593,732601,733368,733371,733374,733500,733503,733573,733579,733587,733595,734355,734358,734361,734487,734490,734560,734566,734574,734582,735334,735337,735340,735466,735469,735539,735545,735553,735561,736301,736304,736307,736433,736436,736506,736512,736520,736528,737273,737276,737279,737405,737408,737478,737484,737492,737500,738237,738240,738243,738369,738372,738442,738448,738456,738464,739192,739196,739199,739324,739329,739397,739404,739414,739420,740142,740144,740148,740274,740278,740344,740349,740358,740364,742110,742113,742117,742243,742246,742313,742318,742324,742332,744083,744086,744089,744216,744219,744286,744291,744297,744306,746048,746051,746054,746181,746184,746250,746255,746262,746272,748009,748014,748016,748140,748143,748213,748217,748224,748232,749991,749996,749998,750122,750125,750195,750199,750206,750214,751973,751978,751980,752104,752107,752177,752181,752188,752196,754852,754857,754859,754985,754986,755056,755061,755066,755076,757725,757730,757732,757858,757861,757929,757934,757939,757949,760591,760596,760598,760724,760727,760795,760801,760806,760817,763456,763460,763462,763586,763589,763661,763668,763676,763678,766315,766319,766321,766445,766448,766520,766527,766535,766537,769166,769171,769172,769299,769301,769369,769374,769382,769391,772012,772017,772018,772144,772147,772215,772220,772227,772237,774852,774857,774858,774984,774986,775054,775059,775066,775077,777687,777692,777693,777819,777821,777889,777894,777901,777909,780518,780523,780524,780650,780653,780720,780725,780733,780742,783354,783358,783360,783484,783487,783559,783566,783574,783576,786183,786188,786189,786315,786317,786385,786390,786398,786407,789009,789014,789015,789141,789143,789211,789216,789224,789232,791831,791836,791837,791963,791965,792033,792038,792047,792054,794650,794655,794656,794783,794784,794847,794852,794859,794866,797459,797464,797465,797591,797593,797656,797662,797668,797675,800264,800268,800270,800396,800398,800461,800467,800473,800480,803066,803070,803072,803197,803199,803266,803272,803280,803282,805860,805864,805866,805993,805995,806058,806064,806071,806077,808649,808653,808655,808782,808784,808847,808853,808859,808866,811432,811435,811438,811565,811567,811631,811635,811641,811649,814211,814214,814218,814344,814346,814410,814414,814420,814428,816985,816988,816992,817118,817120,817184,817188,817194,817202,819752,819754,819759,819885,819887,819950,819955,819961,819969,822512,822516,822518,822644,822646,822713,822719,822727,822729,825263,825265,825270,825396,825398,825461,825466,825472,825480,828009,828011,828016,828143,828146,828207,828213,828218,828226,830752,830757,830884,830887,830949,830954,830959,830967,833491,833496,833623,833626,833688,833693,833698,833706,836228,836354,836356,836423,836429,836437,836439,839085,839088,839150,839154,839160,839168,841810,841813,841874,841879,841885,841893,844528,844530,844594,844598,844604,844612,847267,847269,847332,847337,847343,847351,850000,850002,850065,850070,850076,850084,852729,852731,852794,852799,852805,852813,855459,855461,855524,855529,855535,855543,858185,858186,858249,858254,858260,858268,860905,860908,860970,860974,860980,860988,863617,863620,863681,863687,863692,863700,866318,866321,866382,866387,866393,866401,869008,869011,869072,869077,869083,869091,871692,871695,871756,871761,871767,871775,874375,874378,874443,874449,874450,874458,877054,877057,877118,877124,877129,877137,879738,879741,879803,879807,879813,879821,882418,882421,882486,882487,882493,882501,885101,885104,885165,885170,885176,885184,887771,887773,887840,887846,887854,887856,890436,890439,890501,890506,890511,890519,893096,893099,893164,893170,893171,893179,895754,895757,895818,895823,895829,895837,898403,898405,898472,898478,898486,898488,901049,901052,901113,901118,901124,901132,903685,903687,903750,903755,903761,903769,906309,906311,906373,906378,906384,906393,908924,908926,908989,908994,909000,909009,911536,911538,911605,911611,911619,911621,914173,914175,914242,914248,914256,914258,916882,916884,916948,916953,916959,916967,919582,919584,919646,919651,919658,919667,922268,922269,922332,922337,922343,922352,924967,924969,925032,925037,925044,925051,927660,927661,927724,927729,927737,927746,930374,930437,930442,930449,930459,933143,933148,933155,933164,935851,935856,935864,935873,938564,938568,938573,938583,941287,941290,941296,941307,943998,944003,944009,944021,946704,946708,946716,946727,949408,949414,949424,949427,952107,952113,952119,952129,954807,954813,954823,954826,957485,957491,957497,957509,960146,960152,960159,960170,962793,962799,962807,962816,965431,965437,965445,965454,968063,968069,968078,968086,970701,970707,970717,970720,973329,973339,973342,975947,975955,978568,1072118,1072124,1072130,1074519,1074525,1074529,1076906,1076912,1076916,1079282,1079288,1079292,1081643,1081649,1081655,1083995,1084001,1084007,1086333,1086339,1086345,1088656,1088664,1088668,1090994,1091000,1091004,1093317,1093324,1093329,1095636,1095642,1095646,1097936,1097942,1097946,1098149,1098157,1100216,1100221,1100227,1100432,1100439,1102488,1102493,1102499,1102704,1102711,1104745,1104751,1104757,1104962,1104970,1106982,1106988,1106993,1107198,1107207,1109198,1109203,1109210,1109413,1109422,1111392,1111398,1111404,1111608,1111617,1113569,1113575,1113581,1113786,1113792,1115732,1115738,1115742,1115944,1115952,1117873,1117879,1117884,1118087,1118094,1120007,1120013,1120018,1120221,1120228,1122139,1122145,1122150,1122360,1122369,1124277,1124283,1124288,1124498,1124507,1126472,1126478,1126483,1126693,1126702,1128686,1128689,1128695,1128919,1128928,1130899,1130903,1130908,1131132,1131140,1133094,1133099,1133104,1133327,1133336,1135285,1135291,1135296,1135531,1135542,1137493,1137499,1137503,1137737,1137747,1139692,1139698,1139703,1139936,1139947,1141888,1141894,1141897,1142133,1142144,1144073,1144076,1144085,1144317,1144328,1146250,1146256,1146261,1146495,1146505,1148414,1148420,1148425,1148659,1148669,1150569,1150575,1150580,1150813,1150823,1152720,1152726,1152731,1152964,1152974,1154865,1154868,1154875,1155111,1155123,1157004,1157011,1157014,1157242,1157253,1159170,1159177,1159181,1159410,1159421,1161325,1161332,1161336,1161564,1161576,1163467,1163473,1163477,1163705,1163715,1165597,1165604,1165609,1165836,1165848,1167736,1167742,1167746,1167974,1167984,1169865,1169870,1169877,1170103,1170115,1171987,1171991,1171999,1172225,1172238,1174103,1174109,1174113,1174341,1174351,1176249,1176255,1176259,1176487,1176497,1178384,1178390,1178394,1178622,1178632,1180512,1180518,1180522,1180750,1180760,1182631,1182637,1182641,1182869,1182879,1184741,1184747,1184751,1184979,1184989,1186849,1186853,1186860,1187088,1187098,1188955,1188960,1188966,1189194,1189204,1189258,1189265,1189274,1189315,1189318,1189325,1189326,1191054,1191059,1191065,1191293,1191303,1191358,1191367,1191375,1191414,1191416,1191424,1191425,1193142,1193147,1193153,1193381,1193391,1193446,1193455,1193463,1193502,1193505,1193512,1193518,1195221,1195225,1195232,1195460,1195470,1195525,1195534,1195542,1195581,1195584,1195591,1195597,1197297,1197301,1197308,1197536,1197546,1197601,1197609,1197618,1197657,1197660,1197667,1197673,1199366,1199372,1199376,1199604,1199614,1199668,1199677,1199684,1199725,1199728,1199736,1199742,1201427,1201433,1201437,1201665,1201675,1201729,1201738,1201745,1201786,1201789,1201797,1201803,1203479,1203483,1203489,1203717,1203727,1203786,1203795,1203805,1203848,1203852,1203858,1203864,1205530,1205536,1205540,1205768,1205778,1205836,1205846,1205854,1205897,1205900,1205908,1205914,1207567,1207573,1207577,1207805,1207815,1207873,1207883,1207891,1207934,1207937,1207945,1207951,1209596,1209602,1209606,1209839,1209849,1209909,1209919,1209929,1209976,1209979,1209986,1209993,1211633,1211637,1211644,1211878,1211890,1211945,1211954,1211968,1212014,1212020,1212026,1212033,1213666,1213672,1213676,1213908,1213918,1213977,1213988,1213999,1214047,1214050,1214058,1214065,1215688,1215694,1215698,1215930,1215940,1215999,1216010,1216021,1216069,1216072,1216080,1216087,1217697,1217703,1217707,1217939,1217949,1218008,1218019,1218030,1218078,1218081,1218089,1218096,1219691,1219697,1219701,1219933,1219943,1220002,1220013,1220024,1220072,1220075,1220083,1220090,1221674,1221680,1221684,1221916,1221926,1221985,1221996,1222007,1222055,1222058,1222066,1222073,1223650,1223656,1223660,1223892,1223902,1223961,1223972,1223983,1224031,1224034,1224042,1224049,1225621,1225627,1225631,1225863,1225873,1225932,1225943,1225954,1226002,1226005,1226013,1226020,1227614,1227620,1227624,1227856,1227866,1227925,1227936,1227947,1227995,1227998,1228006,1228013,1229628,1229634,1229638,1229873,1229883,1229942,1229953,1229964,1230012,1230015,1230023,1230030,1231637,1231644,1231648,1231881,1231896,1231950,1231958,1231971,1232017,1232024,1232029,1232035,1233634,1233640,1233644,1233879,1233889,1233948,1233959,1233970,1234018,1234021,1234029,1234036,1235621,1235628,1235630,1235865,1235880,1235934,1235942,1235954,1236000,1236008,1236013,1236022,1237602,1237608,1237612,1237847,1237857,1237916,1237927,1237938,1237985,1237988,1237996,1238002,1239576,1239580,1239815,1239825,1239884,1239895,1239906,1239953,1239956,1239964,1239970,1241536,1241771,1241781,1241840,1241851,1241862,1241909,1241912,1241920,1241926,1243754,1243764,1243823,1243834,1243845,1243892,1243895,1243903,1243909,1245726,1245741,1245796,1245803,1245816,1245862,1245868,1245874,1245881,1247688,1247699,1247759,1247769,1247782,1247824,1247829,1247835,1247841,1249672,1249682,1249741,1249752,1249763,1249810,1249813,1249821,1249827,1251650,1251660,1251719,1251730,1251741,1251788,1251791,1251799,1251805,1253631,1253641,1253700,1253711,1253722,1253769,1253772,1253780,1253786,1255606,1255620,1255674,1255682,1255695,1255742,1255748,1255754,1255762,1257575,1257585,1257644,1257655,1257666,1257713,1257716,1257724,1257730,1259535,1259545,1259604,1259615,1259626,1259673,1259676,1259684,1259690,1261482,1261492,1261551,1261562,1261573,1261620,1261623,1261631,1261637,1263416,1263426,1263485,1263496,1263507,1263554,1263557,1263565,1263571,1265341,1265351,1265410,1265421,1265432,1265479,1265482,1265490,1265496,1267271,1267281,1267340,1267351,1267362,1267409,1267412,1267420,1267426,1269191,1269201,1269260,1269271,1269282,1269329,1269332,1269340,1269346,1271100,1271110,1271169,1271180,1271191,1271238,1271241,1271249,1271255,1272998,1273008,1273067,1273078,1273089,1273136,1273139,1273147,1273153,1274882,1274892,1274951,1274962,1274973,1275020,1275023,1275031,1275037,1276749,1276763,1276819,1276829,1276838,1276883,1276889,1276894,1276901,1278606,1278616,1278675,1278686,1278697,1278744,1278747,1278755,1278761,1280457,1280469,1280529,1280537,1280550,1280597,1280603,1280608,1280610,1282302,1282314,1282371,1282382,1282396,1282436,1282442,1282447,1282454,1284136,1284146,1284205,1284216,1284227,1284274,1284277,1284285,1284291,1285960,1285970,1286029,1286040,1286051,1286098,1286101,1286109,1286115,1287771,1287781,1287840,1287851,1287862,1287909,1287912,1287920,1287926,1289565,1289575,1289634,1289645,1289656,1289703,1289706,1289714,1289720,1291350,1291360,1291419,1291430,1291441,1291488,1291491,1291499,1291505,1293160,1293170,1293229,1293240,1293251,1293298,1293301,1293309,1293315,1294962,1294972,1295031,1295042,1295053,1295100,1295103,1295111,1295117,1296757,1296767,1296826,1296837,1296848,1296895,1296898,1296906,1296912,1298543,1298553,1298612,1298623,1298634,1298681,1298684,1298692,1298698,1300314,1300324,1300383,1300394,1300405,1300452,1300455,1300463,1300469,1302072,1302083,1302142,1302152,1302166,1302207,1302214,1302219,1302226,1303822,1303832,1303891,1303902,1303913,1303960,1303963,1303971,1303977,1305570,1305580,1305639,1305650,1305661,1305708,1305711,1305719,1305725,1307310,1307320,1307379,1307390,1307401,1307448,1307451,1307459,1307465,1309040,1309050,1309109,1309120,1309131,1309178,1309181,1309189,1309195,1310758,1310768,1310827,1310838,1310849,1310896,1310899,1310907,1310913,1312677,1312687,1312746,1312757,1312768,1312815,1312818,1312826,1312832,1314594,1314604,1314663,1314674,1314685,1314732,1314735,1314743,1314749,1316528,1316538,1316597,1316608,1316619,1316666,1316669,1316677,1316683,1318455,1318465,1318524,1318535,1318546,1318593,1318596,1318604,1318610,1320374,1320384,1320443,1320454,1320465,1320512,1320515,1320523,1320529,1322283,1322293,1322352,1322363,1322374,1322421,1322424,1322432,1322438,1324184,1324194,1324254,1324265,1324276,1324323,1324326,1324334,1324340,1326071,1326081,1326141,1326152,1326163,1326210,1326213,1326221,1326227,1327942,1327954,1328009,1328018,1328031,1328078,1328082,1328088,1328095,1329800,1329810,1329870,1329881,1329892,1329939,1329942,1329950,1329956,1331687,1331697,1331757,1331768,1331779,1331826,1331829,1331837,1331843,1333564,1333574,1333634,1333645,1333656,1333703,1333706,1333714,1333720,1335441,1335501,1335512,1335523,1335570,1335573,1335581,1335587,1337297,1337357,1337368,1337379,1337426,1337429,1337437,1337443,1339202,1339213,1339224,1339271,1339274,1339282,1339288,1341032,1341043,1341054,1341101,1341104,1341112,1341118,1342849,1342860,1342871,1342918,1342921,1342929,1342935,1344658,1344669,1344680,1344727,1344730,1344738,1344744,1346465,1346476,1346487,1346534,1346537,1346545,1346551,1348262,1348273,1348284,1348331,1348334,1348342,1348348,1350052,1350063,1350074,1350121,1350124,1350132,1350138,1351957,1351968,1351979,1352026,1352029,1352037,1352043,1353849,1353860,1353871,1353918,1353921,1353929,1353935,1355730,1355741,1355752,1355799,1355802,1355810,1355816,1357601,1357612,1357623,1357670,1357673,1357681,1357687,1359473,1359484,1359531,1359534,1359542,1359548,1361325,1361336,1361383,1361386,1361394,1361400,1363179,1363226,1363229,1363237,1363243,1365011,1365058,1365061,1365069,1365075,1366877,1366880,1366888,1366894,1368686,1368689,1368697,1368703,1370490,1370493,1370501,1370507,1372283,1372286,1372294,1372300,1374063,1374066,1374074,1374080,1375923,1375926,1375934,1375940,1377766,1377769,1377777,1377783,1379595,1379598,1379606,1379612,1381413,1381416,1381424,1381430,1383229,1383232,1383240,1383246,1385039,1385047,1385053,1386851,1386857,1388651,1482946,1482953,1482963,1484302,1484309,1484319,1485646,1485653,1485663,1486981,1486988,1486998,1488305,1488312,1488322,1489611,1489618,1489628,1490906,1490913,1490923,1492192,1492199,1492209,1493506,1493513,1493523,1494811,1494818,1494828,1496108,1496115,1496125,1497403,1497412,1497422,1498706,1498715,1498725,1499999,1500008,1500018,1501282,1501291,1501301,1502558,1502567,1502577,1503826,1503835,1503845,1505087,1505096,1505106,1506340,1506349,1506359,1507587,1507596,1507606,1508824,1508833,1508843,1510052,1510061,1510071,1511274,1511285,1511296,1512499,1512510,1512521,1513727,1513738,1513749,1514948,1514959,1514970,1516171,1516182,1516193,1517386,1517397,1517408,1518592,1518603,1518614,1519795,1519806,1519817,1520991,1521002,1521013,1522181,1522192,1522203,1523364,1523376,1523387,1524539,1524551,1524562,1525707,1525719,1525730,1526868,1526880,1526891,1528023,1528035,1528046,1529172,1529184,1529195,1530317,1530329,1530340,1531458,1531470,1531481,1532597,1532607,1532617,1533729,1533739,1533749,1534857,1534867,1534877,1535981,1535991,1536001,1537100,1537110,1537120,1538213,1538223,1538233,1539350,1539360,1539370,1540480,1540490,1540500,1541605,1541615,1541625,1542724,1542734,1542744,1543835,1543845,1543855,1544940,1544950,1544960,1546038,1546048,1546058,1547123,1547133,1547143,1548196,1548206,1548216,1549259,1549269,1549279,1550313,1550325,1550336,1551361,1551373,1551384,1552400,1552412,1552423,1553441,1553453,1553464,1553579,1553585,1554476,1554488,1554499,1554614,1554620,1555503,1555515,1555526,1555641,1555647,1556521,1556533,1556544,1556659,1556665,1557531,1557543,1557554,1557669,1557675,1558539,1558551,1558562,1558677,1558683,1559537,1559549,1559560,1559675,1559681,1560895,1560907,1560918,1561033,1561039,1562244,1562256,1562267,1562382,1562388,1564087,1564099,1564110,1564225,1564231,1565920,1565932,1565943,1566058,1566064,1567745,1567756,1567768,1567878,1567885,1570669,1570680,1570687,1570803,1570810,1573562,1573573,1573580,1573695,1573703,1576441,1576453,1576464,1576578,1576584,1579313,1579324,1579337,1579448,1579454,1582175,1582187,1582198,1582312,1582318,1585022,1585034,1585045,1585159,1585165,1587860,1587871,1587884,1587994,1588000,1590695,1590707,1590718,1590832,1590838,1593520,1593532,1593543,1593657,1593663,1596377,1596389,1596400,1596514,1596520,1599248,1599260,1599271,1599385,1599391,1602107,1602119,1602131,1602241,1602246,1604956,1604968,1604979,1605093,1605099,1607795,1607806,1607817,1607930,1607934,1610630,1610642,1610653,1610764,1610769,1613455,1613468,1613479,1613589,1613594,1616276,1616287,1616294,1616410,1616417,1619078,1619090,1619101,1619215,1619221,1621871,1621882,1621893,1622004,1622010,1624644,1624656,1624667,1624781,1624787,1627413,1627425,1627436,1627550,1627556,1630171,1630181,1630193,1630304,1630309,1632918,1632928,1632940,1633051,1633056,1635719,1635732,1635742,1635854,1635862,1638546,1638558,1638569,1638683,1638689,1641387,1641399,1641410,1641524,1641530,1644215,1644224,1644236,1644348,1644353,1647029,1647038,1647050,1647161,1647167,1649841,1649854,1649864,1649977,1649982,1652723,1652733,1652846,1652851,1655581,1655592,1655706,1655712,1658440,1658554,1658560,1661277,1661391,1661397,1664214,1664220,1667026,1667032,1669833,1669839,1672692,1672698,1675544,1675550,1678387,1678394,1681224,1681229,1684051,1684059,1686872,1686878,1689725,1689730,1692581,1692587,1695348,1695355,1698108,1698114,1700861,1700867,1703605,1703611,1706343,1706344,1709114,1709115,1711876,1711882,1714660,1714666,1717435,1717441,1720197,1720203,1722944,1722951,1725685,1725691,1728420,1728426,1731146,1731152,1733854,1733860,1736559)) 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





	
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						

							
	
USD ($) 
	

		
EUR (€)
GBP (£)
RUB
AUD ($)
	




	


		 
Log in / Register 
				

					
Sign-in
					
Register
				
			
				

			Wishlist 1
		
				
 Contact us
	









	

		

		

			


		

		
Toll Free 0800 011 2023
US and CanadaUnited KingdomAustraliaBrazilNetherlandsRussiaSweden	
	





	
	
	




	
Day tours
Tours by Region
						
MoscowSaint PetersburgGolden RingLake BaikalMurmanskSiberia & Far EastSochi & Southern RussiaAmsterdamBerlinCopenhagenGdanskGeorgiaHelsinkiKaliningradKamchatkaKareliaKazanKlaipedaNizhny NovgorodNorthern EuropeOsloPermRigaRyazanStockholmTallinnUlan-UdeVeliky NovgorodVilniusVladivostokVolgogradYakutiaYekaterinburg
					
Why Choose our Day Tours
											
Shore Excursions
One Day ToursTwo Days ToursThree Day Tours
Tours
About Russian tours
						
Private vs Group Tours
					
Tours by Region
						
Moscow & St.PeterburgMoscowSaint PetersburgGolden RingLake BaikalTrans-SiberianSiberia & Far EastAltaiKaliningradKamchatkaKareliaKazanPermVeliky NovgorodYakutiaYekaterinburg
					
Tour Types
						
Small Group ToursPrivate TourTheme Tour
					
Theaters
Moscow eventsSt. Petersburg eventsEvents archive
Events by type
							
BalletOperaConcertShowAll types
						
Top theaters
							
Bolshoi theatre - Historic StageBolshoi theatre - Small StageMariinsky TheaterMariinsky Theatre - Mariinsky IIMikhailovsky Theater
						
River Cruises
Direction
						
Moscow - St.PetersburgSt. Petersburg - Moscow
					
Ships
						
MS RostropovichMS Volga DreamMS Anton ChekhovMS General LavrinenkovMS Georgy ChicherinMS Ivan BuninMS Konstantin FedinMS Konstantin KorotkovMS KronshtadtMS Maxim GorkyMS Nikolay ChernyshevskyMS Nizhny NovgorodMS RachmaninoffMS River VictoriaMS Scenic TsarMS Tikhy Don (MS Alexander Borodin)MS Vasiliy KandinskyMS Zosima ShashkovMustai Karim
					
Russian Visa Invitation
Explore
Moscow
						
The KremlinRed SquareGolden RingTverskaya StreetGrand Kremlin Palace (The Kremlin)Christ the SaviorNovodevichiy ConventMoscow SubwayThe Bolshoi TheaterArmoury Chamber (The Kremlin)St. Basil's CathedralThe Pushkin Museum of Fine ArtsYury Gagarin Cosmonauts training center
					
Saint Petersburg
						
Hermitage MuseumPeterhofCatherine's Palace (Tsarskoe Selo)PavlovskSt. Isaac CathedralPeter and Paul FortressNevsky ProspectYusupov PalaceSavior on BloodAmber roomBronze Horseman (Senate square)Hermitage TheatreKazansky CathedralKronstadtPalace SquareSpit of the Vasilievsky Island
					
1/7th of the World
						
Volga RiverSiberiaBaikalKazanSochiSmolenskNizhny NovgorodKaliningradUlyanovskVerkhoturova Island
					
About
uVisitRussia
						
Why travel with UVisitRussiaCustomers' TestimonialsContact detailsCancellations & Changes
					
Russian Travel News
											
Russian travel advice
						
Advices while packingAdvices while travelling
					



	
		


			

				
				

					
Home Theaters Yuri Markelov (Tenor)
			
																
Yuri Markelov (Tenor)
														
				

        

        
About
    


    

        
Biography
Began to study singing in the early 70’s, after serving in the army. To begin with he sang with Krasnodar amateur groups, then he joined the Operetta Theatre. He sang for many years with the Krasnodar Cathedral Choir. He completed his studies at the Kharkov Conservatoire.
In 1983, he was accepted into the Bolshoi Theatre Opera Company’s group of probationers and soon became a Theatre soloist.

Repertoire
Rodrigo (Otello)
Ovlur, Yeroshka (Borodin’s Prince Igor )
Young boy (Rimsky-Korsakov’s The Tsar’s Bride)
First herald, Leshy (Rimsky-Korsakov’s The Snow Maiden)
Haydamak, Interpreter (Prokofiev’s Semyon Kotko)
Missail, Court Boyar, Boyar from Kromy (Boris Godunov)
Nireno (Handel’s Giulio Cesare)
Monsieur Triquet (Eugene Onegin)
Schmidt (Werther)
Drunken сossack (Tchaikovsky’s Mazeppa)
Astrologer, Gvidon (Rimsky-Korsakov’s The Golden Cockerel)
Almerik (Tchaikovsky’s Iolanta)
Chaplitsky, Master of ceremonies (The Queen of Spades)
Lopez, Pablo, Lay brother (Prokofiev’s Betrothal in a Monastery)
Ruiz (Il Trovatore)
Don Curzio (Le Nozze di Figaro)
Bardolfo (Falstaff)
Goro, Official registrar (Madama Butterfly)
Servant to Amelia (Un Ballo in Maschera)
Doctor, Jacob Glock (Prokofiev’s The Fiery Angel)
Emperor Altoum (Turandot)
Second foremen, Shabby Peasant (Shostakovich’s The Lady Macbeth of Mtsensk)
Sleeping car attendant (Desyatnikov’s The Children of Rosenthal)
Abbat, Prince Eugene’s aide-de-camp (Prokofiev’s War and Peace)
First of the well-off people (Rimsky-Korsakov’s The Legend of the Invisible City of Kitezh and of the Maiden Fevronia)
Bakula Bobyl (Rimsky-Korsakov’s The Snow Maiden)
Monostatos (Die Zauberfloete)
Dr. Blind (Die Fledermaus)
Marschallin’s Major-Domo, Faninal’s Major-Domo, an innkeeper (Der Rosenkavalier)
Giuseppe (La Traviata)
A Notary (La sonnambula)

Discography
Took part in the recording of Verstovsky’s Askold’s Grave ( conductor Y. Nikonenko, Melodiya, 1992).
        

    
    

            
			
		


	


	
	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				


				

				
Sign up

			
			

		
		

	
	


 

	

		

			
    	

Home
|
Tours
|
Day tours
|
Rail tours
|
Shore excursions
|
My trip
|
About
	

    

        

		
		
Award-winning
Group Tour Packages

The Best of Two Capitals Private
The Best of Two Capitals Small Group
The Best of Two Capitals Gold
 Russia's Ancient Kingdoms
 Cradle of Russia
        
        

		
Useful Links &
Company Information

 About us
 Explore Moscow
 Explore St. Petersburg
 Read Customer Testimonials
 Advantages of Traveling with Us
        
        

        

                        

                    
US office
3422 Old Capitol Trail Suite 1252, 
Wilmington DE, 19808 USA.
US toll-free: 1-888-845-8877

Russian office
Ligovsky pr. 57, Office 19,
191040, St. Petersburg, Russia
tel: +7-812-309-5339
            
        
    
		
	


	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy
		
	



	
	
Contact us


	

		

	

		

		
First name11111111111111<*/span>
		

		

		

		

		
Last name<*/span>
		

		

		

		

		
Country<*/span>
		

		United StatesUnited KingdomAustraliaAustriaBelgiumBrazilCanadaDenmarkFinlandFranceGermanyGreeceIrelandIsraelItalyJapanMexicoNetherlandsNew ZealandNorwayPortugalRussiaSouth AfricaSouth KoreaSpainSwedenSwitzerlandAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntarcticaArgentinaArmeniaArubaAustraliaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBosnia and Herz.BotswanaBouvet IslandBrazilBrunei DarussalamBulgariaBurkina FASOBurmaBurundiCambodiaCameroonCanadaCanary IslandCape VerdeCayman IslandsChadChileChinaChristmas IslandColombiaComorosCongoCook IslandsCosta RicaCote d'IvoireCroatiaCyprusCzech RepublicDenmarkDjiboutiDominicaDominican RepublicEast TimorEcuadorEgyptEl SalvadorEnglandEquatorial GuineaEritreaEspanaEstoniaEthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaGabonGambiaGeorgiaGermanyGhanaGibraltarGreat BritainGreeceGreenlandGrenadaGuadeloupeGuamGuatemalaGuineaGuinea-BissauGuyanaHaitiHondurasHong KongHungaryIcelandIndiaIndonesiaIrelandIsraelItalyJamaicaJapanJordanKazakhstanKenyaKiribatiKorea (South)Korea, Republic ofKuwaitKyrgyzstanLatviaLebanonLesothoLiberiaLiechtensteinLithuaniaLuxembourgMacauMacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMexicoMoldovaMonacoMongoliaMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNetherlands AntillesNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorthern IrelandNorwayOmanPakistanPalauPanamaPapua New GuineaParaguayPeruPhilippinesPolandPortugalPuerto RicoQatarRomaniaSan MarinoSaudi ArabiaScotlandSenegalSerbiaSeychellesSierra LeoneSingaporeSlovakiaSloveniaSolomon IslandsSouth AfricaSouth KoreaSpainSri LankaSt. HelenaSurinameSwazilandSwedenSwitzerlandTaiwanTajikistanTanzaniaThailandTokelauTunisiaTurkeyTurkmenistanTuvaluU.S.A.UgandaUkraineUkraineUnited Arab EmiratesUruguayUzbekistanVanuatuVaticanVenezuelaVietnamWalesYemenZambiaZimbabwe	
		
		

		

		

		
Phone
		

			
		
		

		


		
Email<*/span>
		

		

		

		
		

			
Message text<*/span>
			

			

			

		
		
  		

			
    			
		  
	
					


		
	



	
	

		

			
Sign In
			
Register
		
	

	

		

			

				

					

					

						

					
					

					

						
Email
						

						

						

					

						
Password
						

						

						

					

						
Keep me signed in
						

						

						

					
			
					
					


							
							

					
					Restore password
                    					
					
				
				

					

						
Sign in with your social account
						

                            

                            

						
                        
Sign in to our website using your Facebook or Google+ account.

					
				
				

			
		

		

			

				

					

						

							

						
	
						

							

							
First name
							

							

							

						

							
Last name
							

							

							

						

							
Phone
							
  
							

							

						

							
Email
							

							

							

						

							
Password
							

							

							

						

							
Verify password
							

							

							

								
						
						

							
							
							

							
						
				
				

					

						
Sign in with your social account
						

                            

                            

						
                        
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!
		
Ask a Travel Expert
	





	

	
has been added to your wishlist
	

		View your wishlist
	
	

		Continue booking
	































	 
































    
Ask a Travel Expert 
        
Leave your phone number
        

            
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.com to 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.

        

                
                
There was a problem with your request
Missing phone. Please correct and try again.

        

        
        

            


                

                    
Dates of trip:
                    
                    
 - 
                
                

                    
Comment (optional):
                    
I'm going to visit Russia and want to have an expert advice to choose the best tour
                
                

                    
E-mail:
                    

                
                

                    
Contact person:
                    

                
                

                    
How many travellers:
                    

                                 1234567891011121314151617181920                    
                
                
                

                    

                    
Send Request to Travel Expert
                
            
        
                

            Tour Theme:

            
Active and Adventure
Historical and Heritage
Family
Nature & Eco
Art & Culture
City (general sightseeing)
Special Interest
            
        
                

        

            
            

                

                    

                        
Phone:
                        

                    
                    

                        

                        
Leave your phone number