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 (397982,398035,399811,401581,403339,405096,406848,408595,410335,412102,413859,415602,417341,419081,420814,457342,457353,458909,458920,460465,460476,462013,462024,463565,463576,465123,466665,477970,478065,478225,479515,479539,479636,479794,481077,481105,481824,481849,482562,482587,483297,483324,484036,484063,484790,484814,485559,486297,487021,487738,488450,489163,497362,497568,498826,499032,500282,500492,501718,501736,501946,503210,503228,503437,504707,504917,506178,506389,507647,507861,509119,509330,510582,510793,512249,513714,515187,516650,518104,519548,520990,522427,523858,525279,526687,528092,529496,530892,532286,533672,535110,536530,537960,539384,540800,542233,543677,545147,546601,548058,549510,550953,552388,553811,555228,556635,558037,559434,560826,562213,563594,564964,566327,567689,569040,570387,571727,573105,574477,575839,577197,583952,585266,586574,587880,589176,590817,592415,592435,594047,594066,595766,597456,599137,644522,646028,647524,649015,650510,651991,653467,732065,733048,734036,735019,735992,736046,736969,737023,737937,737991,738896,738951,739849,739904,741820,741875,743796,743851,745765,745821,747726,747782,749711,749766,751693,751748,753675,753730,756551,756606,759421,759476,762287,762343,765150,765206,768006,768062,770855,770911,773698,773754,776535,776591,779368,779424,782204,782260,785037,785092,787865,787920,790689,790744,793509,793564,796317,796377,799124,799184,801927,801990,804725,804788,807518,807581,810305,810368,813086,813149,815866,815925,818637,818696,821401,821460,824156,824216,826905,826965,829649,829709,832385,832446,835124,835184,837853,837916,840580,840643,843303,843366,846047,846111,848783,848847,851514,851578,854247,854309,856976,857038,859698,859760,862416,862477,865124,865184,867819,867879,870503,870563,873186,873246,875869,875929,878556,878616,881240,881300,883926,883986,886601,886662,889266,889328,891928,891990,894583,894645,897237,897299,899949,902544,902590,902660,905170,905218,905292,907835,907909,910449,910523,910560,910599,913060,913134,913171,913211,915691,915765,915803,915841,918395,918469,918507,918546,921088,921162,921199,921238,923767,923841,923881,923917,926461,926532,926574,926612,929175,929249,929288,929329,931958,931994,932035,934665,934702,934743,937370,937407,937448,940101,940137,940178,942819,942855,942896,945524,945560,945602,948226,948262,948304,950932,950968,951010,953632,953668,953710,956322,956359,956400,958999,959035,959076,961653,961693,961730,964293,964333,964370,966929,966969,967006,969561,969601,969638,972189,972229,972266,974849,974886,977461,977498,980068,980105,982660,982697,985244,985284,987868,987908,990488,990527,993102,993137,995708,995748,998305,998343,1000927,1003508,1006080,1008647,1011206,1013786,1016350,1018897,1021444,1023989,1024185,1024199,1026720,1026734,1029250,1029264,1031781,1031788,1034284,1034291,1036774,1036780,1039263,1039269,1041747,1041753,1044222,1044233,1046689,1046700,1049146,1049157,1051590,1051601,1054018,1054031,1056445,1056458,1058866,1058880,1061274,1061289,1063675,1063690,1066069,1066084,1068457,1068466,1070827,1070836,1073227,1073236,1075619,1075629,1078001,1078012,1080372,1080383,1082731,1082743,1085076,1085088,1087405,1087416,1089725,1089735,1092055,1092065,1094377,1094387,1096687,1096697,1098981,1098993,1101258,1101270,1103529,1103541,1105779,1105791,1108006,1108019,1110218,1110226,1112404,1112411,1114571,1114579,1116726,1116735,1118868,1121001,1123138,1447263,1447323,1448821,1448881,1450372,1450425,1451903,1451958,1453423,1453482,1454940,1455000,1456445,1456505,1457943,1458005,1459430,1459492,1460902,1460964,1462363,1462421,1463812,1463872,1465310,1466737,1468152,1469554,1470941,1472316,1473677,1475030,1476369,1483461,1484809,1486147,1487477,1488794,1490095,1491385,1492667,1493977,1495278,1496571,1497864,1499162,1500448,1501727,1503000,1504263,1505522,1506771,1508013,1509241,1510470,1511699,1512921,1514142,1515369,1516588,1517802,1519004,1520204,1521397,1522584,1523763,1524935,1526100,1527258,1528410,1529557,1530700,1531839,1532973,1534101,1535229,1536350,1537466,1538606,1539739,1540865,1541987,1543105,1544212,1545314,1546406,1547486,1548554,1549611,1550663,1551707,1552751,1553791,1554825,1555850,1556859,1557873,1802509,1804947,1807368,1809771,1812152,1814510,1816856,1819178,1821476,1823747,1825995,1828219,1830422,1832610,1834809,1837001,1839185,1841356,1843509,1845648,1847804,1849956,1852102,1971145,1973156,1975152,1977139,1979109,1981108,1983100,2635602,2638248,2640878,2643493,2646103,2648698,2651285,2653860,2656424,2658969,2661498,2664005,2666502,2668980,2671435,2673877,2676301,2678707,2681090,2710299,2713337,2716361,2719426,2722500,2725599,2728688,2731774,2734884,2737975,2741057,2744129,2747180,2750210,2753237,2756261,2759274,2762289,2765298,2768288,2771262,2774232,2777191,2786401,2789480,2792539,2795595,2798664,2801723,2804773,2807740,2810684,2813608,2816524,2819503,2822473,2825455,2828424,2831375,2906735,2909321,2911930,2914521,2917106,2919687,2922254,2924812,2927359,2929887,2932397,2934903,2937398,2939899,2942396,2944883,2947353,2949802,2952247,2954687,2957168,2959643,2962105,2964543,2966963,2969377,3002647,3004943,3007175,3009362,3011543,3056790,3058250,3059700,3061140,3062880,3064612,3066335,3068043,3069739,3071430,3073107,3074774,3076435,3078091,3079746,3081396,3083038,3084661,3086317,3087958,3089591,3091215,3092823,3094426,3096020,3097605,3099179,3100748,3102307,3115009,3116532,3118044,3119556,3121060,3122587,3124285,3125973,3127646,3129309,3130965,3132612,3132712,3134252,3134352,3135892,3135992,3137525,3137625,3139146,3139246,3140758,3140858,3142362,3142462,3143956,3144056,3145546,3145646,3147126,3147226,3147762,3147862,3148392,3148492,3149016,3149116,3149640,3149740,3151187,3151287,3152726,3152826,3154259,3154359,3155782,3155882,3157298,3157398,3158805,3158905,3160299,3160399,3161784,3161884,3163261,3163361,3164733,3164833,3166196,3166296,3167641,3167721,3169035,3169115,3170420,3170500,3171797,3171877,3173168,3173248,3174533,3174613,3175934,3176015,3177332,3177413,3178722,3178802,3180194,3180274,3181662,3181742,3183128,3183208,3184591,3184671,3186052,3186132,3187509,3187589,3188960,3189040,3190407,3190483,3191847,3191926,3193281,3193363,3194972,3195056,3196757,3196837,3198734,3198816,3200705,3200779,3202400,3202479,3204095,3204173,3205783,3205861,3207468,3207551,3209149,3209227,3210823,3210903,3212545,3212622,3214246,3214324,3215942,3216020,3217631,3217714,3219324,3219404,3220998,3221082,3222666,3222749,3224331,3224415,3225960,3226043,3227658,3229276,3230899,3232511,3234125,3235723,3237303,3238878,3240440,3242043,3243638,3245221,3246824,3248411,3249977,3251543,3253106,3254702,3256712,3258723,3260723,3268694,3270743,3272869,3274983,3277073,3279165,3281298,3283425,3285543,3287693,3358035,3360378,3362740,3365094,3367434,3369765,3372090,3374409,3376720,3379028,3381325,3383593,3385877,3388147,3390233,3390285,3390404,3392484,3392536,3392657,3394721,3394774,3394895,3396944,3396995,3397114,3399158,3399209,3399331,3401362,3401411,3401531,3403554,3403601,3403724,3405734,3405781,3405904,3407902,3407952,3408072,3410067,3410116,3410236,3412210,3412258,3412381,3414378,3414429,3414551,3416526,3416574,3416698,3418668,3418716,3418838,3420787,3420837,3420958,3422888,3422938,3423060,3424971,3425020,3425142,3427029,3427078,3427201,3429073,3429121,3429246,3431097,3431146,3431269,3433157,3433281,3435162,3435285,3437159,3437280,3439136,3439261,3441102,3441224,3443069,3443187,3445045,3445162,3447199,3447316,3449344,3449462,3451484,3451603,3453614,3453732,3455734,3455853,3457859,3457977,3459982,3460104,3462240,3464366,3466514,3468694,3470863,3473019,3475175,3477325,3479471,3481610,3483741,3485865,3487977,3490084,3490318,3492211,3492449,3494334,3494571,3496451,3496686,3498603,3498839,3500746,3500981,3502883,3503118,3505014,3505247,3507137,3507374,3509258,3509492,3511372,3511608,3513479,3513717,3515579,3515812,3517667,3517901,3519753,3519985,3521829,3522064,3523899,3524133,3525962,3526197,3528249,3530309,3532351,3534391,3536433,3538438,3538441,3538445,3538449,3538461,3540461,3540465,3540467,3540469,3540485,3542533,3542536,3542537,3542539,3542555,3544588,3544594,3544595,3544598,3544613,3546630,3546633,3546635,3546637,3546654,3548667,3548671,3548673,3548677,3548690,3550699,3550701,3550703,3550710,3550721,3552741,3552742,3552744,3552747,3552764,3554773,3554777,3554778,3554785,3554798,3556813,3556816,3556818,3556820,3556835,3558837,3558841,3558842,3558845,3558859,3560851,3560855,3560856,3560858,3560872,3562852,3562856,3562859,3562865,3562876,3564855,3564858,3564861,3564865,3564876,3566873,3566875,3566876,3566885,3566894,3568885,3568888,3568889,3568892,3568909,3570903,3570908,3570910,3570913,3570926,3572913,3572917,3572919,3572923,3572936,3574926,3574930,3574932,3574934,3574948,3576833,3576836,3576839,3576842,3576856,3578737,3578740,3578741,3578743,3578757,3580635,3580639,3580640,3580642,3580657,3582505,3582510,3582511,3582513,3582524,3584367,3584369,3584370,3584372,3584382,3586222,3586226,3586227,3586229,3586241,3588078,3588080,3588081,3588083,3588095,3589928,3589933,3589934,3589936,3589947,3591777,3591779,3591780,3591786,3591795,3593624,3593626,3593627,3593629,3593639,3595595,3595597,3595600,3595605,3595617,3597586,3597591,3597592,3597596,3597612,3599562,3599568,3599569,3599572,3599588,3601522,3601525,3601527,3601529,3601544,3603470,3603473,3603474,3603482,3603494,3605409,3605411,3605414,3605420,3605433,3607335,3607338,3607339,3607342,3607356,3609253,3609255,3609257,3609263,3609276,3611160,3611165,3611167,3611169,3611186,3613057,3613060,3613064,3613068,3613083,3614981,3614984,3614985,3614988,3615003,3616894,3616899,3616901,3616903,3616918,3617439,3618803,3618805,3618808,3618814,3618827,3619347,3620702,3620705,3620706,3620715,3620728,3621248,3622602,3622604,3622605,3622614,3622627,3623147,3624494,3624497,3624500,3624502,3624518,3625039,3626371,3626374,3626378,3626384,3626397,3626918,3628239,3628242,3628245,3628248,3628265,3628785,3630103,3630104,3630108,3630111,3630124,3630648,3631962,3631963,3631966,3631970,3631985,3632507,3633814,3633816,3633818,3633825,3633835,3634358,3635656,3635659,3635661,3635663,3635680,3636202,3637496,3637498,3637500,3637516,3638037,3639326,3639340,3639861,3641150,3641672,3642953,3643476,3644749,3645269,3646534,3647056,3648835,3650607,3652364,3654112,3655851,3657584,3659306,3661030,3662756,3664471,3666174,3667870,3669558,3671237,3672910,3674577,3676230,3677874,3679513,3681147,3682777,3684402,3686022,3687629,3689231,3690826,3692418,3694000,3695575,3697146,3698701,3700244,3701782,3703316,3704841,3706360,3707869,3709365,3710853,3712337,3713813,3715284,3716749,3718209,3719663,3721110,3722553,3723989,3725417,3726840,3728258,3729667,3731068,3732463,3733848,3735222,3736591,3737956,3739308,3740653,3741990,3743321,3744641,3745958,3747266,3748566,3749856,3751138,3752413,3753680,3754939,3756194,3757449,3758695,3759933,3761166,3762391,3763612,3764829,3766039,3767242,3768436,3769624,3770017,3770405,3770791,3771173,3771553,3771932,3772307,3772678,3773048,3773413,3773782,3774150,3774515,3774878,3775239,3775598,3775955,3776308,3776656,3777008,3777357,3777702,3778042,3778377,3778707,3779032,3779362,3779688,3780009,3780325,3780640,3780951,3781256,3781556,3781853,3782145,3782433,3782716,3783001,3783283,3783562,3783838,3784110,3784381,3784647,3784909,3785167,3785422,3785686,3786020,3786351,3786701,3787047,3787389,3787728,3788063,3788396,3788725,3789051,3789374,3789692,3790008,3790321,3790632,3790939,3791243,3791544,3791841,3792136,3792428,3792717,3793004,3793287,3793566,3793841,3794114,3794383,3794649,3794913,3795175,3795434,3795688,3795953,3796218,3796480,3796739,3796994,3797244,3797488,3797730,3797968,3798203,3798435,3798666,3798892,3799112,3799331,3807821,3816948,3849337,3849571,3849803,3850033,3850261,3850487,3850711,3850933,3851150,3851364,3851575,3851783,3851989,3852193,3852397,3852989,3853580,3854169,3854754,3860808,3861603,3862398,3863187,3863973,3864758,3865536,3866316,3867090,3867861,3868630,3869398,3869485,3870164,3870252,3870927,3871015,3871690,3871778,3873176,3873265,3873931,3874020,3874683,3874771,3875433,3875522,3876181,3876269,3876927,3877015,3877673,3877761,3878414,3878502,3879156,3879245,3879897,3879987,3880638,3880731,3881384,3881475,3882125,3882216,3882867,3882959,3883608,3883700,3884348,3884439,3885088,3885179,3885824,3885915,3886558,3886650,3887294,3887385,3888025,3888116,3888757,3888849,3889486,3889577,3890211,3890303,3890937,3891027,3891656,3891746,3892374,3892463,3893178,3893897,3894617,3895334,3896048,3896756,3897464,3898168,3898871,3899572,3900272,3900992,3901706,3902418,3903129,3903839,3904542,3905243,3905940,3906632,3907325,3907334,3908015,3908023,3908703,3908714,3909386,3909394,3910063,3910073,3910754,3910765,3911441,3911451,3912125,3912134,3912808,3912818,3913489,3913500,3914167,3914178,3914840,3914851,3915529,3916208,3916884,3917554,3922365,3923044,3923722,3924398,3925065,3925731,3926392,3926423,3927055,3927086,3927714,3927746,3928373,3928403,3929057,3929712,3930359,3931006,3931651,3932295,3932936,3933579,3934220,3934857,3935493,3941342,3941980,3942617,3943251,3943877,3944501,3945122,3945740,3946364,3946396,3947018,3947630,3948238,3948881,3949520,3950153,3970015,3970587,3971155,3971721,3972279,3972841,3973394,3973946,3974502,3975060,3975676,3975685,3976282,3976295,3976890,3976900,3977499,3978095,3978688,3979280,3983386,3983399,3983956,3983974,3984527,3984541,3985090,3985108,3985648,3985666,3986207,3986224,3986762,3986777,3987311,3987331,3987858,3987876,3988401,3988418,3988940,3988956,3989491,3990023,3990561,3991095,3994313,3994320,3994839,3994842,3995354,3995361,3995872,3995880,3996386,3996392,3996895,4066001,4138012,4138030,4138682,4138700,4139349,4139367,4140009,4140029,4140671,4140688,4141325,4141343,4141974,4141995,4142627,4142644,4143270,4143291,4143932,4144570,4145202,4145830,4146456)) 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





	Zhanna Dombrovskaya (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Zhanna Dombrovskaya (Soprano)

Zhanna Dombrovskaya (Soprano)

Soprano

Born in Pyatigorsk. Graduated from the St Petersburg State Rimsky-Korsakov Conservatoire (class of Professor Svetlana Gorenkova) as well as the Mariinsky Academy of Young Singers in 2000.
Soprano

Born in Pyatigorsk. Graduated from the St Petersburg State Rimsky-Korsakov Conservatoire (class of Professor Svetlana Gorenkova) as well as the Mariinsky Academy of Young Singers in 2000.
Soloist with the St Petersburg State Musorgsky Academic Theatre of Opera and Ballet from 2001 – 2003.
Has attended master classes given by Renata Scotto (Accademia Nazionale di Santa Cecilia, Rome, 2004; Opera Academy Music Conservatory of Westchester, New York, 2005).
Mariinsky Theatre soloist since 2003.

Repertoire at the Mariinsky Theatre includes:
Antonida (A Life for the Tsar),
Emma (Khovanshchina),
Volkhova (Sadko),
Queen of Shemakha (The Golden Cockerel),
Lucia (Lucia di Lammermoor),
Norina (Don Pasquale),
Gilda (Rigoletto),
Musetta (La Boheme),
Despina (Cosi fan tutte),
Podtochina?s daughter (The Nose).

Repertoire also includes: Lyudmila (Ruslan and Lyudmila), Tatiana (Eugene Onegin), Violetta (La traviata), Donna Anna (Don Giovanni), Fiordiligi (Cosi fan tutte), the soprano part (Les Noces) and the soprano part (Carmina burana).

Has toured to Germany, South Korea and Italy as well as the Bolshoi Theatre (Moscow).