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 (2391254,2391259,2394310,2394315,2397353,2397358,2400382,2400387,2403400,2403405,2406414,2406419,2406425,2406433,2409424,2409430,2409438,2412425,2412433,2415419,3340380,3340382,3340386,3340391,3340393,3342719,3342721,3342725,3342730,3342732,3345080,3345082,3345086,3345091,3345093,3347429,3347431,3347435,3347440,3347442,3349772,3349774,3349778,3349783,3349785,3352100,3352102,3352106,3352111,3352113,3354421,3354423,3354427,3354432,3354434,3356747,3356749,3356753,3356758,3356760,3359095,3359097,3359101,3359106,3359108,3361461,3361463,3361467,3361472,3361474,3363818,3363820,3363824,3363829,3363831,3366162,3366164,3366168,3366173,3366175,3368498,3368500,3368504,3368509,3368511,3370826,3370828,3370832,3370837,3370839,3373147,3373149,3373153,3373158,3373160,3375461,3375463,3375467,3375472,3375474,3377770,3377772,3377776,3377781,3377783,3380070,3380072,3380076,3380081,3380083,3382353,3382355,3382359,3382364,3382366,3384644,3384646,3384650,3384657,3384660,3386918,3386920,3386924,3386931,3386934,3389178,3389181,3389185,3389192,3389195,3391432,3391435,3391439,3391446,3391449,3393675,3393678,3393682,3393689,3393692,3395904,3395907,3395911,3395918,3395921,3398120,3398123,3398127,3398134,3398137,3400327,3400330,3400334,3400341,3400344,3402521,3402524,3402528,3402535,3402538,3404704,3404707,3404711,3404718,3404721,3406876,3406879,3406883,3406890,3406893,3409049,3409052,3409056,3409063,3409066,3411200,3411203,3411207,3411214,3411217,3413329,3413332,3413336,3413343,3413346,3415483,3415486,3415490,3415497,3415500,3417625,3417628,3417632,3417639,3417642,3419756,3419759,3419764,3419772,3419775,3421865,3421868,3421873,3421881,3421884,3423954,3423957,3423962,3423970,3423973,3426021,3426024,3426029,3426037,3426040,3428069,3428072,3428077,3428085,3428088,3430100,3430103,3430108,3430116,3430119,3432114,3432117,3432122,3432130,3432133,3434121,3434124,3434129,3434137,3434140,3436121,3436124,3436129,3436137,3436140,3438108,3438111,3438116,3438124,3438127,3440081,3440084,3440089,3440097,3440100,3442047,3442050,3442055,3442063,3442066,3444025,3444028,3444033,3444041,3444044,3446010,3446013,3446018,3446028,3446031,3448161,3448164,3448169,3448179,3448182,3450304,3450307,3450312,3450322,3450325,3452439,3452442,3452447,3452457,3452460,3454563,3454566,3454571,3454581,3454584,3456682,3456685,3456690,3456700,3456703,3458806,3458809,3458814,3458824,3458827,3460946,3460949,3460954,3460964,3460967,3463076,3463079,3463084,3463094,3463097,3465227,3465230,3465235,3465245,3465248,3467371,3467374,3467379,3467389,3467392,3469544,3469547,3469552,3469562,3469565,3471706,3471709,3471714,3471724,3471727,3473860,3473863,3473868,3473878,3473881,3476016,3476019,3476024,3476034,3476037,3478166,3478169,3478174,3478184,3478187,3480308,3480311,3480316,3480326,3480329,3482440,3482443,3482448,3482458,3482461,3484567,3484570,3484575,3484585,3484588,3486685,3486688,3486693,3486703,3486706,3488795,3488798,3488803,3488813,3488816,3490928,3490931,3490936,3490946,3490949,3493054,3493057,3493062,3493072,3493075,3495174,3495177,3495182,3495192,3495195,3497331,3497334,3497339,3497349,3497352,3499478,3499481,3499486,3499496,3499499,3501618,3501621,3501626,3501636,3501639,3503751,3503754,3503759,3503769,3503772,3505879,3505882,3505887,3505897,3505900,3508002,3508005,3508010,3508020,3508023,3510118,3510121,3510126,3510136,3510139,3512230,3512233,3512238,3512248,3512251,3514332,3514335,3514340,3514350,3514353,3516426,3516429,3516434,3516444,3516447,3518513,3518516,3518521,3518531,3518534,3520599,3520602,3520607,3520617,3520620,3522673,3522676,3522681,3522691,3522694,3524744,3524748,3524754,3524764,3524768,3526800,3526804,3526810,3526820,3526824,3528865,3528869,3528875,3528885,3528889,3530917,3530921,3530927,3530937,3530941,3532959,3532963,3532969,3532979,3532983,3534999,3535003,3535009,3535019,3535023,3537033,3537037,3537043,3537053,3537057,3539059,3539063,3539069,3539079,3539083,3541098,3541102,3541108,3541118,3541122,3543159,3543163,3543169,3543179,3543183,3545207,3545211,3545217,3545227,3545231,3547245,3547249,3547255,3547265,3547269,3549279,3549283,3549289,3549299,3549303,3551321,3551325,3551331,3551341,3551345,3553358,3553362,3553368,3553378,3553382,3555399,3555403,3555409,3555419,3555423,3557429,3557433,3557439,3557449,3557453,3559447,3559451,3559457,3559467,3559471,3561456,3561460,3561466,3561476,3561480,3563456,3563460,3563466,3563476,3563480,3565476,3565480,3565486,3565496,3565500,3567492,3567496,3567502,3567512,3567516,3569515,3569519,3569525,3569535,3569539,3571524,3571528,3571534,3571544,3571548,3573544,3573548,3573554,3573564,3573568,3594217,3594223,3594233,3596219,3596229,3598211)) 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





	Paolo Carignani (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Paolo Carignani (Conductor)

Paolo Carignani (Conductor)

Paolo Carignani was born in Milan, where he graduates from the Giuseppe Verdi Conservatory in composition, organ and piano. He later studied conducting with Alceo Galliera. 
He conducts in many Italian opera houses and in prestigious international venues such as the Staatsoper Wien, Berlin Staatsoper and Deutsche Oper Berlin, the Bayerische Staatsoper, the San Francisco War Memorial, the Met in New York, the Gran Teatre de Liceu in Barcelona, the Concertgebouw Theater Opera in Amsterdam, Royal Opera House in London, the Opera Bastille in Paris, in Oslo, Brussels, Antwerp, Glyndebourne, Spoleto, the Schleswig Holstein Festival, the Rheingau Festival and at the Rossini Opera Festival in Pesaro. 

His symphonic repertoire leads him to work with the Junge Deutsche Philharmonie and the Young Nederland’s Symphony Orchestra, the Munich Philharmonic, the Yomiuri Nippon Orchestra, the KIOTI Sinfonietta, the orchestra of the radio NDR, WDR, ORF, the RAI National Orchestra of Turin, the Nederlands Radio Symphony Orchestra, the Detroit Symphony Orchestra and Gotheburg and many others. 

From 1999 to 2008 Paolo Carignani is Generalmusikdirektor the Opernhouse in Frankfurt am Main and Director of the Stable Frankfurter Opern - and Museumsorchester. 

He conducted: Le Duc d’Albe in Antwerpen, Le convenienze e inconvenienze teatrali in Zurich, Cavalleria Rusticana and PagliacciNabucco and a symphonic concert at Nikikai Opera Foundation in Tokyo, Tosca in Paris, Guillaume Tell in Amsterdam, OtelloLa bohème, TrovatoreFalstaffLa traviataMacbethNabuccoNorma and Aida in Munich, Giovanna dArco at the Salzburg Festspiele, TraviataNabuccoToscaCavalleria Rusticana and PagliacciAndrea ChénierLa Fanciulla del West in Wien. 

Among his recent engagements: Otello in Zurich, Rigoletto in Strasbourg, Tosca in Barcellona, Pagliacci in Bari, Les Vepres Siciliennes in Copenaghen, Turandot and Amleto in Bregenz, Carmen in Toronto, Simon Boccanegra in Antwerp, Stabat Mater in Tokyo with the Yomiuri Nippon Symphony Orchestra and Il Trovatore in Münich, Turandot and La bohème at Metropolitan of New York, Norma in Münich, Carmen in Toronto, at Bregenz Festspiele and in Sidney, Don Carlo and Nabucco in Münich, Macbeth in Bruxelles and Münich, Otello in Hamburg, Budapest and Tokyo, Rigoletto in Copenaghen, Tosca in Zürich, La bohème at Teatro Real in Madrid, Aida in Tokyo, Ali Baba e i 40 ladroni at Teatro alla Scala.