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 (72173,74203,76221,78231,80237,82236,84232,86213,88195,90163,92121,94070,96023,97961,99890,101811,103720,105620,107514,109400,111277,113146,278123,278127,278287,278291,280000,280004,280164,280168,281868,281872,282032,282036,283727,283731,283894,283895,285587,285588,285751,285755,287442,287446,287606,287610,289285,289289,289450,289455,291122,291126,291285,291288,293018,293021,293181,293184,294907,294910,295070,295073,296787,296790,296950,296953,298664,298667,298827,298830,300534,300538,300698,300702,302423,302427,302587,302590,304306,304309,304469,304474,306232,306235,306242,306343,306346,306351,306357,306406,308155,308159,308166,308267,308270,308275,308281,308330,310073,310076,310088,310185,310188,310193,310198,310248,311987,311990,312002,312099,312102,312107,312112,312162,313896,313899,313910,314008,314011,314016,314021,314071,315801,315804,315815,315913,315916,315921,315926,315976,317699,317702,317713,317811,317814,317819,317824,317874,319589,319592,319603,319701,319704,319709,319714,319764,321468,321471,321482,321580,321583,321588,321593,321643,323338,323341,323352,323450,323453,323458,323463,323512,325233,325236,325247,325345,325348,325353,325358,325410,327134,327138,327144,327243,327247,327251,327255,327311,329032,329035,329046,329144,329147,329152,329157,329208,330923,330926,330937,331035,331038,331044,331049,331100,332809,332812,332822,332921,332924,332930,332935,332986,334684,334687,334697,334796,334799,334805,334810,334861,336550,336553,336563,336662,336665,336671,336676,336727,338416,338419,338429,338529,338532,338538,338542,338591,340297,340301,340308,340410,340414,340419,340425,340474,342224,342232,342334,342337,342343,342349,342398,344148,344157,344258,344261,344267,344272,344322,346073,346174,346177,346183,346188,346237,347980,348081,348084,348090,348096,348144,349971,349974,349979,349986,350034,351849,351853,351857,351864,351912,353727,353730,353735,353742,353789,355600,355603,355608,355614,355662,357477,357480,357485,357492,357539,359383,359387,359392,359399,359446,361282,361286,361290,361297,361345,363173,363177,363181,363187,363236,365055,365059,365063,365069,365118,366937,366941,366946,366951,367000,368813,368817,368821,368827,368875,370686,370687,370691,370696,370749,372550,372551,372555,372560,372613,374405,374409,374414,374419,374468,376250,376254,376259,376263,376312,378084,378089,378094,378099,378146,379917,379922,379927,379932,379979,381745,381749,381755,381760,381807,383565,383568,383573,383578,383628,385380,385384,385390,385394,385443,387188,387191,387196,387201,387251,388999,389003,389009,389014,389062,390800,390803,390808,390813,390863,392600,392603,392608,392613,392663,394395,394399,394403,394409,394458,396189,396193,396200,396249,397978,397985,398033,399765,399813,401583,403341,405098,406850,408596,410336,412103,413860,415603,417342,419082,420815,2362422,2362426,2365510,2365516,2368595,3511524,3513630,3515730,3517820,3519904,3521980,3524049,3526113,3528162,3530224,3532269,3534309,3536348,3538379,3540401,3542473,3544528,3546571,3548607,3550639,3552682,3554713,3556754,3558779,3560789,3562793,3564795,3566813,3568824,3570841,3572853,3574866,3576774,3578677,3580575,3595532,3597523,3599504,3601459,3603410)) 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





	Dmitri Jurowski (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Dmitri Jurowski (Conductor)
			

																
Dmitri Jurowski (Conductor)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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