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 (3029499,3030815,3030857,3030926,3030941,3032233,3032271,3032343,3032359,3033637,3033675,3033747,3033764,3035229,3035267,3035339,3035356,3036807,3036850,3036918,3036934,3038418,3038487,3038501,3039978,3040047,3040061,3041528,3041600,3041617,3043071,3043143,3043161,3044609,3044679,3044699,3046143,3046213,3046229,3047659,3047726,3047743,3049234,3049249,3050742,3050762,3052245,3052262,3053736,3053756,3055217,3055235,3056692,3056705,3058149,3058169,3059596,3059617,3061041,3061055,3062777,3062795,3064508,3064528,3064549,3064581,3066233,3066249,3066272,3066300,3067942,3067959,3067978,3068009,3069638,3069656,3069677,3069706,3071345,3071364,3071393,3073020,3073047,3073072,3074688,3074715,3074744,3076374,3076403,3078025,3078058,3079686,3079713,3081335,3081366,3082976,3083005,3084603,3084632,3086283,3087928,3088268,3088351,3089557,3089902,3089981,3091181,3091526,3091606,3092794,3093134,3093218,3094737,3094819,3096328,3096409,3097913,3097997,3099491,3099494,3099574,3101063,3101145,3102623,3102704,3104170,3104253,3105704,3105788,3107257,3107343,3108804,3108910,3110375,3110480,3111932,3112039,3113479,3113584,3115013,3115117,3116534,3116640,3118046,3118152,3119558,3119663,3121062,3121166,3122591,3122697,3124288,3124393,3125970,3126078,3127644,3127754,3129308,3129416,3130964,3131072,3132611,3132698,3132719,3132733,3132763,3134251,3134338,3134359,3134373,3134403,3135891,3135978,3135999,3136013,3136043,3137524,3137611,3137632,3137646,3137676,3139145,3139232,3139253,3139267,3139297,3140757,3140844,3140865,3140879,3140909,3142361,3142448,3142469,3142483,3142513,3143955,3144042,3144063,3144077,3144107,3145545,3145632,3145653,3145667,3145697,3147125,3147212,3147233,3147247,3147277,3147761,3147848,3147869,3147883,3147913,3148391,3148478,3148499,3148513,3148543,3149015,3149102,3149123,3149137,3149167,3149639,3149726,3149747,3149761,3149791,3151186,3151273,3151294,3151308,3151338,3152725,3152812,3152833,3152847,3152877,3154258,3154345,3154366,3154380,3154410,3155781,3155868,3155889,3155903,3155933,3157297,3157384,3157405,3157419,3157449,3158804,3158891,3158912,3158926,3158956,3160298,3160385,3160406,3160420,3160450,3161783,3161870,3161891,3161905,3161935,3163260,3163347,3163368,3163382,3163412,3164732,3164819,3164840,3164854,3164884,3166195,3166282,3166303,3166317,3166347,3167640,3167710,3167726,3167737,3167762,3169034,3169104,3169120,3169131,3169156,3170419,3170489,3170505,3170516,3170541,3171796,3171866,3171882,3171893,3171918,3173167,3173237,3173253,3173264,3173289,3174532,3174602,3174618,3174629,3174653,3175871,3175933,3176004,3176020,3176031,3176055,3177269,3177290,3177331,3177402,3177418,3177429,3177453,3178660,3178681,3178721,3178791,3178807,3178818,3178842,3180132,3180153,3180193,3180263,3180279,3180290,3180314,3181600,3181621,3181661,3181731,3181747,3181758,3181782,3183066,3183087,3183127,3183197,3183213,3183224,3183248,3184529,3184550,3184590,3184660,3184676,3184687,3184711,3184730,3184792,3184810,3185990,3186011,3186051,3186121,3186137,3186148,3186172,3186191,3186253,3186271,3187447,3187468,3187508,3187578,3187594,3187605,3187629,3187648,3187710,3187728,3188898,3188919,3188959,3189029,3189045,3189056,3189080,3189099,3189161,3189179,3190344,3190364,3190406,3190471,3190492,3190502,3190524,3190544,3190609,3190622,3191785,3191804,3191846,3191914,3191933,3191943,3191964,3191985,3192046,3192063,3193241,3193286,3193349,3193367,3193377,3193399,3193423,3193486,3193499,3194931,3194977,3195041,3195059,3195068,3195090,3195113,3195173,3195191,3196717,3196762,3196824,3196845,3196854,3196878,3196900,3196961,3196976,3198691,3198733,3198802,3198819,3198827,3198853,3198872,3198933,3198952,3200660,3200704,3200767,3200788,3200795,3200818,3200841,3200905,3200920,3202357,3202399,3202467,3202486,3202496,3202518,3202538,3202600,3202616,3204051,3204094,3204160,3204179,3204186,3204211,3204232,3204296,3204311,3205741,3205781,3205848,3205868,3205878,3205899,3205920,3205982,3206001,3207428,3207473,3207537,3207554,3207564,3207588,3207611,3207673,3207688,3209153,3209218,3209234,3209244,3209269,3209291,3209353,3209368,3210821,3210891,3210908,3210918,3210939,3210960,3211022,3211041,3212544,3212610,3212626,3212636,3212658,3212683,3212741,3212760,3214245,3214314,3214330,3214339,3214364,3214386,3214449,3214462,3215940,3216006,3216024,3216035,3216056,3216081,3216141,3216157,3217636,3217701,3217718,3217728,3217751,3217776,3217837,3217851,3219323,3219387,3219407,3219418,3219441,3219462,3219525,3219539,3221003,3221067,3221086,3221095,3221119,3221142,3221205,3221218,3222669,3222733,3222754,3222761,3222787,3222810,3222872,3222886,3224335,3224400,3224417,3224426,3224452,3224475,3224536,3224552,3225963,3226030,3226046,3226057,3226079,3226103,3226165,3226182,3227646,3227662,3227672,3227695,3227717,3227780,3227796,3229263,3229279,3229290,3229313,3229334,3229399,3229413,3230884,3230903,3230912,3230937,3230959,3231022,3231036,3232501,3232510,3232518,3232528,3232551,3232574,3232639,3232654,3234111,3234117,3234127,3234136,3234161,3234183,3234244,3234263,3235707,3235717,3235728,3235736,3235760,3235781,3235843,3235862,3237293,3237300,3237311,3237319,3237344,3237365,3237427,3237446,3238861,3238869,3238882,3238892,3238913,3238935,3239000,3239015,3240429,3240439,3240449,3240459,3240482,3240503,3240568,3240582,3242032,3242042,3242050,3242059,3242085,3242105,3242171,3242184,3243628,3243635,3243645,3243655,3243678,3243698,3243762,3243776,3245208,3245215,3245226,3245237,3245261,3245282,3245340,3245358,3246810,3246819,3246830,3246840,3246860,3246882,3246943,3246959,3248395,3248406,3248416,3248426,3248446,3248468,3248529,3248546,3249968,3249975,3249984,3249994,3250018,3250039,3250102,3250116,3251530,3251540,3251550,3251560,3251584,3251603,3251667,3251682,3253092,3253098,3253109,3253120,3253144,3253166,3253227,3253242,3254689,3254698,3254708,3254719,3254742,3254765,3254825,3254841,3256709,3256720,3256729,3256752,3256776,3256833,3256852,3256862,3258721,3258732,3258742,3258764,3258787,3258844,3258863,3258874,3260728,3260739,3260759,3260781,3260841,3260858,3260871,3262710,3262718,3262741,3262765,3262827,3262842,3262851,3264690,3264702,3264725,3264746,3264807,3264822,3264830,3266677,3266702,3266722,3266784,3266799,3266807,3268664,3268687,3268691,3268695,3268709,3268728,3268735,3268770,3268784,3268793,3270711,3270734,3270737,3270747,3270755,3270779,3270786,3270818,3270833,3270843,3272861,3272864,3272872,3272884,3272905,3272912,3272946,3272959,3272970,3274973,3274975,3274982,3274995,3275016,3275022,3275055,3275071,3275079,3277065,3277068,3277077,3277086,3277109,3277115,3277148,3277162,3277172,3279155,3279158,3279161,3279174,3279199,3279203,3279238,3279254,3279265,3281289,3281293,3281296,3281309,3281333,3281338,3281373,3281387,3281396,3283414,3283419,3283422,3283434,3283460,3283463,3283499,3283516,3283527,3283656,3283764,3283775,3285538,3285541,3285556,3285580,3285584,3285619,3285636,3285646,3285783,3285884,3285894,3287691,3287704,3287725,3287732,3287771,3287785,3287797,3287931,3288032,3288044,3289837,3289859,3289868,3289901,3289920,3289928,3290062,3290167,3290175,3291954,3291979,3291983,3292018,3292034,3292045,3292183,3292283,3292294,3294083,3294088,3294123,3294141,3294151,3294281,3294389,3294398,3296185,3296188,3296226,3296240,3296251,3296381,3296486,3296496,3298278,3298281,3298317,3298333,3298343,3298474,3298581,3298589,3300357,3300366,3300400,3300417,3300425,3300565,3300664,3300673,3302435,3302440,3302478,3302494,3302505,3302636,3302743,3302753,3304500,3304505,3304542,3304557,3304566,3304699,3304804,3304817,3306553,3306587,3306606,3306617,3306753,3306855,3306862,3308599,3308633,3308652,3308663,3308799,3308901,3308912,3310674,3310693,3310704,3310840,3310940,3310951,3312708,3312727,3312735,3312873,3312972,3312978,3314727,3314746,3314757,3314889,3314989,3315002,3316741,3316755,3316767,3316897,3317002,3317009,3318742,3318756,3318767,3318898,3319001,3319010,3320727,3320745,3320757,3320887,3320989,3321001,3322712,3322730,3322741,3322872,3322974,3322983,3324859,3324878,3324886,3325021,3325120,3325129,3327132,3327147,3327154,3327293,3327391,3327400,3329518,3329534,3329546,3329676,3329778,3329791,3331901,3331916,3331925,3332059,3332161,3332170,3334268,3334282,3334290,3334424,3334527,3334537,3336633,3336643,3336780,3336878,3336890,3338982,3338993,3339124,3339226,3339238,3341326,3341336,3341357,3341466,3341572,3341583,3343663,3343670,3343698,3343804,3343909,3343921,3346018,3346029,3346051,3346162,3346263,3346275,3348379,3348402,3348517,3348616,3348625,3350720,3350739,3350855,3350955,3350962,3353065,3353173,3353278,3353285,3355382,3355497,3355596,3355605,3357712,3357823,3357926,3357937,3358005,3360060,3360168,3360270,3360280,3360350,3362422,3362531,3362633,3362641,3362710,3362870,3364774,3364881,3364987,3365000,3365065,3365222,3367117,3367224,3367326,3367335,3367406,3367565,3369558,3369655,3369666,3369734,3369893,3371878,3371980,3371995,3372059,3372220,3374201,3374301,3374313,3374379,3374539,3376509,3376611,3376622,3376690,3376849,3378802,3378818,3378919,3378928,3378997,3379156,3381098,3381114,3381215,3381223,3381293,3381451,3383370,3383384,3383483,3383495,3383561,3383722,3385655,3385666,3385770,3385781,3385846,3386007,3387923,3387937,3388035,3388048,3388114,3388276,3390178,3390191,3390295,3390309,3390376,3390534,3392429,3392443,3392549,3392558,3392627,3392787,3394670,3394686,3394786,3394793,3394863,3395023,3396892,3396903,3397007,3397020,3397085,3397245,3399106,3399122,3399220,3399232,3399299,3399459,3401307,3401320,3401422,3401432,3401501,3401661,3403498,3403514,3403616,3403623,3403693,3403850,3405680,3405692,3405793,3405806,3405873,3406030,3407849,3407862,3407963,3407974,3408040,3408215,3410013,3410024,3410127,3410139,3410205,3410380,3412157,3412166,3412270,3412282,3412351,3412526,3414338,3414439,3414452,3414517,3414610,3414695,3416484,3416587,3416599,3416665,3416755,3416845,3418626,3418728,3418739,3418806,3418896,3418986,3420849,3420859,3420929,3421018,3421104,3422951,3422963,3423030,3423119,3423207,3425032,3425042,3425110,3425200,3425291,3427091,3427102,3427170,3427262,3427347,3429134,3429144,3429213,3429303,3429391,3431158,3431168,3431239,3431330,3431415,3433169,3433179,3433249,3433338,3433425,3435172,3435182,3435251,3435341,3435427,3437168,3437180,3437247,3437336,3437423,3439148,3439158,3439228,3439317,3439406,3441116,3441126,3441195,3441283,3441372,3443080,3443091,3443157,3443248,3443332,3445057,3445067,3445132,3445221,3445306,3447208,3447223,3447285,3447377,3447460,3449355,3449370,3449432,3449523,3449607,3451494,3451508,3451570,3451660,3451749,3453627,3453641,3453702,3453791,3453880,3455745,3455755,3455821,3455911,3456002,3457872,3457885,3457947,3458036,3458124,3459996,3460003,3460071,3460161,3460250,3462131,3462144,3462208,3462299,3462387,3464255,3464266,3464334,3464424,3464515,3466405,3466415,3466484,3466574,3466661,3468598,3468664,3468753,3468843,3470764,3470831,3470921,3471008,3472987,3473076,3473164,3475143,3475230,3475318,3477296,3477384,3477472,3479442,3479532,3479623,3481580,3481668,3481750,3483712,3483800,3483885,3485833,3485919,3486006,3487945,3488031,3488116,3490052,3490139,3490227,3492182,3492205,3492267,3492359,3494303,3494325,3494392,3494477,3496419,3496442,3496505,3496595,3498573,3498594,3498658,3498746,3500717,3500738,3500802,3500892,3502852,3502875,3502937,3503027,3504983,3505005,3505068,3505153,3507108,3507132,3507195,3507280,3509228,3509251,3509313,3509399,3511365,3511428,3511512,3513471,3513539,3513621,3515569,3515634,3515720,3517657,3517721,3517806,3519745,3519806,3519897,3521823,3521888,3521976,3523954,3524042,3526016,3526105,3528070,3528159,3530129,3530213,3530361,3532173,3532258,3532409,3534214,3534298,3534449,3536255,3536343,3536486,3538283,3538367,3538515,3540304,3540395,3540540,3542376,3542463,3542612,3544432,3544522,3544666,3546472,3546564,3546709,3548509,3548594,3548746,3550542,3550615,3550627,3550779,3552584,3552657,3552672,3552819,3554616,3554689,3554703,3554854,3556657,3556730,3556742,3556892,3558752,3558768,3558919,3560766,3560780,3560931,3562768,3562786,3562933,3564772,3564788,3564933,3566787,3566801,3566952,3568799,3568815,3568964,3570820,3570834,3570984,3572828,3572844,3572992,3574840,3574853,3575007,3576747,3576763,3576911,3578652,3578669,3578814,3580549,3580568,3580716,3582440,3582450,3582577,3584301,3584315,3584437,3586157,3586168,3586294,3588012,3588026,3588149,3589864,3589873,3589999,3591712,3591723,3591849,3593558,3593572,3593695,3595521,3595676,3596111,3597512,3597667,3598101,3599490,3599643,3600079,3601602,3602039,3603552,3603987,3605490,3605924,3607416,3607851,3609333,3609769,3611241,3611677,3613139,3613576,3615060,3615500,3616978,3617415,3618883,3619320,3620786,3621221,3622683,3623120,3624577,3625013,3626453,3626892,3628323,3628758,3630183,3630623,3632042,3632482,3633893,3634333,3635736,3636174,3637573,3638010,3639397,3639834,3641207,3641646,3643010,3643448,3644806,3645242,3646594,3647032,3648373,3648808,3650141,3650581,3651900,3652337,3653646,3654086,3655390,3655828,3657121,3657557,3658841,3659281,3660563,3660999,3662287,3662725,3664000,3664441,3665705,3666142,3667403,3667839,3669089,3669527,3671206,3672880,3674545,3676201,3677844,3679481,3681115,3682747,3684372,3685991,3687600,3689200,3690796,3692386,3693970,3695544,3697114,3698669,3700213,3701753,3703286,3704809,3706329,3707841,3709334,3710822,3712308,3713785,3715255,3716717,3718181,3719635,3721079,3722524,3723958,3725386,3726810,3728228,3729638,3731037,3732431,3733818,3735191,3736561,3737926,3739279,3740622,3741961,3743289,3744612,3745927,3747235,3748536,3749824,3751107,3752383,3753649,3754910,3756164,3757420,3758665,3759902,3761136,3762363,3763582,3764800,3766010,3767213,3768406,3769593,3769988,3770377,3770761,3771142,3771522,3771901,3772277,3772650,3773018,3773382,3773752,3774121,3774486,3774849,3775210,3775569,3775926,3776279,3776627,3776979,3777328,3777673,3778013,3778348,3778678,3779003,3779333,3779659,3779980,3780296,3780611,3780922,3781227,3781527,3781824,3782116,3782404,3782687,3782972,3783254,3783533,3783809,3784081,3784352,3784618,3784880,3785138,3785393,3785646,3785980,3786311,3786661,3787007,3787349,3787688,3788023,3788356,3788685,3789011,3789334,3789652,3789968,3790281,3790592,3790899,3791203,3791504,3791801,3792096,3792388,3792677,3792964,3793247,3793526,3793801,3794074,3794343,3794609,3794873,3795135,3795394,3810793,3810798,3811183,3811189,3811568,3811572,3811948,3811954,3812326,3812332,3812700,3812707,3813076,3816945,3816955,3816970,3817304,3817318,3817650,3817667,3817695,3818053,3818081,3818452,3818484,3818854,3818882,3819273,3819664,3820050,3820432,3820812,3821187,3821555,3821920,3822284,3835748,3835758,3835763,3835990,3836000,3836004,3836230,3836240,3836244,3836473,3836477,3836705,3836709,3836724,3836737,3836964,3836967,3836983,3836996,3837221,3837225,3837242,3837254,3837481,3837497,3837512,3837736,3837752,3837765,3838004,3838016,3838261,3838272,3838514,3838526,3838765,3838779,3839018,3839032,3839269,3839281,3839529,3839773,3840013,3840253,3840496,3845804,3846050,3846293,3846532,3846770,3847004,3847488,3847720,3847948,3848172,3848401,3848626,3848848,3849069,3852491,3853083,3853676,3854263,3854846,3855431,3856014,3856592,3857168,3857786,3858403,3859203,3860003,3860805,3861599,3862393,3863183,3863969,3864751,3865531,3866309,3867085,3867855,3868626,3869395,3870160,3870923,3871685,3873172,3873928,3874679,3875431,3876178,3876924,3877669,3878411,3879154,3879891,3880632,3881380,3882122,3882865,3883606,3884345,3885080,3885821,3886556,3887287,3888021,3888751,3889482,3890207,3890931,3900256,3900976,3901689,3902401,3903114,3903822,3904525,3905226,3905923,3906614,3907293,3907309,3907982,3907999,3908673,3908684,3909369,3910049,3910739,3918259,3918935,3919622,3920312,3920986,3921668,3922339,3923018,3923727,3924401,3925070,3925734,3926399,3926409,3926420,3927062,3927071,3927079,3927721,3927730,3927742,3928377,3928387,3928397,3929032,3929043,3929054,3929686,3929696,3929706,3930344,3930357,3930991,3931002,3931636,3931649,3932281,3932288,3932291,3932304,3932928,3932932,3932944,3933572,3933575,3933588,3934217,3934231,3934868,3935504,3936137,3936150,3936793,3936808,3937445,3937460,3938111,3938757,3939399,3940039,3940678,3946377,3946388,3947000,3947010,3947612,3947623,3948231,3948873,3953307,3953925,3954539,3955148,3956401,3956431,3957022,3957056,3957644,3957675,3958262,3958293,3958873,3958906,3959485,3959513,3960084,3960119,3960690,3960718,3961286,3961320,3961915,3962501,3963082,3963657,3964229,3973397,3973949,3974500,3975064,3975674,3976286,3976891,3983351,3983372,3983923,3983941,3984494,3984511,3985076,3985635,3986192,3986749,3987299,3994317,3994836,3995359,3995876,3996385,3998405,3998415,3998912,3998922,3999414,3999424,3999923,4000416,4000914,4035099,4035456,4036357,4037255,4038176,4039088,4132032,4132702,4133371,4134036,4134701,4135363,4136023,4136678,4137330,4250753,4279223,4279348,4279471,4279592,4279751,4279906)) 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





	Yevgeny Konovalov (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yevgeny Konovalov (Dancer)

Yevgeny Konovalov (Dancer)