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=175) 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=175) 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<>175 AND tp.id_base=508 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<>175 AND tp.id_base=508 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





	30 November 2018, 19:00 - Giacomo Puccini "La Boheme" (opera in 4 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 30 November 2018, 19:00 - Giacomo Puccini "La Boheme" (opera in 4 acts)
30November
19:00
2018 | Friday
Opera
Bolshoi theatre - Small Stage, Moscow
Duration: 2 hours 30 minutes
World premiere: Turin Teatro Regio, 1 February 1896

There are few productions in the world of opera that could compete with this lyrical drama. It is not pretentious, convoluted or emotional — here, the art of opera and the real world collide. It was not by chance that Puccini turned to the only book by Murger that survived its author: The composer knew the protagonists very well: at times, during his studies at the Milan Conservatory, he too had to go without food, just like them. Later, at the time of success and financial independence, he was a centre of the crowd of artists, painters and writers, nicknamed on his initiative ‘The Bohemian Club.’ The composer conceived the idea of the opera in 1893. The opera was created to an Italian libretto by Luigi Illica (1853-1919) and Giuseppe Giacosa (1847-1906), yet it was Puccini who shaped the plan and sketched the characters of the protagonists, who differ from those in the original. Puccini was absorbed by the opera and started composing it in 1894, when the libretto wasn’t ready yet. Puccini wrote his opera La bohème contemporaneously with Leoncavallo’s own treatment of the same story. The rivalry ended in a quarrel. By the end of 1985 Puccini’s La bohème was ready and received its première on 1 February 1896 in Turin.

Libretto by Giuseppe Giacosa and Luigi Illica based on Henry Murger`s novel Scenes de la Vie de Bohème 

Music Director: Evan Rogister
Director: Jean-Romain Vesperini
Set Designer: Bruno de Lavenere
Costume Designer: Cedric Tirado
Lightning Designer: Christophe Chaupin
Video Designer: Étienne Guiol

Casts & Credits

Composer: Giacomo Puccini
Opera company: Bolshoi Opera
Baritone: Yuri Syrov
Soprano: Damiana Mizzi
Soprano: Dinara Alieva
Tenor: Rame Lahaj
Designer: Marina Azizyan
Musical Director: Peter Feranec
Stage Director: Federik Mirdita
Composer: Giacomo Puccini
Opera company: Bolshoi Opera
Baritone: Yuri Syrov
Soprano: Damiana Mizzi
Soprano: Dinara Alieva
Tenor: Rame Lahaj
Designer: Marina Azizyan
Musical Director: Peter Feranec
Stage Director: Federik Mirdita