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 (14707,14774,16157,16226,17767,17836,19169,19229,20615,20670,22154,23608,25071,26862,27848,29199,31019,32537,34057,35549,35578,35583,37119,37124,37231,38671,38676,38780,40227,56528,57887,59957,62024,64079,66126,68172,70214,72251,74281,76299,78309,80315,82313,84306,86291,88269,90237,92195,94148,96097,98036,99965,101886,103795,105695,107589,107712,107766,108198,109475,109599,109654,110085,111352,111476,111531,111962,113221,113346,113401,113832,115082,115207,115262,115693,116958,117083,117138,117569,118832,118958,119013,119443,120705,120829,120884,121314,122570,122695,122750,123179,124428,124553,124608,125037,126277,126402,126456,126886,128117,128242,128296,128726,129946,130072,130125,130555,131775,131901,131954,132384,133608,133734,133787,134217,135433,135559,135612,136042,137254,137380,137433,137863,139071,139198,139251,139681,140881,141008,141061,141491,142682,142809,142862,143292,144472,144598,144655,145082,146252,146378,146435,146862,148023,148149,148206,148632,149906,149964,150390,151660,151714,152140,153401,153455,153881,155132,155186,155612,156853,156907,157336,158564,158618,159047,160290,160344,160773,162017,162071,162500,163742,163813,164248,165484,165555,165989,167215,167286,167720,168941,169007,169441,170653,170719,171156,172357,172423,172861,174051,174117,174555,175735,175801,176238,177408,177474,177911,179071,179136,179574,180724,180790,181228,182371,182437,182875,184011,184077,184516,185642,185708,186147,187264,187330,187769,188876,188942,189381,190476,190542,190981,192130,192570,193708,194151,196469,196966,197781,198282,198388,199098,199599,199705,200415,200916,201022,202097,202598,202704,203769,204270,204375,205442,205975,206082,207140,207673,207779,208828,209361,209467,211024,211131,212204,212284,212340,212555,212665,213740,213819,213875,214094,214204,215276,215355,215411,215630,215740,216807,216886,216942,217161,217271,218335,218415,218471,218690,218800,219858,219938,219994,220213,220323,221377,221456,221513,221732,221842,222891,222970,223027,223246,223356,224400,224479,224536,224755,224865,225906,225989,226047,226266,226376,227411,227494,227552,227771,227881,228910,228993,229051,229270,229380,230895,230978,231036,231255,231365,232890,232973,233031,233250,233360,234880,234963,235021,235240,235350,236869,236948,237006,237225,237335,238840,238922,238980,239199,239309,240810,240888,240946,241165,241275,242771,242849,242907,243126,243236,244728,244806,244864,245087,245197,246682,246760,246818,247039,247149,248629,248707,248765,248986,249096,250572,250651,250712,250933,251040,252556,252634,252692,252913,253023,254529,254612,254669,254890,254997,256494,256576,256634,256855,256961,258454,258533,258591,258813,258935,260421,260503,260561,260783,260901,262463,262521,262743,262861,264430,264487,264709,264828,266390,266447,266669,266788,268342,268399,268620,268739,270283,270340,270561,270680,272222,272279,272500,272619,274155,274212,274286,274302,274433,274552,276089,276146,276220,276236,276367,276486,278014,278071,278147,278163,278294,278413,279891,279948,280024,280040,280171,280290,281758,281816,281892,281908,282039,282157,283617,283675,283751,283767,283898,284016,285474,285532,285608,285624,285754,285873,287328,287387,287463,287479,287609,287727,289171,289229,289307,289322,289454,289572,291009,291067,291144,291160,291291,291456,292905,292962,293040,293056,293187,293352,294851,294929,294945,295076,295241,296731,296809,296825,296956,297121,298606,298684,298699,298829,299000,300477,300554,300569,300699,300871,302367,302445,302461,302592,302758,304249,304327,304343,304473,304642,306175,306256,306273,306405,306574,308099,308180,308197,308329,308498,310017,310098,310115,310247,310416,311931,312012,312029,312161,312330,313840,313921,313938,314070,314239,315745,315826,315843,315975,316143,317724,317741,317873,318040,319613,319631,319763,319930,321492,321510,321642,321809,323362,323381,323513,323679,325257,325275,325409,325584,327159,327176,327310,327494,329057,329074,329209,329390,330948,330965,331101,331283,332834,332851,332987,333169,334709,334727,334862,335044,336574,336593,336728,336910,338440,338457,338592,338790,340321,340338,340472,340723,342245,342262,342306,342355,342396,342647,344169,344189,344230,344278,344320,344571,346085,346105,346146,346195,346236,346494,347993,348012,348053,348102,348143,348401,349882,349902,349943,349992,350033,350290,351763,351778,351820,351868,351911,352167,353638,353658,353699,353747,353788,354046,355528,355571,355619,355661,355925,357405,357448,357495,357538,357802,359312,359355,359402,359445,359709,361212,361254,361301,361344,361610,363146,363195,363237,363499,365028,365075,365119,365385,366909,366953,367001,367265,368785,368832,368876,369139,370654,370703,370746,371013,372519,372566,372610,372877,374373,374421,374465,374732,376221,376266,376313,376577,378056,378100,378148,378412,379889,379933,379981,380245,381717,381761,381809,382073,383583,383630,383893,385400,385445,385708,387206,387253,387516,389020,389064,389326,390819,390864,391126,392618,392664,392926,394417,394459,394721,396206,396250,396515,397991,398035,398298,399767,399811,400075,401537,401581,401844,403339,403603,405096,405360,406848,407112,408595,408859,410335,410599,412102,412366,413859,414123,415602,415866,417341,417606,419081,419346,420814,421079,422809,424537,426251,427948,429642,431351,433053,434751,436449,438130,439798,441455,443096,444726,446348,447961,449563,451155,452745,454333,455917,457353,457491,458920,459056,460476,460611,462024,462159,463576,463711,465123,465259,466665,466801,468504,470208,471759,473301,474881,476458,477965,478033,479537,479606,481100,481847,482585,483319,484062,484812,485558,486295,487019,487734,488444,497330,497366,498794,498830,500286,501712,501740,503232,504711,506182,507655,509114,509123,510586,512041,523831,525250,526658,528062,529466,530866,532259,533647,535081,536505,537934,539359,540775,542207,543649,545119,546573,548029,549483,550926,552362,553786,555202,556609,558011,559408,560801,562187,563569,564939,566302,567661,569012,570362,614263,615927,617576,619210,620842,622464,624078,625703,627320,628925,630521,632110,633694,635267,636828,638383,639921,641451,642970,644522,646028,647524,649015,650510,651991,653467,732028,732042,733013,733029,733999,734012,734981,734995,735954,735968,736051,736931,736945,737029,737899,737913,737997,738859,738873,738957,739812,739826,739910,741783,741797,741881,743759,743773,743857,745728,745741,745826,747693,747709,747785,749677,749687,749771,751659,751669,751753,753641,753651,753735,756517,756533,756610,759387,759403,759480,762254,762270,762347,765117,765133,765209,767973,767989,768065,770822,770838,770914,773664,773681,773757,776501,776518,776594,779334,779351,779427,782170,782185,782263,785003,785018,785096,787831,787846,787924,790655,790670,790748,793475,793490,793568,796281,796297,796384,799088,799104,799191,801891,801907,801994,804689,804705,804792,807481,807498,807585,810268,810285,810372,813049,813065,813153,815825,815840,815929,818596,818611,818700,821360,821375,821464,824116,824131,824220,826865,826880,826969,829609,829624,829713,832349,832365,832449,835084,835100,835188,837813,837829,837920,840540,840556,840647,843262,843279,843370,846007,846024,846115,848743,848760,848851,851474,851491,851582,854207,854224,854315,856936,856953,857044,859658,859674,859766,862375,862390,862483,865082,865097,865190,867776,867792,867885,870460,870476,870569,873143,873158,873252,875826,875841,875934,878527,878621,881211,881305,883904,883991,886666,889331,891993,894649,897303,899952,902593,902641,902660,905221,905269,905292,907838,907885,907909,910452,910499,910523,913064,913110,913134,915696,915742,915765,918399,918445,918469,921092,921138,921162,923772,923817,923841,926465,926513,926532,929179,929230,929249,931888,931939,931958,934646,934665,937351,937370,940082,940101,942800,942819,945505,945524,948207,948226,950913,950932,953612,953632,956302,956322,958979,958999,961653,964293,966929,969561,972189,1031674,1031709,1034178,1034212,1036668,1036702,1039157,1039191,1041641,1041674,1044117,1044150,1046584,1046617,1049041,1049074,1051485,1051518,1053915,1053948,1056342,1056375,1058764,1058797,1061173,1061205,1063574,1063605,1065967,1065999,1068348,1068385,1070718,1070755,1073118,1073155,1075511,1075547,1077894,1077930,1080301,1082660,1085005,1087333,1089653,1091983,1494042,1495343,1496638,1497931,1499229,1500514,1501793,1503067,1504333,1505589,1506838,1508080,1509313,1510537,1511766,1512989,1514214,1515441,1516661,1517870,1519072,1520271,1521465,1522652,1523831,1525003,1526168,1527326,1528478,1529625,1530768,1531907,1533041,1534171,1535297,1536418,1537534,1538674,1539807,1540933,1542055,1543173,1544280,1545382,1546474,1547554,1548622,1549683,1550735,1551779,1552824,1553866,1554900,1555919,1556932,1557942,1558946,1559942,1561295,1562985,1564825,1566652,1569287,1572189,1575076,1577953,1580821,1583674,1586513,1589349,1915682,1917894,1920093,1922292,1924482,1926730,1928971,1931200,1933414,1935613,1937809,1939997,1942175,1944346,1946506,1948655,1950790,1952922,1955049,1957125,1959189,1961239,1963276,1965304,1967329,1969344,1971359,1973365,1975366,1977348,1979323,1981317,1983309,1985298,1987272,1989241,1991200,1993140,1995075,1997004,1998928,2000842,2002745,2004634,2006511,2008394,2010279,2012156,2014024,2015864,2017687,2019501,2021308,2023109,2024898,2026895,2028885,2030864,2032828,2034788,2036742,2038687,2040625,2042551,2044463,2046358,2048250,2050130,2052003,2053869,2055820,2057855,2059888,2061915,2063935,2067971,2069975,2071968,2112760,2114665,2116561,2118457,2120338,2122207,2124067,3030838,3032253,3033662,3035251,3036833,3038402,3039962,3041512,3043056,3177678,3177723,3179071,3179130,3180543,3180602,3182011,3182070,3183473,3183521,3184938,3184986,3186399,3186447,3187856,3187904,3189307,3189355,3190752,3190799,3192193,3192240,3193657,3193740,3195348,3195431,3197133,3197216,3199107,3199190,3201049,3201095,3202746,3202793,3204440,3204487,3206129,3206176,3207816,3207864,3209496,3209544,3210919,3211170,3211216,3212637,3212889,3212935,3214340,3214592,3214640,3216033,3216289,3216336,3217729,3217983,3218030,3219415,3219671,3219717,3221097,3221350,3221397,3222763,3223023,3223071,3224428,3224687,3224738,3226056,3226317,3226367,3227671,3227933,3227983,3229289,3229550,3229600,3230913,3231173,3231223,3232529,3232789,3232838,3234138,3234397,3234447,3235735,3235996,3236046,3237320,3237580,3237630,3238890,3239151,3239201,3240458,3240718,3240768,3242060,3242321,3242370,3243656,3243911,3243962,3245235,3245493,3245544,3246837,3247096,3247145,3248424,3248682,3248731,3249996,3250251,3250302,3251558,3251816,3251866,3253118,3253420,3253469,3254718,3255076,3255187,3256730,3257086,3257197,3258740,3259096,3259208,3260736,3261095,3261205,3262721,3263075,3263188,3264701,3265057,3265168,3266678,3267048,3267161,3268661,3268790,3269032,3269190,3270713,3270835,3271122,3271280,3272966,3273250,3273405,3275075,3275359,3275516,3277168,3277453,3277608,3279255,3279543,3279697,3281393,3281678,3281834,3283518,3283805,3283959,3285640,3285926,3286083,3287792,3288074,3288232,3289924,3290210,3290363,3292038,3292325,3292479,3294146,3294431,3294586,3296247,3296529,3296687,3298336,3298623,3298778,3300421,3300707,3300863,3302496,3302785,3302940,3304558,3304846,3305004,3306611,3306895,3307053,3308657,3308941,3309099,3310697,3310982,3311140,3312733,3313013,3313165,3314751,3314851,3315033,3315184,3316759,3316862,3317044,3317198,3318760,3318864,3319045,3319199,3320751,3320850,3321033,3321187,3322735,3322835,3323016,3323171,3324881,3324983,3325163,3325317,3327148,3327253,3327436,3327590,3329541,3329640,3329824,3329975,3331919,3332021,3332203,3332358,3334285,3334386,3334569,3334725,3336635,3336739,3336922,3337076,3338985,3339089,3339271,3339424,3341327,3341432,3341614,3341769,3343666,3343769,3343950,3344104,3346026,3346124,3346307,3346463,3348374,3348476,3348661,3348813,3350814,3350996,3351152,3353136,3353319,3353472,3355457,3355639,3355792,3357787,3357973,3358143,3360131,3360316,3360498,3362493,3362679,3362857,3364846,3365032,3365214,3367188,3367372,3367554,3369518,3369704,3369883,3371841,3372028,3372209,3374161,3374345,3374527,3376471,3376659,3376836,3378779,3378963,3379145,3381074,3381238,3381260,3381441,3383345,3383508,3383530,3383711,3385630,3385794,3385814,3385995,3387898,3388061,3388083,3388263,3390158,3390209,3390238,3390322,3390326,3390344,3390523,3392407,3392463,3392490,3392573,3392575,3392594,3392775,3394646,3394700,3394727,3394809,3394813,3394830,3395011,3396867,3396923,3396949,3397033,3397035,3397053,3397231,3399082,3399135,3399162,3399248,3399249,3399268,3399449,3401283,3401333,3401364,3401448,3401452,3401471,3401649,3403475,3403526,3403556,3403639,3403644,3403660,3403842,3405708,3405735,3405821,3405823,3405840,3406022,3407872,3407905,3407989,3407993,3408008,3408205,3410038,3410069,3410154,3410155,3410175,3410369,3412188,3412213,3412296,3412300,3412318,3412511,3414351,3414380,3414465,3414470,3414485,3414683,3416497,3416528,3416612,3416616,3416634,3416829,3418638,3418669,3418753,3418757,3418776,3418970,3420766,3420791,3420873,3420878,3420896,3421090,3422861,3422894,3422977,3422980,3422997,3423192,3424975,3425057,3425060,3425080,3425274,3427034,3427117,3427121,3427138,3427332,3429075,3429159,3429164,3429182,3429377,3431100,3431184,3431190,3431207,3431401,3433112,3433193,3433198,3433215,3433413,3435197,3435202,3435220,3435416,3437195,3437197,3437217,3437410,3439173,3439177,3439195,3439392,3441141,3441144,3441161,3441358,3443105,3443109,3443126,3443318,3445080,3445082,3445100,3445295,3447234,3447237,3447255,3447447,3449382,3449385,3449401,3449592,3451521,3451525,3451539,3451734,3453652,3453655,3453672,3453867,3455769,3455773,3455791,3455986,3457897,3457901,3457917,3458111,3460017,3460024,3460039,3460124,3460235,3462156,3462157,3462176,3462262,3462370,3464279,3464285,3464302,3464386,3464499,3466430,3466434,3466451,3466538,3466648,3468612,3468614,3468632,3468716,3468828,3470777,3470780,3470799,3470885,3470995,3472933,3472937,3472955,3473041,3473150,3475088,3475092,3475111,3475196,3475304,3477241,3477247,3477266,3477348,3477458,3479389,3479393,3479409,3479494,3479606,3481532,3481547,3481633,3481740,3483679,3483766,3483872,3485803,3485888,3485991,3487915,3487997,3488102,3490023,3490105,3490212,3492235,3492341,3494356,3494461,3496472,3496578,3498625,3498730,3500770,3500874,3502904,3503010,3505036,3505141,3507160,3507268,3509282,3509387,3511396,3511501,3513502,3513607,3515599,3515706,3517687,3517795,3519775,3519878,3521853,3521957,3523922,3524028,3525984,3526089,3528035,3528141,3530096,3530202,3532141,3532247,3534180,3534287,3534292,3536219,3536325,3536333,3538250,3538353,3538365,3540378,3540384,3542447,3542455,3544503,3544511,3546547,3546554,3548583,3548590,3550613,3550625,3552654,3552663,3554691,3554696,3556728,3556738,3558753,3558764,3560767,3560776,3562770,3562779,3564770,3564780,3566789,3566797,3568800,3568808,3570821,3570830,3572830,3572837,3574841,3574852,3576748,3576759,3578653,3578661,3580551,3580560,3582442,3582447,3584300,3584309,3586158,3586165,3588011,3588018,3589865,3589870,3591711,3591720,3593557,3593566,3595516,3596101,3597508,3598093,3600070,3602029,3603977,3605915,3607841,3609759,3611668,3613568,3615490,3617404,3619312,3621213,3623112,3625004,3626883,3628751,3630612,3632471,3634324,3636167,3638003,3639827,3641637,3643439,3645234,3647021,3648800,3650572,3652330,3654077,3655817,3657549,3659270,3660989,3662717,3664431,3666134,3667829,3669518,3671198,3672869,3674536,3676191,3677834,3679471,3681107,3682737,3684361,3685982,3687590,3689189,3690786,3692378,3693961,3695535,3697104,3698661,3700202,3701742,3703276,3704800,3706319,3707830,3709325,3710813,3712295,3713772,3715242,3716708,3718168,3719622,3721070,3722513,3723947,3725376,3726800,3728218,3729628,3731028,3732421,3733807,3735183,3736552,3737916,3739268,3740611,3741951,3743279,3744601,3745916,3747226,3748526,3749815,3751097,3752373,3753638,3754898,3756153,3757409,3758654,3759894,3761125,3762350,3763573,3764790,3766000,3767202,3768396,3769583,3769977,3770365,3770750,3771133,3771513,3771891,3772267,3772638,3773008,3773374,3773741,3774110,3774475,3774838,3775199,3775558,3775915,3776268,3776616,3776968,3777317,3777662,3778002,3778337,3778667,3778992,3779322,3779648,3779969,3780285,3780600,3780911,3781216,3781516,3781813,3782105,3782393,3782676,3782961,3783243,3783522,3783798,3784070,3784341,3784607,3784869,3785127,3785382,3785634,3785968,3786299,3786649,3786995,3787337,3787676,3788011,3788344,3788673,3788999,3789322,3789640,3789956,3790269,3790580,3790887,3791191,3791492,3791789,3792084,3792376,3792665,3792952,3793235,3793514,3793789,3794062,3794331,3827418,3827759,3828093,3828428,3828752,3829079,3829402,3829717,3830031,3830344,3830647,3836771,3837030,3837287,3837544,3837797,3838053,3838310,3838562,3838816,3839069,3839319,3839567,3839811,3840053,3840291,3840546,3840829,3841108,3841383,3841655,3841922,3842184,3842444,3842711,3842976,3843239,3843497,3843751,3844002,3844259,3844514,3849337,3849571,3849803,3850033,3850261,3850487,3850711,3850933,3851150,3851364,3851575,3851783,3851989,3852193,3852397,3852989,3853580,3854169,3854754,3860821,3861618,3862408,3863200,3863987,3864769,3865549,3866326,3867105,3867874,3868645,3869412,3870179,3870942,3871701,3873187,3873943,3874698,3875445,3876197,3876943,3877685,3878430,3879168,3879912,3880653,3881396,3882141,3882879,3883620,3884364,3885100,3885835,3886574,3887306,3888040,3888769,3889501,3890226,3890948,3891670,3892384,3893102,3893815,3894532,3895251,3922363,3923042,3923720,3924395,3925063,3925727,3926390,3926423,3926435,3927053,3927086,3927099,3927713,3927746,3927757,3928403,3928418,3929057,3929072,3929712,3929726,3930359,3930374,3931006,3931021,3931651,3931666,3932295,3932309,3932936,3932950,3933579,3933593,3934220,3934232,3934857,3934870,3935493,3935506,3936141,3936796,3937447,3938099,3953335,3953952,3954565,3955173,3955780,3956382,3957005,3957628,3958246,3963666,3964239,3964810,3965378,3965961,3969984,3970015,3970556,3970587,3971123,3971155,3971693,3971721,3972255,3972279,3972841,3973394,3973946,3974502,3975060,3975676,3975692,3976282,3976303,3976890,3976908,3977504,3978103,3978695,3979288,3979873,3980459,3983391,3983962,3984530,3985095,3985654,3986215,3986770,3987320,3987867,3988409,3988948,3989480,3990011,4035097,4035457,4036360,4037256,4038175,4039090,4051521,4051530,4052398,4052407,4053275,4053282,4054145,4054157,4055016,4055025,4055879,4055888,4056745,4056754,4057601,4057613,4058458,4058467,4059307,4059318,4060159,4060165,4061004,4061012,4061852,4062687,4125919,4126608,4127290)) 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





	Alexander Timchenko (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Alexander Timchenko (Tenor)

Alexander Timchenko (Tenor)

Born in St Petersburg. Graduated from the St Petersburg Choral College (1993) and from the St Petersburg State Rimsky-Korsakov Conservatoire (choral conducting faculty, 1999, and vocal faculty, 2002).
Soloist with the Mariinsky Academy of Young Singers since 2001.
Made his Mariinsky Theatre debut in 2002 in the roles of Lensky (Eugeny Onegin).
Mariinsky Theatre soloist since 2005.
Born in St Petersburg. Graduated from the St Petersburg Choral College (1993) and from the St Petersburg State Rimsky-Korsakov Conservatoire (choral conducting faculty, 1999, and vocal faculty, 2002).
Soloist with the Mariinsky Academy of Young Singers since 2001.
Made his Mariinsky Theatre debut in 2002 in the roles of Lensky (Eugeny Onegin).
Mariinsky Theatre soloist since 2005.

Repertoire includes:
Lensky (Eugene Onegin),
Vaudemont (Iolanta),
Lykov (The Tsar?s Bride),
Duke (Rigoletto),
Alfredo (La traviata),
Gonzalve (L?heur espagnole).
Has toured with the Mariinsky Opera Company to Austria, Holland, Finland, Japan and France.

© State Academic Mariinkiy Opera and Ballet theatre