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 (2451032,2453935,2456819,2459698,2462562,2465417,2468294,2512088,2514943,2517793,2520636,2523468,2526288,2529101,2531909,2534710,2537504,2540298,2543082,2545855,2548620,2551425,2554221,2557032,2559833,2562622,2565401,2568167,2570994,2573818,2576632,2696781,2696791,2699865,2699876,2702948,2702959,2706023,2706034,2709070,2709081,2712113,2712124,2715143,2715154,2718164,2718175,2721229,2721240,2724337,2724348,2727436,2727447,2730523,2730534,2733638,2733649,2736741,2736752,2739828,2739839,2742906,2742917,2745966,2745977,2749007,2749018,2752036,2752047,2755063,2755074,2758083,2758094,2761105,2761118,2764120,2764133,2767119,2767132,2770103,2770116,2773076,2773089,2776041,2776054,2779030,2779043,2782011,2782024,2785099,2785112,2788185,2788198,2791255,2791268,2794313,2794326,2794634,2794646,2797388,2797401,2797709,2797721,2800450,2800463,2800772,2800784,2803505,2803518,2803827,2803839,2806479,2806492,2806801,2806813,2809435,2809448,2809757,2809769,2812369,2812382,2812691,2812703,2815291,2815304,2815613,2815625,2818274,2818287,2818596,2818608,2821250,2821263,2821572,2821584,2824222,2824235,2824544,2824556,2827198,2827211,2827520,2827532,2830157,2830170,2830479,2830491,2833099,2833112,2833421,2833433,2836026,2836039,2836348,2836360,2838960,2838973,2839282,2839294,2841884,2841897,2842206,2842218,2850458,2850471,2850787,2850800,2863095,2863108,2863420,2863433,2865872,2865885,2866197,2866210,2880941,2880954,2881271,2881285,2883713,2883726,2884043,2884057,2886471,2886484,2886795,2886808,2889206,2889219,2889530,2889543,2891929,2891942,2892253,2892266,2894632,2894645,2894956,2894969,2897321,2897334,2897645,2897658,2900018,2900031,2900342,2900355,2902709,2902722,2903033,2903046,2905293,2905306,2905617,2905630,2907885,2907898,2908209,2908222,2910502,2910515,2910826,2910839,2913100,2913113,2913424,2913437,2915688,2915701,2916012,2916025,2918278,2918291,2918602,2918615,2920851,2920864,2921175,2921188,2923416,2923429,2923740,2923753,2925971,2925984,2926294,2926307,2928507,2928520,2928830,2928843,2931026,2931039,2931349,2931362,2933534,2933547,2933857,2933870,2936034,2936047,2936357,2936370,2938542,2938555,2938865,2938878,2941058,2941368,2941381,2943552,2943862,2943875,2946340,2946353,2948802,2948815,2951249,2951262,2953696,2953709,2956185,2956198,2958668,2958681,2961137,2961150,2963586,2963599,2966017,2966030,2968435,2968448,2970851,2970864,2973251,2973264,2975640,2975653,2978017,2978030,2980407,2980420,2982783,2982796,2985152,2985165,2987536,2987549,2989914,2989927,2992290,2992303,2994653,2994666,2997003,2997016,2999337,2999350,3001661,3001675,3003973,3003986,3006263,3006276,3008489,3008502,3010677,3010690,3012845,3012858,3014997,3015010,3017141,3017154,3019329,3019342,3021465,3021475,3022942,3022952,3024411,3024421,3025867,3025877,3027313,3027323,3028751,3028761,3030183,3030193,3031605,3031615,3033017,3033027,3034615,3034625,3036201,3036211,3037776,3037786,3039343,3039353,3040902,3040912,3042452,3042462,3043994,3044004,3045529,3045539,3047052,3047062,3048564,3048574,3050069,3050079,3051577,3051587,3053075,3053085,3054560,3054570,3056036,3056046,3057501,3057511,3058954,3058964,3060399,3060409,3061836,3061846,3063581,3065307)) 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





	Rame Lahaj (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Rame Lahaj (Tenor)
			

																
Rame Lahaj (Tenor)

														
				


        




    

        
Biography
Born in Istog (Kosovo). 
In 2016 Rame Lahaj was a prize winner in Placido Domingo's Operalia competition. He is considered to be one of the most prominent singers in his generation. 

The 2016/17 season marked highlights such as Edgardo (Lucia di Lammermoor) at the Paris National Opera, the title role of Faust in Tel Aviv, Duca di Mantova (Rigoletto) with McVickar at Savonlinna Opera Festival and Finnish National Opera in Helsinki as well as concerts in London and Mexico next to Placido Domingo. 

Most notable engagements in 2017/18 include Alfredo (La Traviata) with Placido Domingo at the Paris National Opera and at the Bolshoi Theatre in Moscow (conductor Tugan Sokhiev), Duca di Mantova (Rigoletto) in Malmo Opera House (Sweden). 

In 2014/15 and 2015/16 he performed Duca di Mantova (Rigoletto) at Haus fūr Mozart in Salzburg, Duca di Mantova (Rigoletto) and Alfredo (La Traviata) at Polish National Opera in Warsaw, Alfredo (La Traviata) at Opera Australia in Sydney, Rodolfo (La Bohème) at Teatro Verdi in Trieste, Pinkerton (Madama Butterfly) at Puccini Festival Torre del Lago and at Opera Las Palmas. He also inaugurated the new 'Amber' Concert Hall in Latvia together w. soprano Marina Rebeka. 

In 2014 he made his house debuts as Duca di Mantova (Rigoletto) at La Monnaie de Bruxelles, as Alfredo(La Traviata) at the Hamburg State Opera and as Duca di Mantova (Rigoletto) at Deutsche Oper Berlin. 

In season 2013/2014 Lahaj was also at Semperoper Dresden as Duca di Mantova (Rigoletto), Alfredo (La Traviata) and Rodolfo (La Bohème). Moreover, he performed Rodolfo (La Bohème) at Royal Albert Hall in London. 

In 2012 he performed Rodolfo (La Bohème) in France at National Opera de Montpellier. His Italian debut turned out to be a great success with the performance of Rigoletto in the role of Duca di Mantova at Teatro Massimo di Palermo. 

A first major success was his debut at the Hungarian State Opera in Budapest in 2011 with the role of Macduff(Macbeth). 
        

    

    

            


			

		





	


	

	

		


			

				

					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