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 (736071,737051,738019,738979,739932,741903,743878,745846,747803,749791,751773,753755,756631,759500,762367,765230,768085,770933,773775,776612,779445,782281,785114,787942,790766,793586,796399,799206,802016,804814,807607,810394,813174,815949,818720,821484,824240,826989,829733,832468,835208,837940,840667,843390,846135,848871,851602,854335,857064,859786,862503,865210,867905,870589,873272,875955,878642,881326,884012,886685,889350,892012,894668,897321,899971,902614,905241,907857,910471,913085,915716,918419,921112,923794,926488,929202,931907,934616,937321,940052,942770,1317590,1319513,1321428,1323331,1325228,1327104,1328964,1330825,1332707,1334576,1336441,1338293,1340128,1341951,1343763,1345571,1347375,1349167,1350952,1352849,1354735,1494059,1495360,1496651,1497944,1499242,1500529,1501808,1503080,1504344,1505602,1506851,1508093,1509325,1510550,1511779,1513002,1514227,1515454,1516673,1517883,1519085,1520288,1521478,1522665,1523844,1525016,1526184,1527339,1528491,1529638,1530781,1531920,1533054,1534186,1535310,1536431,1537547,1538687,1539820,1540948,1542070,1543186,1544293,1545395,1546487,1547567,1548635,1549693,1550745,1551789,1552834,1553876,1554910,1555932,1556944,1557955,1558957,1559954,1561307,1562999,1564836,1566666,1569303,1572200,1575088,1577965,1580833,1583686,1586526,1589362,1592190,1595012,1597886,1915732,1917944,1920145,1922343,1924532,1926780,1929022,1931251,1933465,1935664,1937860,1940049,1942228,1944399,1946560,1948708,1950843,1952974,1955102,1957178,1959242,1961290,1963328,1965356,1967377,1969395,1971148,1971407,1973157,1973417,1975155,1975414,1977140,1977400,1979112,1979371,1981113,1981369,1983105,1983361,1985087,1985346,1987324,1989294,1991252,1993188,1995129,1997057,1998976,2000890,2002793,2004684,2006559,2008446,2010331,2012207,2014070,2015910,2017736,2019547,2021354,2023155,2024948,2026941,2028931,2030910,2032874,2034834,2036788,2038737,2040675,2042601,2044509,2046409,2048296,2050181,2052053,2053916,2055867,2057906,2059939,2061966,2063986,2065996,2067998,2070004,2071995,2073974,2075946,2077910,2079908,2081899,3015956,3016085,3018095,3018224,3018323,3020288,3020416,3020515,3023613,3025075,3026526,3027967,3029399,3030831,3030973,3032245,3032387,3033652,3033791,3035244,3035384,3036821,3036967,3038390,3038536,3039949,3040096,3041644,3043188,3044729,3046259,3047772,3049279,3050793,3052290,3053783,3055265,3056665,3056734,3058123,3058198,3059574,3059645,3061012,3061086,3062827,3064554,3066279,3067989,3069687,3071371,3073053,3074720,3076377,3078033,3079692,3081341,3082978,3084605,3086262,3177600,3177608,3177664,3177731,3178989,3178997,3179057,3179140,3180461,3180469,3180529,3180612,3181929,3181937,3181997,3182080,3183395,3183403,3183459,3183529,3184860,3184868,3184924,3184994,3186321,3186329,3186385,3186455,3187778,3187786,3187842,3187912,3189229,3189237,3189293,3189363,3190674,3190682,3190738,3190808,3192115,3192123,3192179,3192249,3193552,3193560,3193631,3193756,3195243,3195251,3195322,3195447,3197028,3197036,3197107,3197233,3199002,3199010,3199082,3199207,3200970,3200979,3201034,3201104,3202668,3202676,3202732,3202802,3204361,3204370,3204425,3204495,3206051,3206059,3206115,3206185,3207739,3207746,3207802,3207872,3209419,3209426,3209482,3209552,3211091,3211099,3211155,3211225,3212810,3212819,3212874,3212944,3214515,3214522,3214578,3214648,3216209,3216218,3216274,3216344,3217904,3217912,3217968,3218038,3219591,3219600,3219656,3219726,3221271,3221278,3221335,3221405,3222938,3222946,3223007,3223080,3224603,3224612,3224672,3224747,3226232,3226241,3226301,3226376,3227849,3227857,3227917,3227992,3229466,3229473,3229534,3229609,3231089,3231096,3231157,3231232,3232705,3232712,3232773,3232848,3234314,3234322,3234382,3234457,3235912,3235921,3235981,3236056,3237496,3237505,3237565,3237640,3239066,3239074,3239135,3239210,3240633,3240641,3240702,3240777,3242236,3242245,3242305,3242380,3243827,3243835,3243896,3243971,3245409,3245418,3245478,3245553,3247012,3247019,3247080,3247155,3248598,3248605,3248666,3248741,3250168,3250175,3250236,3250311,3251733,3251741,3251801,3251876,3253305,3253315,3253404,3253479,3254904,3254913,3255046,3255206,3256916,3256926,3257057,3257218,3258926,3258936,3259068,3259228,3260923,3260934,3261064,3261225,3262905,3262916,3263047,3263208,3264886,3264895,3265027,3265189,3266864,3266874,3267008,3267179,3268850,3268859,3268991,3269216,3270899,3270908,3271073,3271305,3273025,3273036,3273202,3273431,3275135,3275145,3275310,3275541,3277228,3277237,3277403,3277634,3279319,3279329,3279491,3279726,3281452,3281461,3281628,3281859,3283581,3283590,3283754,3283988,3285701,3285712,3285876,3286107,3287850,3287861,3288026,3288257,3289985,3289993,3290158,3290392,3292101,3292111,3292274,3292507,3294206,3294215,3294379,3294611,3296306,3296316,3296481,3296712,3298398,3298408,3298572,3298804,3300483,3300491,3300657,3300891,3302559,3302568,3302733,3302965,3304621,3304632,3304796,3305028,3306671,3306679,3306846,3307078,3308717,3308727,3308893,3309123,3310758,3310767,3310934,3311165,3312791,3312802,3312964,3313192,3314810,3314821,3314983,3315211,3316822,3316831,3316992,3317223,3318823,3318832,3318994,3319224,3320811,3320821,3320983,3321212,3322796,3322806,3322968,3323196,3324942,3324951,3325115,3325343,3327211,3327221,3327383,3327614,3329599,3329608,3329770,3330002,3331981,3331990,3332152,3332383,3334347,3334357,3334519,3334749,3336699,3336709,3336870,3337102,3339048,3339056,3339220,3339452,3341390,3341399,3341564,3341794,3343728,3343737,3343901,3344130,3346085,3346095,3346257,3346488,3348437,3348446,3348609,3348841,3350773,3350784,3350944,3351177,3353097,3353105,3353269,3353501,3355416,3355424,3355586,3355819,3357746,3357754,3357918,3358170,3360091,3360100,3360263,3360525,3362452,3362461,3362625,3362844,3362886,3364807,3364817,3364978,3365198,3365241,3367146,3367156,3367320,3367539,3367580,3369477,3369486,3369647,3369871,3369911,3371802,3371812,3371973,3372193,3372236,3374119,3374130,3374292,3374511,3374553,3376431,3376441,3376605,3376825,3376867,3378738,3378748,3378910,3379128,3379173,3381035,3381045,3381207,3381425,3381470,3383304,3383314,3383475,3383695,3383738,3385602,3385762,3385980,3386023,3387870,3388029,3388249,3388293,3390288,3390509,3390551,3392541,3392761,3392802,3394777,3394996,3395038,3396999,3397220,3397260,3399213,3399432,3399476,3401416,3401637,3401677,3403605,3403825,3403870,3405786,3406005,3406050,3407953,3408192,3408237,3410119,3410355,3410400,3412264,3412499,3412546,3414431,3414669,3414714,3416581,3416818,3416862,3418722,3418959,3419003,3420842,3421078,3421123,3422945,3423181,3423226,3425023,3425262,3425307,3427082,3427322,3427367,3429128,3429362,3429409,3431150,3431390,3431433,3433163,3433398,3433445,3435166,3435400,3435447,3437160,3437395,3437444,3439142,3439378,3439422,3441109,3441343,3441388,3443074,3443306,3443352,3445048,3445279,3445327,3447202,3447434,3447479,3449349,3449580,3449627,3451487,3451717,3451767,3453620,3453849,3453899,3455737,3455968,3456019,3457862,3458097,3458144,3459987,3460219,3460272,3462124,3462356,3462410,3464481,3464536,3466630,3466683,3468811,3468863,3470978,3471030,3473136,3473186,3475217,3475292,3475345,3477371,3477442,3477496,3479517,3479589,3479642,3481655,3481724,3481776,3483787,3483856,3483909,3485906,3485977,3486030,3488019,3488089,3488141,3490126,3490198,3490253,3492254,3492327,3492380,3494377,3494446,3494505,3496494,3496561,3496618,3498645,3498714,3498772,3500791,3500858,3500917,3502926,3502994,3503051,3505056,3505125,3505182,3507183,3507252,3507310,3509302,3509371,3509429,3511414,3511485,3511542,3513525,3513595,3513649,3515621,3515690,3515747,3517707,3517777,3517835,3519795,3519865,3519923,3521871,3521943,3521999,3523941,3524014,3524068,3526003,3526075,3526132,3528056,3528126,3528183,3530114,3530185,3530243,3530395,3532160,3532230,3532286,3532441,3534201,3534270,3534326,3534481,3536238,3536310,3536365,3536519,3538269,3538340,3538395,3538547,3540293,3540364,3540421,3540573,3542363,3542431,3542491,3542643,3544420,3544490,3544548,3544700,3546462,3546531,3546588,3546740,3548496,3548566,3548624,3548777,3550598,3550657,3550812,3552639,3552698,3552852,3554673,3554731,3554888,3556714,3556770,3556924,3558740,3558797,3558951,3560749,3560808,3560964,3562753,3562811,3562965,3564755,3564812,3564966,3566774,3566830,3566985,3568784,3568843,3568998,3570803,3570863,3571015,3572815,3572872,3573026,3574825,3574885,3575038,3576734,3576790,3576945,3578637,3578694,3578848,3580534,3580594,3580747,3582430,3582475,3582609,3584288,3584334,3584468,3586145,3586192,3586325,3588045,3588179,3589898,3590032,3591745,3591879,3593591,3593725,3595550,3595710,3596091,3597545,3597703,3598082,3599520,3599678,3600058,3601479,3601637,3602017,3603426,3603586,3603967,3605363,3605521,3605905,3607290,3607447,3607830,3609209,3609367,3609748,3611120,3611277,3611658,3613173,3613557,3615095,3615476,3617008,3617391,3618916,3619300,3620817,3621200,3622717,3623097,3624607,3624990,3626486,3626870,3628356,3628736,3630217,3630600,3632076,3632459,3633928,3634308,3635771,3636152,3637607,3637989,3639430,3639811,3641239,3641623,3643046,3643427,3644837,3645220,3646625,3647007,3648403,3648785,3650175,3650558,3651932,3652314,3653681,3654061,3655422,3655803,3657152,3657537,3658874,3659258,3660593,3660976,3662321,3662701,3664033,3664416,3665739,3666118,3667436,3667817,3669124,3669506,3670803,3671183,3672474,3672857,3674140,3674521,3675794,3676175,3677437,3677819,3679076,3679457,3680709,3681092,3682342,3682722,3684348,3685968,3687577,3689176,3690772,3692362,3693945,3695522,3697092,3698648,3700190,3701730,3703261,3704787,3706306,3707814,3709312,3710797,3712283,3713760,3715230,3716696,3718157,3719610,3721058,3722499,3723934,3725363,3726787,3728205,3729614,3731013,3732407,3733793,3735170,3736537,3737901,3739255,3740597,3741936,3743265,3744587,3745903,3747213,3748513,3749800,3751083,3752358,3753624,3754885,3756140,3757394,3758639,3759881,3761112,3762336,3763560,3764777,3765986,3767188,3768381,3769569,3769963,3770351,3770736,3771119,3771499,3771876,3772252,3772623,3772995,3773359,3773729,3774094,3774459,3774822,3775183,3775542,3775899,3776252,3776600,3776952,3777301,3777646,3777986,3778321,3778651,3778976,3779306,3779632,3779953,3780269,3780584,3780895,3781200,3781500,3781797,3782089,3782377,3782660,3782945,3783227,3783506,3783782,3784054,3784325,3784591,3784853,3785111,3785366,3785618,3785952,3786283,3786633,3786979,3787321,3787660,3787995,3788328,3788657,3788983,3789306,3789624,3789940,3790253,3790564,3790871,3791175,3791476,3791773,3792068,3792360,3792649,3792936,3793219,3845826,3846072,3846315,3846554,3846792,3847026,3847255,3847483,3847715,3847943,3848167,3848396,3848621,3918268,3918941,3919631,3920319,3920997,3921679,3922351,3923028,3923707,3924381,3953312,3953927,3954546,3955152,3955764,3983396,3983970,3984539,3985100,3985659,3986221,3986776,3987323,3987870,3988417,3988954,3989488,3990019,3990559,4051512,4052389,4053266,4054137,4055002,4055872,4056732,4057594,4058446,4125911,4125912,4132022,4132023,4132027,4132029,4132693,4132694,4132698,4132699,4133360,4133361,4133366,4133368,4134027,4134028,4134030,4134033,4134690,4134691,4134696,4134697,4135353,4135355,4135357,4135358,4136016,4136021)) 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





	Anna Markarova (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Anna Markarova (Soprano)

Anna Markarova (Soprano)

Mezzo-soprano

Honoured Artist of Russia (2006).

Prize-winner at the International Schubert Vocalists? Competition (Grand Prix; Moscow, 1995).
Took part in the XI International Tchaikovsky Vocalists? Competition (Moscow, 1998).
Special Prize winner "For best performance of an aria by Mascagni" (founded in memory of Alessandra Armiento) at the XVIII International Competition Valsesia Musica (Varallo, Italy, 2002).
Prize-winner and recipient of the special prize "For the best performance of a work by Rimsky-Korsakov" at the VII International Rimsky-Korsakov Young Opera Singers? Competition (St Petersburg, 2006), the VI International Elena Obraztsova Competition (St Petersburg, 2007).

Born in Rostov on Don.
Graduated from the Rostov State Rakhmaninov Conservatoire (Academy) in 2000. Soloist with the Rostov Musical Theatre from 1999-2006, where she performed as Lyubasha (The Tsar?s Bride), Olga (Eugene Onegin), Rosina (Il barbiere di Siviglia), Maddalena (Rigoletto) and Carmen (Carmen).

In 2002 and 2003 she toured with the Rostov Musical Theatre to Germany and the UK. She has appeared in Manchester and Birmingham as well as at the Albert Hall in London and the Philharmonic Hall in Dublin, performing as Olga (Eugene Onegin), Rosina (Il barbiere di Siviglia) and Suzuki (Madama Butterfly).

Has performed as Rosina (Il barbiere di Siviglia) at Moscow?s Bolshoi Theatre.

Soloist with the Mariinsky Academy of Young Singers since 2006.

Appeared in Academy gala concerts in October 2006 in St Petersburg (Mariinsky Theatre) and Moscow (performing works by Andrew Lloyd Webber, who attended the concert). Has toured with the Mariinsky Academy of Young Singers to Spain, Portugal, the UK and France.