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 (3114199,3114207,3115726,3115737,3117244,3117255,3118753,3118766,3120263,3120276,3121765,3121778,3123376,3123392,3125068,3125084,3126748,3126764,3128418,3128434,3130077,3130093,3131729,3131745,3133373,3133389,3135009,3135025,3136645,3136661,3138270,3138286,3139886,3139902,3141495,3141511,3143096,3143112,3144690,3144706,3146275,3146291,3150352,3150368,3151896,3151912,3153433,3153449,3154961,3154977,3156481,3156497,3157993,3158009,3159493,3159509,3160982,3160998,3162464,3162480,3163940,3163956,3165407,3165423,3166889,3166905,3168286,3168301,3169673,3169688,3171053,3171068,3172427,3172442,3173795,3173810,3175155,3175170,3176556,3176571,3177952,3177967,3179426,3179441,3180896,3180911,3182363,3182378,3183824,3183839,3185287,3185302,3186745,3186760,3188199,3188214,3189646,3189661,3191089,3191104,3192528,3192543,3194221,3194236,3195908,3195923,3197691,3197706,3199661,3199676,3201362,3201377,3203056,3203071,3204748,3204763,3206437,3206452,3208119,3208134,3209793,3209804,3211463,3211474,3213172,3213183,3214872,3214887,3216566,3216581,3218257,3218272,3219941,3219956,3221616,3221631,3223288,3223303,3224923,3224938,3226545,3226560,3228159,3228174,3229776,3229791,3231393,3231408,3233006,3233021,3234608,3234623,3236195,3236210,3237770,3237785,3239339,3239354,3240902,3240917,3242500,3242515,3244086,3244101,3245662,3245677,3247253,3247268,3248830,3248845,3250398,3250413,3251962,3251977,3253559,3253574,3255570,3257585,3282552,3282566,3282576,3284676,3284690,3284700,3286794,3286806,3286818,3288934,3288946,3288958,3291057,3291069,3291081,3293166,3293178,3293190,3295270,3295282,3295294,3297366,3297378,3297390,3299454,3299466,3299478,3301533,3301545,3301557,3303600,3303612,3303624,3305655,3305667,3305679,3307702,3307714,3307726,3309746,3309758,3309770,3311782,3311794,3311806,3313804,3313816,3313828,3315818,3315830,3315842,3317822,3317834,3317846,3319816,3319828,3319840,3321802,3321814,3321826,3323785,3323797,3323809,3325929,3325941,3325953,3328198,3328210,3328222,3330581,3330593,3330605,3332951,3332963,3332975,3335308,3335320,3335332,3337658,3337670,3337682,3340004,3340016,3340028,3342343,3342355,3342367,3344704,3344716,3344728,3347056,3347068,3347080,3349399,3349411,3349423,3351727,3351739,3351751,3354048,3354060,3354072,3356366,3356378,3356390,3358714,3358726,3358738,3361079,3361091,3361103,3363436,3363448,3363460,3365780,3365792,3365804,3368116,3368128,3368140,3370444,3370456,3370468,3372765,3372777,3372789,3375079,3375091,3375103,3377388,3377400,3377412,3379688,3379700,3379712,3381971,3381983,3381995,3384248,3384262,3384276,3386522,3386536,3386550,3388782,3388796,3388810,3391036,3391050,3391064,3393279,3393293,3393307,3395508,3395522,3395536,3397724,3397738,3397752,3399931,3399945,3399959,3402125,3402139,3402153,3404308,3404322,3404336,3406480,3406494,3406508,3408667,3408681,3410832)) 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





	Pyotr Melentyev (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Pyotr Melentyev (Tenor)
			

																
Pyotr Melentyev (Tenor)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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