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 (8434,8450,10143,10153,11726,11736,13309,13319,14657,14670,14725,14745,14753,14763,16108,16123,16177,16197,16205,16215,16948,16984,17020,17056,17092,17718,17733,17787,17808,17815,17825,19184,19186,19203,19211,19219,20627,20629,20646,20654,22100,22111,22112,22130,22137,23554,23565,23566,23584,23591,25028,25029,25046,25054,26734,26770,26773,26807,26825,27611,27657,27665,27731,27758,29072,29098,29101,29140,29160,30965,30976,30977,30994,31002,32487,32488,32510,32518,32527,34046,37144,37186,37206,37221,38695,38736,38761,38771,40144,40188,40209,40225,41603,41604,41656,41665,41677,42995,43001,43050,43058,43074,44356,44362,44409,44419,44431,45708,45714,45761,45771,45783,47053,47059,47106,47116,47132,48392,48398,48447,48455,48471,49725,49732,49779,49789,49805,51060,51107,51117,51133,52426,52436,52452,53741,53751,53767,55050,55061,55076,56353,56362,56374,56429,56502,57716,57726,57738,57787,57863,59786,59796,59808,59857,59933,61850,61858,61871,61925,61997,63905,63913,63926,63977,64052,65952,65960,65973,66027,66099,67997,68005,68018,68072,68144,70039,70047,70060,70114,70186,72076,72084,72097,72151,72223,74114,74127,74181,74253,76132,76145,76199,76271,78155,78209,78281,80161,80215,80287,82160,82214,82286,84207,84279,86192,86264,88170,88242,90138,90210,92096,92168,94045,94121,95998,96070,97937,98009,99866,99938,101787,101859,103695,103768,105668,107562,107764,108032,108194,109449,109651,109919,110081,110147,111326,111528,111796,111958,112024,113195,113398,113666,113828,113894,115055,115258,115527,115689,115755,116931,117134,117403,117564,117631,118806,119009,119278,119439,119506,120676,120880,121149,121310,121377,122542,122746,123015,123176,123243,124400,124603,124873,125034,125101,126249,126452,126722,126883,126950,128089,128292,128562,128723,128790,129918,130121,130391,130552,130619,131747,131950,132220,132381,132448,133580,133783,134053,134214,134281,135405,135608,135878,136039,136106,137226,137429,137699,137860,137927,139247,139517,139678,139745,141057,141327,141488,141555,142858,143128,143289,143356,144648,144918,145079,145146,146428,146698,146858,146926,148202,148469,148629,148697,149960,150227,150387,150455,151710,151977,152137,152205,153451,153718,153878,153946,155182,155447,155609,155676,156903,157166,157330,157397,158614,158877,159041,159108,160340,160603,160767,160834,162067,162330,162494,162561,163807,164084,164245,164313,165549,165825,165986,166054,167280,167556,167717,167785,169001,169275,169438,169506,170713,170987,171150,171218,172417,172692,172855,172923,174111,174386,174549,174616,175794,176069,176233,176301,177467,177742,177906,177973,179130,179405,179569,179636,180784,181058,181223,181290,182431,182705,182870,182937,184071,184350,184511,184578,185702,185981,186142,186209,187324,187603,187764,187831,188936,189215,189376,189443,190536,190815,190976,191043,192124,192404,192564,192632,193702,193985,194145,194213,196462,196783,196961,197030,197775,198098,198277,198346,198380,198383,198399,198421,198474,199092,199415,199594,199663,199697,199700,199716,199738,199791,200409,200732,200911,200980,201014,201017,201033,201055,201108,202091,202414,202593,202662,202696,202699,202715,202737,202790,203762,204085,204265,204334,204368,204371,204387,204409,204462,205422,205436,205760,205969,206038,206073,206076,206093,206116,206168,207123,207134,207458,207667,207736,207771,207776,207791,207814,207866,208810,208822,209146,209355,209424,209459,209464,209478,209502,209554,210813,211018,211089,211124,211127,211141,211165,211218,212264,212322,212553,212622,212657,212659,212674,212698,212751,213799,213857,214092,214161,214196,214198,214213,214238,214290,215335,215393,215628,215697,215732,215734,215749,215774,215826,216866,216924,217159,217228,217263,217265,217280,217305,217357,218395,218453,218688,218757,218792,218794,218809,218834,218886,219918,219976,220211,220280,220315,220317,220332,220357,220409,221437,221495,221730,221799,221834,221836,221851,221876,221928,222951,223008,223244,223313,223348,223350,223365,223389,223442,224464,224517,224753,224822,224857,224859,224874,224898,224951,225971,226028,226264,226333,226368,226370,226385,226409,226462,227471,227533,227769,227838,227873,227875,227890,227914,227967,228975,229032,229268,229337,229372,229374,229389,229413,229466,230960,231017,231253,231322,231357,231359,231374,231398,231451,232955,233012,233248,233317,233352,233354,233369,233393,233446,234945,235002,235238,235307,235342,235344,235359,235383,235436,236930,236985,237223,237291,237327,237329,237344,237368,237421,238904,238961,239196,239266,239301,239303,239318,239342,239395,240869,240925,241162,241232,241267,241269,241284,241308,241361,242830,242886,243123,243193,243228,243230,243245,243269,243322,244787,244844,245084,245153,245189,245191,245206,245230,245283,246741,246798,247036,247105,247141,247143,247158,247182,247235,248688,248745,248983,249053,249088,249090,249105,249129,249182,250632,250688,250927,250997,251032,251036,251051,251073,251126,252615,252672,252910,252980,253015,253017,253034,253056,253109,254589,254645,254884,254953,254989,254993,255008,255031,255083,256553,256610,256849,256918,256954,256957,256971,256996,257048,258514,258570,258810,258891,258927,258929,258946,258968,259021,260480,260537,260777,260858,260893,260897,260912,260936,260988,262440,262497,262737,262817,262853,262857,262872,262896,262948,264408,264463,264703,264783,264820,264824,264839,264862,264914,266368,266423,266663,266743,266780,266784,266798,266822,266874,268320,268375,268614,268694,268731,268735,268749,268773,268825,270261,270316,270555,270635,270672,270676,270690,270714,270766,272200,272255,272494,272574,272611,272615,272629,272653,272705,274133,274188,274290,274319,274427,274507,274544,274548,274562,274586,274638,276066,276122,276224,276253,276361,276441,276478,276482,276496,276520,276572,277990,278046,278151,278180,278288,278368,278404,278408,278423,278447,278499,279867,279923,280028,280057,280165,280245,280281,280285,280300,280324,280376,281735,281791,281896,281925,282033,282113,282149,282153,282168,282192,282244,283594,283655,283755,283784,283891,283972,284008,284011,284027,284051,284103,285451,285512,285612,285641,285748,285829,285865,285868,285884,285908,285960,287367,287467,287496,287603,287683,287719,287722,287737,287762,287814,289208,289310,289338,289451,289529,289564,289567,289583,289606,289660,291047,291148,291177,291284,291395,291445,291449,291472,291500,291562,292943,293044,293073,293180,293291,293341,293345,293368,293397,293458,294832,294933,294962,295069,295180,295229,295234,295256,295285,295347,296712,296813,296842,296949,297060,297109,297114,297136,297165,297227,298587,298687,298715,298826,298936,298984,298989,299011,299041,299104,300457,300557,300585,300696,300807,300856,300860,300882,300913,300978,302347,302449,302478,302585,302697,302746,302751,302774,302802,302868,304231,304331,304360,304467,304577,304629,304633,304656,304684,304750,306157,306261,306292,306399,306509,306561,306565,306588,306616,306682,308185,308216,308323,308433,308485,308489,308512,308540,308606,310103,310134,310241,310351,310403,310407,310430,310458,310524,312017,312048,312155,312265,312317,312321,312344,312372,312438,313926,313957,314064,314174,314226,314230,314253,314281,314347,315831,315862,315969,316079,316131,316135,316158,316186,316252,317729,317760,317867,317977,318029,318033,318056,318084,318150,319619,319650,319757,319867,319919,319923,319946,319974,320040,321497,321529,321636,321746,321797,321802,321825,321853,321919,323367,323399,323506,323616,323667,323672,323695,323723,323789,325262,325294,325403,325521,325573,325577,325600,325628,325694,327161,327194,327304,327428,327479,327486,327508,327536,327601,329062,329093,329202,329327,329379,329383,329406,329434,329500,330953,330984,331094,331220,331272,331276,331299,331327,331393,332839,332870,332980,333106,333158,333162,333185,333213,333279,334714,334745,334855,334981,335032,335037,335060,335088,335154,336580,336611,336721,336847,336898,336903,336926,336954,337020,338445,338477,338587,338725,338778,338783,338806,338835,338901,340327,340358,340468,340646,340706,340715,340738,340765,340832,342250,342282,342342,342362,342392,342570,342630,342639,342662,342689,342756,344173,344204,344266,344287,344316,344496,344554,344563,344586,344613,344680,346089,346120,346182,346203,346232,346419,346477,346486,346507,346536,346603,347997,348027,348089,348110,348139,348326,348384,348393,348414,348443,348510,349887,349917,349980,350000,350029,350216,350276,350283,350303,350334,350400,351764,351798,351858,351878,351908,352093,352155,352161,352181,352213,352278,353642,353673,353736,353756,353785,353972,354032,354039,354058,354090,354156,355515,355545,355609,355628,355658,355843,355911,355918,355939,355973,356038,357423,357486,357505,357535,357721,357788,357795,357816,357850,357915,359332,359393,359412,359442,359627,359695,359702,359723,359757,359822,361231,361246,361291,361311,361341,361528,361596,361601,361624,361658,361723,363121,363137,363183,363204,363234,363419,363484,363491,363515,363548,363613,365004,365018,365065,365084,365116,365302,365370,365375,365398,365431,365497,366884,366896,366943,366967,366997,367185,367249,367257,367282,367311,367376,368762,368777,368823,368841,368873,369060,369127,369132,369155,369188,369254,370632,370645,370693,370715,370743,370933,370997,371002,371026,371059,371124,372509,372557,372579,372607,372797,372861,372866,372890,372923,372988,374364,374411,374434,374462,374652,374716,374721,374749,374778,374843,376209,376256,376279,376309,376497,376561,376569,376594,376623,376688,378091,378114,378144,378331,378396,378401,378429,378458,378523,379924,379947,379977,380164,380229,380237,380262,380291,380356,381752,381775,381805,381992,382057,382065,382089,382119,382184,383575,383594,383626,383813,383876,383885,383909,383941,384006,385387,385410,385441,385628,385693,385701,385724,385756,385820,387199,387217,387249,387436,387499,387508,387532,387564,387629,389007,389029,389060,389246,389312,389320,389344,389375,389439,390811,390828,390861,391046,391114,391121,391145,391176,391241,392611,392628,392661,392846,392914,392919,392944,392976,393041,394405,394426,394456,394641,394706,394713,394737,394770,394835,396197,396214,396247,396432,396499,396506,396531,396562,396627,397982,397999,398032,398217,398284,398289,398316,398347,398412,399780,399808,399998,400060,400067,400091,400124,400190,401546,401578,401764,401830,401836,401863,401894,401959,403308,403336,403526,403588,403595,403620,403653,403718,405065,405093,405283,405346,405352,405378,405410,405475,406817,406845,407035,407098,407104,407130,407162,407227,408592,408782,408845,408851,408877,408909,408974,410332,410522,410584,410591,410616,410648,410714,412099,412289,412351,412358,412383,412415,412481,413856,414046,414108,414115,414140,414173,414238,415600,415788,415851,415858,415882,415916,415981,417339,417528,417591,417600,417622,417657,417724,419079,419268,419331,419340,419362,419397,419464,421001,421064,421073,421095,421128,421197,422731,422794,422803,422825,422859,422927,424456,424519,424528,424554,424583,424652,426170,426233,426242,426264,426299,426366,427868,427932,427942,427967,427997,428065,429562,429626,429636,429661,429691,429759,431251,431330,431341,431369,431405,431473,432953,433033,433043,433072,433108,433180,434651,434730,434741,434769,434806,434878,436345,436424,436435,436463,436499,436572,438028,438107,438117,438151,438182,438255,439695,439775,439789,439819,439850,439923,441351,441432,441446,441476,441507,441579,442995,443078,443088,443118,443149,443221,444625,444707,444718,444747,444778,444852,446245,446329,446340,446369,446400,446476,447859,447942,447954,447980,448016,448091,449462,449546,449556,449584,449618,449691,451053,451137,451148,451173,451210,451285,452643,452727,452738,452763,452800,452875,454230,454315,454326,454351,454388,454463,455810,455895,455905,455931,455967,456043,457323,457333,457383,457387,457469,457478,457505,457541,457617,458898,458949,458953,459036,459043,459073,459107,459183,460505,460509,460592,460599,460629,460664,460740,462053,462057,462140,462147,462177,462212,462287,463605,463609,463692,463699,463729,463764,463839,465153,465157,465240,465247,465276,465311,465387,466695,466699,466782,466789,466818,466854,466929,468396,468397,468483,468490,468522,468557,468634,470093,470098,470187,470194,470228,470265,470349,471644,471648,471738,471745,471779,471816,471899,473189,473190,473279,473287,473320,473357,473440,474766,474770,474860,474867,474900,474938,475020,476346,476347,476435,476444,476477,476515,476597,477918,477919,477970,478009,478018,478052,478090,478172,479492,479539,479581,479589,479623,479661,479741,481105,481144,481849,481891,481899,482587,482629,482637,483324,483363,483372,484063,484106,484116,484814,484857,484867,485559,485602,485613,486297,486340,486348,487021,487064,487072,487738,487779,487787,488450,488489,488499,489163,489204,489212,489913,489921,490615,490623,491312,491322,491999,492677,492693,493359,493375,494041,494053,494713,494725,495378,495390,496043,496685,497352,497392,497399,497472,497492,497497,497517,498815,498855,498863,498934,498955,498960,498980,500270,500310,500318,500390,500413,500416,500439,501724,501765,501772,501844,501864,501870,501890,503217,503257,503264,503340,503358,503360,503383,504695,504735,504743,504815,504838,504841,504864,506211,506217,506288,506310,506313,506335,507680,507688,507760,507782,507784,507807,509146,509155,509229,509251,509254,509277,510614,510621,510692,510714,510716,510739,512069,512077,512148,512170,512172,512196,513516,513523,513595,513615,513621,513645,514990,514994,515071,515090,515095,515118,516449,516457,516531,516553,516556,516584,517902,517911,517985,518007,518010,518038,519358,519429,519451,519453,519481,520800,520871,520893,520895,520923,522308,522330,522332,522360,523742,523760,523766,523779,523790,523805,525160,525178,525185,525203,525210,525230,526564,526587,526589,526606,526618,526633,527934,527968,527991,527993,528010,528022,528039,529337,529371,529395,529397,529414,529426,529442,530736,530772,530795,530797,530814,530826,530842,532130,532168,532189,532191,532208,532220,532237,533555,533574,533580,533598,533603,533626,534984,535007,535011,535028,535040,535055,536410,536433,536435,536452,536464,536480,537841,537862,537864,537881,537893,537909,539264,539286,539289,539306,539318,539335,540679,540701,540705,540722,540734,540751,542114,542135,542137,542154,542166,542183,543560,543576,543585,543602,543608,543627,545046,545054,545072,545078,545097,546505,546508,546526,546535,546551,547961,547963,547982,547990,548007,549412,549414,549432,549442,549457,549527,550857,550875,550885,550900,550970,552309,552321,552337,552405,553736,553745,553761,553829,555152,555161,555178,555244,556568,556585,556651,557971,557988,558053,559385,559449,560777,560841,562164,562229,563546,563610,564979,566341,567703,569054,570402,571742,573119,574491,575852,577210,578561,579902,581235,583952,584004,585266,585317,586574,586629,587880,587930,589176,589232,590817,590873,592435,592489,594066,594117,595766,595776,595816,597456,597466,597505,599137,599147,599186,600819,600859,602496,602535,604163,604202,605860,607509,609148,610835,612515,614189,615851,617499,638453,638459,639992,639997,641521,641527,643041,643049,644554,644560,646061,646066,647559,647567,649050,649058,650542,650550,652026,652034,653502,653510,654968,654976,656421,656431,656467,657866,657876,657915,659315,659325,659364,660752,660761,660806,662178,662187,662232,663606,663650,665021,665067,666471,667906,669326,670765,672189,673612,675018,676412,693922,694021,695170,695269,696400,696502,697619,697721,698827,698928,700023,700125,701313,702509,703694,704870,706027,707171,708304,709426,710571,711712,712850,713976,715087,716190,717285,718364,732024,732041,732060,732068,733008,733028,733045,733054,733995,734018,734031,734039,734978,735001,735017,735022,735952,735967,735985,735995,736038,736929,736944,736964,736972,737017,737896,737912,737931,737940,737985,738856,738872,738890,738899,738945,739809,739825,739843,739852,739898,741780,741796,741814,741823,741869,743756,743772,743790,743799,743845,745725,745747,745763,745768,745814,747686,747708,747725,747733,747779,749671,749693,749709,749718,749759,751653,751675,751691,751700,751741,753635,753657,753673,753682,753723,756511,756532,756549,756558,756597,759381,759402,759419,759427,759467,762248,762269,762286,762294,762334,765111,765132,765149,765157,765197,767966,767988,768005,768013,768053,770815,770837,770854,770862,770902,773658,773680,773697,773705,773745,776495,776517,776533,776543,776582,779328,779350,779366,779376,779415,782164,782184,782202,782212,782257,784998,785017,785035,785045,785090,787826,787845,787863,787873,787918,790650,790669,790687,790696,790742,793470,793489,793507,793516,793562,796275,796296,796315,796325,796374,799082,799103,799122,799132,799181,801887,801906,801925,801935,801983,804685,804704,804723,804733,804781,807477,807497,807515,807526,807574,810264,810284,810302,810313,810361,813045,813064,813083,813094,813142,815822,815839,815859,815870,815918,818593,818610,818630,818641,818689,821357,821374,821393,821405,821453,824113,824130,824149,824161,824209,826862,826879,826899,826909,826958,829606,829623,829643,829653,829702,832343,832364,832383,832393,832442,835081,835097,835118,835128,835177,837810,837826,837846,837857,837909,840537,840555,840573,840583,840636,843260,843278,843296,843306,843359,846005,846023,846040,846051,846104,848741,848759,848776,848787,848840,851472,851490,851507,851518,851571,854205,854223,854240,854251,854302,856934,856952,856973,856980,857031,859656,859673,859695,859702,859753,862373,862389,862412,862419,862458,862470,865079,865096,865119,865126,865163,865177,867774,867791,867813,867821,867858,867872,870457,870475,870497,870505,870542,870555,873140,873164,873180,873188,873225,873237,875847,875863,875871,875908,875920,878533,878550,878558,878595,878607,881217,881234,881242,881279,881290,883902,883920,883928,883965,883976,886594,886604,886640,886651,889260,889269,889306,889317,891922,891931,891968,891979,894577,894586,894623,894634,897239,897277,897294,899889,899928,899944,902538,902568,902579,902684,905200,905214,905314,907817,907831,907933,910430,910445,910547,910573,913041,913056,913156,913183,915672,915681,915787,915815,918376,918391,918491,918519,921084,921184,921212,923760,923863,923891,926556,926583,929271,929299,931980,932006,934687,934713,937392,937418,940123,940149,942841,942867,945548,945572,948250,948274,950956,950980,953656,953680,956346,956370,959023,959047,961678,961701,964318,964340,966954,966976,969586,969608,972207,972214,972236,974827,974833,974856,977439,977446,977468,980046,980052,980075,982638,982644,982667,985231,985255,985295,987855,987879,987919,990498,990538,993108,993154,995719,995759,998313,998354,1000897,1000938,1003478,1003519,1006053,1006098,1008665,1011222,1013802,1016367,1018914,1021461,1024006,1026540,1029069,1031595,1031615,1031637,1031670,1034117,1034140,1034173,1036609,1036630,1036663,1039098,1039119,1039152,1039303,1039310,1041582,1041603,1041636,1041787,1041794,1044058,1044079,1044112,1044263,1044270,1044308,1046548,1046579,1046730,1046737,1046775,1049005,1049036,1049187,1049197,1049231,1051448,1051480,1051631,1051641,1051680,1053877,1053910,1054061,1054071,1054110,1056304,1056336,1056488,1056498,1056537,1058758,1058910,1058920,1058959,1061167,1061322,1061328,1061366,1063568,1063722,1063729,1063767,1065961,1066116,1066122,1066161,1068343,1068499,1068504,1068542,1070716,1070869,1070874,1070912,1073116,1073269,1073274,1073312,1075509,1075662,1075667,1075704,1078045,1078050,1078087,1080416,1080421,1080457,1082776,1082782,1082817,1085121,1085127,1085162,1087450,1087455,1087491,1089769,1089775,1089810,1092099,1092105,1092140,1094421,1094427,1094462,1096731,1096737,1096772,1099028,1099034,1099074,1101305,1101311,1101351,1103576,1103582,1103622,1105825,1105831,1105872,1108053,1108058,1108099,1110260,1110265,1110306,1112447,1112455,1112493,1114615,1114623,1114660,1116768,1116772,1116814,1118903,1118907,1118948,1121034,1121038,1121080,1123173,1123181,1123219,1125307,1125315,1125349,1127498,1127502,1127539,1129717,1129725,1129765,1131921,1131928,1131969,1134112,1134119,1134160,1136316,1136323,1136364,1138518,1138525,1138563,1140723,1140761,1142914,1142952,1145134,1147304,1149460,1151613,1153766,1155901,1155907,1158074,1158080,1158110,1160239,1160244,1160275,1162395,1162421,1164554,1166683,1168817,1170942,1173059,1175166,1175239,1177379,1179509,1181635,1183750,1185856,1187965,1190068,1192162,1194243,1196320,1198392,1200458,1202512,1204570,1206613,1208644,1553775,1553909,1553920,1554943,1554954,1555966,1555978,1556981,1556988,1557989,1558001,1558994,1559001,1559988,1560000,1561341,1561353,1563032,1563045,1564872,1564879,1566698,1566711,1569338,1569350,1572236,1572246,1575122,1575132,1577999,1578009,1580866,1580877,1583719,1583730,1586559,1586571,1589395,1589407,1592223,1592236,1595046,1595058,1597920,1597932,1600786,1600797,1603639,1603651,1606481,1606493,1609318,1609330,1612149,1612161,1614969,1614982,1617781,1617794,1620594,1623377,1707867,1710639,1713393,1716173,1718943,1721697,1724444,1727183,1729915,1732627,1735331,1738024,1740706,1743372,1746034,1748687,1751330,1753969,1756597,1759214,1761819,1764420,1767016,1769606,1772186,1774759,1777328,1915705,1917918,1920118,1922317,1924503,1926751,1928991,1931220,1933440,1935639,1937835,1940024,1942203,1944374,1946533,1948681,1950817,1952949,1955071,1957147,1959211,1961264,1963301,1965332,1967355,1969372,1971173,1971385,1973185,1973394,1975180,1975392,1977168,1977377,1979137,1979349,1981137,1981345,1983129,1983337,1985112,1985324,1987091,1987299,1989061,1989269,1991015,1991224,1992954,1993166,1994892,1995100,1997029,1998954,2000868,2002771,2004659,2006537,2008419,2010305,2012182,2014049,2015889,2017711,2019526,2021333,2023134,2024926,2026920,2028910,2030889,2032851,2034813,2036765,2038710,2040648,2042574,2044488,2046382,2048275,2050154,2052026,2053894,2055845,2057874,2059907,2061934,2063954,2065964,2067973,2069976,2071969,2112794,2114700,2116603,2118495,2120376,2122246,2124106,2125950,2127790,2129619,2131440,2133251,2135052,2136842,2196900,2197540,2198428,2199065,2199944,2200599,2201464,2202154,2203004,2203695,2204536,2205225,2206058,2206753,2207587,2208280,2209102,2209795,2210605,2211299,2212098,2212840,2213796,2214541,2215484,2216229,2217167,2217912,2218946,2219760,2221184,2221996,2223408,2224222,2226436,2228636,2230826,2233005,2235423,2238044,2240955,2244132,2247299,2250454,2253602,2256744,2259873,2262995,2266106,2269208,2272300,2275412,2278557,2281693,2284845,2287987,2291120,2294243,2297364,2300488,2303617,2306763,2309932,2313096,2316258,2319415,2322566,2325706,2328840,2331956,2335063,2338163,2341261,2344371,2347474,2350576,2353701,2356816,2359919,2363018,2366107,2369183,2372255,2375314,2378358,2381392,2384421,2386999,2387440,2390063,2390505,2393124,2393565,2396175,2396617,2399211,2399653,2402233,2402672,2405243,2405686,2408255,2408697,2411258,2411699,2414249,2414689,2417231,2417713,2420239,2420721,2423231,2423714,2426221,2426705,2429205,2429688,2432176,2432660,2435140,2435623,2438091,2438575,2441027,2441513,2443955,2444441,2446878,2446938,2447365,2449795,2449850,2450281,2452702,2452757,2453186,2455589,2455644,2456075,2458470,2458525,2458962,2461398,2461833,2464251,2464689,2467103,2467560,2469976,2470472,2472911,2473389,2475819,2476338,2478758,2479275,2481682,2482199,2484592,2485109,2487498,2488015,2490439,2490953,2493882,2496802,2499713,2502606,2505486,2508354,2511216,2514076,2516930,2519779,2522619,2525444,2528259,2531069,2533874,2536671,2539469,2542262,2545041,2547806,2550277,2550612,2553077,2553412,2555866,2556229,2558673,2559037,2561473,2561834,2564256,2564617,2567025,2567387,2569828,2570222,2572657,2573052,2575476,2575871,2578285,2578680,2581094,2581489,2583884,2584279,2586661,2587053,2589428,2589823,2592194,2592586,2594945,2595341,2597694,2598086,2600430,2600825,2603152,2603548,2605864,2606257,2608569,2608962,2611268,2611660,2613995,2614388,2616714,2617110,2619427,2619824,2622132,2622525,2624817,2625210,2627498,2627894,2630172,2630565,2632834,2633232,2635884,2638527,2641158,2643774,2646383,2648980,2651566,2654142,2656706,2659253,2661779,2664288,2666786,2669260,2671713,2674159,2676580,2678743,2678744,2678985,2681125,2681126,2681368,2683496,2683497,2683741,2685863,2685864,2686105,2688220,2688221,2688465,2690571,2690572,2690816,2692909,2692910,2693152,2695231,2695232,2695474,2697880,2697884,2698217,2700954,2700958,2701291,2704036,2704040,2704373,2707108,2707112,2707445,2710226,2710489,2713269,2713527,2716293,2716550,2719358,2719620,2722432,2722722,2725531,2725824,2728620,2728913,2731705,2731772,2732002,2734816,2734883,2735112,2737907,2737974,2738203,2740989,2741056,2741285,2744061,2744128,2744357,2747179,2747408,2750209,2750438,2753236,2753465,2756260,2756493,2759273,2759506,2762288,2762521,2765297,2765530,2768287,2768520,2771261,2771494,2774231,2774464,2777423,2780407,2783432,2786459,2786513,2789538,2789592,2792597,2792651,2795653,2795707,2798722,2798776,2801781,2801835,2804831,2804885,2807798,2807852,2810742,2810796,2813666,2813720,2816582,2816636,2819563,2819617,2822533,2822587,2825515,2825569,2828484,2828538,2831435,2831489,2834365,2834419,2837288,2837342,2840215,2840270,2843132,2843187,2844571,2844626,2845999,2846054,2847418,2847473,2848881,2851735,2853155,2854568,2855978,2857381,2858777,2860164,2861540,2864316,2864328,2867093,2867105,2868478,2869857,3029386,3029397,3030813,3030824,3032226,3032237,3033632,3033643,3035225,3035234,3036816,3038385,3056727,3058183,3059633,3061076,3062813,3064545,3064583,3066268,3066305,3067974,3068013,3069671,3069714,3071362,3071400,3073040,3073080,3074711,3074750,3076367,3076406,3078023,3078061,3079682,3079721,3081329,3081369,3082969,3083007,3084635,3086291,3087931,3088204,3088227,3088240,3089565,3089836,3089861,3089868,3091188,3091461,3091485,3091492,3092796,3093069,3093096,3093105,3094399,3094672,3094697,3094703,3096265,3096290,3096297,3097848,3097874,3097886,3099424,3099448,3099459,3100995,3101021,3101030,3102555,3102578,3102592,3104099,3104124,3104137,3105638,3105662,3105670,3107191,3107214,3107222,3108732,3108757,3108767,3110300,3110326,3110336,3111860,3111883,3111892,3113407,3113431,3113443,3114942,3114964,3114977,3116460,3116486,3116498,3117977,3117999,3118014,3119485,3119509,3119519,3120989,3121014,3121024,3122356,3122518,3122542,3122555,3124052,3124215,3124238,3124249,3125741,3125901,3125927,3125935,3127414,3127577,3127601,3127609,3129079,3129240,3129265,3129273,3130734,3130896,3130921,3130929,3132381,3132543,3132568,3132576,3134183,3134208,3134216,3135823,3135848,3135856,3137456,3137481,3137489,3139077,3139102,3139110,3140689,3140714,3140722,3142293,3142318,3142326,3143887,3143912,3143920,3145477,3145502,3145510,3147057,3147082,3147090,3147693,3147718,3147726,3148323,3148348,3148356,3148947,3148972,3148980,3149571,3149596,3149604,3151118,3151143,3151151,3152657,3152682,3152690,3154190,3154215,3154223,3155713,3155738,3155746,3157229,3157254,3157262,3158736,3158761,3158769,3160230,3160255,3160263,3161715,3161740,3161748,3163192,3163217,3163225,3164664,3164689,3164697,3166127,3166152,3166160,3167588,3167605,3167612,3168982,3168999,3169006,3170367,3170384,3170391,3171744,3171761,3171768,3173115,3173132,3173139,3174480,3174497,3174504,3175880,3175897,3175904,3177278,3177295,3177302,3178669,3178686,3178693,3180141,3180158,3180165,3181609,3181626,3181633,3183075,3183092,3183099,3184538,3184555,3184562,3185999,3186016,3186023,3187456,3187473,3187480,3188907,3188924,3188931,3190352,3190367,3190375,3191792,3191808,3191816,3193227,3193245,3193253,3194919,3194936,3194947,3196704,3196721,3196732,3198695,3198704,3200663,3200676,3202361,3202370,3204054,3204064,3205746,3205756,3207432,3207442,3209112,3209124,3210786,3210795,3212512,3214215,3376534,3378839,3381136,3383401,3385686,3387954,3390218,3392470,3394703,3396927,3399145,3401348,3403532,3405718,3407880,3410049,3412192,3414357,3416510,3418650,3420768,3422869,3424957)) 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





	Dmitry Voropaev (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Dmitry Voropaev (Tenor)

Dmitry Voropaev (Tenor)

Prize-winner at the International Rimsky-Korsakov Young Opera Singers? Competition (St Petersburg, 2000).
Prize-winner at the International Mirjam Helin Singers? Competition (Finland, 2004).
Prize-winner at the International PlЁ?cido Domingo Operalia Vocal Competition (2004).

Born in Baku.
Graduated from the Choral School of the St Petersburg Academic Glinka Capella with distinction in 1998.
Graduated from the conducting and choral faculty of the St Petersburg State Rimsky-Korsakov Conservatoire with distinction in 2003.

Soloist with the Mariinsky Academy of Young Singers since 2000. Made his Mariinsky Theatre debut the same year as Count Almaviva in Rossini?s Il barbiere di Siviglia.

Repertoire includes:
Simpleton (Boris Godunov);
Lensky (Eugene Onegin);
Indian Merchant (Sadko);
Guidon (The Tale of Tsar Saltan);
Ivan Lykov (The Tsar?s Bride);
Fisherman (The Nightingale);
Count Almaviva (Il barbiere di Siviglia);
Belfiore (Il viaggio a Reims);
Ferrando (Cosi fan tutte);
Don Ottavio (Don Giovanni);
Domizio (Cleopatra);
Nemorino (L?elisir d?amore);
Sailor (Tristan und Isolde)
and the First Jew (Salome).

At concerts of the Academy of Young Singers his repertoire includes: Mozart?s Requiem, Mahler?s Lied von der Erde, Beethoven?s Christus am Olberge and Ninth Symphony, Bach?s Coffee Cantata, Magnificat and Christmas Oratorio, Schubert?s Stabat Mater and Mass in G minor, Handel?s Messiah, Liszt?s Faust Symphony and Stravinsky?s Pulcinella.

Has taken part in the Music Festival in Aix-en-Provence and has performed at the opera house in Graz (Austria), the Theatre du Chatelet (Paris), the Opera National in Bordeaux, Wigmore Hall (London) and the Concertgebouw in Bruges (Belgium).

Has worked with such conductors as Valery Gergiev, Pierre Boulez, Eri Klas, Alexander Titov, Alexander Dmitriev and Gianandrea Noseda.

He has participated in Academy concerts at the Mariinsky Theatre and abroad.