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 (3030928,3030952,3032346,3032369,3033750,3033773,3035342,3035365,3036923,3036944,3038492,3038513,3040052,3040073,3041602,3041626,3043147,3043170,3044686,3044708,3046216,3046238,3047731,3047754,3049238,3049260,3050751,3050772,3052251,3052274,3053741,3053764,3055223,3055244,3056694,3056716,3058157,3058177,3059605,3059626,3061044,3061066,3062783,3062805,3064516,3064536,3064581,3066235,3066259,3066300,3067945,3067968,3068009,3069644,3069665,3069706,3071332,3071352,3071393,3073032,3073072,3074701,3074744,3076360,3076403,3078013,3078058,3079673,3079713,3081366,3083005,3084632,3086283,3087928,3089557,3091181,3092794,3142591,3144185,3145775,3147355,3147991,3148621,3149245,3149869,3151416,3152955,3154488,3156011,3157527,3159034,3160528,3162013,3163491,3164963,3166441,3167849,3169243,3170628,3172005,3173376,3174740,3176142,3177328,3177540,3177724,3178718,3178929,3179131,3180190,3180401,3180603,3181658,3181869,3182071,3183124,3183335,3183522,3184587,3184800,3184987,3186048,3186261,3186448,3187505,3187718,3187905,3188956,3189169,3189356,3190399,3190614,3190801,3191839,3192055,3192242,3193275,3193491,3193742,3194967,3195182,3195433,3196754,3196967,3197219,3198728,3198942,3199194,3200695,3200908,3201097,3202394,3202608,3202795,3204087,3204299,3204488,3205779,3205991,3206178,3207463,3207678,3207865,3209144,3209358,3209545,3210819,3211031,3211218,3212535,3212748,3212937,3214240,3214454,3214641,3215932,3216147,3216337,3217628,3217843,3218031,3219314,3219529,3219719,3220994,3221210,3221398,3222661,3222876,3223072,3224324,3224541,3224739,3226170,3226368,3227788,3227984,3229405,3229601,3231027,3231224,3232643,3232840,3234252,3234449,3235850,3236048,3237434,3237632,3239006,3239202,3240573,3240769,3242174,3242372,3243767,3243963,3245348,3245545,3246951,3247147,3248537,3248733,3250107,3250303,3251672,3251868,3253231,3253471,3254829,3255189,3256842,3257201,3258852,3259212,3260850,3261209,3262830,3263190,3264811,3265172,3266788,3267165,3268739,3268773,3269193,3270788,3270824,3271283,3272914,3272949,3273409,3275025,3275059,3275517,3277119,3277152,3277612,3279206,3279244,3279703,3281342,3281377,3281835,3283466,3283506,3283766,3283965,3285588,3285626,3285886,3286085,3287737,3287775,3288036,3288233,3289871,3289910,3290171,3290369,3291985,3292024,3292285,3292485,3294091,3294129,3294390,3294590,3296191,3296231,3296490,3296690,3298284,3298322,3298585,3298783,3300367,3300408,3300672,3300867,3302445,3302483,3302745,3302943,3304507,3304547,3304807,3305006,3306555,3306595,3306858,3307054,3308601,3308641,3308904,3309100,3310643,3310682,3310943,3311141,3312716,3312974,3313169,3314735,3314992,3315189,3316745,3317004,3317199,3318746,3319005,3319202,3320735,3320994,3321188,3322720,3322979,3323173,3324868,3325127,3325321,3327136,3327394,3327592,3329526,3329786,3329980,3331907,3332163,3332360,3334272,3334530,3334728,3336625,3336883,3337078,3338974,3339233,3339428,3341577,3341770,3343914,3344107,3346270,3346465,3348624,3348817,3350957,3351154,3353281,3353478,3355599,3355797,3357931,3357982,3358147,3360277,3360330,3360500,3362635,3362690,3362861,3364992,3365043,3365215,3367330,3367383,3367557,3369662,3369715,3369887,3371988,3372041,3372212,3374305,3374359,3374528,3376616,3376669,3376842,3378921,3378976,3379148,3381217,3381273,3381445,3383491,3383541,3383714,3385774,3385826,3385997,3388044,3388095,3388269,3390304,3390353,3390526,3392552,3392604,3392777,3394790,3394843,3395016,3397012,3397063,3397238,3399229,3399281,3399451,3401431,3401482,3401653,3403537,3403553,3403569,3403619,3403672,3403846,3405716,3405731,3405749,3405800,3405853,3406026,3407884,3407899,3407922,3407967,3408020,3408206,3410045,3410065,3410087,3410130,3410185,3410373,3412194,3412209,3412230,3412279,3412328,3412516,3414362,3414377,3414400,3414443,3414497,3414685,3416506,3416524,3416546,3416591,3416645,3416834,3418648,3418665,3418688,3418732,3418786,3418975,3420772,3420788,3420808,3420855,3420906,3421095,3422870,3422889,3422907,3422958,3423009,3423198,3424954,3424972,3424993,3425035,3425090,3425279,3427030,3427047,3427098,3427150,3427336,3429074,3429095,3429141,3429193,3429380,3431098,3431119,3431166,3431216,3431404,3433124,3433173,3433229,3433415,3435134,3435177,3435231,3435419,3437124,3437172,3437227,3437414,3439108,3439155,3439208,3439394,3441119,3441172,3441362,3443084,3443138,3443322,3445060,3445113,3445299,3447213,3447266,3447450,3449363,3449412,3449596,3451498,3451550,3451738,3453633,3453684,3453870,3455753,3455802,3455988,3457874,3457926,3458113,3459998,3460051,3460240,3462136,3462188,3462377,3464262,3464313,3464500,3466412,3466463,3466650,3468592,3468643,3468831,3470810,3470996,3472967,3473154,3475123,3475309,3477277,3477463,3479424,3479608,3481562,3481742,3483694,3483873,3485813,3485996,3487924,3488108,3490033,3490214,3492161,3492345,3492411,3494284,3494465,3494533,3496401,3496580,3496650,3498734,3498802,3500877,3500946,3503013,3503081,3505024,3505144,3505212,3507146,3507271,3507340,3509269,3509389,3509458,3511383,3511505,3511572,3513490,3513611,3513682,3515591,3515709,3515777,3517676,3517796,3517866,3519759,3519884,3519953,3521839,3521962,3522029,3523911,3524032,3524099,3525971,3526094,3526160,3528020,3528145,3528215,3530083,3530203,3530275,3532249,3532317,3534289,3534357,3536327,3536399,3538360,3538426,3540380,3540449,3542452,3542520,3544509,3544576,3546548,3546617,3548585,3548654,3550612,3550619,3550688,3552651,3552658,3552729,3554684,3554694,3554762,3556726,3556731,3556802,3558750,3558757,3558825,3560763,3560769,3560838,3562766,3562771,3562840,3564768,3564775,3564843,3566785,3566792,3566862,3568796,3568803,3568875,3570817,3570824,3570893,3572824,3572831,3572902,3574838,3574846,3574916,3576746,3576754,3576821,3578649,3578657,3578723,3580548,3580555,3580625,3582437,3582443,3582496,3584299,3584305,3584359,3586154,3586162,3586215,3588009,3588016,3588067,3589861,3589866,3589919,3591708,3591716,3591770,3593562,3593613,3595510,3595583,3596100,3597575,3598091,3599550,3600066,3601509,3602027,3603459,3603976,3605395,3605912,3607321,3607839,3609241,3609758,3611149,3611665,3613048,3613566,3614967,3615488,3616884,3617400,3617465,3618793,3619311,3619374,3620691,3621208,3621277,3622590,3623109,3623176,3624483,3625001,3625067,3626361,3626880,3626947,3628745,3628814,3630609,3630679,3632467,3632538,3634319,3634388,3636161,3636230,3637997,3638068,3639821,3639890,3641632,3641700,3643437,3643507,3645229,3645298,3647019,3647084,3648798,3648863,3650569,3650637,3652325,3652392,3654071,3654139,3655814,3655880,3657544,3657614,3659266,3659337,3660986,3661069,3662714,3662794,3664428,3664509,3666128,3666210,3667826,3667908,3669513,3669596,3671192,3671276,3672866,3672946,3674533,3674615,3676188,3676268,3677830,3677912,3679469,3679548,3681102,3681184,3682734,3682814,3684360,3684442,3685979,3686060,3687584,3687666,3689188,3689270,3690784,3690864,3692374,3692454,3693958,3694039,3695531,3695613,3697100,3697181,3698658,3698736,3700199,3700283,3701739,3701818,3703272,3703354,3704797,3704876,3706314,3706396,3707825,3707905,3709321,3709400,3710808,3710889,3712294,3712375,3713768,3713852,3715239,3715323,3716704,3716784,3718164,3718249,3719618,3719702,3721066,3721146,3722510,3722591,3723945,3724025,3725372,3725455,3726796,3726879,3728215,3728295,3729625,3729704,3731023,3731106,3732420,3732501,3733802,3733885,3735177,3735258,3736546,3736631,3737913,3737993,3739265,3739346,3740607,3740688,3741945,3742026,3743275,3743356,3744598,3744678,3745912,3745993,3747221,3747303,3748522,3748604,3749811,3749891,3751093,3751175,3752368,3752450,3753634,3753716,3754896,3754975,3756151,3756229,3757406,3757486,3758649,3758731,3759889,3759973,3761122,3761202,3762347,3762428,3763568,3763652,3764785,3764869,3765996,3766078,3767198,3767281,3768393,3768472,3769579,3769660,3769974,3770054,3770360,3770443,3770749,3770827,3771129,3771209,3771508,3771590,3771889,3771967,3772261,3772343,3772634,3772716,3773004,3773086,3773368,3773451,3773740,3773820,3774106,3774187,3774471,3774552,3774834,3774915,3775195,3775276,3775554,3775635,3775911,3775992,3776264,3776345,3776612,3776693,3776964,3777045,3777313,3777394,3777658,3777739,3777998,3778079,3778333,3778414,3778663,3778744,3778988,3779069,3779318,3779399,3779644,3779725,3779965,3780046,3780281,3780362,3780596,3780677,3780907,3780988,3781212,3781293,3781512,3781593,3781809,3781890,3782101,3782182,3782389,3782470,3782672,3782753,3782957,3783038,3783239,3783320,3783518,3783599,3783794,3783875,3784066,3784147,3784337,3784418,3784603,3784684,3784865,3784946,3785123,3785204,3785378,3785459,3785630,3785742,3785964,3786076,3786295,3786407,3786645,3786757,3786991,3787103,3787333,3787445,3787672,3787784,3788007,3788119,3788340,3788452,3788669,3788781,3788995,3789107,3789318,3789430,3789636,3789748,3789952,3790064,3790265,3790377,3790576,3790688,3790883,3790995,3791187,3791299,3791488,3791600,3791785,3791897,3792080,3792192,3792372,3792484,3792661,3792773,3792948,3793060,3793231,3793343,3793510,3793622,3793785,3793897,3794058,3794170,3794439,3794705,3794969,3795231,3795490,3795744,3796011,3796276,3796538,3796797,3797052,3797302,3797546,3797788,3798026,3798261,3798493,3798724,3798950,3799170,3799389,3799605,3799819,3800030,3800239,3800444,3800647,3800849,3801049,3801246,3801440,3801631,3801817,3801995,3802172,3802347,3802519,3802688,3802855,3803018,3807825,3807826,3808201,3808202,3808575,3816958,3816962,3817306,3817314,3817655,3817659,3818039,3818043,3818445,3835746,3835988,3836737,3836753,3836996,3837013,3837254,3837271,3837512,3837527,3837765,3837780,3838016,3838034,3838272,3838289,3838526,3838542,3838779,3838794,3839032,3839048,3839281,3839297,3839529,3839544,3839773,3839789,3840013,3840030,3840253,3840269,3840496,3840519,3840802,3841081,3841356,3841628,3841895,3842157,3842423,3842690,3842955,3847488,3847720,3847948,3848172,3848401,3848626,3848848,3849069,3850712,3850934,3851151,3851365,3851576,3851784,3851990,3852194,3852385,3852390,3852396,3852418,3852424,3852491,3852983,3852988,3853011,3853015,3853083,3853575,3853579,3853600,3853608,3853676,3854167,3854190,3854195,3854263,3854753,3854774,3854781,3854846,3855355,3855362,3855431,3855937,3855944,3856014,3856516,3856524,3856592,3857094,3857099,3857168,3857705,3857710,3857786,3858318,3858325,3858403,3859120,3859127,3859203,3859920,3859928,3860003,3860719,3860724,3860805,3861522,3861599,3862315,3862393,3863183,3863969,3864751,3865531,3866309,3867085,3867855,3868626,3869395,3870160,3870923,3871685,3873172,3873928,3874679,3875431,3876178,3876924,3877669,3878411,3879154,3879891,3880632,3881380,3882122,3882865,3883606,3884345,3885080,3885821,3886556,3887287,3888021,3888751,3889482,3890207,3890931,3897426,3898131,3898832,3899533,3900232,3900283,3900949,3901000,3901663,3901714,3902375,3902429,3903088,3903139,3903797,3903848,3904503,3904552,3905199,3905253,3905901,3905951,3906642,3907308,3907337,3907997,3908025,3908683,3908712,3909366,3909396,3910048,3910075,3910737,3910766,3911452,3912135,3912819,3913498,3914175,3914849,3915530,3916206,3916883,3917556,3918261,3918938,3919628,3920315,3920994,3921670,3922346,3923027,3923705,3926405,3926424,3927067,3927084,3927727,3927745,3928385,3928402,3929041,3929059,3929693,3929710,3930342,3930360,3930989,3931007,3931635,3931652,3932291,3932296,3932932,3932935,3933575,3933580,3934217,3934219,3934856,3935492,3948247,3948255,3948889,3948896,3949530,3949539,3950162,3950173,3950794,3950801,3951423,3951430,3952048,3952057,3952680,3953299,3953320,3953920,3953936,3954549,3955158,3955769,3956370,3956431,3957056,3957675,3958293,3958906,3959513,3960119,3960718,3961320,3961915,3962501,3963082,3963657,3963662,3964229,3964234,3964806,3979885,3980469,3981051,3981627,3982200,3990022,3990562,3991097,3995873,3996383,4051483,4051498,4051508,4052376,4052386,4053254,4053259,4054125,4054130,4054991,4054998,4055857,4055867,4056728,4057589,4066003,4066036,4066821,4066853,4067670,4068482,4069290,4070095,4070895,4071689,4072484,4073274,4074065,4074853,4250753,4279226,4279351,4279474,4279595,4279754,4279909)) 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





	Maria Bulanova (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Maria Bulanova (Dancer)

Maria Bulanova (Dancer)

Born in St Petersburg. Graduated from the Vaganova Ballet Academy (class of Professor Lyudmila Kovaleva) and joined the Mariinsky Ballet in 2018.

Repertoire includes: 
La Sylphide (Effie); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen, 
Giselle (Myrtha); choreography by Jean Coralli, Jules Perrot and Marius Petipa, 
La Bayadère (D’Jampe, Grand pas); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani, 
Swan Lake (brides, swans); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
Le Corsaire (Trio of Odalisques); production by Pyotr Gusev after the composition and choreography of Marius Petipa, 
Don Quixote (Street Dancer); choreography by Alexander Gorsky after motifs of the production by Marius Petipa, 
The Firebird (the Princess of Great Beauty); choreography by Michel Fokine, 
The Fountain of Bakhchisarai (Zarema); choreography by Rostislav Zakharov, 
The Nutcracker (Waltz of the Flores); choreography by Vasily Vainonen, 
Symphony in C (III. Allegro vivace); choreography by George Balanchine,
The Legend of Love (Dance of the Court Dancers); choreography by Yuri Grigorovich, 
In the Night; choreography by Jerome Robbins, 
The Nutcracker (Queen of the Snowflakes); production by Mihail Chemiakin and choreography by Kirill Simonov, 
The Little Humpbacked Horse (Mare, Sea Princess), Anna Karenina (Princess Betsy), Cinderella (Female Dance, Dance teachers); choreography by Alexei Ratmansky, 
Paquita (Carducha); choreography by Yuri Smekalov, reconstruction and staging of Marius Petipa's choreography (Act III Grand Pas) by Yuri Burlaka,
Pulcinella (Prudenza); choreography by Ilya Zhivoi, 
Push Comes to Shove; choreography by Twyla Tharp.