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 (196486,196492,196497,196500,196505,196509,196510,196514,196515,196519,196523,196527,196531,197798,197804,197810,197812,197817,197821,197822,197826,197827,197831,197836,197839,197843,199115,199121,199127,199129,199134,199138,199139,199143,199144,199148,199153,199156,199160,200432,200438,200444,200446,200451,200455,200456,200460,200461,200465,200470,200473,200477,202114,202120,202126,202128,202133,202137,202138,202142,202143,202147,202152,202155,202159,203786,203792,203797,203800,203805,203809,203810,203814,203815,203819,203823,203827,203831,205461,205467,205472,205475,205479,205483,205484,205488,205489,205493,205498,205501,205505,207159,207165,207170,207173,207177,207181,207182,207186,207187,207191,207195,207199,207203,208847,208853,208858,208860,208865,208869,208870,208874,208875,208879,208883,208887,208891,210509,210514,210519,210523,210528,210532,210533,210537,210538,210542,210545,210550,210554,717314,717318,717323,717328,717333,717338,717342,717347,717351,717356,717361,717365,717370,717374,717378,717382,717386,717390,717394,718395,718400,718403,718408,718413,718418,718424,718428,718432,718437,718442,718446,718451,718455,718459,718463,718467,718471,718476,719467,719471,719476,719481,719486,719491,719495,719500,719504,719509,719514,719518,719523,719527,719531,719535,719539,719543,719547,720526,720530,720535,720540,720545,720550,720554,720559,720563,720568,720573,720577,720582,720586,720590,720594,720598,720602,720606,721575,721579,721584,721589,721594,721599,721603,721608,721612,721617,721622,721626,721631,721635,721639,721643,721647,721651,721655,722625,722630,722635,722640,722645,722650,722655,722659,722664,722669,722674,722678,722683,722687,722691,722695,722699,722703,722708,723682,723687,723690,723695,723700,723705,723711,723716,723720,723725,723730,723734,723739,723743,723747,723751,723755,723759,723764,724734,724737,724742,724747,724752,724758,724762,724766,724772,724777,724781,724786,724790,724794,724798,724802,724806,724811,725779,725784,725789,725794,725798,725803,725807,725812,725817,725821,725826,725830,725834,725838,725842,725846,725850,726812,726817,726822,726826,726831,726835,726840,726845,726849,726854,726858,726862,726866,726870,726874,726878,727838,727843,727847,727852,727856,727861,727866,727870,727875,727879,727883,727887,727891,727895,727899,728856,728860,728864,728869,728874,728877,728879,728884,728888,728892,728896,728900,728905,728910,729861,729866,729870,729875,729880,729884,729889,729893,729897,729901,729905,729909,729913,730862,730866,730871,730876,730880,730885,730889,730893,730897,730901,730905,730909,731855,731860,731862,731869,731873,731876,731881,731885,731889,731893,731897,732841,732846,732850,732855,732859,732863,732867,732871,732875,732879,733832,733839,733843,733848,733851,733855,733859,733863,733868,734821,734825,734830,734833,734837,734841,734845,734850,735800,735805,735808,735812,735816,735820,735825,736782,736786,736790,736794,736798,736799,737753,737757,737762,737766,737770,738717,738721,738725,738730,739674,739678,739683,741649,741654,743630,1473709,1473717,1473722,1473729,1473735,1473742,1473744,1475064,1475070,1475076,1475083,1475089,1475094,1475098,1476403,1476409,1476415,1476422,1476428,1476433,1476437,1477747,1477754,1477760,1477767,1477773,1477778,1477780,1479112,1479119,1479125,1479131,1479138,1479144,1479152,1480496,1480502,1480508,1480515,1480521,1480526,1480530,1481861,1481867,1481873,1481880,1481886,1481891,1481895,1483217,1483224,1483229,1483236,1483242,1483248,1483251,1484573,1484579,1484586,1484592,1484597,1484600,1485917,1485923,1485930,1485935,1485937,1487252,1487259,1487263,1487266,1488575,1488580,1488583,1488587,1488591,1488595,1488599,1488603,1488608,1488609,1488614,1488618,1488622,1488626,1488630,1488634,1488635,1488639,1488640,1489881,1489885,1489889,1489893,1489897,1489901,1489904,1489911,1489912,1489916,1489920,1489924,1489928,1489932,1489935,1489937,1489941,1489942,1491175,1491179,1491183,1491187,1491191,1491194,1491201,1491202,1491206,1491210,1491214,1491218,1491222,1491225,1491227,1491231,1491232,1492461,1492465,1492469,1492473,1492476,1492483,1492484,1492488,1492492,1492496,1492500,1492504,1492507,1492509,1492513,1492514,1493774,1493778,1493782,1493787,1493792,1493793,1493797,1493801,1493805,1493809,1493813,1493817,1493819,1493822,1493823,1495079,1495083,1495087,1495093,1495094,1495098,1495102,1495106,1495110,1495114,1495117,1495119,1495123,1495124,1496377,1496380,1496387,1496388,1496392,1496396,1496400,1496404,1496408,1496411,1496413,1496417,1496418,1497674,1497681,1497682,1497686,1497690,1497694,1497698,1497702,1497705,1497707,1497711,1497712,1498979,1498980,1498984,1498988,1498992,1498996,1499000,1499003,1499005,1499009,1499010,1500270,1500274,1500278,1500282,1500286,1500289,1500290,1500294,1500296,1501552,1501556,1501560,1501564,1501568,1501569,1501573,1501574,1502830,1502834,1502838,1502841,1502843,1502847,1502848,1504096,1504100,1504104,1504105,1504109,1504110,1505360,1505363,1505365,1505369,1505370,1506612,1506614,1506618,1506619,1507860,1507861,1598069,1600934,1603788,1606631,1609468,1612299,1615120,1617932,1620732,1623515,1626284,1629048,1631800,1634544,1637339,1640190,1643024,1645841,1648657,1651466,1654330,1657184,1660027,1662857,1665674,1668481,1671284,1674139,1676986,1679830,1682663,1685482,1688340,1691198,1693969,1696734,1699492,1702241,1704981,2387013,2387112,2387161,2387185,2390075,2390175,2390225,2390250,2393135,2393235,2393286,2393310,2396187,2396287,2396338,2396361,2399223,2399324,2399373,2399398,2402244,2402345,2402394,2402418,2405257,2405359,2405408,2405432,2408269,2408370,2408419,2408443,2411269,2411370,2411420,2411443,2414258,2414362,2414411,2414435,2417242,2417370,2417434,2417458,2420250,2420379,2420442,2420466,2423244,2423373,2423435,2423459,2426233,2426362,2426425,2426450,2429216,2429345,2429409,2429433,2432188,2432317,2432380,2432405,2435151,2435280,2435344,2435368,2438103,2438233,2438295,2438320,2441041,2441172,2441234,2441258,2443969,2444100,2444162,2444186,2446892,2447024,2447086,2447110,2449808,2449939,2450001,2450026,2452713,2452844,2452907,2452930,2455601,2455733,2455795,2455820,2458481,2458612,2458675,2458698,2461351,2461484,2461546,2461570,2464208,2464339,2464402,2464426,2467191,2467254,2467278,2470065,2470127,2470151,2472998,2473061,2473084,2475907,2475970,2476003,2478845,2478909,2478941,2481769,2481833,2481865,2484679,2484743,2484775,2487586,2487649,2487681,2490528,2490591,2490623,2493455,2493520,2493551,2496376,2496440,2496471,2499286,2499350,2499381,2502181,2502244,2502276,2505060,2505125,2505157,2507928,2507992,2508024,2510790,2510854,2510886,2513651,2513715,2513747,2516505,2516569,2516601,2519353,2519418,2519449,2522192,2522257,2522288,2525019,2525083,2525115,2527834,2527898,2527930,2530644,2530709,2530741,2533448,2533513,2533544,2536244,2536309,2536341,2539035,2539099,2539132,2541826,2541891,2541922,2544606,2544671,2544703,2547372,2547436,2547469,2550200,2550232,2553000,2553032,2555793,2555824,2558600,2558631,2561397,2561429,2564180,2564212,2566949,2566981,2569753,2569785,2572583,2572614,2575400,2575432,2578211,2578242,2581020,2581051,2583810,2583841,2586584,2586616,2589385,2592150,2594904,2597650,2600388,2603112,2605821,2783573,2786610,2786654,2786842,2786923,2789689,2789733,2789921,2790002,2792748,2792792,2792980,2793061,2795804,2795850,2796038,2796126,2798873,2798919,2799107,2799195,2801932,2801977,2802166,2802254,2804982,2805027,2805216,2805304,2807949,2807994,2808183,2808271,2810893,2810938,2811127,2811215,2813817,2813862,2814051,2814139,2816733,2816778,2816972,2817072,2819714,2819759,2819953,2820053,2822684,2822729,2822925,2823024,2825666,2825711,2825907,2826006,2828635,2828680,2828876,2828975,2831586,2831631,2831827,2831926,2834516,2834561,2834757,2834856,2837439,2837484,2837680,2837779,2840367,2840412,2840608,2840707,2843285,2843330,2843526,2843625,2844724,2844769,2844965,2845064,2846152,2846197,2846393,2846492,2847571,2847616,2847812,2847911,2848979,2849024,2849220,2849319,2851833,2851878,2852074,2852173,2853253,2853298,2853494,2853593,2854666,2854711,2854907,2855008,2856076,2856121,2856317,2856418,2857479,2857524,2857720,2857821,2858875,2858920,2859116,2859217,2860262,2860307,2860503,2860604,2861638,2861683,2861879,2861980,2864414,2864459,2864656,2864757,2867191,2867236,2867433,2867534,2868564,2868609,2868806,2868907,2869943,2869988,2870185,2870286,2871319,2871364,2871563,2871664,2872690,2872735,2872934,2873036,2874055,2874100,2874299,2874400,2875412,2875457,2875656,2875757,2876758,2876803,2877002,2877103,2878101,2878146,2878345,2878446,2879473,2879518,2879717,2879818,2882249,2882294,2882493,2882594,2885014,2885059,2885258,2885359,2887755,2887800,2887999,2888100,2890483,2890528,2890725,2890828,2893197,2893242,2893439,2893542,2895889,2895934,2896131,2896234,2898619,2898816,2898919,2901318,2901515,2901618,2904002,2904197,2904294,2906581,2906780,2906886,2909167,2909367,2909473,2911776,2911976,2912082,2914367,2914567,2914673,2917151,2917257,2919732,2919837,2922299,2922404,2924861,2924966,2927408,2927513,2929936,2930041,2932446,2932551,2934952,2935057,2937447,2937552,2939948,2940053,2942445,2942550,2944932,2945037,2947402,2947507,2949851,2949956,2952295,2952402,2954736,2954841,2955435,2955440,2955446,2955452,2955459,2955463,2955466,2955470,2955474,2955481,2955486,2955491,2955496,2955502,2955506,2955509,2955513,2955517,2957217,2957327,2957921,2957926,2957932,2957938,2957945,2957949,2957952,2957956,2957960,2957967,2957972,2957977,2957982,2957988,2957992,2957995,2957999,2958003,2959692,2959802,2960396,2960401,2960407,2960413,2960420,2960424,2960427,2960431,2960435,2960442,2960447,2960452,2960457,2960463,2960467,2960470,2960474,2960478,2962154,2962264,2962858,2962863,2962869,2962875,2962882,2962886,2962889,2962893,2962897,2962904,2962909,2962914,2962919,2962925,2962929,2962932,2962936,2962940,2964592,2964702,2965296,2965301,2965307,2965313,2965320,2965324,2965327,2965331,2965335,2965342,2965347,2965352,2965357,2965363,2965367,2965370,2965374,2965378,2967012,2967122,2967716,2967721,2967727,2967733,2967740,2967744,2967747,2967751,2967755,2967762,2967767,2967772,2967777,2967783,2967787,2967790,2967794,2967798,2969426,2969536,2970132,2970137,2970143,2970149,2970156,2970160,2970163,2970167,2970171,2970178,2970183,2970188,2970193,2970199,2970203,2970206,2970210,2970214,2971844,2971954,2972534,2972539,2972545,2972551,2972558,2972562,2972565,2972569,2972573,2972580,2972585,2972590,2972595,2972601,2972605,2972608,2972612,2972616,2974236,2974346,2974927,2974932,2974938,2974944,2974951,2974955,2974958,2974962,2974966,2974973,2974978,2974983,2974988,2974994,2974998,2975001,2975005,2975009,2976617,2976727,2977308,2977313,2977319,2977325,2977332,2977336,2977339,2977343,2977347,2977354,2977359,2977364,2977369,2977375,2977379,2977382,2977386,2977390,2978985,2979093,2979673,2979678,2979684,2979690,2979697,2979701,2979704,2979708,2979712,2979719,2979724,2979729,2979734,2979740,2979744,2979747,2979751,2979755,2981365,2981473,2982053,2982058,2982064,2982070,2982077,2982081,2982084,2982088,2982092,2982099,2982104,2982109,2982114,2982120,2982124,2982127,2982131,2982135,2983733,2983844,2984424,2984429,2984435,2984441,2984448,2984452,2984455,2984459,2984463,2984470,2984475,2984480,2984485,2984491,2984495,2984498,2984502,2984506,2986209,2986789,2986794,2986800,2986806,2986813,2986817,2986820,2986824,2986828,2986835,2986840,2986845,2986850,2986856,2986860,2986863,2986867,2986871,2988591,2989169,2989174,2989180,2989186,2989193,2989197,2989200,2989204,2989208,2989215,2989220,2989225,2989230,2989236,2989240,2989243,2989247,2989251,2990963,2991537,2991542,2991548,2991553,2991561,2991564,2991567,2991572,2991576,2991584,2991590,2991595,2991601,2991606,2991611,2991614,2991619,2991623,2993331,2993905,2993910,2993916,2993921,2993929,2993932,2993935,2993940,2993944,2993952,2993958,2993963,2993969,2993974,2993979,2993982,2993987,2993991,2995686,2996260,2996265,2996271,2996276,2996284,2996287,2996290,2996295,2996299,2996307,2996313,2996318,2996324,2996329,2996334,2996337,2996342,2996346,2998024,2998598,2998603,2998609,2998614,2998622,2998625,2998628,2998633,2998637,2998645,2998651,2998656,2998662,2998667,2998672,2998675,2998680,2998684,3000344,3000918,3000923,3000929,3000934,3000942,3000945,3000948,3000953,3000957,3000965,3000971,3000976,3000982,3000987,3000992,3000995,3001000,3001004,3002662,3003236,3003241,3003247,3003252,3003260,3003263,3003266,3003271,3003275,3003283,3003289,3003294,3003300,3003305,3003310,3003313,3003318,3003322,3004958,3005533,3005538,3005544,3005549,3005556,3005559,3005562,3005567,3005571,3005579,3005585,3005590,3005596,3005601,3005606,3005609,3005614,3005618,3007190,3007766,3007771,3007777,3007782,3007789,3007792,3007795,3007800,3007804,3007812,3007818,3007823,3007829,3007834,3007839,3007842,3007847,3007851,3009377,3009959,3009964,3009970,3009975,3009982,3009985,3009988,3009993,3009997,3010005,3010011,3010016,3010022,3010027,3010032,3010035,3010040,3010044,3011558,3012138,3012143,3012149,3012154,3012161,3012164,3012167,3012172,3012176,3012184,3012190,3012195,3012201,3012206,3012211,3012214,3012219,3012223,3013715,3014297,3014302,3014308,3014313,3014320,3014323,3014326,3014331,3014335,3014343,3014349,3014354,3014360,3014365,3014370,3014373,3014378,3014382,3015858,3016442,3016447,3016453,3016458,3016465,3016468,3016471,3016476,3016480,3016488,3016494,3016499,3016505,3016510,3016515,3016518,3016523,3016527,3018581,3018586,3018592,3018597,3018604,3018607,3018610,3018615,3018619,3018627,3018633,3018638,3018644,3018649,3018654,3018657,3018662,3018666,3020775,3020780,3020786,3020791,3020798,3020801,3020804,3020809,3020813,3020821,3020827,3020832,3020838,3020843,3020848,3020851,3020856,3020860,3022432,3022437,3022441,3022446,3022449,3022451,3022456,3022458,3022462,3022463,3022468,3022473,3022477,3022481,3022486,3022487,3022492,3022495,3023904,3023908,3023912,3023917,3023922,3023927,3023928,3023933,3023935,3023940,3023943,3023948,3023952,3023957,3023962,3023963,3023965,3023968,3025371,3025375,3025379,3025384,3025388,3025393,3025395,3025396,3025400,3025406,3025409,3025414,3025419,3025423,3025429,3025430,3025431,3025434,3026821,3026826,3026829,3026834,3026838,3026843,3026845,3026847,3026850,3026856,3026859,3026864,3026869,3026874,3026879,3026880,3026881,3026884,3028258,3028262,3028267,3028271,3028276,3028280,3028282,3028286,3028289,3028293,3028297,3028303,3028306,3028312,3028316,3028317,3028321,3028322,3029695,3029699,3029703,3029708,3029713,3029717,3029719,3029721,3029724,3029730,3029735,3029739,3029743,3029749,3029753,3029754,3029756,3029759,3031122,3031126,3031130,3031136,3031140,3031144,3031146,3031148,3031152,3031157,3031161,3031165,3031169,3031176,3031180,3031181,3031184,3031186,3032536,3032541,3032545,3032551,3032554,3032559,3032561,3032566,3032568,3032571,3032576,3032581,3032584,3032590,3032594,3032596,3032599,3032601,3033942,3033946,3033952,3033956,3033960,3033965,3033966,3033974,3033975,3033976,3033982,3033986,3033990,3033994,3033999,3034000,3034006,3034008,3035534,3035538,3035544,3035548,3035552,3035557,3035558,3035566,3035567,3035568,3035574,3035578,3035582,3035586,3035591,3035592,3035597,3035599,3037116,3037121,3037125,3037126,3037134,3037135,3037136,3037144,3037145,3037147,3037152,3037157,3037161,3037165,3037170,3037171,3037178,3037179,3038685,3038689,3038694,3038699,3038703,3038704,3038709,3038713,3038714,3038720,3038724,3038729,3038732,3038738,3038743,3038744,3038747,3038748,3040245,3040249,3040254,3040259,3040263,3040268,3040269,3040273,3040274,3040280,3040284,3040289,3040293,3040298,3040302,3040303,3040307,3040308,3041795,3041799,3041805,3041810,3041813,3041819,3041820,3041824,3041825,3041831,3041835,3041839,3041844,3041849,3041853,3041854,3041858,3041859,3043338,3043343,3043348,3043353,3043356,3043362,3043363,3043367,3043368,3043373,3043378,3043383,3043387,3043392,3043397,3043399,3043402,3043403,3044876,3044884,3044886,3044889,3044897,3044902,3044903,3044904,3044906,3044912,3044916,3044922,3044924,3044928,3044934,3044937,3044939,3044942,3046406,3046414,3046418,3046419,3046427,3046432,3046433,3046437,3046438,3046442,3046446,3046451,3046456,3046460,3046463,3046464,3046470,3046471,3047924,3047929,3047931,3047938,3047940,3047945,3047947,3047954,3047955,3047956,3047963,3047966,3047970,3047978,3047981,3047982,3047985,3047986,3049430,3049434,3049441,3049443,3049447,3049451,3049452,3049460,3049462,3049467,3049471,3049474,3049479,3049484,3049488,3049489,3049493,3049494,3050942,3050945,3050949,3050956,3050958,3050961,3050963,3050968,3050972,3050976,3050978,3050983,3050988,3050995,3050998,3051000,3051002,3051003,3052442,3052448,3052453,3052456,3052460,3052464,3052466,3052470,3052474,3052479,3052483,3052485,3052489,3052494,3052502,3052503,3052504,3052506,3053933,3053938,3053942,3053944,3053952,3053954,3053958,3053959,3053961,3053968,3053972,3053974,3053981,3053987,3053991,3053992,3053994,3053995,3055414,3055418,3055421,3055425,3055431,3055436,3055438,3055439,3055441,3055449,3055453,3055455,3055460,3055467,3055471,3055472,3055474,3055477,3056885,3056888,3056896,3056899,3056902,3056908,3056910,3056914,3056917,3056918,3056926,3056931,3056934,3056936,3056941,3056945,3056948,3056950,3058344,3058351,3058356,3058359,3058362,3058366,3058369,3058374,3058375,3058382,3058384,3058388,3058392,3058399,3058402,3058405,3058407,3058408,3059793,3059800,3059804,3059807,3059810,3059814,3059816,3059820,3059825,3059830,3059834,3059836,3059840,3059848,3059852,3059854,3059856,3059857,3061236,3061240,3061244,3061246,3061253,3061255,3061259,3061264,3061266,3061268,3061273,3061276,3061284,3061288,3061293,3061295,3061296,3061298,3062976,3062979,3062982,3062986,3062994,3062997,3062999,3063003,3063005,3063009,3063013,3063016,3063024,3063027,3063031,3063034,3063036,3063038,3064704,3064710,3064715,3064718,3064723,3064726,3064728,3064734,3064737,3064742,3064744,3064749,3064752,3064757,3064762,3064765,3064767,3064768,3066425,3066433,3066435,3066439,3066443,3066447,3066450,3066454,3066455,3066463,3066467,3066471,3066473,3066480,3066484,3066487,3066490,3066491,3068136,3068138,3068145,3068149,3068154,3068156,3068160,3068162,3068167,3068169,3068176,3068178,3068182,3068190,3068193,3068195,3068197,3068200,3069832,3069836,3069844,3069848,3069851,3069854,3069859,3069860,3069865,3069868,3069874,3069879,3069881,3069888,3069890,3069892,3069895,3069898,3071521,3071526,3071532,3071534,3071539,3071543,3071546,3071548,3071553,3071554,3071561,3071566,3071568,3071574,3071577,3071580,3071584,3071585,3073201,3073203,3073209,3073212,3073220,3073222,3073225,3073231,3073232,3073235,3073240,3073243,3073250,3073254,3073259,3073260,3073263,3073264,3074869,3074876,3074880,3074882,3074886,3074890,3074893,3074898,3074899,3074905,3074910,3074912,3074917,3074921,3074925,3074930,3074932,3074933,3076528,3076531,3076539,3076543,3076547,3076549,3076553,3076555,3076560,3076562,3076569,3076572,3076575,3076579,3076584,3076589,3076590,3076591,3078195,3078199,3078202,3078207,3078213,3078215,3078219,3078220,3078223,3078229,3078232,3078235,3078243,3078244,3078249,3078253,3078257,3078258,3079852,3079858,3079863,3079867,3079869,3079874,3079877,3079880,3079884,3079888,3079891,3079897,3079900,3079903,3079908,3079912,3079914,3079917,3081500,3081507,3081511,3081516,3081520,3081523,3081524,3081530,3081533,3081538,3081541,3081544,3081548,3081554,3081558,3081560,3081564,3081565,3083142,3083145,3083150,3083152,3083160,3083163,3083166,3083167,3083169,3083174,3083178,3083183,3083189,3083191,3083198,3083200,3083202,3083204,3084768,3084773,3084778,3084780,3084786,3084788,3084793,3084795,3084796,3084802,3084806,3084809,3084816,3084819,3084826,3084828,3084829,3084832,3086423,3086426,3086429,3086433,3086441,3086445,3086447,3086449,3086450,3086457,3086462,3086465,3086470,3086475,3086479,3086482,3086485,3086486,3088062,3088069,3088073,3088078,3088081,3088084,3088087,3088091,3088094,3088100,3088102,3088105,3088110,3088116,3088120,3088123,3088125,3088127,3089697,3089701,3089704,3089708,3089716,3089719,3089721,3089723,3089727,3089732,3089734,3089738,3089746,3089749,3089752,3089754,3089758,3089761,3091319,3091322,3091330,3091335,3091337,3091340,3091344,3091348,3091351,3091352,3091359,3091363,3091366,3091374,3091376,3091378,3091381,3091384,3092929,3092933,3092940,3092943,3092949,3092954,3092955,3092957,3092958,3092962,3092970,3092974,3092978,3092982,3092986,3092987,3092992,3092994,3094529,3094534,3094540,3094545,3094548,3094551,3094556,3094557,3094561,3094565,3094571,3094573,3094579,3094585,3094586,3094590,3094593,3094595,3096123,3096130,3096132,3096137,3096141,3096144,3096148,3096150,3096155,3096159,3096162,3096165,3096170,3096174,3096179,3096184,3096185,3096188,3097707,3097715,3097717,3097722,3097725,3097729,3097733,3097738,3097740,3097743,3097746,3097751,3097755,3097759,3097767,3097768,3097770,3097773,3099283,3099287,3099293,3099297,3099301,3099305,3099308,3099310,3099312,3099316,3099324,3099328,3099330,3099337,3099340,3099341,3099345,3099347,3099497,3100856,3100859,3100863,3100870,3100873,3100875,3100880,3100881,3100886,3100887,3100892,3100899,3100904,3100906,3100910,3100912,3100917,3100919,3101066,3102414,3102417,3102421,3102429,3102432,3102434,3102439,3102442,3102445,3102448,3102451,3102459,3102463,3102466,3102469,3102471,3102475,3102476,3102625,3103961,3103966,3103969,3103972,3103979,3103981,3103985,3103987,3103990,3103995,3103997,3104002,3104009,3104012,3104017,3104020,3104021,3104023,3104172,3105495,3105501,3105507,3105509,3105514,3105518,3105521,3105524,3105526,3105530,3105537,3105540,3105544,3105551,3105553,3105557,3105559,3105561,3105710,3107048,3107052,3107060,3107063,3107067,3107072,3107074,3107077,3107079,3107082,3107090,3107093,3107098,3107104,3107106,3107110,3107112,3107114,3107263,3108594,3108596,3108600,3108608,3108612,3108614,3108618,3108620,3108622,3108625,3108630,3108637,3108641,3108646,3108648,3108650,3108654,3108656,3108809,3110160,3110164,3110169,3110175,3110179,3110183,3110187,3110190,3110192,3110194,3110202,3110206,3110208,3110214,3110217,3110219,3110224,3110225,3110376,3111721,3111724,3111728,3111731,3111739,3111742,3111744,3111748,3111751,3111754,3111759,3111761,3111769,3111774,3111778,3111780,3111781,3111782,3111935,3113269,3113271,3113275,3113283,3113286,3113289,3113292,3113294,3113295,3113301,3113306,3113313,3113316,3113322,3113324,3113327,3113329,3113331,3113484,3114799,3114807,3114810,3114813,3114817,3114821,3114824,3114828,3114832,3114836,3114839,3114843,3114847,3114855,3114858,3114860,3114862,3114863,3115016,3116320,3116327,3116330,3116334,3116338,3116344,3116346,3116348,3116350,3116358,3116362,3116366,3116369,3116373,3116377,3116382,3116385,3116386,3116538,3117836,3117841,3117845,3117848,3117853,3117857,3117860,3117862,3117864,3117871,3117875,3117877,3117884,3117890,3117893,3117894,3117898,3117899,3118051,3119342,3119345,3119349,3119356,3119359,3119362,3119364,3119368,3119370,3119375,3119380,3119386,3119388,3119394,3119397,3119401,3119403,3119404,3119562,3120848,3120852,3120855,3120859,3120864,3120868,3120870,3120873,3120876,3120879,3120887,3120892,3120893,3120900,3120902,3120906,3120909,3120911,3121066,3122377,3122379,3122383,3122391,3122395,3122397,3122400,3122402,3122406,3122411,3122414,3122418,3122424,3122426,3122431,3122433,3122437,3122440,3122595,3124072,3124077,3124080,3124084,3124091,3124094,3124097,3124099,3124102,3124106,3124109,3124115,3124120,3124123,3124127,3124130,3124133,3124135,3124289,3125759,3125764,3125769,3125772,3125777,3125779,3125781,3125785,3125790,3125793,3125796,3125804,3125807,3125810,3125815,3125817,3125820,3125822,3125976,3127431,3127438,3127442,3127446,3127450,3127454,3127458,3127462,3127464,3127469,3127473,3127475,3127481,3127483,3127492,3127493,3127496,3127497,3127651,3129097,3129101,3129106,3129110,3129115,3129117,3129120,3129123,3129126,3129131,3129136,3129140,3129145,3129149,3129152,3129155,3129158,3129161,3129315,3130752,3130756,3130761,3130765,3130770,3130773,3130775,3130779,3130781,3130786,3130791,3130795,3130800,3130804,3130808,3130810,3130814,3130816,3130971,3132399,3132403,3132408,3132412,3132417,3132420,3132422,3132426,3132428,3132433,3132438,3132442,3132447,3132451,3132455,3132457,3132461,3132463,3132618,3134039,3134043,3134048,3134052,3134057,3134060,3134062,3134066,3134068,3134073,3134078,3134082,3134087,3134091,3134095,3134097,3134101,3134103,3134258,3135672,3135676,3135681,3135685,3135690,3135693,3135695,3135699,3135701,3135706,3135711,3135715,3135720,3135724,3135728,3135730,3135734,3135736,3135898,3137305,3137309,3137314,3137318,3137323,3137326,3137328,3137332,3137334,3137339,3137344,3137348,3137353,3137357,3137361,3137363,3137367,3137369,3137531,3138926,3138930,3138935,3138939,3138944,3138947,3138949,3138953,3138955,3138960,3138965,3138969,3138974,3138978,3138982,3138984,3138988,3138990,3139152,3140538,3140542,3140547,3140551,3140556,3140559,3140561,3140565,3140567,3140572,3140577,3140581,3140586,3140590,3140594,3140596,3140600,3140602,3140764,3142147,3142152,3142156,3142161,3142164,3142166,3142170,3142172,3142177,3142182,3142186,3142191,3142195,3142199,3142201,3142205,3142207,3142368,3143746,3143750,3143755,3143758,3143760,3143764,3143766,3143771,3143776,3143780,3143785,3143789,3143793,3143795,3143799,3143801,3143962,3145340,3145345,3145348,3145350,3145354,3145356,3145361,3145366,3145370,3145375,3145379,3145383,3145385,3145389,3145391,3145552,3146925,3146928,3146930,3146934,3146936,3146941,3146946,3146950,3146955,3146959,3146963,3146965,3146969,3146971,3147132,3147564,3147566,3147570,3147572,3147577,3147582,3147586,3147591,3147595,3147599,3147601,3147605,3147607,3147768,3148200,3148202,3148207,3148212,3148216,3148221,3148225,3148229,3148231,3148235,3148237,3148398,3148831,3148836,3148840,3148845,3148849,3148853,3148855,3148859,3148861,3149022,3149455,3149460,3149464,3149469,3149473,3149477,3149479,3149483,3149485,3149646,3151002,3151007,3151011,3151016,3151020,3151024,3151026,3151030,3151032,3151193,3152546,3152550,3152555,3152559,3152563,3152565,3152569,3152571,3152732,3154083,3154088,3154092,3154096,3154098,3154102,3154104,3154265,3155611,3155615,3155619,3155621,3155625,3155627,3155788,3157131,3157135,3157137,3157141,3157143,3157304,3158642,3158644,3158648,3158650,3158811,3160142,3160144,3160305,3161790,3163267,3164739,3166202,3167646,3169040,3170425,3171802,3173173,3174538,3175940,3177338,3178728,3180200,3181668,3183134,3184597,3186058,3187515,3188966,3190411,3191852,3193287,3194978,3196763,3198738,3200707,3202405,3204098,3205788,3207475,3209155,3210828,3212547,3214250,3215944,3217637,3219326,3221004,3222672,3224337,3225966,3227581,3530387,3532433,3534473,3536512,3538542,3540564,3542636,3544693,3546732,3548771,3550803,3552844,3554880,3556917,3558942,3560956,3562957,3564960,3566979,3568990,3571009,3573017,3575031,3576939,3578841,3580740,3582603,3584463,3586320,3588173,3590026,3591872,3593719,3595701,3597694,3599671,3601629,3603578,3605515,3607440,3609360,3611269,3613166,3615086,3617002,3618909,3620809,3622708,3624600,3626478,3628346,3630210,3632069,3633921,3635762,3637598,3639422,3641233,3643036,3644830,3646618,3648396,3650168,3651926,3653674,3655414,3657147,3658867,3660586,3662312,3664027,3665729,3667426,3669115,3670793,3672467,3674132,3675786,3677431,3679070)) 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





	Leonid Yakobson (Choreography) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Leonid Yakobson (Choreography)
			

																
