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-05-19' AND tmp.date<='2024-06-08' AND tmp.perf_id=2595) 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-05-19' AND '2024-06-08' AND tmp.perf_id=2595) 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<>2595 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<>2595 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





	,  - L.Minkus "Don Quixote" (Ballet in three acts) Imperial Russian Ballet - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" , - L.Minkus "Don Quixote" (Ballet in three acts) Imperial Russian Ballet
|
Classical ballet
Moscow theatre "New Opera", Moscow
Duration: 2 hours 30 minutes

Ballet in three acts

Imperial Russian Ballet
Artistic Director Gediminas Taranda

Choreographers: Marius Petipa, Alexander Gorsky, Gediminas Taranda
Novaya Opera Orchestra

Conductor Valery Kritskov

Synopsis

Prologue

Don Quixote, having read his fill of romances about knights and chivalry, decides to set off on his travels in order to achieve great feats, which will bring glory to his name. As his sword-bearer, he chooses the loyal Sancho Panza, a man of sober outlook who is not prone to dreams.

Act I

In Barcelona there is festive anima­tion in the air. Kitri, daughter of the innkeeper, is flirting with Basilio, the barber, who is in love with her. Finding them together Lorenzo, Kitri’s father, chases Basilio away: the barber is no fit match for his daughter. Lorenzo intends Kitri to marry Gamache, a rich noble­man. Kitri refuses outright to submit to her father’s will.

At the height of the merry-making, Don Quixote appears in the square, accompanied by his sword bearer, Sancho Panza. Catching sight of the innkeeper, Don Quixote mistakes him for the owner of a knight’s castle and greets him with respect. Lorenzo responds in like terms and invites Don Quixote into the inn. Sancho Panza is left in the square. But when some young people start to mock Sancho, Don Quixote immediately hurries to his sword-bearer’s rescue.

Seeing Kitri, Don Quixote thinks she is the beautiful Dulcinea whom he has seen in his dreams and chosen as ‘the lady of his heart’. But Kitri disappears. She has run off with Basilio. Lorenzo, Gamache and Don Quixote set out to look for her.

Act II

Scene 1
Kitri and Basilio are hiding in a tavern. Here they are found by Lorenzo, Gamache and Don Quixote. Lorenzo wishes to make an immediate announce­ment of the betrothal of Kitri and Gamache. But Basilio, by agreement with Kitri, pretends to take his life. Kitri sobs over the body of her sweetheart. Don Quixote overcоme by noble indignation accuses Lorenzo of hardheartedness and, threatening him with his sword forces him to agree to his daughter’s marriage with the barber Basilio jumps to his feet. There is no point in him pretending to be dead am longer.

Scene 2
In the glade by the windmills is a sprawling gipsy encampment. Here too is a puppet theatre. Don Quixote and Sancho soon appear on the scene. The owner of the puppet theatre invites Don Quixote to watch a show. Don Quixote follows the performance with rapt attention and, forgetting it is theatre, rushes on to the stage, sword in hand, to defend those who need his protection. He breaks down the stage, sends the puppets flying and, catching sight of the windmills, mistakes them for evil magicians whom he has to get the better of. Grabbing a mill sail, he is first lifted into the air and then falls to the ground.

Scene 3
The wounded Don Quixote and Sancho Panza find themselves in a forest. To Don Quixote, the forest seems to be full of monsters and giants. Sancho Panza settles Don Quixote down to sleep, while he runs off for help. In his dreams, Don Quixote sees Dulcinea, ‘the lady of his heart’, surrounded by Dryads and fairies Sancho Panza comes back with the Duke and Duchess who have been hunting in the forest. He begs them to help the dreaming Don Quixote. The Duke and Duchess invite the wandering knight to visit them m their castle.

Act III

The Duke’s castle. All is ready for the reception of Don Quixote.
Having heard from Sancho Panza the happy story of Kitri and Basilio’s love, the Duke and Duchess have kindly agreed to allow them to hold their wedding in the castle. Don Quixote and Sancho Panza are invited to occupy the seats of honor. A solemn procession files past. Catching sight of Kitri, Don Quixote again mis­takes her for ‘the lady of his reveries’. But the Duke and Sancho Panza manage to persuade him that she is the very same innkeeper’s daughter whom he helped to unite with Basilio, her sweetheart.
The festivities continue. All thank the va­liant knight and his faithful sword-bearer.

Photos

Casts & Credits

Choreography: Marius Petipa
Choreography: Gediminas Taranda
Artistic Director: Gediminas Taranda
Choreography: Marius Petipa
Choreography: Gediminas Taranda
Artistic Director: Gediminas Taranda