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-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=2544) 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-14' AND '2024-06-03' AND tmp.perf_id=2544) 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<>2544 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<>2544 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





	10 January 2019, 18:00 - Estonian National Opera production "Modigliani – the Cursed Artist" Ballet in two acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 10 January 2019, 18:00 - Estonian National Opera production "Modigliani – the Cursed Artist" Ballet in two acts
10January
18:00
2019 | Thursday
New Estonian Ballet Capturing and Beautiful"It is a dramatic, sometimes violent performance, deeply tragical and very beautiful. Modigliani’s paintings play an important role and evocative lighting and use of smoke and mists heightens the sense of a dream world – though the sets and many of the scenes are very realistic."

STAGING TEAM

  • Choreographer-Stage Director: Thomas Edur
  • Libretto: Irina Müllerson and Thomas Edur
  • Music: Tauno Aints
  • Conductors: Lauri Sirp
  • Concept of Set Design: Thomas Edur and Liina Keevallik
  • Designer: Liina Keevallik
  • Lighting Designer: Tiit Urvik

 

Thomas Edur’s ballet to the music of Tauno Aints 
World premiere on May 11, 2012 at the Estonian National Opera

“Modigliani – the Cursed Artist” is Thomas Edur’s debut as a stage director at the Estonian National Opera. The ballet tells an exciting story of the stormy life of Amedeo Modigliani (1884–1920), one of the most famous bohemian artists of the 20th century. His art forms a bridge between the generation of Cubists and the Art Deco painters of the 1920s. Legends are told about Modigliani’s life – his eccentric nature, his bragging, emotional twists, passionate affairs with writers Anna Akhmatova and Beatrice Hastings, and artist Jeanne Hébuterne, a dream to mount Parnassus and his rivalry with Picasso, health problems and the onset of tuberculosis that he tried to conceal by consuming alcohol and drugs excessively – it all provides colourful material for the birth of an astonishing stage-work.

“What I am seeking is not the real and not the unreal but rather the unconscious, the mystery of the instinctive in the human race.”
Amedeo Modigliani

Tauno Aints graduated from Viljandi Culture College in 1998 and from Estonian Music Academy where he studied composition with Lepo Sumera and Helena Tulve. He has worked as a concertmaster at the male choir Sakala in Viljandi and the Drama School of Estonian Academy of Music and teacher of theoretical subjects at the choir studio Ellerhein. Since 2001, Aints is a teacher of music theory and music history in Tallinn Music High School. In 2002–2007, Aints was active as a pop musician in the ensemble “Genialistid”. His music has been performed by Estonian National Symphony Orchestra, Tallinn Chamber Orchestra, Estonian Dream Big Band, Ensemble U:, etc.