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 (3551485,3553522,3555563,3557593,3559611,3561620,3563620,3565640,3567656,3569472,3569480,3569610,3569615,3569651,3569671,3569679,3569688,3569749,3569753,3569758,3569780,3569784,3569794,3569799,3569803,3569822,3569830,3569905,3569916,3571491,3571618,3571623,3571659,3571679,3571687,3571696,3571760,3571764,3571769,3571791,3571795,3571805,3571810,3571814,3571833,3571841,3571916,3571926,3573638,3573643,3573679,3573699,3573707,3573716,3573780,3573784,3573789,3573811,3573815,3573825,3573830,3573834,3573853,3573861,3573936,3573946,3575546,3575551,3575587,3575607,3575615,3575624,3575688,3575692,3575697,3575719,3575723,3575733,3575738,3575742,3575761,3575769,3575844,3575854,3577453,3577458,3577494,3577514,3577522,3577531,3577595,3577599,3577604,3577626,3577630,3577640,3577645,3577649,3577668,3577676,3577751,3577761,3579356,3579361,3579397,3579417,3579425,3579434,3579498,3579502,3579507,3579529,3579533,3579543,3579548,3579552,3579571,3579579,3579654,3579664,3581255,3581260,3581296,3581316,3581324,3581333,3581397,3581401,3581406,3581428,3581432,3581442,3581447,3581451,3581470,3581478,3581553,3581563,3583117,3583122,3583156,3583174,3583187,3583194,3583258,3583260,3583265,3583291,3583295,3583307,3583308,3583315,3583331,3583342,3583414,3583424,3584977,3584982,3585016,3585034,3585047,3585054,3585118,3585120,3585125,3585151,3585155,3585167,3585168,3585175,3585191,3585202,3585274,3585284,3586834,3586839,3586873,3586891,3586904,3586911,3586975,3586977,3586982,3587008,3587012,3587024,3587025,3587032,3587048,3587059,3587131,3587141,3588688,3588693,3588727,3588745,3588758,3588765,3588829,3588831,3588836,3588862,3588866,3588878,3588879,3588886,3588902,3588913,3588985,3588995,3590540,3590545,3590579,3590597,3590610,3590617,3590681,3590683,3590688,3590714,3590718,3590730,3590731,3590738,3590754,3590765,3590837,3590847,3592389,3592394,3592428,3592446,3592459,3592466,3592530,3592532,3592537,3592563,3592567,3592579,3592580,3592587,3592603,3592614,3592686,3592696,3594326,3594331,3594371,3594389,3594410,3594417,3594481,3594483,3594488,3594514,3594518,3594530,3594531,3594538,3594554,3594565,3594639,3594649,3596322,3596327,3596367,3596385,3596406,3596413,3596477,3596479,3596484,3596510,3596514,3596526,3596527,3596534,3596550,3596561,3596635,3596645,3598304,3598309,3598349,3598367,3598388,3598395,3598459,3598461,3598466,3598492,3598496,3598508,3598509,3598516,3598532,3598543,3598617,3598627,3600271,3600276,3600316,3600334,3600355,3600362,3600426,3600428,3600433,3600459,3600463,3600475,3600476,3600483,3600499,3600510,3600584,3600594,3602223,3602228,3602268,3602286,3602307,3602314,3602378,3602380,3602385,3602411,3602415,3602427,3602428,3602435,3602451,3602462,3602536,3602546,3604166,3604171,3604211,3604229,3604250,3604257,3604321,3604323,3604328,3604354,3604358,3604370,3604371,3604378,3604394,3604405,3604479,3604489,3606097,3606102,3606142,3606160,3606181,3606188,3606252,3606254,3606259,3606285,3606289,3606301,3606302,3606309,3606325,3606336,3606410,3606420,3608020,3608025,3608065,3608083,3608104,3608111,3608175,3608177,3608182,3608208,3608212,3608224,3608225,3608232,3608248,3608259,3608333,3608343,3609933,3609938,3609978,3609996,3610017,3610024,3610088,3610090,3610095,3610121,3610125,3610137,3610138,3610145,3610161,3610172,3610246,3610256,3611834,3611839,3611879,3611897,3611918,3611925,3611989,3611991,3611996,3612022,3612026,3612038,3612039,3612046,3612062,3612073,3612147,3612157,3613763,3613768,3613808,3613826,3613847,3613854,3613918,3613920,3613925,3613951,3613955,3613967,3613968,3613975,3613991,3614002,3614076,3614086,3615680,3615685,3615725,3615743,3615764,3615771,3615835,3615837,3615842,3615868,3615872,3615884,3615885,3615892,3615908,3615919,3615993,3616003,3617590,3617595,3617635,3617653,3617674,3617681,3617745,3617747,3617752,3617778,3617782,3617794,3617795,3617802,3617818,3617829,3617903,3617913,3619494,3619499,3619539,3619557,3619578,3619585,3619649,3619651,3619656,3619682,3619686,3619698,3619699,3619706,3619722,3619733,3619807,3619817,3621397,3621402,3621442,3621460,3621481,3621488,3621552,3621554,3621559,3621585,3621589,3621601,3621602,3621609,3621625,3621636,3621710,3621720,3623292,3623297,3623337,3623355,3623376,3623383,3623447,3623449,3623454,3623480,3623484,3623496,3623497,3623504,3623520,3623531,3623605,3623615,3625175,3625180,3625220,3625238,3625259,3625266,3625330,3625332,3625337,3625363,3625367,3625379,3625380,3625387,3625403,3625414,3625488,3625498,3627047,3627052,3627092,3627110,3627131,3627138,3627202,3627204,3627209,3627235,3627239,3627251,3627252,3627259,3627275,3627286,3627360,3627370,3628911,3628916,3628956,3628974,3628995,3629002,3629066,3629068,3629073,3629099,3629103,3629115,3629116,3629123,3629139,3629150,3629224,3629234,3630771,3630776,3630816,3630834,3630855,3630862,3630926,3630928,3630933,3630959,3630963,3630975,3630976,3630983,3630999,3631010,3631084,3631094,3632630,3632670,3632688,3632709,3632716,3632780,3632782,3632787,3632813,3632817,3632829,3632830,3632837,3632853,3632864,3632938,3632948,3634516,3634534,3634555,3634562,3634626,3634628,3634633,3634659,3634663,3634675,3634676,3634683,3634699,3634710,3634784,3634794,3636355,3636373,3636394,3636401,3636465,3636467,3636472,3636498,3636502,3636514,3636515,3636522,3636538,3636549,3636623,3636633,3638184,3638202,3638223,3638230,3638294,3638296,3638301,3638327,3638331,3638343,3638344,3638351,3638367,3638378,3638452,3638462,3640000,3640018,3640039,3640046,3640110,3640112,3640117,3640143,3640147,3640159,3640160,3640167,3640183,3640194,3640268,3640278,3641806,3641824,3641845,3641852,3641916,3641918,3641923,3641949,3641953,3641965,3641966,3641973,3641989,3642000,3642074,3642084,3643604,3643622,3643643,3643650,3643714,3643716,3643721,3643747,3643751,3643763,3643764,3643771,3643787,3643798,3643872,3643882,3645394,3645412,3645433,3645440,3645504,3645506,3645511,3645537,3645541,3645553,3645554,3645561,3645577,3645588,3645662,3645672,3647195,3647216,3647223,3647287,3647289,3647294,3647320,3647324,3647336,3647337,3647344,3647360,3647371,3647445,3647455,3648970,3648991,3648998,3649062,3649064,3649069,3649095,3649099,3649111,3649112,3649119,3649135,3649146,3649220,3649230,3650732,3650753,3650760,3650824,3650826,3650831,3650857,3650861,3650873,3650874,3650881,3650897,3650908,3650982,3650992,3652504,3652511,3652575,3652577,3652582,3652608,3652612,3652624,3652625,3652632,3652648,3652659,3652733,3652743,3654247,3654254,3654318,3654320,3654325,3654351,3654355,3654367,3654368,3654375,3654391,3654402,3654476,3654486,3655983,3655990,3656054,3656056,3656061,3656087,3656091,3656103,3656104,3656111,3656127,3656138,3656212,3656222,3657709,3657716,3657780,3657782,3657787,3657813,3657817,3657829,3657830,3657837,3657853,3657864,3657938,3657948,3659441,3659505,3659507,3659512,3659538,3659542,3659554,3659555,3659562,3659578,3659589,3659663,3659673,3661172,3661236,3661238,3661243,3661269,3661273,3661285,3661286,3661293,3661309,3661320,3661394,3661404,3662954,3662956,3662961,3662987,3662991,3663003,3663004,3663011,3663027,3663038,3663112,3663122,3664662,3664664,3664669,3664695,3664699,3664711,3664712,3664719,3664735,3664746,3664820,3664830,3666364,3666366,3666371,3666397,3666401,3666413,3666414,3666421,3666437,3666448,3666522,3666532,3668059,3668061,3668066,3668092,3668096,3668108,3668109,3668116,3668132,3668143,3668217,3668227,3669742,3669744,3669749,3669775,3669779,3669791,3669792,3669799,3669815,3669826,3669900,3669910,3671418,3671420,3671425,3671451,3671455,3671467,3671468,3671475,3671491,3671502,3671576,3671586,3673089,3673091,3673096,3673122,3673126,3673138,3673139,3673146,3673162,3673173,3673247,3673257,3674748,3674750,3674755,3674781,3674785,3674797,3674798,3674805,3674821,3674832,3674906,3674916,3676397,3676399,3676404,3676430,3676434,3676446,3676447,3676454,3676470,3676481,3676555,3676565,3678039,3678041,3678046,3678072,3678076,3678088,3678089,3678096,3678112,3678123,3678197,3678207,3679676,3679678,3679683,3679709,3679713,3679725,3679726,3679733,3679749,3679760,3679834,3679844,3681311,3681313,3681318,3681344,3681348,3681360,3681361,3681368,3681384,3681395,3681469,3681479,3682940,3682942,3682947,3682973,3682977,3682989,3682990,3682997,3683013,3683024,3683098,3683108,3684563,3684565,3684570,3684596,3684600,3684612,3684613,3684620,3684636,3684647,3684721,3684731,3686174,3686176,3686181,3686207,3686211,3686223,3686224,3686231,3686247,3686258,3686332,3686342,3687776,3687778,3687783,3687809,3687813,3687825,3687826,3687833,3687849,3687860,3687934,3687944,3689374,3689376,3689381,3689407,3689411,3689423,3689424,3689431,3689447,3689458,3689532,3689542,3690970,3690975,3691001,3691005,3691017,3691018,3691025,3691041,3691052,3691126,3691136,3692562,3692588,3692592,3692604,3692605,3692612,3692628,3692639,3692713,3692723,3694166,3694170,3694182,3694183,3694190,3694206,3694217,3694291,3694301,3695738,3695742,3695754,3695755,3695762,3695778,3695789,3695863,3695873,3697299,3697303,3697315,3697316,3697323,3697339,3697350,3697424,3697434,3698848,3698852,3698864,3698865,3698872,3698888,3698899,3698973,3698983,3700388,3700392,3700404,3700405,3700412,3700428,3700439,3700513,3700523,3701927,3701939,3701940,3701947,3701963,3701974,3702048,3702058,3703468,3703469,3703476,3703492,3703503,3703577,3703587,3704991,3704992,3704999,3705015,3705026,3705100,3705110,3706506,3706507,3706514,3706530,3706541,3706615,3706625,3708015,3708031,3708042,3708116,3708126,3709521,3709532,3709606,3709616,3711007,3711018,3711092,3711102,3712488,3712499,3712573,3712583,3713960,3713971,3714045,3714055,3715428,3715439,3715513,3715523,3716901,3716975,3716985,3718356,3718430,3718440,3719879,3719889,3721324,3721334,3722765,3722775,3724198,3724208,3725625,3725635,3727045,3727055,3728457,3728467,3729863,3729873,3731258,3731268,3732646,3732656,3734025,3734035,3735397,3735407,3736763,3736773,3738119,3738129,3739466,3739476,3740807,3740817,3742141,3742151,3743465,3743475,3744793,3746105)) 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





	Konstantin Artemiev (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Konstantin Artemiev (Tenor)
			

																
Konstantin Artemiev (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