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 (14695,16143,17753,19161,35516,37196,37245,38749,38796,40197,40243,41551,105740,107634,109521,111398,113267,115128,117004,118879,120749,122615,124473,126322,128161,129990,131819,133652,135477,137297,139115,140925,142726,144516,146296,148067,149824,151574,153314,155043,156764,158475,160201,212271,213806,215342,216873,218402,219925,221443,222957,224466,225973,227478,228976,230961,232956,234946,236931,238905,240871,242832,244789,246743,248690,250639,252622,254596,256560,258521,260487,262447,264414,266374,268326,270267,272206,274139,276073,277996,279873,281741,283600,285457,287311,342331,344255,346171,348078,349968,351846,353724,355597,357474,359381,361280,363170,365052,366934,368810,370679,372543,374401,376245,378081,379914,381742,383561,385377,387184,388996,390796,392596,478002,479573,481137,481884,482622,483354,484098,484849,485594,486332,487056,487770,488482,489196,489905,490607,491305,491993,492671,493353,494030,523786,525205,526613,528017,529421,530821,532216,533602,535035,536460,537889,539313,540729,542162,543605,545075,546529,547985,549438,549474,549522,550881,550917,550965,552317,552353,552400,553742,553777,553823,555158,555193,555239,556564,556600,556646,558003,558048,559400,559445,560793,560838,562179,562223,563560,563605,564930,564975,566292,566336,567649,567694,569049,570397,571736,573116,574488,575849,577207,578559,579898,595776,597466,599147,600819,602496,604163,656480,657931,659380,660817,662244,663660,665077,666484,667919,669339,670778,672202,673622,675027,676425,677811,679219,693933,695181,696410,697630,698837,700033,701222,702421,902619,902690,905252,905320,907869,907940,910483,910554,913094,913164,915722,915795,918426,918499,921119,921192,923798,923872,926493,926565,929209,929280,931918,931989,934625,934696,937330,937400,940061,940130,942779,942848,945484,945553,948186,948255,950961,953660,956353,959029,961684,964324,966960,969592,972220,974840,977452,980059,982651,985237,987861,990480,993091,1006243,1006294,1008810,1008861,1011368,1011420,1013948,1014000,1016516,1016561,1019061,1019111,1021608,1021658,1024153,1024203,1026688,1026738,1029218,1029268,1031744,1031793,1034247,1034296,1036737,1036786,1039234,1039274,1041717,1041758,1044193,1044234,1046660,1046705,1049117,1049162,1051561,1051605,1053991,1054035,1056418,1056462,1058840,1058884,1061249,1061293,1063648,1063694,1066042,1066088,1068424,1068470,1070794,1070840,1073192,1073240,1075585,1075633,1077968,1078015,1080339,1080386,1082699,1082746,1085041,1085089,1087375,1087422,1089689,1089739,1092019,1092068,1094341,1094390,1096658,1096703,1098954,1098999,1101230,1101276,1103501,1103547,1105750,1105796,1107978,1108024,1110231,1112417,1114585,1116738,1118873,1121004,1123144,1125280,1483409,1483461,1484758,1484809,1486096,1486147,1487424,1487477,1488742,1488794,1490044,1490095,1491334,1491385,1492616,1492667,1493924,1493977,1494042,1495226,1495278,1495343,1496520,1496571,1496638,1497813,1497864,1497931,1499111,1499162,1499229,1500395,1500448,1500514,1501673,1501727,1501793,1502949,1503000,1503067,1504209,1504263,1504333,1505471,1505522,1505589,1506720,1506771,1506838,1507962,1508013,1508080,1509194,1509241,1509313,1510419,1510470,1510537,1511648,1511699,1511766,1512870,1512921,1512989,1514095,1514142,1514214,1515322,1515369,1515441,1516541,1516588,1516661,1517751,1517802,1517870,1518953,1519004,1519072,1520153,1520204,1520271,1521346,1521397,1521465,1522533,1522584,1522652,1523712,1523763,1523831,1524884,1524935,1525003,1526048,1526100,1526168,1527207,1527258,1527326,1528359,1528410,1528478,1529506,1529557,1529625,1530649,1530700,1530768,1531788,1531839,1531907,1532922,1532973,1533041,1534051,1534101,1534171,1535178,1535229,1535297,1536300,1536350,1536418,1537416,1537466,1537534,1538556,1538606,1538674,1539689,1539739,1539807,1540815,1540865,1540933,1541937,1541987,1542055,1543055,1543105,1543173,1544162,1544212,1544280,1545264,1545314,1545382,1546406,1546474,1547486,1547554,1548554,1548622,1549611,1549683,1550663,1550735,1551707,1551779,1552751,1552824,1553791,1553866,1554825,1554900,1555850,1555919,1556859,1556932,1557873,1557942,1558946,1559942,1561295,1562985,1564825,1566652,1569287,1572189,1575076,1577953,1580821,1583674,1586513,1589349,2112754,2114659,2116556,2118448,2120330,2122203,3032457,3033865,3035457,3037034,3038602,3040162,3041713,3043262,3044797,3046326,3047845,3049352,3050861,3052361,3053851,3055334,3056808,3058265,3059716,3061152,3062895,3064627,3066344,3068057,3069753,3071439,3073122,3074788,3076451,3078101,3079759,3081413,3083047,3084675,3086330,3087970,3089604,3091230,3092841,3094438,3096034,3097616,3099194,3132685,3134325,3135965,3137598,3139219,3140831,3142435,3144029,3145619,3147199,3147835,3148465,3149089,3149713,3151260,3152799,3154332,3155855,3157371,3158878,3160372,3161857,3163334,3164806,3166269,3167699,3169093,3170478,3171855,3173226,3174591,3175993,3177391,3177597,3177656,3178780,3178986,3179049,3180252,3180458,3180521,3181720,3181926,3181989,3183186,3183392,3183451,3184649,3184857,3184916,3186110,3186318,3186377,3187567,3187775,3187834,3189018,3189226,3189285,3190465,3190669,3190730,3191906,3192110,3192171,3193341,3193550,3193617,3195031,3195236,3195308,3196816,3197021,3197093,3198792,3199000,3199068,3200761,3200965,3201026,3202459,3202662,3202724,3204152,3204357,3204417,3205840,3206049,3206107,3207530,3207734,3207794,3209210,3209414,3209474,3210831,3210880,3210940,3211089,3211147,3212549,3212599,3212659,3212808,3212866,3214254,3214306,3214365,3214509,3214570,3215946,3215999,3216057,3216204,3216266,3217641,3217692,3217752,3217899,3217960,3219327,3219379,3219438,3219588,3219648,3221008,3221058,3221120,3221266,3221327,3222675,3222726,3222786,3222933,3222999,3224338,3224393,3224449,3224601,3224664,3225968,3226019,3226081,3226230,3226293,3227584,3227636,3227697,3227843,3227909,3229201,3229253,3229314,3229462,3229526,3230876,3230936,3231086,3231149,3232492,3232550,3232699,3232765,3234101,3234160,3234310,3234374,3235702,3235761,3235909,3235973,3237286,3237345,3237492,3237557,3238854,3238915,3239063,3239127,3240422,3240480,3240627,3240694,3242025,3242084,3242235,3242297,3243619,3243677,3243824,3243888,3245201,3245259,3245405,3245470,3246801,3246861,3247006,3247072,3248389,3248449,3248594,3248658,3249957,3250017,3250161,3250228,3251523,3251582,3251728,3251793,3253141,3253298,3253396,3254740,3254899,3255026,3256753,3256908,3257038,3258765,3258919,3259047,3260761,3260917,3261045,3262742,3262903,3263027,3264722,3264882,3265008,3266701,3266858,3266985,3268686,3268847,3268970,3270733,3270897,3271044,3272863,3273023,3273171,3274970,3275134,3275282,3277063,3277226,3277374,3279153,3279313,3279465,3281286,3281446,3281597,3283412,3283579,3283713,3283725,3285698,3285833,3285845,3287843,3287983,3287996,3289979,3290114,3290130,3292095,3292229,3292244,3294198,3294340,3294350,3296300,3296434,3296450,3298392,3298531,3298544,3300480,3300618,3300627,3302556,3302693,3302706,3304620,3304754,3304768,3306667,3306804,3306815,3308715,3308852,3308861,3310754,3310890,3310905,3312785,3312924,3314808,3314940,3316815,3316948,3318815,3318950,3320808,3320940,3322793,3322924,3324935,3325074,3327204,3327345,3327694,3329598,3329729,3330080,3331974,3332108,3332461,3334341,3334474,3334828,3336692,3336827,3337181,3339043,3339178,3339529,3341386,3341520,3341873,3343726,3343858,3344210,3346079,3346213,3346567,3348435,3348566,3348917,3350768,3350903,3351254,3353090,3353225,3353578,3355408,3355549,3355896,3357743,3357877,3358027,3358246,3360089,3360222,3360373,3360615,3362445,3362580,3362733,3362978,3364799,3364940,3365089,3365332,3367141,3367274,3367429,3367671,3369469,3369610,3369759,3370002,3371795,3371929,3372084,3372327,3374114,3374249,3374399,3374645,3376427,3376559,3376714,3376958,3378732,3378871,3379018,3379262,3381027,3381167,3381317,3381561,3383437,3383585,3383830,3385718,3385869,3386115,3387987,3388138,3388382,3390250,3390397,3390638,3392497,3392649,3392890,3394733,3394887,3395126,3396954,3397108,3397348,3399174,3399324,3399565,3401374,3401524,3401767,3403564,3403715,3403956,3405745,3405897,3406138,3407910,3408062,3408323,3410080,3410228,3410489,3412219,3412374,3412632,3414389,3414540,3414803,3416536,3416691,3416951,3418677,3418832,3419092,3420803,3420953,3421211,3422903,3423054,3423314,3424980,3425134,3425394,3427045,3427194,3427453,3429082,3429238,3429497,3431113,3431260,3431521,3433120,3433272,3433532,3435122,3435276,3435535,3437122,3437271,3437532,3439252,3439512,3441218,3441477,3443178,3443441,3445154,3445414,3447308,3447569,3449454,3449713,3451594,3451855,3453727,3453987,3455843,3456106,3457968,3458232,3460096,3460364,3462230,3462500,3464358,3464634,3466506,3466783,3468688,3468963,3470852,3471130,3473009,3473288,3475165,3475444,3477318,3477598,3479466,3479743,3481601,3481878,3483736,3484010,3485858,3486131,3487967,3488240,3490074,3490324,3490375,3492204,3492456,3492507,3494327,3494578,3494627,3496441,3496691,3496745,3498595,3498846,3498899,3500741,3500988,3501042,3502873,3503122,3503180,3505006,3505253,3505311,3507130,3507382,3507435,3509249,3509499,3509551,3511363,3511613,3511668,3513472,3513724,3513773,3515568,3515821,3515872,3517656,3517907,3517961,3519744,3519819,3519993,3520049,3521820,3521899,3522071,3522126,3523968,3524141,3524195,3526029,3526204,3526256,3528080,3528255,3528330,3530137,3530316,3530389,3532182,3532358,3532435,3534224,3534401,3534475,3536264,3536440,3536514,3538295,3538467,3538544,3540319,3540493,3540569,3542386,3542563,3542639,3544444,3544620,3544695,3546487,3546661,3546736,3548519,3548698,3548773,3550553,3550728,3550806,3552595,3552771,3552847,3554627,3554804,3554883,3556666,3556841,3556920,3558690,3558868,3558946,3560704,3560878,3560958,3562883,3562962,3564883,3564962,3566902,3566981,3568915,3568994,3570933,3571012,3572942,3573023,3574956,3575033,3576861,3576940,3578764,3578843,3580665,3580742,3582531,3582605,3584391,3584464,3586248,3586321,3588101,3588176,3589954,3590029,3591800,3591875,3593645,3593722,3595626,3595706,3597620,3597697,3599596,3599674,3601552,3601632,3603501,3603582,3605438,3605519,3607367,3607443,3609283,3609364,3611191,3611270,3613089,3613170,3615011,3615092,3616925,3617004,3617466,3618835,3618913,3619373,3620735,3620812,3621280,3622635,3622711,3623178,3624525,3624604,3625070,3626405,3626483,3626948,3628273,3628351,3628817,3630133,3630211,3630676,3631994,3632070,3632537,3633845,3633925,3634386,3635689,3635766,3636232,3637523,3637602,3638066,3639347,3639427,3639889,3641158,3641235,3641703,3642962,3643042,3643503,3644755,3644833,3645300,3646542,3646620,3647087,3648321,3648399,3648864,3650093,3650171,3650636,3651928,3652396,3653678,3654140,3655416,3655879,3657148,3657613,3658869,3659341,3660589,3661068,3662316,3662796,3664029,3664508,3665734,3666212,3667432,3667907,3669120,3669594,3670799,3671277,3672469,3672949,3674136,3674614,3675792,3676269,3677434,3677910,3679071,3679551,3680705,3681183,3682815,3684438,3686058,3687665,3689269,3690863,3692457,3694040,3695611,3697185,3698738,3700280,3701819,3703352,3704879,3706395,3707908,3709402,3710888,3712374,3713853,3715322,3716788,3718247,3719703,3721150,3722590,3724026,3725453,3726877,3728294,3729706,3731107,3732500,3733883,3735259,3736630,3737992,3739345,3740689,3742029,3743360,3744681,3745994,3747302,3748603,3749893,3751174,3752449,3753718,3754979,3756232,3757487,3758733,3759970,3761203,3762431,3763649,3764866,3766079,3767280,3768476,3769661,3770055,3770441,3770828,3771210,3771589,3771971,3772345,3772715,3773085,3773449,3773821,3774185,3774550,3774913,3775274,3775633,3775990,3776343,3776691,3777043,3777392,3777737,3778077,3778412,3778742,3779067,3779397,3779723,3780044,3780360,3780675,3780986,3781291,3781591,3781888,3782180,3782468,3782751,3783036,3783318,3783597,3783873,3784145,3784416,3784682,3784944,3785202,3785457,3785738,3786072,3786403,3786753,3787099,3787441,3787780,3788115,3788448,3788777,3789103,3789426,3789744,3790060,3790373,3790684,3790991,3791295,3791596,3791893,3792188,3792480,3792769,3793056,3793339,3793618,3793893,3794166,3794435,3794701,3794965,3795227,3795486,3795740,3796007,3796272,3796534,3796793,3797048,3797298,3797542,3797784,3798022,3798257,3798489,3798720,3798946,3799166,3799385,3799601,3799815,3800026,3800235,3800440,3800643,3800845,3801045,3801242,3801436,3801627,3801813,3801991,3802168,3802343,3802515,3802684,3802851,3803014,3827427,3827766,3828102,3828433,3828763,3829088,3829404,3829722,3830037,3830352,3830651,3830950,3914865,3915546,3916223,3916894,3917568,3918240,3918913,3919604,3920290,4132022,4132023,4132027,4132029,4132693,4132694,4132698,4132699,4133360,4133361,4133366,4133368,4134027,4134028,4134030,4134033,4134690,4134691,4134696,4134697,4135353,4135355,4135357,4135358,4136016,4136021,4137998,4138667,4139334,4140000,4140657)) 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





	Alexander Trofimov (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Alexander Trofimov (Tenor)
			

																
Alexander Trofimov (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