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 (1911041,1913181,1915343,1917558,1919756,1921953,1924143,1926390,2176693,2176711,2178296,2178315,2179895,2179913,2181474,2181488,2183042,2183060,2184593,2184612,2186140,2186159,2187686,2187698,2189219,2189239,2190742,2190761,2192260,2192280,2193767,2193784,2195300,2195317,2196825,2196842,2198353,2198370,2199869,2199887,2201388,2201407,2202947,2204478,2206003,2362474,2365560,2368646,2371715,2374774,2377817,2380852,2383881,2386897,2389962,2393023,2396075,2399110)) 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





	Irina Kosheleva (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Irina Kosheleva (Dancer)
			

																
Irina Kosheleva (Dancer)

														
				


        




    

        Born in Barnaul in 1978.
Graduated from the Novosibirsk Choreography School.
In 1996 joined the Mikhailovsky Theatre.

Repertory includes: 

- Odette-Odile (Swan Lake)
- Giselle (Giselle)
- Raymonda (Raymonda)
- Soloist (Paquita)
- Princess Aurora, Lilac Fairy (The Sleeping Beauty)
- Nikiya, Gamzatti (La Bayadиre)
- Street dancer (Don Quixote)
- Medora (Le Corsaire)

        

    

    

            


			

		





	


	

	

		


			

				

					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