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 (3817746,3818131,3818535,3818933,3819323,3819714,3820098,3820483,3820861,3821235,3821606,3821971,3822334,3822697,3823051,3823406,3823750,3824092,3824436,3824774,3825112,3825448,3825776,3826104,3826424,3826745,3827059,4035079,4037295,4038213,4039128,4040037,4040940,4041840,4042736,4043631,4044519,4045403,4046281,4047151,4260377,4260683,4260985,4261281,4261574,4261863,4262149,4262433,4262714,4262991,4263263,4263532,4285144,4285273,4285399,4285522,4285643,4285762,4285879,4285994,4286106,4286215,4286321,4286425,4286527,4286626,4286724,4286819,4286910,4286999,4287086,4287170,4287251,4287331,4287409,4287486,4287562,4287636,4287709,4287781,4287852,4287922,4287990,4288056,4288121,4288184,4288244,4288302,4288357,4288409,4288459,4288508,4288555,4288600,4288642,4288717,4288788,4288856,4288922,4288987,4289049)) 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

	Khibla Gerzmava - ДОБАВИТЬ ПРЕФИКС "Stars of the Stars" (Soloist) - uVisitRussia



Home Theaters Khibla Gerzmava - ДОБАВИТЬ ПРЕФИКС "Stars of the Stars" (Soloist)

Khibla Gerzmava - ДОБАВИТЬ ПРЕФИКС "Stars of the Stars" (Soloist)

Born on January 6, 1970 in Pitsunda (USSR).
Graduated from the Moscow State Conservatoire in 1994 (teachers - professor Irina Maslennikova, professor Evgenia Arefieva), and completed the post-graduate course of the Moscow Conservatoire in 1996. Since 1995 she has been a soloist of the Stanislavsky and Nemirovich-Danchenko Moscow academic Music Theater (Stanislavsky Opera). Took part in the performances of the Mariinsky Theater, «Theatre des Champs Elysees» and «Theatre du Chatelet» in Paris (France), Teatro Comunale di Firenze (Italy), Gran Teatro del Liceu in Barcelona (Spain), Opera of Sofia (Bulgaria), Tokyo Bunka Kaikan (Japan). Parts performed in the productions of the Stanislavsky Opera: Ludmila («Ruslan and Ludmila» by M. Glinka), The Swan («The Tale of Tsar Saltan» by N. Rimsky-Korsakov), Queen of Shemakha («The Golden Cockerel» by Rimsky-Korsakov), Louise («Wedding in the Monastery» by S. Prokofiev), Nymph («Daphne» by M. da Gagliano), Rosina («Il Barbiere di Siviglia» by G. Rossini), Adina («L‘Elisir d‘Amore» by G. Donizetti), Violetta («La Traviata» by G. Verdi), Musetta and Mimi («La Boheme» by G. Puccini), Adele («Die Fledermaus» by I. Strauss). Parts performed in Europe also include: Lucia («Lucia di Lammermoor» by Donizetti), Zerlina («Don Giovanni» by Mozart), Parasha («Mavra» by I. Stravinsky). Took part in the international tours of the Stanislavsky Opera (South Korea, 1997 and 2003; USA, 2002, 2004). Toured Sweden, France, Holland, Austria, Belgium, Spain, Greece, USA, Japan, Turkey. Participated in the Ludwigsburg Festival in 2002 and 2003 (sang the part of Eva in «Die Schopfung» by I. Hayden and the part of Angel in «La Rappresentazione di Anima e di Corpo» by E. dei Cavalieri). Patronized the Classical Music Festival «Khibla Gerzmava invites» in Pitsunda (Abkhasia). The prize-winner of the International Competition «Voci Verdiani» in Busseto (Italy, 1993), the International Francisco Vinas Competition in Barcelona (Spain, 1994), the International N. Rimsky-Korsakov Competition in Saint-Petersburg (1994). Grand Prix of the International Tchaikovsky Competition (Moscow, 1994). The «Best Singer» Award of «The Golden Orpheus» Opera Festival in Moscow (2001). CD: «Ave Maria» Khibla Gerzmava. DICJ-25008; Khibla Gerzmava sings Russian Romances. DMCC - 26015; Oriental Romances Hibla Gerzmava. DICC - 28006; World Premiere. The Music of Aldo Finzi. Bel Air Music BAM 2029; Musical Assemblies at the Tretiakov‘s House. Copyright - Musica Viva, 2002