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.id IN (3377724,3377728,3377736,3380024,3380028,3380036,3382307,3382311,3382319,3384597,3384602,3384611,3386871,3386876,3386885,3389131,3389136,3389145,3391385,3391390,3391399,3393628,3393633,3393642,3395857,3395862,3395871,3398073,3398078,3398087,3400280,3400285,3400294,3402474,3402479,3402488,3404657,3404662,3404671,3406829,3406834,3406843,3409002,3409007,3409016,3411153,3411158,3411167,3413282,3413287,3413296,3415436,3415441,3415450,3417578,3417583,3417592,3419710,3419715,3419729,3421819,3421824,3421838,3423908,3423913,3423927,3425975,3425980,3425994,3428023,3428028,3428042,3430054,3430059,3430073,3432068,3432073,3432087,3434075,3434080,3434094,3436075,3436080,3436094,3438062,3438067,3438081,3440035,3440040,3440054,3442001,3442006,3442020,3443979,3443984,3443998,3445955,3445961,3445978,3448106,3448112,3448129,3450249,3450255,3450272,3452384,3452390,3452407,3454508,3454514,3454531,3456627,3456633,3456650,3458751,3458757,3458774,3460890,3460896,3460913,3463020,3463026,3463043,3465170,3465177,3465194,3467314,3467321,3467338,3469487,3469494,3469511,3471649,3471656,3471673,3473803,3473810,3473827,3475959,3475966,3475983,3478109,3478116,3478133,3480251,3480258,3480275,3482383,3482390,3482407,3484510,3484517,3484534,3486628,3486635,3486652,3488738,3488745,3488762,3490871,3490878,3490895,3492997,3493004,3493021,3495117,3495124,3495141,3497274,3497281,3497298,3499421,3499428,3499445,3501561,3501568,3501585,3503694,3503701,3503718,3505822,3505829,3505846,3507945,3507952,3507969,3510061,3510068,3510085,3512173,3512180,3512197,3514275,3514282,3514299,3516369,3516376,3516393,3518456,3518463,3518480,3520542,3520549,3520566,3522616,3522623,3522640,3524685,3524692,3524709,3526741,3526748,3526765,3528806,3528813,3528830,3530858,3530865,3530882,3532900,3532907,3532924,3534940,3534947,3534964,3536973,3536981,3536998,3538999,3539007,3539024,3541038,3541046,3541063,3543099,3543107,3543124,3545147,3545155,3545172,3547185,3547193,3547210,3549219,3549227,3549244,3551261,3551269,3551286,3553298,3553306,3553323,3555339,3555347,3555364,3557369,3557377,3557394,3559387,3559395,3559412,3561396,3561404,3561421,3563396,3563404,3563421,3565424,3565441,3567440,3567457,3569480,3571491)) ORDER BY date ASC, ves DESC, time ASC LIMIT 10
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





	Jacques Imbrailo (Baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Jacques Imbrailo (Baritone)

Jacques Imbrailo (Baritone)

A former member of the Jette Parker Young Artists Programme at the Royal Opera House, Covent Garden, Imbrailo also studied at the Royal College of Music.

Highlights of the 2018/19 season included Pelléas Pelléas et Mélisande for the Opéra national du Rhin, title role Billy Budd at the Norwegian National Opera and the Royal Opera House, Covent Garden.
In the 2019/20 season, Imbrailo returned to the Royal Opera House, Covent Garden as Albert Werther and appeared in title role Hamlet in Washington.

Recent highlights included the title role Billy Budd at the Teatro Real, Madrid, his debut for Minnesota Opera as Count Le Nozze di Figaro, Pelléas Pelléas et Mélisande for Opera Vlaanderen, Zurich Opera, the Royal Swedish Opera, Welsh National Opera and Essen Opera, Michael in the world premiere of Daníel Bjarnason's Brothers for Danish National Opera, Zurga Les pêcheurs de perles for English National Opera, Horatio in Brett Dean's Hamlet at Glyndebourne Festival Opera, Messner in the world premiere of Jimmy López Bel Canto at the Lyric Opera of Chicago, the title role Don Giovanni for Perm Opera with Teodor Currentzis and for Scottish Opera, Valentin in Faust in Baden-Baden, Guglielmo Così fan tutte for Houston Grand Opera, Papageno Die Zauberflöte for Welsh National Opera, and Tarquinius The Rape of Lucretia in Florence and Houston.

On the concert platform, recent appearances include Britten War Requiem with the São Paulo Symphony Orchestra and Marin Alsop, Berlioz L‘enfance du Christ with the Deutsches Symphonie-Orchester Berlin and Robin Ticciati, Pelléas Pelléas et Mélisande with the City of Birmingham Symphony Orchestra under the baton of Mirga Gražinytė-Tyla, a return to the BBC Proms for James MacMillan A European Requiem, Jesus The Apostles with the Royal Scottish National Orchestra and Edward Gardner at the Edinburgh International Festival, and with the Hallé and Sir Mark Elder at the BBC Proms.
Imbrailo has given solo recitals at Wigmore Hall, St John’s Smith Square and the Het Concertgebouw, Amsterdam, and performed at Verbier Festival, the Royal Albert Hall and Southbank Centre.