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 (590435,590500,592056,592121,593694,593760,595402,595466,597099,597163,598783,598848,600461,600525,602140,602205,603814,603878,605476,605542,607131,607195,608776,608840,610414,610484,612098,612168,613775,613845,615442,615512,617095,617166,618739,618809,620372,620442,621997,622068,623618,623688,625229,625317,626850,626938,628461,628549,630061,630149,631654,631742,633241,633329,634819,634907,636386,636474,637944,638032,639488,639579,641026,641114,642552,642639,644072,644156,645581,645669,647086,647172,648581,648667,650080,650166,651568,651654,653049,653135,654521,654607,655982,656068,657433,657519,658888,658974,660331,660417,661763,661849,663187,663273,664604,664690,666014,666100,667455,667541,668883,668969,670324,670410,671756,671842,673180,673266,674591,674677,675993,676079,677384,677472,678765,678859,680166,680260,681558,681652,682940,683034,684312,684406,685671,685758,687011,687098,688319,688405,689618,689704,690904,690990,692180,692266,693447,693532,694702,694788,695941,696027,697167,697253,698380,698466,699582,699668,700776,700862,701963,702052,703155,703244,704336,704425,705506,705594,706656,706744,707795,707883,708923,709010,710041,710128,711189,711276,712327,712414,713461,713547,714580,714667,715689,715776,716787,716874,717875,717962,718953,719040,720019,720106,721074,721161,722132,722219,723194,723281,724246,724333,725289,725376,726322,726409,727347,727435,728364,728452,729371,729459,730371,730459,731363,731451,732350,732438,733344,733432,734331,734419,735310,735398,736277,736365,737249,737337,738213,738301,739170,739258,740120,740206,742088,742174,744060,744147,746025,746112,747987,748073,749969,750055,751951,752037,754830,754916,757703,757789,760569,760655,763430,763519,766289,766378,769144,769230,771990,772076,774829,774916,777663,777751,780496,780582,783328,783417,786160,786247,788987,789073,791809,791895,794628,794716,797437,797525,800241,800329,803040,803129,805837,805926,808626,808715,811498,814277,817051,819818,822576,825328,828074,830815,833554,836286,839016,841741,844461,847200,849933,852662,855392,858117,860837,863549,866249,868939,871623,874306,876986,879670,882350,1892832,1894904,1896987,1899122,1901270,1903407,1905531,1907679,1909836,1911985,1914145,1916366,2196557,2198089,2199609,2201138,2202686,2204221,2205743,2207273,2208795,2210306,2211805,2213505,2215200,2216885,2218671,2220912,2223144,2225364,2227571,2229767,2231952,2234130,2236539,2239158,2242069,2245238,2248401,2251554,2254699,2257835,2260961,2264079,2267185,2270283,2273393,2276501,2279642,2282776,2285922,2289060,2292190,2295311,2298428,2301549,2304676,2307820,2310988,2314151,2317310,2320464,2323612,2326750,2329880,2332991,2336093,2339197,2342293,2345400,2348499,2351595,2354714,2357821,2360923,2364018,2367103,2370177,2373242,2376292,2379330,2382362,2385389,2388404,2391466,2394522,2397565,2400594,2403612,2406626,2409631,2412626,2415613,2418627,2421629,2424620,2427606,2430583,2433551,2436510,2439456,2442391,2445317,2448238,2451148,2454051,2456935,2459814,2462678,2465533,2468410,2471348,2474262,2477205,2480137,2483055,2485963,2488866,2491799,2494723,2497637,2500538,2503426,2506302,2509169,2512030,2514885,2517735,2520578,2523410,2526230,2529043,2531851,2534652,2537445,2540239,2543023)) 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





	Sergey Kondrashev (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Sergey Kondrashev (Conductor)
			

																
Sergey Kondrashev (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