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 (8425,8458,10132,10162,11715,11745,13298,13328,14651,14680,14691,14762,16102,16131,16144,16214,17741,17755,17824,19162,19216,32524,34048,34080,34105,35573,37116,38664,38816,40268,41579,41661,42966,43057,44413,45765,47110,48454,49783,51116,52435,53750,55059,56355,56356,57722,57723,59789,59791,61853,61854,63907,63908,65954,65955,67999,68000,70041,70042,72078,72079,74108,74109,193697,196457,197769,199086,200403,202085,203756,205431,207129,208817,221383,221411,222897,222925,224406,224434,225912,225939,227417,227444,228916,228943,230901,230928,232896,232923,234886,234913,236871,236898,238846,238872,240813,240838,242774,242799,244731,244759,246686,246713,248633,248660,250577,250603,252561,252587,254534,254560,256499,256524,258460,258485,260426,260451,262386,262411,264377,266337,268289,270230,272169,274102,289318,289335,291156,291173,293052,293069,294940,294958,296820,296838,298695,298712,300565,300582,302456,302474,304338,304356,306268,306288,308192,308212,310110,310130,312024,312044,313933,313953,315838,315858,317736,317756,319626,319646,321505,321525,323374,323395,325270,325290,327171,327187,329069,329089,330960,330980,332846,332866,334721,334741,336587,336607,338453,338473,340334,340354,342258,342278,342304,342308,342324,342353,342364,342372,344181,344200,344227,344231,344249,344279,344288,344296,346097,346116,346143,346147,346164,346190,346204,346212,348004,348023,348050,348054,348072,348097,348111,348119,349894,349913,349940,349944,349961,349988,350001,350009,351773,351791,351821,351825,351836,351871,351879,351885,353650,353669,353696,353700,353717,353744,353757,353764,355523,355541,355572,355576,355590,355616,355629,355636,357401,357419,357449,357453,357467,357493,357506,357513,359308,359326,359356,359360,359373,359400,359413,359420,361225,361255,361259,361270,361299,361312,361318,363118,363145,363149,363163,363194,363203,363212,364998,365029,365033,365044,365073,365086,365092,366878,366906,366910,366923,366957,366965,366975,368756,368786,368790,368802,368830,368843,368850,370655,370658,370672,370701,370713,370723,372520,372523,372537,372565,372577,372587,374374,374378,374392,374420,374432,374442,376218,376222,376236,376265,376277,376287,378053,378057,378072,378101,378112,378121,379886,379890,379904,379934,379945,379954,381714,381718,381731,381762,381772,381782,383542,383557,383584,383595,383602,385367,385397,385411,385418,387180,387209,387218,387225,388986,389018,389030,389037,390817,390829,390837,392622,392629,392636,394416,394425,394434,396204,396215,396223,397989,398000,398009,399771,399777,399786,401535,401547,401556,403305,403314,405062,405072,406814,406824,408570,410310,497375,497404,498844,498868,500297,500324,501752,501778,503243,503268,504724,504747,506197,506219,507667,507692,509137,509159,510601,510626,512056,512080,513504,513528,514974,515000,516461,517915,519362,520804,522240,539355,539357,540771,540773,542203,542205,543644,543652,545114,545121,546568,546575,548024,548031,549475,549481,550918,550924,552354,552360,553782,553784,555198,555200,556605,556607,558008,558010,559404,559407,560797,560800,562184,562186,563565,563568,564935,564938,566295,566301,567654,567660,569009,569013,570363,583997,585314,586620,587928,589224,590862,592479,594109,595809,597500,599181,600852,602529,604196,605854,607503,609141,610828,612510,614182,615844,615975,616023,616065,617624,617672,617714,619259,619308,619353,620890,620937,620980,622513,622562,622607,624127,624176,624221,625752,625801,625846,627369,627416,627460,628974,629021,629064,630570,630617,630659,632159,632206,632248,633741,633790,633832,635315,635362,635406,636877,636924,636968,638429,638477,638520,639969,640016,640059,641499,641549,641589,643019,643068,643113,644532,644579,644624,646037,646085,646130,647538,647586,647631,649025,649076,649116,650520,650569,650614,652004,652052,652092,653480,653528,653568,654946,654994,655034,656402,656448,656489,657896,657940,659344,659389,660781,660826,662207,662253,663626,663678,665040,665087,666448,666497,667883,667932,669307,669356,670742,670791,672214,673633,675043,676438,677824,679231,680625,682011,693978,695226,696454,697674,698881,700078,701267,702466,703648,704823,705981,707128,708256,709378,710524,875918,875943,878605,878629,881289,881313,883975,883999,886650,886674,889316,889340,891978,892002,894633,894657,897287,897311,899936,899961,902572,902602,905204,905231,907821,907848,910435,910462,913048,913073,915679,915705,918382,918409,921075,921102,921121,921137,921156,921168,921172,921186,923780,923800,923816,923836,923848,923852,923865,926471,926491,926505,926529,926542,926549,926558,929189,929207,929224,929243,929256,929260,929273,931898,931916,931933,931952,931965,931969,931982,934605,934623,934640,934659,934672,934676,934689,937310,937328,937345,937364,937377,937381,937394,940059,940076,940095,940108,940111,940125,942777,942794,942813,942825,942829,942843,945482,945499,945521,945529,945534,945547,948184,948201,948223,948231,948236,948249,950906,950928,950936,950942,950955,953605,953628,953641,953647,953655,956294,956318,956329,956337,956345,958995,959006,959014,959022,961649,961660,961669,961677,964289,964299,964307,964317,966925,966935,966943,966953,969557,969567,969575,969585,972195,972203,972213,974815,974823,974834,977427,977435,977445,980042,980053,982645,985230,987854,995847,995870,998440,998464,1001024,1001048,1003605,1003629,1006178,1006202,1008745,1008769,1011304,1011328,1013884,1013907,1016449,1016472,1018995,1019019,1021542,1021566,1024088,1024111,1026621,1026649,1029151,1029178,1031681,1031704,1034184,1034207,1036673,1036696,1039162,1039185,1041646,1041669,1044122,1044145,1046589,1046612,1049046,1049069,1051490,1051513,1053919,1053943,1056346,1056370,1058768,1058792,1061177,1061201,1063577,1063602,1065971,1065996,1068352,1068380,1070725,1070750,1073125,1073149,1073213,1073214,1075518,1075542,1075606,1075607,1077901,1077925,1077989,1077990,1080271,1080296,1080360,1080361,1082656,1082720,1082721,1082827,1085000,1085065,1085066,1085171,1087328,1087392,1087393,1087500,1089649,1089713,1089714,1089820,1092043,1092044,1092150,1094364,1094365,1094472,1096670,1096671,1096781,1098967,1098968,1099078,1101244,1101245,1101354,1103515,1103516,1103625,1105764,1105765,1105875,1107991,1107992,1108103,1110204,1110206,1110310,1112390,1112392,1112497,1114666,1116815,1118953,1121081,1123226,1125358,1127549,1129769,1131973,1134164,1136368,1138568,1140772,1142963,1145146,1147316,1149472,1151625,1153767,1155910,1158082,1160246,1162391,1330807,1332689,1334560,1336423,1338274,1340112,1341936,1343748,1345554,1347360,1349151,1553858,1553885,1554892,1554920,1555913,1555941,1556926,1556953,1557936,1557964,1558939,1558965,1559931,1559962,1561284,1561315,1562978,1563005,1564816,1564845,1566644,1566672,1569281,1569307,1572176,1572206,1575063,1575092,1577940,1577969,1580807,1580837,1583660,1583690,1586529,1589365,1592195,1595016,1597890,1600756,1893905,1895991,1898097,1900250,1915676,1915699,1915740,1917887,1917911,1917951,1920087,1920110,1920151,1922286,1922310,1922350,1924476,1924500,1924540,1926724,1926748,1926787,1928966,1928989,1931195,1931218,1933409,1933431,1935608,1935629,1937804,1937825,1939992,1940014,1942171,1942192,1944342,1944363,1946502,1946522,1948651,1948671,1950786,1950807,1952918,1952939,1955045,1955065,1957121,1957141,1959185,1959205,1961234,1961260,1963272,1963298,1965300,1965319,1967323,1967346,1969340,1969359,1971163,1971353,1971376,1973172,1973362,1973386,1975170,1975360,1975383,1977161,1977344,1977368,1979127,1979317,1979340,1981130,1981313,1981336,1983120,1983305,1983328,1985102,1985292,1985315,1987082,1987268,1987291,1989052,1989239,1989261,1991007,1991194,1991216,1993134,1993157,1995071,1995090,1997000,1997019,1998922,1998945,2000836,2000859,2002739,2002762,2004630,2004654,2006505,2006528,2008391,2008414,2010276,2010298,2012153,2012175,2014018,2014040,2015858,2015880,2017685,2017706,2019495,2019517,2021302,2021324,2023103,2023125,2024897,2024915,2026889,2026911,2028879,2028901,2030858,2030880,2032823,2032845,2034782,2034804,2036737,2036758,2038682,2038703,2040620,2040641,2042546,2042566,2044457,2044479,2046355,2046373,2048244,2048266,2050126,2050144,2051999,2052017,2053863,2053885,2055814,2055836,2057849,2057872,2059882,2059905,2061909,2061931,2063951,2065960,2067962,2067971,2069968,2069975,2071968,2112792,2114698,2116596,2118488,2120369,2122239,2124098,2125944,2127782,2129610,2131431,2133242,2135043,2756307,2759320,2762335,2765344,2768334,2771308,2774278,2777237,2780221,2783246,2786327,2789406,2792465,2795521,2798590,2871446,2872817,2874182,2875539,2876885,2878228,2879600,2882376,2885141,2887882,2890610,2893324,2896016,2898701,2901400,2904084,2906663,2909249,2911858,2914449,2917034,2919615,2922182,2924740,2927287,2929815,2932325,2934831,2937326,2937460,2939827,2939902,2939961,2942324,2942399,2942458,2942475,2944811,2944886,2944945,2944962,2947356,2947415,2947432,2949805,2949864,2949881,2952249,2952307,2952324,2954690,2954749,2954766,2957171,2957230,2957249,2959646,2959705,2959724,2962108,2962167,2962186,2964546,2964605,2964624,2966966,2967025,2967044,2969380,2969439,2969458,2971857,2971876,2974249,2974268,2976630,2976649,2978998,2979017,2981378,2981397,2983746,2983765,2986111,2986130,2988492,2988511,2990883,2993251,2995606,3023730,3025196,3026643,3028083,3029518,3030917,3030945,3032331,3032362,3033736,3033768,3035328,3035360,3036907,3036938,3038477,3038507,3040037,3040067,3041588,3041621,3043135,3043165,3044673,3044702,3046200,3046232,3047716,3047747,3049227,3049257,3050733,3050767,3052238,3052268,3053730,3053758,3055209,3055240,3056680,3056711,3058141,3058170,3059591,3059619,3061032,3061062,3062772,3062802,3064501,3064531,3064631,3066222,3066253,3066355,3067960,3068064,3069660,3069762,3071349,3071447,3073025,3073127,3074697,3074795,3076355,3076452,3078110,3079769,3081416,3083054,3084681,3086338,3087977,3089613,3091235,3092844,3094443,3096039,3097624,3099197,3100769,3102326,3103877,3105409,3106962,3108506,3132640,3134280,3135920,3137553,3139174,3140786,3142390,3143984,3145574,3147154,3147790,3148420,3149044,3149668,3151215,3152754,3154287,3155810,3157326,3158833,3160327,3161812,3163289,3164761,3166224,3167662,3169056,3170441,3171818,3173189,3174554,3175956,3177354,3178744,3180216,3181684,3183150,3184613,3184730,3186074,3186191,3187531,3187648,3188982,3189099,3190430,3190544,3191868,3191985,3193306,3193423,3194994,3195113,3196781,3196900,3198754,3198872,3200726,3200841,3202421,3202538,3204114,3204232,3205806,3205920,3207491,3207611,3209172,3209291,3210846,3210960,3212565,3212683,3214267,3214386,3215959,3216081,3217655,3217776,3219345,3219462,3221022,3221142,3222691,3222696,3222700,3222742,3222750,3222759,3222768,3222777,3222810,3224353,3224362,3224364,3224407,3224414,3224424,3224432,3224444,3224475,3225983,3225991,3225993,3226035,3226044,3226052,3226059,3226071,3226103,3227597,3227605,3227608,3227654,3227657,3227669,3227677,3227689,3227717,3229215,3229221,3229226,3229271,3229275,3229286,3229292,3229306,3229334,3230841,3230844,3230850,3230892,3230900,3230910,3230918,3230927,3230959,3232456,3232462,3232465,3232509,3232512,3232526,3232533,3232545,3232574,3234064,3234072,3234076,3234116,3234124,3234133,3234140,3234154,3234183,3235663,3235671,3235675,3235715,3235724,3235733,3235741,3235752,3235781,3237247,3237255,3237259,3237299,3237307,3237317,3237323,3237336,3237365,3238823,3238828,3238872,3238873,3238886,3238895,3238906,3238935,3240392,3240396,3240438,3240442,3240454,3240463,3240474,3240503,3241998,3242040,3242046,3242058,3242065,3242077,3242105,3243636,3243639,3243650,3243658,3243671,3243698,3245218,3245223,3245234,3245241,3245251,3245282,3246818,3246821,3246834,3246845,3246853,3246882,3248404,3248408,3248421,3248430,3248440,3248468,3249976,3249980,3249992,3249997,3250011,3250039,3251539,3251546,3251555,3251565,3251574,3251603,3253101,3253105,3253117,3253125,3253134,3253166,3254700,3254706,3254716,3254722,3254734,3254765,3256708,3256717,3256725,3256734,3256746,3256776,3258720,3258727,3258736,3258746,3258757,3258787,3260721,3260735,3260742,3260753,3260781,3262717,3262726,3262734,3262765,3264697,3264704,3264715,3264746,3266673,3266684,3266692,3266722,3268658,3268668,3268677,3268709,3268750,3270715,3270727,3270755,3270797,3272841,3272853,3272884,3272925,3274964,3274995,3275035,3277058,3277086,3277129,3279145,3279174,3279216,3281309,3281353,3283434,3283482,3285556,3285603,3287704,3287751,3289837,3289886,3291954,3292002,3294104,3296205,3298300,3300382,3302455,3304521,3306571,3308616,3310657,3312693,3314710,3316721,3318723,3403528,3403639,3405704,3405821,3407873,3407989,3410042,3410154,3412184,3412296,3414350,3414465,3416501,3416612,3418642,3418753,3420759,3420873,3422863,3422977,3425057,3427117,3429159,3431184,3433193,3435197,3437195,3439173,3441141,3443105,3445080,3447234,3449382,3451521,3453652,3455769,3457897,3460017,3462156,3464279,3466430,3468612,3470777,3472933,3475088,3477241,3479389,3534292,3536333,3538365,3540384,3542455,3544511,3546554,3548590,3550625,3552663,3554696,3556738,3558764,3560776,3562779,3564780,3566797,3568808,3570830,3572837,3574852,3576759,3578661,3580560,3582447,3584309,3586165,3588018,3589870,3591720,3593566,3595516,3596117,3597508,3598110,3600086,3602044,3603994,3605931,3607857,3609776,3611683,3613586,3615508,3617421,3619329,3621231,3623129,3625021,3626900,3628768,3630629,3632488,3634340,3636184,3638019,3639843,3641653,3643458,3645252,3647038,3648817,3650588,3652347,3654094,3655835,3657567,3659288,3661009,3662736,3664449,3666152,3667849,3669538,3671217,3672889,3674555,3676210,3677852,3679492,3681125,3682756,3684382,3686001,3687609,3689209,3690806,3692397,3693979,3695555,3697125,3698679,3700222,3701761,3703294,3704819,3706339,3707849,3709343,3710831,3712315,3713793,3715263,3716728,3718189,3719643,3721090,3722531,3723967,3725397,3726820,3728236,3729646,3731048,3732441,3733826,3735201,3736571,3737934,3739286,3740631,3741970,3743300,3744621,3745937,3747246,3748544,3749834,3751118,3752393,3753658,3754919,3756172,3757427,3758673,3759913,3761146,3762371,3763591,3764809,3766019,3767220,3768416,3769603,3769995,3770385,3770770,3771152,3771533,3771910,3772285,3772657,3773026,3773393,3773762,3774129,3774494,3774857,3775218,3775577,3775934,3776287,3776635,3776987,3777336,3777681,3778021,3778356,3778686,3779011,3779341,3779667,3779988,3780304,3780619,3780930,3781235,3781535,3781832,3782124,3782412,3782695,3782980,3783262,3783541,3783817,3784089,3784360,3784626,3784888,3785146,3785401,3785656,3785990,3786321,3786671,3787017,3787359,3787698,3788033,3788366,3788695,3789021,3789344,3789662,3789978,3790291,3790602,3790909,3791213,3791514,3791811,3792106,3792398,3792687,3792974,3793257,3793536,3793811,3794084,3794353,3794619,3794883,3795145,3795404,3795658,3807836,3808212,3808585,3808954,3809322,3809688,3836710,3836973,3837227,3837483,3837737,3837991,3847495,3847727,3847955,3848179,3848408,3848633,3848855,3849076,3849295,3849529,3849761,3850712,3850934,3851151,3851365,3851576,3851784,3851990,3852194,3852396,3852988,3853579,3854167,3854753,3893831,3893836,3894552,3894555,3895270,3895273,3895984,3895987,3896692,3896694,3897398,3897400,3898102,3898109,3898807,3898808,3899505,3899508,3900206,3900209,3900926,3910091,3910778,3911464,3912153,3912830,3913516,3914192,3914863,3915542,3916222,3916896,3917567,3918239,3918912,3919601,3920292,3923042,3923720,3924395,3925063,3925727,3926390,3927053,3927713,3946389,3947012,3947626,3948233,3948876,3949514,3953318,3953941,3954548,3955164,3955766,3956368,3957620,3979878,3980462,3981047,3998403,3998909,4125928,4125940,4125943,4126615,4126629,4126631,4127299,4127312,4127314,4127980,4127993,4127995,4128657,4128669,4128673,4129333,4129346,4129348,4130019,4130020,4130686,4130689,4131349,4131350)) 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





	Alexandra Iosifidi (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Alexandra Iosifidi (Dancer)

Alexandra Iosifidi (Dancer)

Diploma-recipient at the Vaganova-Prix International Competition.

Born in Leningrad. Graduated from the Vaganova Academy in 1995.
Joined the Mariinsky Theatre in 1995.

Repertoire:
Giselle (Myrtha);
La Bayadere (Grand pas classique), revised version by Vakhtang Chabukiani;
The Sleering Beauty (Lilac Fairy), revival of the 1890 production;
The Sleering Beauty (Lilac Fairy), revised version by Konstantin Sergeev;
Swan Lake (Big swans, Spanish Dance);
Scheherazade (Zobeide);
Le Sacre du printemps (The Chosen One);
Les Noces (the Bride);
Don Quixote (Street dancer, Mersedes);
The Fountan of Bakhchisarai (Zarema);
The Legend of Love (Dancers);
Pas de quatre (Maria Taglioni, Lucile Grahn);
Le Jeune Homme et La Mort ;
The Nutcracker (The Queen of the Snowflakes, Eastern Dance);
Cinderella (Stepmother), Le baiser de la fee(Fee), choreography by Alexei Ratmansky;
In the Middle, Somewhat Elevated;
Dances in the operas
Ruslan and Lyudmila (dances of Naina?s enchantments, soloist)
and Prince Igor (Captive).

Performed in Le Sacre du printemps (The Chosen One) at the Opera Nazionale of Italy (Rome, 2007).