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 (477486,477493,479060,479067,480628,480635,481381,481387,482127,482132,482864,482869,483598,483602,484350,484355,485099,485104,485842,485847,486571,486577,487292,487298,488006,488012,488720,488725,489432,489437,490139,490144,490838,490844,491533,491539,492218,492224,492901,492907,493583,493589,494259,494265,494928,494934,495589,495595,496239,496244,496877,496882,498347,498352,499809,499814,501264,501269,502710,502717,504196,504202,505672,505679,507143,507150,508615,508622,510082,510089,511542,511549,512995,513001,514475,514480,515945,515950,517406,517411,518857,518862,520301,520306,521742,521747,523176,523181,524601,524606,526017,526022,527424,527429,528830,528835,530234,530238,531632,531636,533022,533027,534462,534467,535892,535897,537323,537328,538751,538757,540172,540178,541584,541590,543034,543039,544508,544515,545978,545984,547432,547438,548887,548893,550336,550342,551777,551783,553210,553216,554631,554637,556044,556049,557450,557455,558850,558855,560247,560252,561637,561642,563023,563029,564399,564405,565766,565772,567125,567131,568484,568490,569838,569844,571181,571187,572564,572570,573944,573950,575313,575319,576673,576679,578030,578036,579381,579386,580720,580725,582049,582054,583379,583384,584698,584704,586011,586017,587320,587326,588621,588627,589922,589934,591542,591553,593182,593192,594887,594898,596584,596595,598270,598280,599946,599957,601629,601637,603299,603310,604973,606627,712359,712367,713491,713498,714612,714620,715721,715729,716819,716827,717907,717915,718985,718993,720051,720059,721106,721114,722164,722172,723226,723234,724278,724286,725321,725329,726354,726362,727379,727387,728396,728404,729403,729411,730403,730411,731395,731403,732382,732390,733376,733384,734363,734371,735342,735350,736309,736317,737281,737289,738245,738253,739201,739208,740151,740159,742119,742127,744092,744100,746057,746065,748018,748027,750000,750009,751982,751991,754861,754870,757734,757743,760600,760609,763463,763472,766322,766331,769175,769184,772021,772030,774861,774870,777696,777703,780527,780536,783361,783370,786192,786201,789018,789027,791840,791849,794659,794667,797468,797476,800273,800280,803073,803082,805869,805877,808658,808666,811440,811449,814219,814228,816993,817002,819760,819768,822519,822528,825271,825280,828017,828026,830758,830767,833497,833506,836229,836238,838959,838968,841693,844412,1188934,1191033,1193121,1195200,1197276,1199343,1201404,1203458,1205507,1207544,1209573,1211612,1213643,1215665,1217674,1219668,1221651,1223627,1225598,1227591,1229605,1424038,1424044,1425727,1425733,1427401,1427407,1429065,1429071,1430715,1430721,1432355,1432361,1433986,1433992,1435602,1435608,1437207,1437213,1438828,1438834,1440436,1440442,1442038,1442044,1443632,1443638,1445216,1445222,1446789,1446795,1448353,1448359,1449905,1449911,1451445,1451451,1452975,1452981,1454495,1454501,1456009,1456018,1457511,1457520,1459002,1459011,1460481,1460490,1461947,1461956,1463403,1463412,1464849,1464858,1466281,1466290,1467703,1467712,1469112,1469121,1470506,1470515,1471887,1471896,1473255,1473264,1474614,1474623,1475960,1475969,1477311,1477320,1478659,1478668,1480043,1480052,1481415,1481424,1482776,1482785,1484132,1484141,1485476,1485485,1486811,1486820,1488135,1488144,1489441,1489450,1490736,1490745,1492022,1492031,1493336,1493345,1494641,1494650,1495938,1495947,1497231,1497241,1498534,1498544,1499827,1499837,1501110,1501120,1502386,1502396,1503654,1503664,1504915,1504925,1506168,1506178,1507415,1507425,1508652,1508662,1509880,1509890,1511102,1511112,1512327,1512337,1513555,1513565,1514776,1514786,1515999,1516009,1517214,1517224,1518420,1518430,1519619,1519629,1520815,1520825,1522005,1522015,1523188,1523198,1524363,1524373,1525531,1525541,1526692,1526702,1527847,1527857,1528996,1529006,1530141,1530151,1531282,1531292,1532416,1532429,1533548,1533561,1534676,1534689,1535800,1535813,1536919,1536932,1538032,1538045,1539169,1539182,1540299,1540312,1541424,1541437,1542543,1542556,1543654,1543667,1544759,1544772,1545857,1545870,1546942,1546955,1548015,1548028,1549078,1549091,1550137,1550147,1551185,1551195,1552224,1552234,1553275,1554310,1647464,1647471,1650276,1650281,1653146,1653151,1656005,1656010,1658853,1658858,1661690,1661695,1664513,1664518,1667326,1667333,1670132,1670137,1672991,1672996,1675843,1675848,1678690,1678698,1681527,1681532,1684354,1684361,1687222,1687229,1690076,1690084,1692930,1692937,1695696,1695703,1698458,1698465,1701211,1701218,1703955,1703962,1706692,1706699,1709463,1709470,1712226,1712233,1715010,1715017,1717785,1717792,1720547,1720554,1723294,1723301,1726035,1726042,1728770,1728777,1731496,1731503,1734204,1734211,1736903,1736910,1739591,1739598,1742265,1742272,1744929,1744936,1747587,1747594,1750236,1750243,1752878,1752885,1755511,1755518,1758135,1758144,1760746,1760755,1763349,1763355,1765946,1765953,1768539,1768546,1771124,1771131,1773700,1773707,1776274,1776281,1778833,1778840,1781382,1781389,1783924,1783931,1786456,1786463,1788961,1788968,1791455,1791462,1793931,1793938,1796388,1796395,1798830,1798839,1801291,1801298,1803736,1803743,1806161,1806168,1808570,1808582,1810962,1810970,1813325,1813332,1815674,1815681,1818006,1818013,1820313,1820320,1822594,1822601,1824850,1824857,1827083,1827090,1829295,1829301,1831487,1831494,1833673,1833680,1835871,1835882,1838061,1838071,1840240,1840251,1842400,1842410,1844545,1844555,1846685,1846692,1848839,1848845,1850988,1850994,1853137,1855273,3255798,3257813,3259814,3261802,3263784,3265762,3267750,3269802,3271895,3274010,3276109,3278199,3280304,3282434,3284558,3286677,3288817,3290940,3293049,3295152,3297248,3299336,3301415,3303482,3305537,3307584,3309628,3311664,3313686,3315700,3317704,3319698,3321684,3323667,3325811,3328080,3330463,3332833,3335190,3337540,3339886,3342225,3344586,3346938,3349281,3351609,3353930,3356248,3358596,3360961,3363318,3365662)) 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





	Venera Gimadieva (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Venera Gimadieva (Soprano)

Venera Gimadieva (Soprano)

Biography

Venera Gimadieva graduated from Kazan Musical College. In 2009 she graduated from the St. Petersburg State Conservatoire (Svetlana Gorenkova’s class).
In 2008 she joined the St. Petersburg Opera theatre.

In October, 2009, Venera Gimadieva joined the Bolshoi Theatre Young Artists Program.
Since 2011, she has been soloist with the Bolshoi Theatre Opera Company.

Repertoire

At the Bolshoi:
Sirin (The Legend of the Invisible City of Kitezh and of the Maiden Fevronia)
title role (The Snow Maiden)
The Tsaritsa of Shemakha (The Golden Cockerel)
Marfa (The Tsar’s Bride)
Xenia (Boris Godunov)
Violetta (La Traviata)
Amina (La Sonnambula)
A Voice from Heaven (Don Carlo)

Also in repertoire:
title role (Lucia di Lammermoor)
Gilda (Rigoletto)
Lucia (The Rape of Lucretia)
Genovieffa (Suor Angelica)
Serafina (Il campanello di notte)

Tours

Venera Gimadieva is a guest soloist of Kazan State Theatre of Opera and Ballet.
In February, 2010, she sang Serpina in concert performance of Pergolesi’s La serva padrona with Moscow Chamber Orchestra Musica Viva, conductor Alexander Rudin. She toured with the Bolshoi Theatre Young Artists Program singers in Baku and Washington, and she performed at the Moscow Conservatoire Big Hall with Moscow Philharmonic Academic Orchestra, conductor Yuri Simonov.

Awards

Prize at the Rimsky-Korsakov International Competition in St. Petersburg (2008).
Diploma at the Opera Singers International Competition in Dresden (2009).
The 1st Prize at the Chaliapin International Competition in Ples, Russia (2010).
Prize of the President of the Russian Federation (2012).
The Golden Mask National Theatre prize for the role of Amina in La Sonnambula (2014).