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 (8401,8404,10108,10111,11691,11694,13274,13277,14691,14693,14727,16144,16146,16179,17755,17756,17789,19162,19163,19187,20630,22114,23568,25030,26776,27673,29104,30978,32490,34157,35548,35588,35591,37130,37132,37139,37190,38677,38683,38687,38745,40139,40192,41621,41650,43016,43043,43104,43124,43129,44374,44402,44463,44482,44487,45726,45754,45815,45834,45839,47071,47099,47160,47179,47184,48413,48440,48501,48521,48526,49744,49772,49833,49856,49860,51072,51100,51161,51184,51188,52391,52419,52479,52503,52507,53706,53734,53794,53817,53821,55015,55043,55103,55126,55130,56318,56346,56406,56425,56430,57710,57771,57790,57794,59780,59840,59860,59864,61843,61903,61922,61926,63899,63958,63979,63982,65946,66005,66024,66028,67990,68050,68069,68073,70092,70111,70115,72129,72148,72152,74159,74178,74182,76177,76196,76200,78187,78206,78210,80193,80212,80216,82192,82211,82215,84185,84204,84208,86170,86189,86193,88148,88167,88171,90115,90135,90139,92073,92093,92097,94026,94046,94050,95975,95994,95999,97933,97938,99862,99867,101783,101788,103696,103697,105600,105610,105615,105688,105732,107505,107509,107582,107626,109391,109395,109469,109513,111272,111346,111390,113215,113258,115075,115119,116951,116995,118826,118870,120696,120740,122562,122610,124420,124468,126269,126317,128109,128157,129938,129986,131767,131815,133600,133648,135425,135473,137246,137294,139063,139112,140873,140922,142673,142723,144463,144513,146293,148064,149820,151570,153310,153397,153418,155040,155128,155149,156761,156849,156870,158472,158560,158581,160286,160306,162013,162033,163744,163768,165486,165510,167217,167241,168936,168961,170648,170673,172352,172377,174046,174071,175730,175754,177403,177427,179066,179090,180725,180744,182372,182391,184012,184031,185643,185667,187265,187289,188877,188901,190477,190501,192090,193668,196422,197736,199053,200370,202052,203723,205397,207095,274175,274197,276109,276131,278034,278056,279911,279933,281779,281801,283638,283659,285494,285516,287349,287371,289191,289213,289323,289327,289331,291027,291049,291161,291165,291169,292923,292945,293057,293061,293065,294812,294838,294946,294950,294953,296692,296718,296826,296830,296834,298570,298592,298700,298704,298708,300441,300463,300570,300574,300578,302350,302462,302466,302470,304233,304344,304348,304352,306159,306275,306280,306284,308083,308199,308204,308208,310117,310122,310125,312031,312036,312039,313940,313945,313948,315845,315850,315853,317743,317748,317751,319633,319638,319641,321512,321517,321520,323382,323387,323390,325277,325282,325285,327172,327182,327184,329076,329081,329084,330967,330972,330975,332853,332858,332861,334728,334733,334736,336594,336599,336602,338459,338465,338468,340341,340346,340350,342265,342270,342274,342314,342319,342339,344188,344192,344198,344238,344242,344263,346104,346108,346114,346154,346158,346179,348011,348015,348021,348060,348065,348086,349901,349905,349911,349950,349955,349976,351777,351786,351789,351828,351834,351855,353657,353661,353667,353706,353712,353731,355527,355535,355539,355579,355585,355604,357404,357412,357417,357456,357462,357481,359311,359319,359323,359363,359369,359388,361210,361218,361222,361262,361268,361287,363110,363114,363154,363159,363178,364995,365036,365042,365061,366875,366914,366920,366939,368794,368799,368819,370663,370670,370689,372527,372534,372553,374382,374389,374407,376226,376231,376252,378061,378067,378087,379894,379899,379920,381722,381726,381748,383546,383550,383571,385361,385366,385383,387173,387194,389002,390806,392606,394400,396191,457330,458895,478004,478016,479576,479583,481139,481151,481887,481898,482624,482636,483358,483370,484101,484112,484852,484863,485597,485608,486335,486346,487059,487070,487774,487785,488484,488496,489199,489210,489908,489918,490609,490620,491308,491319,491998,492006,492676,492685,493358,493366,494036,494044,494708,494716,495381,496037,497363,497407,497416,497421,498827,498871,498880,498885,500281,500326,500335,500341,501735,501780,501791,501795,503227,503275,503283,503285,504706,504751,504759,504766,506177,506228,506229,506238,507651,507699,507707,507709,509118,509163,509170,509178,510581,510627,510634,510641,512087,512088,512096,513531,513539,513545,515003,515012,515016,516465,516473,516480,517919,517927,517934,519363,519369,519377,520810,520811,520819,522247,522255,522256,523676,523684,523687,525102,525106,526515,528021,528035,529425,529439,530825,530839,532219,532233,533606,533618,535039,535052,536463,536476,537892,537906,539301,539309,539317,539330,539355,539371,539410,540717,540725,540733,540746,540771,540785,540826,542141,542151,542157,542165,542178,542203,542217,542252,543583,543594,543599,543609,543620,543644,543666,543697,545052,545064,545069,545079,545090,545114,545136,545167,546506,546516,546523,546532,546544,546568,546589,546621,547966,547978,547979,547991,548000,548024,548045,548077,549417,549429,549435,549441,549451,549475,549496,549528,550860,550872,550878,550884,550898,550918,550938,550971,552307,552313,552320,552334,552354,552374,552407,553732,553738,553744,553757,553782,553796,553835,555154,555160,555173,555198,555212,555251,556567,556580,556605,556618,556658,557970,557984,558008,558020,558060,559381,559404,559417,559457,560773,560797,560810,560849,562160,562184,562196,562236,563565,563578,563617,564935,564948,564987,566295,566308,566350,567654,567673,567709,569009,569021,569063,570369,570411,571715,571746,573088,573123,574495,575856,577214,578566,579907,581240,582568,583955,584019,585272,585332,586579,586641,587886,587945,589182,589241,590822,590882,592439,592500,594069,594129,595769,595829,597459,597519,599140,599199,600812,600872,602548,604215,605873,607521,609164,610851,612530,614205,615867,615940,616005,616017,617516,617589,617654,617665,619147,619227,619290,619302,620782,620854,620920,620931,622401,622481,622544,622556,624095,624158,624170,625720,625783,625795,627334,627398,627414,628939,629003,629017,630534,630598,630613,632123,632187,632202,633707,633771,633786,635280,635347,635358,636842,636909,636920,638399,638462,638473,639938,640000,640012,641468,641529,641542,642987,643050,643062,644497,644562,644575,646003,646068,646081,647505,647564,647579,649055,649069,650551,650563,652031,652045,653507,653521,654973,654987,656427,656442,657872,657889,659321,659338,660762,660774,662188,662200,663607,663625,665022,665034,666441,667876,669299,693939,693958,694002,694019,694040,695187,695206,695250,695267,695288,696419,696434,696481,696500,696519,697639,697654,697701,697719,697738,698846,698862,698906,698926,698946,700042,700060,700103,700123,700142,701231,701249,701297,701311,701330,702427,702446,702490,702507,702528,703612,703630,703678,703692,703710,704805,704852,704867,704885,705961,706009,706024,706045,707108,707152,707169,707190,708284,708301,708320,709406,709423,709442,710552,710567,710588,711692,711708,711729,712829,712846,712867,713957,713974,713995,715072,715090,715105,716193,716207,717283,717304,718367,718386,719457,720516,721565,859670,859671,862387,862395,865094,865102,867788,867797,870472,870481,873154,873163,875836,875846,875884,875943,878523,878532,878571,878629,881207,881216,881254,881313,883901,883940,883999,886615,886674,889281,889340,891943,892002,894597,894657,897250,897311,899905,899961,902540,902602,905173,905231,907848,910462,913073,915705,918409,921102,921121,921150,921156,921207,921224,923780,923800,923826,923836,923887,923907,926471,926491,926519,926529,926578,926596,929189,929207,929232,929243,929295,929313,931898,931916,931946,931952,932001,932018,934605,934623,934648,934659,934709,934726,937310,937328,937352,937364,937414,937431,940059,940089,940095,940144,940162,942777,942806,942813,942862,942879,945482,945511,945521,945567,945584,948184,948213,948223,948269,948286,950919,950928,950975,950992,953619,953628,953674,953692,956309,956318,956364,956382,958986,958995,959040,959058,961641,961649,961695,961713,964289,964338,964352,966925,966974,966988,969557,969606,969620,972234,972248,974853,974874,977465,977486,980072,980093,982663,982684,985250,985267,987874,987891,990493,990510,993107,993127,995714,995731,995792,995802,995865,995873,998309,998325,998387,998397,998459,998468,1000893,1000908,1000971,1000981,1001043,1001052,1003474,1003490,1003552,1003562,1003624,1003633,1006064,1006125,1006135,1006197,1006205,1008637,1008692,1008705,1008764,1008772,1011196,1011251,1011264,1011323,1011331,1013775,1013831,1013844,1013903,1013911,1016396,1016406,1016467,1016476,1018943,1018957,1019015,1019025,1021490,1021504,1021562,1021572,1024035,1024049,1024107,1024117,1026570,1026583,1026645,1026652,1029099,1029113,1029175,1029182,1031625,1031638,1031701,1031706,1034127,1034141,1034204,1034209,1036617,1036631,1036694,1036699,1039110,1039120,1039183,1039188,1041594,1041604,1041667,1041676,1044070,1044080,1044143,1044152,1046537,1046545,1046610,1046619,1048993,1049002,1049067,1049076,1051446,1051510,1051520,1053879,1053939,1053950,1056306,1056366,1056377,1058788,1058799,1061197,1061208,1063598,1063609,1065992,1066003,1068376,1068384,1070745,1070754,1073145,1073154,1073186,1073204,1075538,1075546,1075578,1075596,1077921,1077929,1077961,1077979,1080292,1080300,1080332,1080350,1082652,1082659,1082692,1082710,1082781,1082822,1084997,1085004,1085037,1085054,1085125,1085167,1087325,1087332,1087362,1087383,1087454,1087496,1089652,1089682,1089702,1089774,1089815,1091982,1092013,1092031,1092104,1092145,1094335,1094351,1094426,1094467,1096645,1096661,1096735,1096777,1098942,1098957,1099032,1099073,1101219,1101234,1101309,1101350,1103490,1103505,1103580,1103621,1105739,1105755,1105830,1105871,1107990,1108061,1108098,1110197,1110268,1110305,1112454,1112492,1114622,1114659,1116775,1116809,1118910,1118947,1121041,1121075,1123180,1123218,1125314,1125353,1127505,1127543,1129724,1129763,1131931,1131967,1134121,1134158,1136325,1136362,1136450,1138527,1138567,1138652,1140725,1140765,1140849,1142916,1142955,1143040,1145137,1145223,1147307,1147393,1149464,1149549,1151617,1151702,1153761,1153851,1155905,1155990,1158078,1158163,1160243,1160321,1162470,1164603,1166733,1168867,1170992,1173108,1175219,1177359,1179489,1181615,1183730,1185836,1187946,1190047,1192140,1194221,1196299,1198374,1200439,1412266,1414029,1415783,1442453,1444043,1445623,1447192,1447200,1447206,1447207,1448759,1448765,1448766,1450309,1450310,1716116,1718886,1721639,1724381,1727120,1729852,1732563,1735267,1737962,1740645,1802567,1805005,1807426,1809829,1812210,1814565,1816911,1819235,1821532,1823804,1826053,1828277,1830479,1832667,1834866,1837058,1839242,1841410,1843563,1845703,1847856,1850008,1852154,1854294,1856436,1858563,1860679,1862794,1864905,1867006,1869093,1871173,1873238,1875293,1877346,1879421,1971147,1971181,1971190,1973155,1973191,1973195,1975154,1975188,1975197,1977138,1977173,1977182,1979111,1979145,1979154,1981107,1981142,1981149,1983099,1983134,1983141,1985120,1985129,1987098,1987104,1989067,1989074,1991022,1991029,1992962,1992971,1994899,1994907,1996828,1996836,1998750,1998759,2000673,2112758,2114664,2116566,2118456,2120337,2122208,2124068)) 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





	Sofia Ivanova-Skoblikova (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Sofia Ivanova-Skoblikova (Dancer)
			

																
Sofia Ivanova-Skoblikova (Dancer)

														
				


        




    

        
Born in St Petersburg.
Graduated from the Vaganova Academy of Russian Ballet in 2013 (class of Veronika Ivanova).
Joined the Mariinsky Ballet in 2013. 
Repertoire includes: 
La Sylphide (Effie); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen, 
Swan Lake (Prince's Friends); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
Raymonda (variation in the scene The Dream); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
Le Corsaire (Trio of Odalisques); production by Pyotr Gusev after the composition and choreography of Marius Petipa,
The Fountain of Bakhchisarai (Young Polish Women); choreography by Rostislav Zakharov,
The Nutcracker (Doll); choreography by Vasily Vainonen, 
Don Quixote (Flower-Seller); choreography by Alexander Gorsky after motifs of the choreography by Marius Petipa, 
The Legend of Love (Gold Dance); choreography by Yuri Grigorovich 
and Alexei Ratmansky’s ballets Cinderella (Kubyshka) and The Little Humpbacked Horse (Wet-Nurse). 
Repertoire also includes: 
the pas de deux from the ballet Le Carnaval de Venise; choreography by Marius Petipa. 
        

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy