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 (39537,39556,42429,42434,42470,42471,43814,43818,43854,43855,45171,45175,45211,45212,46520,46524,46560,46561,47863,47867,47903,47904,49200,49204,49240,49241,50532,50536,50572,50573,51856,51860,51896,51897,53173,53177,53213,53214,54486,54490,54526,54527,55797,55833,55834,57164,57200,57201,59275,59276,61344,61345,63405,63406,65457,65458,67504,67505,69550,69551,71590,71591,73623,73624,75648,75649,77662,77663,79671,79672,81675,81676,83673,83674,85663,85664,87646,87647,87793,89766,91730,93686,95637,97582,99518,101443,103358,105263,107160,109054,110936,112813,114675,116531,118403,120276,122146,124009,125864,127713,129545,131374,133203,135032,136855,138675,140488,142293,144089,145874,147649,149417,151173,152919,154656,156382,158098,159806,161529,163250,164997,183814,183815,183823,185452,185453,185461,187080,187081,187089,188698,188699,188707,190305,190306,190314,191900,191901,191909,193484,193485,193493,195069,195070,195080,195451,195452,195462,195833,195834,195844,196215,196216,196226,201843,201844,201854,203521,203522,203532,205193,205194,205204,206897,206898,206908,208591,208592,208602,210249,210250,210260,211815,211816,211827,213348,213349,213360,214886,214887,214898,216419,216420,216431,217950,217951,217962,219475,219476,219487,220996,220997,221008,222513,222514,222525,224025,224026,224037,225533,225534,225545,227041,227042,227053,228544,228545,228556,230040,230042,230053,232024,232025,232037,234018,234019,234031,236006,236007,236019,237987,237988,237999,239969,241932,243892,245850,247800,251724,251725,253704,253705,255676,255677,257641,257642,259612,259613,261577,261578,263534,263535,265498,265499,267454,267455,269401,269402,271341,271343,273280,273281,275209,275210,277139,277140,279064,279065,303484,305415,307345,309268,311186,313100,315009,316910,318804,320688,322564,324433,326337,328241,330137,358604,360507,362404,364293,366174,368052,369928,371796,373655,375505,377346,379180,381011,382836,384655,386467,388271,390079,391879,393678,395473,474109,474164,474165,475689,475744,475745,477266,477320,477321,478839,478895,478896,480406,480462,480463,481159,481213,481214,481903,481959,481960,482640,482696,482697,483375,483430,483431,484175,484176,484924,484925,485667,485668,486397,486398,487118,487119,487832,487833,488544,488545,489256,489257,489963,489964,490663,490664,491358,491359,492043,492044,492726,492727,493408,493409,494084,494085,494753,494754,495414,495415,496063,496064,496701,496702,498171,498172,499633,499634,501088,501089,501115,502536,502537,502563,504048,505526,506997,508469,509936,511396,512848,514327,515796,517257,557389,558789,560186,561576,562963,564340,565707,567067,568425,569779,571122,844481,847219,849951,852681,855411,858135,860855,863567,866268,868958,871642,874325,877005,879689,882369,885052,887721,890387,893047,895705,898353,991715,994321,996921,999509,1002091,1004673,1007242,1009804,1012357,1014925,1017483,1020030,1022572,1025113,1097762,1100044,1102316,1104574,1106811,1109027,1111222,1113399,1115557,1117698,1119833,1121963,1124101,1126296,1128486,1130699,1132895,1135085,1137290,1139490,1152569,1152630,1152633,1154717,1154781,1154782,1156853,1156915,1156916,1159021,1159082,1159083,1161176,1161237,1161238,1163316,1163377,1163380,1165448,1165509,1165510,1167585,1167646,1167649,1169715,1169776,1169777,1171898,1171899,1174013,1174016,1176159,1176162,1178294,1178297,1180422,1180425,1182541,1182544,1184651,1184654,1186766,1186767,1188872,1188873,1190971,1190972,1193059,1193060,1195138,1195139,1197214,1197215,1199276,1199279,1201337,1201340,1203393,1203394,1259424,1261371,1263305,1265230,1267160,1269080,1270989,1272887,1274771,1276640,1276771,1276780,1278495,1278626,1278636,1280349,1280481,1280491,1282194,1282322,1282332,1284025,1284156,1284166,1285849,1285980,1285990,1287660,1287791,1287801,1289585,1289595,1291370,1291380,1293180,1293190,1294982,1294992,1296777,1296787,1298563,1298573,1300334,1300344,1302094,1302104,1303842,1303852,1305590,1305600,1307330,1307340,1309060,1309070,1310778,1310788,1312697,1312707,1314614,1314624,1316548,1316558,1318475,1318485,1320394,1320404,1322303,1322313,1324204,1324215,1326091,1326102,1327962,1327972,1329820,1329831,1331707,1331718,1333584,1333595,1335451,1335462,1337307,1337318,1339152,1339163,1340993,1342810,1545856,1546941,1548014,1549077,1550132,1551180,1553338,1554373,1555400,1556418,1557428,1558436,1559434,1560792,1562141,1563984,1565817,1567642,1570562,1573455,1576338,1579211,1582072,1584919,1587757,1647069,1649880,1652749,1655612,1658460,1661297,1664120,1666935,1669739,1672595,1675447,2323369,2326507,2329637,2332748,2335850,2338946,2342042,2345149,2348248,2351344,2354463,2357570,2360671,2363766,2366851,2369925,2372990,2376040)) 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 Allash (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Maria Allash (Dancer)

Maria Allash (Dancer)

Biography
Born in Moscow. In 1994, she completed her studies at the Moscow Choreographic College (today the Moscow Choreographic Academy), where her teacher was Sophia Golovkina, and joined the Bolshoi Ballet Company.
Her permanent coach at the Bolshoi is Tatiana Golikova.

Main Repertory

1994
Mazur, 11th  Waltz (Chopiniana)

1995
Queen of the Dryads (Don Quixote. Yuri Grigorovich production)
Countess Cherry (Cipollino. Music by Karen Khachaturyan. Production by Genrikh Mayorov)
Myrtha (Giselle. Vladimir Vasiliev production; then Yuri Grigorovich production)

1996
Spanish Bride (Swan Lake. Yuri Grigorovich production) 
Gamzatti (La Bayadere. Yuri Grigorovich production)
Swan/Two Swans (Swan Lake. Vladimir Vasiliev production) - creation

1997

A street dancer (Don Quixote
Clemence, 1st variation in Raymonda's Dreams, Henriette (Raymonda. Yuri Grigorovich production)
Fairy of Sapphire, Lilac Fair (The Sleeping Beauty. Yuri Grigorovich production)
3rd variation in The Shadows (La Bayadere)
1st variation grand pas (Don Quixote
Fairy of Gold (The Sleeping Beauty)

1998 
'Four' ("Mozartiana) - creation at at Bolshoi Theatre
Mekhmene Banu
(A Legend of Love. Music by Arif Melikov. Yuri Grigorovich production)

1999
Horse
(The Humpbacked Horse. Music by Rodion Shchedrin. Nikolai Androsov production) - creation
"Two pairs" in Part 3
(Symphony in C) - creation at at Bolshoi Theatre
Aegina
(Spartacus)

2001
Swan/Three Swans
, Hungarian Bride, Friend to the Prince (Swan Lake. Yuri Grigorovich new production) 

2003

Title role (Raymonda)

2004
Odette-Odile
(Swan Lake)
Leading Soloist (Concerto Barocco)
Soloist Part 3 (Symphony in C)
Lea (Lea to music by Leonard Bernstein. Alexei Ratmansky production)

2005
Nikia (La Bayadere)
Hyppolita/Titania (A Midnight's Summer Dream. John Neumeier production)
Passion (Les Presages to music by Pyotr Tchaikovsky. Choreography by Leonide Massine) - creation in Russia
Kitri (Don Quixote. Alexei Fadeyechev production)

2006
Rita (The Golden Age. Music by Dmitry Shostakovich. Yuri Grigorovich production)

2007
Serenade (choreography by Georges Balanchine) - creation at Bolshoi Theatre
Class Concert
 (to music by different composers; choreography by  Asaf Messerer)

2009
Fleur de Lys (Esmeralda by Cesare Pugni, choreography by Marius Petipa, staging and new choreographic version by Yuri Burlaka and Vasily Medvedev) - creation

Awards

In 2002, she was awarded the title of Merited Artist of the Russian Federation.