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 (394673,396462,398247,400027,401794,403556,405313,407065,408812,410552,412319,414076,415819,417559,419299,421032,422762,424487,426201,427900,429594,431286,432988,434686,436380,438063,439731,441387,443029,444658,446278,447892,449494,451087,452677,454265,455845,457418,458985,460541,462089,463641,465187,466730,468429,470130,471682,473223,474803,476380,477953,479524,481087,481834,482573,483307,484048,484799,485544,486282,1915703,1915712,1917915,1917924,1920114,1920124,1922313,1922323,1924506,1924514,1926754,1926762,1928995,1929003,1931225,1931232,1933437,1933446,1935636,1935645,1937832,1937841,1940022,1940030,1942201,1942209,1944372,1944380,1946532,1946541,1948680,1948691,1950816,1950827,1952948,1952959,1955077,1955086,1957153,1957162,1959217,1959226,1961263,1961278,1963300,1963316,1965330,1965340,1967350,1967360,1969370,1969380,1971380,1971390,1973392,1973401,1975387,1975397,1977375,1977386,1979344,1979354,1981343,1981355,1983335,1983347,1985319,1985329,1987298,1987309,1989268,1989279,1991223,1991234,1993161,1993171,1995099,1995111,1997028,1997039,1998949,1998959,2000863,2000873,2002766,2002776,2004656,2004668,2006532,2006542,2008423,2008429,2010308,2010314,2012185,2012191,2014044,2014053,2015884,2015893,2017714,2017720,2019521,2019530,2021328,2021337,2023129,2023138,2024924,2024933,2026915,2026924,2028905,2028914,2030884,2030893,2032849,2032859,2034808,2034817,2036762,2036773,2038707,2038718,2040646,2040657,2042572,2042583,2044483,2044492,2046380,2046391,2048270,2048279,2050152,2050163,2052031,2052035,2053889,2053899,2055840,2055850,2057879,2057890,2059912,2059923,2061939,2061950,2063959,2063970,2065969,2065980,2067970,2067982,2069974,2069987,2071966,2071978,2073956,2075928)) 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





	Mariinsky Theatre Chorus (Choir) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Mariinsky Theatre Chorus (Choir)
			

																
Mariinsky Theatre Chorus (Choir)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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