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 (203502,203505,205174,205177,206878,206881,208572,208575,210230,210233,211800,211802,211804,213333,213335,213337,214871,214873,214875,216404,216406,216408,217935,217937,217939,219460,219462,219464,220981,220983,220985,222498,222500,222502,224010,224012,224014,225518,225520,225522,227028,227030,228533,477537,477540,477545,477548,479109,479113,479117,479122,480676,480680,480684,480689,481430,481433,481438,481441,482172,482176,482181,482186,482909,482913,482918,482923,483644,483648,483652,483657,484395,484399,484403,484408,485144,485148,485152,485157,485887,485891,485895,485900,486620,486623,486629,486631,487341,487342,487346,487351,488052,488056,488060,488065,488765,488768,488772,488778,489477,489480,489484,489490,490184,490187,490191,490197,490886,490890,490895,490896,491579,491582,491586,491592,492264,492267,492271,492277,492947,492950,492954,492960,493629,493632,493636,493642,494307,494311,494316,494317,494976,494980,494985,494988,495637,495638,495642,495648,496286,496290,496295,496298,496924,496928,496933,496934,498394,498397,498403,498406,499856,499859,499865,499868,501311,501314,501320,501323,502759,502763,502768,502771,504242,504245,504249,504254,505721,505725,505730,505731,507190,507193,507197,507202,508662,508665,508669,508674,510129,510132,510136,510141,511589,511592,511596,511601,513043,513047,513048,513053,514520,514523,514527,514532,515990,515993,515997,516002,517451,517454,517458,517463,518904,518905,518909,518914,520348,520351,520357,520359,521789,521790,521794,521799,523223,523226,523232,523234,524648,524651,524657,524659,526064,526065,526069,526074,527471,527472,527476,527481,528877,528878,528882,528887,530279,530283,530286,530291,531677,531681,531684,531690,533067,533070,533074,533080,534509,534513,534518,534521,535937,535940,535944,535950,537372,537376,537380,537384,538803,538808,538812,538813,540224,540228,540233,540235,541636,541640,541645,541647,543083,543087,543091,543095,544561,544565,544570,544572,546030,546034,546039,546040,547485,547489,547493,547494,548939,548943,548948,548950,550388,550392,550397,550399,551829,551833,551838,551840,553263,553267,553271,553273,554684,554688,554692,554693,556096,556100,556104,556105,557502,557506,557510,557511,558902,558906,558910,558911,560299,560303,560307,560308,561689,561693,561697,561699,563076,563080,563084,563086,564453,564457,564461,564463,565819,565824,565828,565830,567177,567182,567186,567188,568538,568542,568546,568548,569891,569895,569899,569901,571233,571238,571242,571244,572616,572620,572624,572626,573996,574000,574004,574006,575365,575369,575373,575375,576725,576729,576733,576735,578082,578086,578090,578092,579432,579436,579440,579442,580771,580775,580779,580781,582100,582104,582108,582110,583430,583434,583438,583440,584750,584754,584758,584760,586063,586067,586071,586073,587372,587376,587380,587382,588672,588676,588681,588683,590006,590011,590016,590022,591626,591631,591636,591642,593265,593270,593275,593281,594974,594979,594985,594989,596671,596676,596682,596686,598354,598360,598364,598370,600033,600038,600044,600048,601711,601717,601721,601727,603386,603391,603397,603401,605046,605052,605057,605063,606703,606708,606714,606718,608348,608353,608359,608363,609986,609991,609997,610001,611670,611675,611681,611685,613348,613353,613359,613363,615015,615020,615026,615030,616668,616673,616678,616684,618312,618317,618323,618327,619945,619950,619956,619960,621570,621575,621580,621586,623191,623196,623202,623206,624801,624806,624812,624816,626422,626427,626433,626437,628033,628038,628044,628048,629633,629638,629644,629648,631226,631231,631237,631241,632813,632818,632824,632828,634391,634396,634402,634406,635963,635969,635973,637527,637531,639076,3234561,3234566,3234571,3234582,3234590,3236148,3236153,3236158,3236169,3236177,3237723,3237728,3237733,3237744,3237752,3239292,3239297,3239302,3239313,3239321,3240855,3240860,3240865,3240876,3240884,3242458,3242463,3242474,3242482,3244049,3244060,3244068,3245636,3245644,3247235,3508064,3508068,3508072,3510180,3510184,3510188,3512292,3512296,3512300,3514394,3514398,3514402,3516488,3516492,3516496,3518575,3518579,3518583,3520660,3520664,3520668,3522734,3522738,3522742,3524808,3524812,3524816,3526864,3526868,3526872,3528929,3528933,3528937,3530981,3530985,3530989,3533023,3533027,3533031,3535063,3535067,3535071,3537097,3537101,3537105,3539123,3539127,3539131,3541162,3541166,3541170,3543223,3543227,3543231,3545271,3545275,3545279,3547309,3547313,3547317,3549344,3549348,3549352,3551386,3551390,3551394,3553423,3553427,3553431,3555464,3555468,3555472,3557494,3557498,3557502,3559512,3559516,3559520,3561521,3561525,3561529,3563521,3563525,3563529,3565541,3565545,3565549,3567557,3567561,3567565,3569580,3569584,3569588,3571588,3571592,3571596,3573608,3573612,3573616,3594296,3594300,3594301,3596292,3596296,3596297,3598274,3598278,3598279,3600241,3600245,3600246,3602193,3602197,3602198,3604136,3604140,3604141,3606067,3606071,3606072,3607990,3607994,3607995,3609903,3609907,3609908,3611804,3611808,3611809,3613733,3613737,3613738,3615650,3615654,3615655,3617560,3617564,3617565,3619468,3619469,3621372)) 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 (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Ainars Rubikis (Conductor)
			

																
Ainars Rubikis (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