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 (590642,592262,593901,595606,597303,598990,600665,602347,604018,605682,607335,608980,610628,612312,613989,615656,617312,618953,620586,622214,623832,625461,627082,628693,630293,631886,633473,635051,636618,638176,639723,641258,642782,644299,645812,647313,648808,650307,651795,653276,654748,656209,657660,659115,660557,661990,663414,664831,666241,667684,669110,670551,671983,673407,674818,676220,677615,679025,680426,681818,683200,684572,685924,687264,688571,689870,691156,692432,693700,694954,696193,697419,698632,699834,701028,702218,703410,704591,705755,706905,708044,709171,710310,711458,712596,713732,714849,715958,717056,718144,719222,720288,721343,722401,723463,724515,725558,726591,727617,728634,729641,730641,731633,732620,733614,734601,735580,736547,737519,738483,739442,740392,742360,744333,746298,748260,750242,752224,755103,757976,760842,763702,766561,769417,772264,775104,777937,780770,783600,786434,789260,792082,794893,797702,800505,803304,806102,808891,811674,814453,817227,819994,822751,825503,828249,830990,833729,836461,839197,841922,844637,847374,850107,852836,855566,858297,861017,863729,866430,869120,871804,874489,877168,879852,882532,885209,887880,890550,893210,895868,898512,901163,903799,906423,909038,911645,914282,916996,919694,922380,925080,927774,930487,933186,935895,938609,941333,944054,946753,949454,952157,954853,957542,960202,962844,965487,968119,970747,973369,975989,978602,981197,983787,986414,989036,991649,994261,2302002,2305129,2308273,2308428,2311441,2311596,2314604,2314759,2317763,2317918,2320917,2321072,2324064,2324219,2327202,2327357,2330332,2330487,2333443,2333598,2336545,2336700,2339649,2339804,2342739,2342894,2345846,2346001,2348947,2349102,2352076,2352231,2355195,2355350,2358302,2358457,2361406,2361561,2364501,2364656,2367586,2367741,2370660,2370815,2373725,2373880,2376775,2376930,2379813,2379968,2382845,2383000,2385871,2386026,2388939,2389094,2392002,2392157,2395058,2395213,2398101,2398256,2401130,2401285,2404148,2404303,2407162,2407317,2410167,2410322,2413162,2413317,2416149,2416304,2419163,2419318,2422165,2422320,2425156,2425311,2428142,2428297,2431119,2431274,2434086,2434241,2437043,2437198,2439989,2440144,2442924,2443079,2445851,2446006,2448772,2448927,2451682,2451837,2454575,2454730,2457459,2457614,2460338,2460493,2463202,2463357,2466057,2466212,2468935,2469090,2471873,2472028,2474787,2474942,2477730,2477885,2480662,2480817,2483580,2483735,2486488,2486643,2489434,2489589,2492367,2492522,2495292,2495447,2498206,2498361,2501107,2501262,2503995,2504150,2506871,2507026,2509737,2509892,2512599,2512754,2515456,2515611,2518307,2518462,2521150,2521305,2523982,2524137,2526802,2526957,2529615,2529770,2532423,2532578,2535224,2535379,2538019,2538174,2540813,2540968,2543597,2543752,2546370,2546525,2549136,2549291,2551941,2552096,2554737,2554892,2557548,2557703,2560351,2560506,2563140,2563295,2565918,2566075,2568685,2568881,2571514,2571709,2574336,2574531,2577150,2577345,2579959,2580158,2582756,2582955,2585538,2585737,2588309,2588508,2591077,2591276,2593836,2594035,2596587,2596786,2599329,2599528,2602058,2602257,2604774,2604973,2607481,2607680,2610184,2610383,2612878,2613103,2615602,2615827,2618319,2618544,2621026,2621251,2623718,2623943,2626399,2626624,2629080,2629304,2631745,2631969,2634412,2634636,2637059,2637284,2639693,2639918,2642314,2642539,2644923,2645152,2647524,2647753,2650112,2650341,2652691,2652920,2655258,2655487,2657810,2658039,2660344,2660573,2662859,2663088,2665360,2665589,2667847,2668076,2670310,2670539,2672761,2672990,2675192,2675421,2677604,2677833,2679996,2680225,2682372,2682601,2684739,2684968,2687101,2687327,2689455,2689681,2691799,2692025,2694127,2694353,2696513,2696784,2699598,2699869,2702676,2702952,2705753,2706027,2708800,2709074,2711843,2712117,2714874,2715147,2717894,2718168,2720959,2721233,2724067,2724341,2727166,2727440,2730253,2730527,2733351,2733642,2736454,2736745,2739541,2739832,2742618,2742910,2745678,2745970,2748719,2749011,2751748,2752040,2754774,2755067,2757794,2758087,2760815,2761110,2763831,2764125,2766830,2767124,2769814,2770108,2772787,2773081,2775752,2776046,2778741,2779035,2781722,2782016,2784810,2785104,2787896,2788190,2790966,2791260,2794024,2794318,2797099,2797393,2800161,2800455,2803216,2803510,2806190,2806484,2809146,2809440,2812080,2812374,2815002,2815296,2817985,2818279,2820961,2821255,2823933,2824227,2826909,2827203,2830162,2833104,2836031,2838965,2841889,2850463,2863100,2865877,2880946,2883718,2886476,2889211,2891934,2894637,2897326,2900023,2902714,2905298,2907890,2910507,2913105,2915693,2918283,2920856,2923421,2925976,2928512,2931031,2933539,2936039,2938547,2941050,2943544)) 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





	Presidential Orchestra of the Russian Federation (Orchestra) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Presidential Orchestra of the Russian Federation (Orchestra)
			

																
Presidential Orchestra of the Russian Federation (Orchestra)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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