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-23' AND tmp.date<='2024-05-13' AND tmp.perf_id=1995) 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-23' AND '2024-05-13' AND tmp.perf_id=1995) 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<>1995 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<>1995 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





	3 December 2017, 14:00 - Louis Herold "La Fille Mal Gardee (Vain Precautions)" (Ballet in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 3 December 2017, 14:00 - Louis Herold "La Fille Mal Gardee (Vain Precautions)" (Ballet in two acts)
3December
14:00
2017 | Sunday
Classical ballet
Bolshoi theatre - Small Stage, Moscow
Duration: 2 hours 10 minutes
World premiere: January 29, 2002.

Presented with one interval.

Synopsis

Act I

Scene 1
Cockcrow at the start of a new day. Lise, a rebellious girl, is in love with Colas, a young farm worker, but her mother, Madame Simone, has more ambitious plans. Sent about her chores, Lise keeps leaving them to look for Colas. At last she succeeds in meeting him. But Madame Simone is too watchful: she finds the lovers and sends Colas away. The shy and simple-minded Alain is brought by his wealthy father Thomas to meet Lise as the prospective husband her mother favors.

Scene 2
The harvesters finish their work and amuse themselves by dancing. Lise prefers to dance with Colas. One of the peasants plays flute. Alain tries to show his abilities too but in vain: everybody laughs at him. Suddenly, a violent thunderstorm scatters everybody.

Act II

At home Lise is again put to work. While her mother dozes she spears to Colas through a broken panel in the locked door. At last Colas smuggles himself inside with the harvesters, who come for their wages. After the harvesters are paid, she goes out, firmly locking the door on the frustrated Lise, neither of them aware that Colas has hidden himself inside. Thinking herself alone, Lise imagines the bliss of marriage and motherhood, and becomes deeply embarrassed when Colas emerges, have observed her feelings. They declare love and exchange their scarfs, but are interrupted by the mother’s return. Colas, looking in vain for a hiding place, takes refuge in a bedroom upstairs. Angry at Lise, her mother sends her to the same room to make herself ready for Alain and his father. They arrive with a marriage contract, which is signed before Lise is discovered in Colas’ arms. The marriage plans are abruptly ended. After begging the mother to forgive and bless them, she concedes.


Additional information

  • Characters and performers

    Casts & Credits

    Choreography: Yuri Grigorovich
    Choreography: Frederick Ashton
    Ballet company: Bolshoi Ballet
    Artistic Director: Maestro Yuri Grigorovich
    Balletmaster: Emilio Martins
    Conductor: Igor Dronov
    Musical Director: Alexander Kopylov
    Musical version: John Lanchbery
    Set Designer: Osbert Lancaster
    Choreography: Yuri Grigorovich
    Choreography: Frederick Ashton
    Ballet company: Bolshoi Ballet
    Artistic Director: Maestro Yuri Grigorovich
    Balletmaster: Emilio Martins
    Conductor: Igor Dronov
    Musical Director: Alexander Kopylov
    Musical version: John Lanchbery
    Set Designer: Osbert Lancaster