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.date>='2024-04-22' AND tmp.date<='2024-05-12' AND tmp.perf_id=2769) ORDER BY date ASC, ves DESC, time ASC
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

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.date>='' AND tmp.date NOT BETWEEN '2024-04-22' AND '2024-05-12' AND tmp.perf_id=2769) ORDER BY date ASC, ves DESC, time ASC
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

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.date>='' AND tmp.perf_id<>2769 AND tp.id_base=-1 AND tmp.city_id=1 ORDER BY date ASC, ves DESC, time ASC
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

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.date>='' AND tmp.perf_id<>2769 AND tp.id_base=-1 AND tmp.city_id=2 ORDER BY date ASC, ves DESC, time ASC
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





	19 January 2020, 19:00 - Grand Jubilee Concert "Hibla Gerzmava and Friends" - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow Kremlin Theatre of Classical Russian Ballet 19 January 2020, 19:00 - Grand Jubilee Concert "Hibla Gerzmava and Friends"
19January
19:00
2020 | Sunday
Opera
Moscow Kremlin Theatre of Classical Russian Ballet, Moscow
The brilliant opera diva, the “golden soprano of Russia”, the owner of the voice of divine beauty and phenomenal dramatic talent, Hibla Gerzmava, has long been in need of special performances. The most famous scenes of the world - the Metropolitan Opera and the Royal Theater Covent Garden, the Vienna Opera and Carnegie Hall, the opera houses of Paris, Rome, Munich, Madrid and Barcelona, ​​the most famous conductors and directors invite the singer to their productions, each new role in the performances of leading Russian theaters (Bolshoi Theater, Mariinsky Theater, Stanislavsky and Nemirovich-Danchenko Moscow Music Theatre) is invariably accompanied by a train of rave reviews and a never-ending cascade of awards: two Golden Masks, Casta Diva , BraVo, Triumph, Golden Orpheus "...

Guests of the evening: Anna Netrebko (soprano), Yusif Eyvazov (tenor), Denis Matsuev (piano), Vladimir Spivakov, Inna Churikova, Chulpan Khamatova and many others.

Every solo project of Hibla Gerzmava in Moscow is always an event of the year in the world of classical music. A stunning fusion of brilliant classical virtuosity, modern drive and the incredible charisma of a true diva, amazing sophistication and a sense of style in everything from program selection to costumes and scenography - this is what sets Hibla's concerts out of hundreds of other classical concerts and allows eyewitnesses to compare these luxurious show with the world opera and classical crossover shows - Sarah Brightman, Andrea Bocelli, Joyce DiDonato.

The grand anniversary concert “Hibla Gerzmava and Friends” was conceived as a grand theatrical show full of bright emotions and surprises, with a spectacular program that takes you into the magical world of classical opera, incredible harmony in everything, a sea of ​​flowers and ovations - enthusiastic, stormy, long.

For the audience this evening will be not only a unique opportunity to enjoy the vocal art of the brilliant Hibla Gerzmava, but also a rare chance to see the most famous artists of our time in one project: Anna Netrebko, Yusif Eyvazov and Ekaterina Gubanova, world opera stars, famous virtuoso pianist Denis Matsuev, outstanding violinist and conductor Vladimir Spivakov, brilliant Russian actress Inna Churikova, famous artist and prominent public figure Chulpan Khamatova and many others will congratulate a colleague and friend in the Kremlin Palace.

Would you like to witness how the multi-thousandth hall in an instant turns into a single enthusiastic listener? - come to this grand festival of beautiful music, to a meeting with great artists of the 21st century.

Casts & Credits