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=634) 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=634) 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<>634 AND tp.id_base=764 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

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<>634 AND tp.id_base=764 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





	20 December 2017, 19:00 - The Gambler (Opera in Four Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 20 December 2017, 19:00 - The Gambler (Opera in Four Acts)
20December
19:00
2017 | Wednesday
Opera
Mariinsky Theater, Saint Petersburg
Duration: 2 hours 35 minutes
World premiere: Third Mariinsky Theatre production, 5 December 1991

Music by Sergei Prokofiev
Libretto by Sergei Prokofiev based on the novel of the same name by Fyodor Dostoevsky
Musical Director: Valery Gergiev
Director: Temur Chkheidze
Set Designer: Zinovy Margolin
Costume Designer: Tatyana Noginova
Lighting Designer: Gleb Filshtinsky
Directed by Yuri Laptev
Responsible accompanist: Marina Mishuk
Chief Choirmaster: Andrei Petrenko

World premiere: 29 April 1929, Theatre Royal de la Monnaie, Brussels
First Mariinsky Theatre production: 5 December 1991
Second Mariinsky Theatre production: 18 June 1996
Third Mariinsky Theatre production: 21 June 2007

Synopsis

The action takes place in 1865 in the imaginary city of Roulettenburg, near the Spa.

In the resort town of Roulettenburg, famous for its gambling houses, fate brought the retired General, Pauline - his stepdaughter, Alexey Ivanovich - the teacher of his children, the Marquise, Mr. Astley and the lady of the half-light Mademoiselle Blanche.

The general lost his fortune to roulette and was in debt with the Marquis. In addition, the charms of Mademoiselle Blanche completely turned his head. All hopes the General and his friends are laying on the state of the rich Moscow grandmother and are eagerly awaiting the news of her death. But instead of the telegram, Babulenka is herself, and soberly assessing the situation, refuses the General in the inheritance. Intrigued by tales of roulette, she decides to see first hand what it is. Leaving Babulenka gambling house, losing almost everything that it had.

The only way out of a desperate situation, the General sees in the marriage of his stepdaughter with the Marquis. But Pauline, after experiencing the passion of the Marquis, understands now all the meanness of this man, and the fact that she owes him a large sum makes her dependence even more painful. Alexei Ivanovich promises Polina to get money. In the gambling house he is fantastically lucky: he breaks the bank - two hundred thousand francs. However, Polina, feeling that this money is not the gift of a man in love, but the player's winnings, throws them to Alexei Ivanovich in the face.

Casts & Credits

Bass-baritone: Andrei Serov
Costume Designer: Tatiana Noginova
Lighting Designer: Gleb Filshtinsky
Musical Director: Maestro Valery Gergiev
Musical Preparation: Marina Mishuk
Principal Chorus Master: Andrei Petrenko
Set Designer: Zinovy Margolin
Stage Director: Temur Chkheidze
Bass-baritone: Andrei Serov
Costume Designer: Tatiana Noginova
Lighting Designer: Gleb Filshtinsky
Musical Director: Maestro Valery Gergiev
Musical Preparation: Marina Mishuk
Principal Chorus Master: Andrei Petrenko
Set Designer: Zinovy Margolin
Stage Director: Temur Chkheidze