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 (381013,381031,382838,382856,384657,384675,386469,386487,388273,388291,390081,390099,391881,391899,393680,393698,395475,395493,397264,397282,399065,400839,402604,404362,406118,407869,409613,844512,847251,849984,852712,855443,858167,860887,863599,866300,868989,871673,874356,877036,879721,882399,885084,887750,890418,893077,895735,898382,901029,903665,906289,908903,911515,914152,916862,1071897,1071899,1074292,1074300,1076681,1076687,1079057,1079063,1081422,1081425,1083774,1083778,1086112,1086116,1088436,1088439,1090770,1090776,1093099,1093101,1095412,1095418,1097712,1097718,1099994,1099995,1102265,1102266,1104523,1104524,1106760,1106762,1108977,1108978,1111171,1111174,1113348,1113352,2436358,2436363,2436377,2439304,2439309,2439323,2442239,2442244,2442258,2445165,2445170,2445184,2448091,2448105,2451015,2451058,2451063,2453918,2453961,2453966,2456802,2456845,2456850,2459724,2459729,2462588,2462593,2465443,2465448,2468320,2468325,2471258,2471263,2474172,2474177,2477115,2477120,2480047,2480052,2482965,2482970,2485873,2485878,2488781,2754709,2757730,2760751,2763767,2766766,2769750,2772723,2775688,2778677,2781658,2784746,2787832,2790902,2793960,2880932,2883704,2886462,2889197,2891920,2894623,2897312,2900009,2902700,2905284,2907876,2910493,2913091,2915679,2918269,2920842,2923407,2925962,2928498,2931017,2933525,2936025,3110809,3110828,3112381,3113920,3139772,3141381,3142981,3144575,3146160,3150237,3151781,3153318,3154846,3156366,3157878,3159378,3160867,3162349,3163825,3165292,3166774,3168171,3168214,3168217,3168226,3168235,3169558,3169601,3169604,3169613,3169622,3170938,3170981,3170984,3170993,3171002,3172312,3172355,3172358,3172367,3172376,3173680,3173723,3173726,3173735,3173744,3175040,3175083,3175086,3175095,3175104,3176441,3176484,3176487,3176496,3176505,3177837,3177880,3177883,3177892,3177901,3179311,3179354,3179357,3179366,3179375,3180781,3180824,3180827,3180836,3180845,3182248,3182291,3182294,3182303,3182312,3183709,3183752,3183755,3183764,3183773,3185172,3185215,3185218,3185227,3185236,3186630,3186673,3186676,3186685,3186694,3188084,3188127,3188130,3188139,3188148,3189531,3189574,3189577,3189586,3189595,3190974,3191017,3191020,3191029,3191038,3192413,3192456,3192459,3192468,3192477,3194106,3194149,3194152,3194161,3194170,3195793,3195836,3195839,3195848,3195857,3197576,3197619,3197622,3197631,3197640,3199546,3199589,3199592,3199601,3199610,3201247,3201290,3201293,3201302,3201311,3202941,3202984,3202987,3202996,3203005,3204633,3204676,3204679,3204688,3204697,3206321,3206365,3206368,3206377,3206386,3208003,3208047,3208050,3208059,3208068,3209676,3209720,3209726,3209728,3209741,3211346,3211390,3211396,3211398,3211411,3213055,3213099,3213105,3213107,3213120,3214756,3214800,3214803,3214812,3214821,3216450,3216494,3216497,3216506,3216515,3218141,3218185,3218188,3218197,3218206,3219869,3219872,3219881,3219890,3221544,3221547,3221556,3221565,3223216,3223219,3223228,3223237,3224851,3224854,3224863,3224872,3226473,3226476,3226485,3226494,3228087,3228090,3228099,3228108,3229702,3229705,3229714,3229723,3231319,3231322,3231331,3231340,3231391,3232932,3232935,3232944,3232953,3233004,3234537,3234546,3234555,3234606,3234639,3234646,3234656,3234663,3236142,3236193,3236226,3236233,3236243,3236250,3237768,3237801,3237808,3237818,3237825,3239337,3239370,3239377,3239387,3239394,3240900,3240933,3240940,3240950,3240957,3242498,3242531,3242538,3242548,3242555,3244084,3244117,3244124,3244134,3244141,3245660,3245693,3245700,3245710,3245717,3247251,3247284,3247291,3247301,3247308,3248828,3248861,3248868,3248878,3248885,3250396,3250429,3250436,3250446,3250453,3251960,3251993,3252000,3252010,3252017,3253557,3253590,3253597,3253607,3253614,3255586,3255593,3255603,3255610,3257601,3257608,3257618,3257625,3259602,3259609,3259619,3259626,3261590,3261597,3261607,3261614,3263572,3263579,3263589,3263596,3265552,3265559,3265565,3265577,3267540,3267547,3267553,3267565,3267594,3269599,3269605,3269617,3269646,3271688,3271700,3271729,3273815,3273844,3275943,3278033,3280120,3282250,3284374,3286494,3299214,3301293,3303360,3305415,3307462,3309506,3313682,3315696,3317700,3319694,3321680,3323663,3325807,3328076,3330459,3332829,3335186,3337536,3339882,3339901,3339955,3342221,3342240,3342294,3344582,3344601,3344655,3346934,3346953,3347007,3349277,3349296,3349350,3351605,3351624,3351678,3353926,3353945,3353999,3356244,3356263,3356317,3358592,3358611,3358665,3360957,3360976,3361030,3363314,3363333,3363387,3365677,3365731,3368013,3368067,3370341,3370395,3372662,3372716,3374976,3375030,3375071,3375087,3375108,3375112,3377285,3377339,3377380,3377396,3377417,3377421,3377426,3379639,3379680,3379696,3379717,3379721,3379727,3381922,3381963,3381979,3382000,3382004,3382010,3384187,3384238,3384257,3384281,3384286,3384293,3386461,3386512,3386531,3386555,3386560,3386567,3388721,3388772,3388791,3388815,3388820,3388827,3390975,3391026,3391045,3391069,3391074,3391081,3393269,3393288,3393312,3393317,3393324,3395498,3395517,3395541,3395546,3395553,3397714,3397733,3397757,3397762,3397769,3399921,3399940,3399964,3399969,3399976,3402115,3402134,3402158,3402163,3402170,3402188,3402204,3402213,3402242,3402250,3404298,3404317,3404341,3404346,3404353,3404371,3404387,3404396,3404425,3404433,3406489,3406513,3406518,3406525,3406543,3406559,3406568,3406597,3406605,3408662,3408686,3408691,3408698,3408716,3408732,3408741,3408770,3408778,3410837,3410842,3410849,3410867,3410883,3410892,3410921,3410929,3412971,3412978,3412996,3413012,3413021,3413050,3413058,3415150,3415166,3415175,3415204,3415212,3417292,3417308,3417317,3417346,3417354,3419440,3419449,3419478,3419486,3421549,3421558,3421587,3421595,3423676,3423684,3425743,3425751,3427791,3427799,3456487,3456499,3458611,3458623,3460745,3460757,3462875,3462887,3465025,3465037,3467169,3467181,3469342,3469354,3471504,3471516,3473658,3473670,3475814,3475826,3477964,3477976,3480106,3480118,3482238,3482250,3484365,3484377,3486483,3486495,3488592,3488604,3490725,3490737,3492863,3494983,3497140)) 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





	Dmitry Efremov (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Dmitry Efremov (Dancer)
			

																
Dmitry Efremov (Dancer)

														
				


        
    
            





    

                

    

    

            


			

		





	


	

	

		


			

				

					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