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 (2216890,2218676,2220917,2223149,2225369,2227576,2229772,2231957,2234135,2236544,2239163,2242071,2245243,2248406,2251559,2254704,2257840,2260966,2264084,2267190,2270288,2273398,2276506,2279647,2282781,2285927,2289065,2292195,2295316,2298433,2301554,2304681,2307825,2310993,2314156,2317315,2320469,2323617,2326755,2329885,2332996,2336098,2339202,2342298,2345405,2348504,2351600,2354719,2357826,2360928,2364023,2367108,2370182,2373247,2376297,2379335,2382367,2385394,2388409,2391471,2394527,2397570,2400599,2403617,2406631,2409636,2412631,2415618,2418632,2421634,2424625,2427611,2430588,2433556,2436515,2439461,2442396,2445322,2448243,2451153,2454056,2456940,2459819,2462683,2465538,2468415,2471353,2474267,2477210,2480142,2483060,2485968,2488871,2491804,2494728,2497642,2500543,2503431,2506307,2509174,2512035,2514890,2517740,2520583,2523415,2526235,2529048,2531856,2534657,2537450,2540244,2543028,2577021,2579830,2582627,2585409,2588180,2590948,2593707,2596458,2599200,2601929,2604645,2607352,2607375,2610055,2610078,2612749,2612772,2615473,2615496,2618190,2618213,2620897,2620920,2623589,2623612,2626270,2626293,2628951,2628974,2631616,2631639,2634283,2634306,2636929,2636952,2639563,2639586,2642184,2642207,2644793,2644816,2647394,2647417,2649982,2650005,2652561,2652584,2655128,2655151,2657680,2657703,2660214,2660237,2662729,2662752,2665230,2665253,2667717,2667740,2670180,2670203,2672631,2672654,2675062,2675085,2677474,2677497,2679866,2679889,2682242,2682265,2684609,2684632,2686971,2686994,2689326,2689349,2691670,2691693,2693998,2694021,2696343,2696373,2699428,2699458,2702498,2702529,2705574,2705605,2708621,2708652,2711664,2711695,2714695,2714726,2717715,2717746,2720780,2720811,2723888,2723919,2726987,2727018,2730074,2730105,2733173,2733204,2736307,2739394,2742471,2745531)) 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





	Kostas Smoriginas (Bass-baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Kostas Smoriginas (Bass-baritone)
			

																
Kostas Smoriginas (Bass-baritone)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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