Leonid Yakobson (Choreography)

														
				


        




    

        Jacobson, Leonid (also spelled Leonid Yakobson;born - St Petersburg, 15 Jan. 1904, died - Moscow, 17 Oct. 1975). Soviet dancer, choreographer, and ballet master. 

He came to ballet late, beginning his studies at the age of 16 with evening classes at the Leningrad Ballet School. However, he progressed so quickly that he was soon transferred to day classes; he graduated in 1926 into the GATOB (later the Kirov). He specialized in character roles, although he also began to choreograph early on in his career. His first notable achievement was his collaboration with Kaplan, Vainonen, and Tchesnakov in the first production of Shostakovich's The Golden Age in 1930. His choreography frequently ran foul of the Soviet authorities, who were upset by his determination to be daring and innovative. He was once banned from working for six years. 

He continued to dance with the Kirov until 1970, although there were several large gaps while he worked elsewhere. He was with the Bolshoi Ballet in Moscow from 1933 to 1942 as dancer and choreographer; he also worked as choreographer with the Isadora Duncan studio in Moscow in 1948. His major ballets include Shurale (mus. Yarullin, Kirov, 1950), Solveig (mus. Grieg, Maly Theatre, 1952), and Spartacus (Kirov, 1956), which was the first production to Khatchaturian's score. He created several ballets for the Kirov in the 1960s, including The Bedbug (1962), for which he chose a young Natalia Makarova in the lead, New Love (1963), and Land of Miracles (1967). He was also a popular concert artist, thanks to his skill at acrobatic dance, and created more than 100 concert pieces. It was Jacobson who made Vestris, the solo Baryshnikov danced when he won the International Ballet Competition in Moscow in 1969. One of Jacobson's miniatures was Rodin, with music by Debussy and inspired by Rodin sculptures at the Hermitage. In 1990 it entered the repertoire of San Francisco Ballet. He formed his own company, Choreographic Miniatures, in St Petersburg in 1970, although it appeared abroad as the Jacobson Ballet. After his death it became the State Ballet of Leningrad.        

    

    

            


			

		





	


	

	

		


			

				

					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