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 (1895009,1897092,1899227,1901375,1903512,1905638,1907783,1909940,1912090,1914251,1916471,1918678,1920877,1923074,1925280,1927525,1929760,1931982,1934187,1936385,1938581,1940766,1942941,1945105,1947260,1949401,1951535,1953665,1955744,1957813,1959870,1961913,1963944,1965970,1967991,2198157,2199677,2201206,2202754,2204289,2205817,2207342,2208864,2210375,2211874,2213579,2215274,2216959,2218745,2220986,2223218,2225438,2227645,2229841,2232026,2234204,2236613,2239232,2242143,2245312,2248475,2251628,2254773,2257909,2261035,2264152,2267258,2270356,2273466,2276579,2279720,2282854,2286000,2289138,2292268,2295389,2298504,2301625,2304752,2307896,2311064,2314227,2317386,2320540,2323688,2326826,2329956,2333067,2336169,2339273,2342368,2345475,2348574,2351676,2354795,2357902,2361005,2364100,2367185,2370259,2373324,2376374,2379412,2382444,2385470,2388487,2391549,2394605,2397648,2400677,2403695,2406709,2409714,2412709,2415696,2418710,2421712,2424703,2427689,2430666,2433634,2436593,2439539,2442474,2445400,2448321,2451231,2454134,2457018,2459897,2462761,2465616,2468493,2471431,2474345,2477288,2480220,2483138,2486046,2488949,2491882,2494806,2497720,2500621,2503509,2506385,2509251,2512112,2514967,2517817,2520660,2523492,2526312,2529125,2531933,2534734,2537528,2540322,2543106,2545879,2548644,2551449,2554245,2557056,2559857,2562646,2565415,2568181,2571018,2573842,2576656,2579460,2582257)) 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





	Moscow Contemporary Music Ensemble (Ensemble) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Moscow Contemporary Music Ensemble (Ensemble)
			

																
Moscow Contemporary Music Ensemble (Ensemble)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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