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 (712176,713307,1199512,1201573,1203625,1205676,1207713,1209741,1211779,1213811,1215833,1217842,1219836,1221819,1223795,1225766,1227759,1229773,1231783,1233779,1235766,1237747,1239715,1241671,1243654,1245629,1247591,1249572,1251550,1253531,1255508,1257475,1259435,1261382,1263316,1265241,1267171,1269091,1271000,1272898,1274782,1276651,1278506,1280358,1282204,1284036,1285860,1287671,1289465,1291250,1293060,1294862,1647464,1647471,1650276,1650281,1653146,1653151,1656005,1656010,1658853,1658858,1661690,1661695,1664513,1664518,1667326,1667333,1670132,1670137,1672991,1672996,1675843,1675848,1678690,1678698,1681527,1681532,1684354,1684361,1687222,1687229,1690076,1690084,1692930,1692937,1695696,1695703,1698458,1698465,1701211,1701218,1703955,1703962,1706692,1706699,1709463,1709470,1712226,1712233,1715010,1715017,1717785,1717792,1720547,1720554,1723294,1723301,1726035,1726042,1728770,1728777,1731496,1731503,1734204,1734211,1736903,1736910,1739591,1739598,1742265,1742272,1744929,1744936,1747587,1747594,1750236,1750243,1752878,1752885,1755511,1755518,1758135,1758144,1760746,1760755,1763349,1763355,1765946,1765953,1768539,1768546,1771124,1771131,1773700,1773707,1776274,1776281,1778833,1778840,1781382,1781389,1783924,1783931,1786456,1786463,1788961,1788968,1791455,1791462,1793931,1793938,1796388,1796395,1798830,1798839,1801291,1801298,1803736,1803743,1806161,1806168,1808570,1808582,1810962,1810970,1813325,1813332,1815674,1815681,1818006,1818013,1820313,1820320,1822594,1822601,1824850,1824857,1827083,1827090,1829295,1829301,1831487,1831494,1833673,1833680,1835871,1835882,1838061,1838071,1840240,1840251,1842400,1842410,1844545,1844555,1846685,1846692,1848839,1848845,1850988,1850994,1853137,1855273,3444139,3444149,3446140,3446153,3448291,3448304,3450434,3450447,3452569,3452582,3454693,3454706,3456814,3456830,3458937,3458953,3461077,3461093,3463207,3463223,3465361,3465377,3467505,3467521,3469678,3469694,3471840,3471856,3473994,3474010,3476150,3476166,3478300,3478316,3480442,3480458,3482574,3482590,3484701,3484717,3486819,3486835,3488929,3488945,3491062,3491078,3493188,3493204,3495308,3495324,3497465,3497481,3499612,3499628,3501752,3501768,3503885,3503901,3506013,3506029,3508136,3508152,3510252,3510268,3512364,3512380,3514466,3514482,3516560,3516576,3518647,3518663,3520731,3520751,3522805,3522825,3524879,3524899,3526935,3526955,3529000,3529020,3531052,3531072,3533094,3533114,3535134,3535154,3537168,3537188,3539194,3539214,3541233,3541253,3543294,3543314,3545342,3545362,3547380,3547400,3549415,3549435,3551457,3551477,3553494,3553514,3555535,3555555,3557565,3557585,3559583,3559603,3561592,3561612,3563592,3563612,3565612,3565632,3567628,3567648,3569651,3569671,3571659,3571679,3573679,3573699,3575587,3575607,3577494,3577514,3579397,3579417,3581296,3581316,3583156,3583174,3585016,3585034,3586873,3586891,3588727,3588745,3590579,3590597,3592428,3592446,3594371,3594389,3596367,3596385,3598349,3598367,3600316,3600334,3602268,3602286,3604211,3604229,3606142,3606160,3608065,3608083,3609978,3609996,3611879,3611897,3613808,3613826,3615725,3615743,3617635,3617653,3619539,3619557,3621442,3621460,3623337,3623355,3625220,3625238,3627092,3627110,3628956,3628974,3630816,3630834,3632670,3632688,3634516,3634534,3636355,3636373,3638184,3638202,3640000,3640018,3641806,3641824,3643604,3643622,3645394,3645412,3647195,3648970,3650732)) 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





	Arturo Chacon-Cruz (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Arturo Chacon-Cruz (Tenor)
			

																
Arturo Chacon-Cruz (Tenor)

														
				


        




    

        Born in Mexico, Arturo Chacon-Cruz has in recent seasons made many important 
international debuts in theaters including the Berlin State Opera, Hamburg State 
Opera, Los Angeles Opera, Teatro Comunale in Bologna, Teatro San Carlo, Naples, 
Teatro la Fenice, Venice, Teatro Regio di Turin, Palau de la Reina Sofia in 
Valencia, L’Opera de Montpellier, and at the Festival de Radio France in 
Montpellier. In North America he has appeared with the Washington Opera, Los 
Angeles Opera, Houston Opera, Michigan Opera Theater, Florida Grand Opera and 
many others.
The 2010/2011 season begins with Arturo Chacon-Cruz singing the 
title role of Les Contes d’Hoffmann for the Aichi Arts Center in Japan. 
He returns to the Opera Royal de la Wallonie for La boheme, and sings his 
debut performances of WertherRigoletto for Opera de Lyon. He will sing 
the Duca in for Den Norske Opera and Cincinnati Opera, as well as 
Hoffmann for Malmo Opera.
He began his 2009/10 season as Rodolfo in 
La Boheme with the Portland Opera. He then debuted in this role with the 
Cologne Opera and subsequently made his debut with the Hamburg State Opera as 
Pinkerton in Madama Butterfly. He also returned to the Berlin State Opera 
in La Boheme. Chacon Cruz also appeared as the Duca in Rigoletto 
with the Opera de La Wallonie, Liege and with the Florentine Opera in 
Milwaukee.
A protege of Ramon Vargas, Arturo Chacon-Cruz is a graduate of the 
Houston Grand Opera where he appeared in productions of several works including 
Madama Butterfly, Romeo et Juliette, Manon Lescaut, the 
world premiere of Lysistrataand Mozart’s Idomeneo.
His 
Spanish debut was in Valencia where he appeared as Christian in Alfano’s 
Cyrano de Bergerac opposite Placido Domingo in the title role (2006). He 
added the title role in Offenbach’s Les Contes D’Hoffmann to his 
repertoire for his debut at the Teatro Regio in Turin followed by his first 
Faust for L’Opera de Montpellier in the season 2007/2008. In 2008 Chacon 
Cruz added the Duca in Rigoletto to his repertoire in Mexico City, where 
he has also been heard as Lensky in Eugene Onegin.
Chacon-Cruz has 
also appeared often in concert. He made his Carnegie Hall debut in March 2002, 
singing Mozart’s Coronation Mass, and he returned to Carnegie Hall in 
June 2003 to sing Beethoven’s Mass in C and Charpentier’s Te Deum 
with the New England Symphonic Ensemble, as well a concert with the New York 
Pops in 2006.
Chacon Cruz has received many awards, including First Place and 
Audience Choice Award at the 2003 Eleanor McCollum Competition in Houston Grand 
Opera, winner of Metropolitan Opera National Council Auditions in the New 
England Region, and he was also a winner of Operalia 2005. He was also the 
recipient of the "Ramon Vargas" Opera Development Scholarship given by Mr. 
Vargas and Pro Opera in Mexico.         

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy