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 (399090,400864,402629,404386,406143,407894,409638,411376,413138,414889,416631,418372,420108,421838,421898,423567,423627,425349,427057,428756,430448,432156,433861,435556,437244,438920,440584,442235,443873,467616,467623,469321,469328,471036,471043,472585,472592,474107,474113,474118,474119,474127,474134,475687,475693,475698,475699,475707,475714,477264,477271,477275,477276,477284,477291,478838,478843,478849,478850,478858,478865,480405,480411,480416,480417,480425,480432,481157,481164,481168,481169,481177,481184,481902,481907,481912,481913,481922,481928,482639,482644,482649,482650,482659,482665,483379,483384,483385,483393,483400,484121,484126,484127,484135,484141,484870,484875,484876,484884,484890,485618,485619,485627,485633,486357,486363,487078,487084,487792,487798,488504,488510,489216,489222,489923,489929,490629,491324,501115,501169,502563,502617,504048,504102,505526,505579,506997,507050,508469,508522,509936,509989,511396,511449,512848,512901,514327,514380,515796,515850,517257,517311,518762,520206,521647,523081,524506,525922,527329,528735,530139,531537,532927,534367,535797,537223,538652,538654,540073,540075,541485,541487,542934,542936,544411,544412,545879,545881,547333,547335,548790,557385,557389,557391,558785,558789,558791,560183,560186,560188,561573,561576,561578,562960,562963,562965,564336,564340,564342,565703,565707,565709,567063,567067,567069,568421,568425,568427,568449,569779,569781,569803,571122,571124,571146,572507,572528,573908,575277,576637,577993,579343,580681,582010,583340,586002,586009,587311,587318,588612,588619,589915,589927,591535,591547,593174,593186,594877,594888,596574,596585,598263,598274,599936,599947,601631,603300,1783669,1783687,1783688,1786219,1786220,1788724,1788725,1791218,1791219,1835845,1835849,1835853,1835866,1838037,1838042,1838056,1840221,1840236,1842396,1844541,1846681,1861677,1861684,1861689,1861692,1863792,1863797,1863804,1863806,1865900,1865907,1865912,1865915,1867990,1867997,1868002,1868005,1870074,1870080,1870084,1870085,1872148,1872155,1872160,1872163,1874209,1874215,1874219,1874220,1876263,1876269,1876273,1876274,1878315,1878322,1878327,1878330,1880395,1880400,1880403,1882459,1882464,1882467,1884519,1884522,2094452,2094471,2094477,2096350,2096356,2098215,2098221,2100176,2100182,2102127,2102133,2104094,2117636,2117641,2117643,2117656,2117664,2119523,2119528,2119530,2119543,2119551,2121400,2121405,2121407,2121420,2121428,2123267,2123272,2123274,2123287,2123295,2125119,2125124,2125126,2125139,2125147,2126960,2126965,2126967,2126980,2126988,2128794,2128799,2128801,2128814,2128822,2128910,2128911,2130620,2130625,2130627,2130640,2130648,2130736,2130737,2132436,2132441,2132443,2132456,2132464,2132552,2132553,2134243,2134248,2134250,2134263,2134271,2134359,2134360,2136042,2136044,2136057,2136065,2136153,2136154,2137838,2137846,2137939,2137940,2139684,2139692,2139780,2139781,2141518,2141526,2141614,2141615,2143351,2143439,2143440,2145165,2145253,2145254,2147057,2147058,2148851,2148852,2150631,2150632,2152398,2152399,2154156,2154157,2155905,2155906,2157643,2157644,2159370,2159371,2161124,2161125,2162863,2162864,2164592,2164593,2166313,2166314,2168016,2168017,2169707,2169708,2170491,2170492,2171270,2171271,2323355,2323363,2323369,2323373,2326493,2326501,2326507,2326511,2329623,2329631,2329637,2329641,2332734,2332742,2332748,2332752,2335836,2335844,2335850,2335854,2338932,2338940,2338946,2338950,2342028,2342036,2342042,2342046,2345135,2345143,2345149,2345153,2348234,2348242,2348248,2348252,2351330,2351338,2351344,2351348,2354449,2354457,2354463,2354467,2357556,2357564,2357570,2357574,2360657,2360665,2360671,2360675,2363752,2363760,2363766,2363770,2366837,2366845,2366851,2366855,2369911,2369919,2369925,2369929,2372976,2372984,2372990,2372994,2376040,2376044,2379082,2382114,2436358,2436363,2439304,2439309,2442239,2442244,2445165,2445170,2445209,2448091,2448130,2451040,2451053,2451058,2451063,2453943,2453956,2453961,2453966,2456827,2456840,2456845,2456850,2459706,2459719,2459724,2459729,2462570,2462583,2462588,2462593,2465425,2465438,2465443,2465448,2468302,2468315,2468320,2468325,2471240,2471253,2471258,2471263,2474154,2474167,2474172,2474177,2477110,2477115,2477120,2480042,2480047,2480052,2482965,2482970,2485873,2485878,2488781,2494648,2551430,2551450,2554226,2554246,2557037,2557057,2559838,2559858,2559879,2559885,2562627,2562647,2562668,2562674,2562724,2565400,2565420,2565445,2565446,2565497,2568166,2568186,2568211,2568212,2568263,2570999,2571019,2571040,2571046,2571096,2573823,2573843,2573864,2573870,2573918,2576637,2576657,2576678,2576684,2576732,2579461,2579479,2579485,2579533,2582258,2582276,2582282,2582330,2585058,2585064,2585112,2587829,2587835,2587883,2590597,2590603,2590651,2593356,2593362,2593410,2596107,2596113,2596161,2598849,2598855,2598903,2601632,2604348,2607055,2609758,2612452,2615176,2617893,2620600,2623292,2625974,2631381,2631396,2631400,2631408,2634048,2634063,2634067,2634075,2636694,2636709,2636713,2636721,2639328,2639343,2639347,2639355,2641949,2641964,2641968,2641976,2644558,2644573,2644577,2644585,2647159,2647174,2647178,2647186,2649762,2649766,2649774,2649817,2649821,2649829,2649835,2649842,2649897,2649902,2652341,2652345,2652353,2652396,2652400,2652408,2652414,2652421,2652476,2652481,2654912,2654920,2654963,2654967,2654975,2654981,2654988,2655043,2655048,2657515,2657519,2657527,2657533,2657540,2657595,2657600,2660049,2660053,2660061,2660067,2660074,2660129,2660134,2662564,2662568,2662576,2662582,2662589,2662644,2662649,2665065,2665069,2665077,2665083,2665090,2665145,2665150,2667556,2667564,2667570,2667577,2667632,2667637,2670033,2670040,2670095,2670100,2672546,2672551,2674977,2674982,2677389,2677394,2679781,2679786,2682157,2682162,2684524,2684529,2686886,2686891,2689241,2689246,2754642,2754648,2754658,2754670,2754682,2754688,2754696,2757664,2757670,2757673,2757680,2757692,2757704,2757718,2760691,2760694,2760701,2760713,2760725,2760739,2763710,2763717,2763729,2763741,2763755,2766728,2766740,2766754,2769712,2769724,2769738,2772685,2772697,2772711,2775662,2775676,2778651,2778665,2781646,2784734,2800162,2800169,2803217,2803224,2806191,2806198,2809147,2809154,2812081,2812088,2815003,2815010,2815039,2815048,2815069,2817986,2817993,2818022,2818031,2818052,2820962,2820969,2820998,2821007,2821028,2823934,2823941,2823970,2823979,2824000,2826910,2826917,2826946,2826955,2826976,2829905,2829914,2829935,2832847,2832856,2832877,2835774,2835783,2835804,2838708,2838717,2838738,2841632,2841641,2841662,2880896,2883668,2886426,2889160,2891883,2894586,2897275,2899972,2902663,2905247,2907839,2907895,2907913,2907919,2910456,2910512,2910530,2910536,2913054,2913110,2913128,2913134,2915642,2915698,2915716,2915722,2918232,2918288,2918306,2918312,2920861,2920879,2920885,2923426,2923444,2923450,2925981,2925999,2926005,2928517,2928535,2928541,2931036,2931054,2931060,2933544,2933562,2933568,2936044,2936062,2936068,2938552,2938570,2938576,2941055,2941073,2941079,2943549,2943567,2943573,2946045,2946051,2948507,2948513,2950954,2950960,2953401,2953407,2955896,3096738,3096770,3096775,3096778,3098319,3098351,3098356,3098359,3099896,3099928,3099933,3099936,3101494,3101499,3101502,3103045,3103050,3103053,3104587,3104592,3104595,3106121,3106131,3106133,3107670,3107680,3107682,3109245,3109255,3109257,3110809,3110819,3110821,3110828,3112372,3112374,3112381,3113920,3139749,3139763,3139768,3141358,3141372,3141377,3142958,3142972,3142977,3144552,3144566,3144571,3146137,3146151,3146156,3150214,3150228,3150233,3151758,3151772,3151777,3153295,3153309,3153314,3154823,3154837,3154842,3156343,3156357,3156362,3157855,3157869,3157874,3159355,3159369,3159374,3160844,3160858,3160863,3162326,3162340,3162345,3163802,3163816,3163821,3165269,3165283,3165288,3166751,3166765,3166770,3168148,3168162,3168167,3168199,3168205,3168214,3168217,3168226,3168235,3169535,3169549,3169554,3169586,3169592,3169601,3169604,3169613,3169622,3170915,3170929,3170934,3170966,3170972,3170981,3170984,3170993,3171002,3172289,3172303,3172308,3172340,3172346,3172355,3172358,3172367,3172376,3173657,3173671,3173676,3173708,3173714,3173723,3173726,3173735,3173744,3175017,3175031,3175036,3175068,3175074,3175083,3175086,3175095,3175104,3176418,3176432,3176437,3176469,3176475,3176484,3176487,3176496,3176505,3177814,3177828,3177833,3177865,3177871,3177880,3177883,3177892,3177901,3179288,3179302,3179307,3179339,3179345,3179354,3179357,3179366,3179375,3180758,3180772,3180777,3180809,3180815,3180824,3180827,3180836,3180845,3182225,3182239,3182244,3182276,3182282,3182291,3182294,3182303,3182312,3183686,3183700,3183705,3183737,3183743,3183752,3183755,3183764,3183773,3185149,3185163,3185168,3185200,3185206,3185215,3185218,3185227,3185236,3186607,3186621,3186626,3186658,3186664,3186673,3186676,3186685,3186694,3188061,3188075,3188080,3188112,3188118,3188127,3188130,3188139,3188148,3189508,3189522,3189527,3189559,3189565,3189574,3189577,3189586,3189595,3190951,3190965,3190970,3191002,3191008,3191017,3191020,3191029,3191038,3192390,3192404,3192409,3192441,3192447,3192456,3192459,3192468,3192477,3194083,3194097,3194102,3194134,3194140,3194149,3194152,3194161,3194170,3195770,3195784,3195789,3195821,3195827,3195836,3195839,3195848,3195857,3197553,3197567,3197572,3197604,3197610,3197619,3197622,3197631,3197640,3199523,3199537,3199542,3199574,3199580,3199589,3199592,3199601,3199610,3201224,3201238,3201243,3201275,3201281,3201290,3201293,3201302,3201311,3202918,3202932,3202937,3202969,3202975,3202984,3202987,3202996,3203005,3204610,3204624,3204629,3204661,3204667,3204676,3204679,3204688,3204697,3206298,3206312,3206317,3206349,3206355,3206365,3206368,3206377,3206386,3207980,3207994,3207999,3208031,3208037,3208047,3208050,3208059,3208068,3209660,3209668,3209673,3209706,3209711,3209720,3209726,3209728,3209741,3211330,3211338,3211343,3211376,3211381,3211390,3211396,3211398,3211411,3213047,3213052,3213085,3213090,3213099,3213105,3213107,3213120,3214752,3214784,3214790,3214800,3214803,3214812,3214821,3216446,3216478,3216484,3216494,3216497,3216506,3216515,3218169,3218175,3218185,3218188,3218197,3218206,3219853,3219859,3219869,3219872,3219881,3219890,3221528,3221534,3221544,3221547,3221556,3221565,3223200,3223206,3223216,3223219,3223228,3223237,3224835,3224841,3224851,3224854,3224863,3224872,3226457,3226463,3226473,3226476,3226485,3226494,3228071,3228077,3228087,3228090,3228099,3228108,3229692,3229702,3229705,3229714,3229723,3231319,3231322,3231331,3231340,3232932,3232935,3232944,3232953,3234537,3234546,3234555,3234646,3234656,3236142,3236233,3236243,3237808,3237818,3239377,3239387,3240940,3240950,3242538,3242548,3244124,3244134,3245700,3245710,3247291,3247301,3248868,3248878,3250436,3250446,3252000,3252010,3253597,3253607,3255593,3255603,3255618,3255622,3257608,3257618,3257633,3257637,3259609,3259619,3259634,3259638,3261597,3261607,3261622,3261626,3263579,3263589,3263604,3263608,3265559,3265565,3265584,3265586,3267547,3267553,3267572,3267574,3267588,3267600,3267613,3267627,3269599,3269605,3269624,3269626,3269640,3269652,3269665,3269679,3271688,3271707,3271709,3271723,3271737,3271751,3271765,3273822,3273824,3273838,3273852,3273866,3273880,3275921,3275923,3275937,3275951,3275965,3275979,3278013,3278027,3278041,3278055,3278069,3280114,3280129,3280147,3280162,3282244,3282259,3282277,3282292,3284368,3284383,3284401,3284416,3286505,3286515,3286536,3288645,3288655,3288676,3290778,3290799,3292887,3292908,3294990,3295011,3297107,3299195,3299214,3301274,3301293,3303360,3305415,3307462,3309506,3313590,3313592,3313663,3313674,3313682,3313689,3313693,3313698,3315604,3315606,3315677,3315688,3315696,3315703,3315707,3315712,3317608,3317610,3317681,3317692,3317700,3317707,3317711,3317716,3319602,3319604,3319675,3319686,3319694,3319701,3319705,3319710,3321588,3321590,3321661,3321672,3321680,3321687,3321691,3321696,3323573,3323644,3323655,3323663,3323670,3323674,3323679,3325722,3325727,3325729,3325738,3325747,3325788,3325799,3325807,3325814,3325818,3325823,3327996,3327998,3328007,3328016,3328057,3328068,3328076,3328083,3328087,3328092,3330381,3330390,3330399,3330440,3330451,3330459,3330466,3330470,3330475,3332769,3332810,3332821,3332829,3332836,3332840,3332845,3335167,3335178,3335186,3335193,3335197,3335202,3337517,3337528,3337536,3337543,3337547,3337552,3339863,3339874,3339882,3339889,3339893,3339898,3339955,3342202,3342213,3342221,3342228,3342232,3342237,3342294,3344563,3344574,3344582,3344589,3344593,3344598,3344655,3346915,3346926,3346934,3346941,3346945,3346950,3347007,3349258,3349269,3349277,3349284,3349288,3349293,3349350,3351586,3351597,3351605,3351612,3351616,3351621,3351678,3353907,3353918,3353926,3353933,3353937,3353942,3353999,3356225,3356236,3356244,3356251,3356255,3356260,3356317,3358584,3358592,3358599,3358603,3358608,3358665,3360949,3360957,3360964,3360968,3360973,3361030,3363306,3363314,3363321,3363325,3363330,3363387,3365665,3365669,3365674,3365731,3368001,3368005,3368010,3368067,3370329,3370333,3370338,3370395,3372654,3372659,3372716,3374973,3375030,3377339,3379639,3381922,3384187,3386461,3388721,3390975,3402204,3402213,3402219,3402227,3402232,3402242,3402250,3404387,3404396,3404402,3404410,3404415,3404425,3404433,3406559,3406568,3406574,3406582,3406587,3406597,3406605,3408732,3408741,3408747,3408755,3408760,3408770,3408778,3410883,3410892,3410898,3410906,3410911,3410921,3410929,3413012,3413021,3413027,3413035,3413040,3413050,3413058,3413097,3413102,3413106,3413109,3413118,3413123,3415166,3415175,3415181,3415189,3415194,3415204,3415212,3415251,3415256,3415260,3415263,3415272,3415277,3417308,3417317,3417323,3417331,3417336,3417346,3417354,3417393,3417398,3417402,3417405,3417414,3417419,3419440,3419449,3419455,3419463,3419468,3419478,3419486,3419525,3419530,3419534,3419537,3419546,3419551,3421549,3421558,3421564,3421572,3421577,3421587,3421595,3421634,3421639,3421643,3421646,3421655,3421660,3423653,3423661,3423666,3423676,3423684,3423723,3423728,3423732,3423735,3423744,3423749,3425733,3425743,3425751,3425790,3425795,3425799,3425802,3425811,3425816,3427791,3427799,3427838,3427843,3427847,3427850,3427859,3427864,3429869,3429874,3429878,3429881,3429890,3429895,3431883,3431888,3431892,3431895,3431904,3431909,3431915,3431917,3431922,3431926,3431937,3431939,3431942,3433890,3433895,3433899,3433902,3433911,3433916,3433922,3433924,3433929,3433933,3433944,3433946,3433949,3435890,3435895,3435899,3435902,3435911,3435916,3435922,3435924,3435929,3435933,3435944,3435946,3435949,3437877,3437882,3437886,3437889,3437898,3437903,3437909,3437911,3437916,3437920,3437931,3437933,3437936,3439850,3439855,3439859,3439862,3439871,3439876,3439882,3439884,3439889,3439893,3439904,3439906,3439909,3441816,3441821,3441825,3441828,3441837,3441842,3441848,3441850,3441855,3441859,3441870,3441872,3441875,3443774,3443778,3443783,3443787,3443790,3443799,3443804,3443810,3443812,3443817,3443821,3443832,3443834,3443837,3445749,3445754,3445758,3445761,3445770,3445775,3445781,3445783,3445788,3445792,3445803,3445805,3445808,3447905,3447909,3447912,3447921,3447926,3447932,3447934,3447939,3447943,3447954,3447956,3447959,3450048,3450052,3450055,3450064,3450069,3450075,3450077,3450082,3450086,3450097,3450099,3450102,3452190,3452199,3452204,3452210,3452212,3452217,3452221,3452232,3452234,3452237,3454323,3454328,3454334,3454336,3454341,3454345,3454356,3454358,3454361,3456442,3456447,3456453,3456455,3456460,3456464,3456475,3456477,3456480,3456491,3458566,3458571,3458577,3458579,3458584,3458588,3458599,3458601,3458604,3458615,3460701,3460707,3460709,3460714,3460718,3460731,3460733,3460736,3460749,3462837,3462839,3462844,3462848,3462861,3462863,3462866,3462879,3464987,3464989,3464994,3464998,3465011,3465013,3465016,3465029,3467133,3467138,3467142,3467155,3467157,3467160,3467173,3469315,3469328,3469330,3469333,3469346,3471490,3471492,3471495,3471508,3473644,3473646,3473649,3473651,3473658,3473662,3473683,3475800,3475802,3475805,3475807,3475814,3475818,3475839,3477950,3477952,3477955,3477957,3477964,3477968,3477989,3480092,3480094,3480097,3480099,3480106,3480110,3480131,3482226,3482229,3482231,3482238,3482242,3482263,3484358,3484365,3484369,3484390,3486483,3486487,3486508,3488592,3488596,3488618,3490725,3490729,3490751,3492855,3492877,3494997,3497154,3499301,3501441,3503574,3503600,3503616,3505702,3505728,3505744,3507825,3507851,3507867,3509967,3509983,3512079,3512095,3514181,3514197,3516275,3516291,3518362,3518378,3520448,3520464,3522522,3522538,3524590,3524606,3526662,3528727,3536936,3536939,3536944,3536972,3536993,3537001,3538962,3538965,3538970,3538998,3539019,3539027,3541001,3541004,3541009,3541037,3541058,3541066,3543062,3543065,3543070,3543098,3543119,3543127,3545110,3545113,3545118,3545146,3545167,3545175,3547148,3547151,3547156,3547184,3547205,3547213,3549185,3549190,3549218,3549223,3549239,3549247,3551232,3551260,3551265,3551281,3551289,3553297,3553302,3553318,3553326,3555338,3555343,3555359,3555367,3557368,3557373,3557389,3557397,3559386,3559391,3559407,3559415,3561395,3561400,3561416,3561424,3563400,3563416,3563424,3565436,3565444,3567452,3567460,3569475,3569483,3571494)) 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





	Elizaveta Kruteleva (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Elizaveta Kruteleva (Dancer)

Elizaveta Kruteleva (Dancer)