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 (2571531,2571533,2571541,2571549,2574353,2574355,2574363,2574371,2577167,2577169,2577177,2577185,2579975,2579978,2579986,2579994,2582772,2582775,2582783,2582791,2585554,2585557,2585565,2585573,2588325,2588328,2588336,2588344,2591093,2591096,2591104,2591112,2593852,2593855,2593863,2593871,2596603,2596606,2596614,2596622,2599345,2599348,2599356,2599364,2602074,2602077,2602085,2602093,2604790,2604793,2604801,2604809,2607497,2607500,2607508,2607516,2610200,2610203,2610211,2610219,2612894,2612897,2612905,2612913,2615618,2615621,2615629,2615637,2618335,2618338,2618346,2618354,2621042,2621045,2621053,2621061,2623734,2623737,2623745,2623753,2626415,2626418,2626426,2626434,2629096,2629099,2629107,2629114,2631761,2631764,2631772,2631779,2634428,2634431,2634439,2634446,2637076,2637079,2637087,2637094,2639710,2639713,2639721,2639728,2642331,2642334,2642342,2642349,2644940,2644944,2644952,2644959,2647541,2647545,2647553,2647560,2650129,2650133,2650141,2650148,2652708,2652712,2652720,2652727,2655275,2655279,2655287,2655294,2657827,2657831,2657839,2657846,2660361,2660365,2660373,2660380,2662876,2662880,2662888,2662895,2665377,2665381,2665389,2665396,2667864,2667868,2667876,2667883,2670327,2670331,2670339,2670346,2672778,2672782,2672790,2672797,2675209,2675213,2675221,2675228,2677621,2677625,2677633,2677640,2680013,2680017,2680025,2680032,2682389,2682393,2682401,2682408,2684756,2684760,2684768,2684775,2687118,2687122,2687130,2687137,2689472,2689476,2689484,2689491,2691816,2691820,2691828,2691835,2694144,2694148,2694156,2694163,2696536,2696540,2696550,2696560,2699621,2699625,2699635,2699645,2702699,2702703,2702713,2702723,2705776,2705780,2705790,2705800,2708823,2708827,2708837,2708847,2711866,2711870,2711880,2711890,2714897,2714901,2714911,2714921,2717917,2717921,2717931,2717941,2720982,2720986,2720996,2721006,2724090,2724094,2724104,2724114,2727189,2727193,2727203,2727213,2730276,2730280,2730290,2730300,2733377,2733381,2733392,2733404,2736480,2736484,2736495,2736507,2739567,2739571,2739582,2739594,2742644,2742648,2742659,2742671,2745704,2745708,2745719,2745731,2748745,2748749,2748760,2748772,2751774,2751778,2751789,2751801,2754800,2754804,2754815,2754827,2757820,2757824,2757835,2757847,2760841,2760845,2760856,2760868,2763857,2763861,2763872,2763884,2766856,2766860,2766871,2766883,2769840,2769844,2769855,2769867,2772813,2772817,2772828,2772840,2775778,2775782,2775793,2775805,2778767,2778771,2778782,2778794,2781748,2781752,2781763,2781775,2784836,2784840,2784851,2784863,2787922,2787926,2787937,2787949,2790992,2790996,2791007,2791019,2794050,2794054,2794065,2794077,2797125,2797129,2797140,2797152,2800187,2800191,2800202,2800214,2803242,2803246,2803257,2803269,2806216,2806220,2806231,2806243,2809172,2809176,2809187,2809199,2812106,2812110,2812121,2812133,2815028,2815032,2815043,2815055,2818011,2818015,2818026,2818038,2820987,2820991,2821002,2821014,2823959,2823963,2823974,2823986,2826935,2826939,2826950,2826962,2829894,2829898,2829909,2829921,2832836,2832840,2832851,2832863,2835763,2835767,2835778,2835790,2838697,2838701,2838712,2838724,2841625,2841636,2841648)) 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





	Ainars Rubikis (Musical Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Ainars Rubikis (Musical Director)
			

																
Ainars Rubikis (Musical Director)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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