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 (2515120,2515126,2515132,2515138,2517970,2517976,2517982,2517988,2520813,2520819,2520825,2520831,2523645,2523651,2523657,2523663,2526465,2526471,2526477,2526483,2529278,2529284,2529290,2529296,2532086,2532092,2532098,2532104,2534887,2534893,2534899,2534905,2537681,2537687,2537693,2537699,2540475,2540481,2540487,2540493,2543259,2543265,2543271,2543277,2546032,2546038,2546044,2546050,2548798,2548804,2548810,2548816,2551603,2551609,2551615,2551621,2551652,2551667,2551673,2551689,2551695,2554399,2554405,2554411,2554417,2554448,2554463,2554469,2554485,2554491,2557210,2557216,2557222,2557228,2557259,2557274,2557280,2557296,2557302,2560013,2560019,2560025,2560031,2560062,2560077,2560083,2560099,2560105,2562802,2562808,2562814,2562820,2562851,2562866,2562872,2562888,2562894,2565582,2565583,2565592,2565593,2565628,2565646,2565647,2565670,2565671,2568348,2568349,2568358,2568359,2568394,2568412,2568413,2568436,2568437,2571174,2571180,2571186,2571192,2571223,2571238,2571244,2571260,2571266,2573996,2574002,2574008,2574014,2574045,2574060,2574066,2574082,2574088,2574153,2574159,2574178,2574181,2574184,2574193,2574202,2576810,2576816,2576822,2576828,2576859,2576874,2576880,2576896,2576902,2576967,2576973,2576992,2576995,2576998,2577007,2577016,2577025,2579612,2579618,2579624,2579630,2579662,2579679,2579687,2579705,2579711,2579776,2579782,2579801,2579804,2579807,2579816,2579825,2579834,2582409,2582415,2582421,2582427,2582459,2582476,2582484,2582502,2582508,2582573,2582579,2582598,2582601,2582604,2582613,2582622,2582631,2585191,2585197,2585203,2585209,2585241,2585258,2585266,2585284,2585290,2585355,2585361,2585380,2585383,2585386,2585395,2585404,2585413,2587893,2587908,2587962,2587968,2587974,2587980,2588012,2588029,2588037,2588055,2588061,2588126,2588132,2588151,2588154,2588157,2588166,2588175,2588184,2590661,2590676,2590730,2590736,2590742,2590748,2590780,2590797,2590805,2590823,2590829,2590894,2590900,2590919,2590922,2590925,2590934,2590943,2590952,2593420,2593435,2593489,2593495,2593501,2593507,2593539,2593556,2593564,2593582,2593588,2593653,2593659,2593678,2593681,2593684,2593693,2593702,2593711,2596171,2596186,2596240,2596246,2596252,2596258,2596290,2596307,2596315,2596333,2596339,2596404,2596410,2596429,2596432,2596435,2596444,2596453,2596462,2598913,2598928,2598982,2598988,2598994,2599000,2599032,2599049,2599057,2599075,2599081,2599146,2599152,2599171,2599174,2599177,2599186,2599195,2599204,2601642,2601657,2601711,2601717,2601723,2601729,2601761,2601778,2601786,2601804,2601810,2601875,2601881,2601900,2601903,2601906,2601915,2601924,2601933,2604358,2604373,2604427,2604433,2604439,2604445,2604477,2604494,2604502,2604520,2604526,2604591,2604597,2604616,2604619,2604622,2604631,2604640,2604649,2607065,2607080,2607134,2607140,2607146,2607152,2607184,2607201,2607209,2607227,2607233,2607298,2607304,2607323,2607326,2607329,2607338,2607347,2607356,2607368,2607438,2607446,2609768,2609783,2609837,2609843,2609849,2609855,2609887,2609904,2609912,2609930,2609936,2610001,2610007,2610026,2610029,2610032,2610041,2610050,2610059,2610071,2610141,2610149,2612462,2612477,2612531,2612537,2612543,2612549,2612581,2612598,2612606,2612624,2612630,2612695,2612701,2612720,2612723,2612726,2612735,2612744,2612753,2612765,2612835,2612843,2615186,2615201,2615255,2615261,2615267,2615273,2615305,2615322,2615330,2615348,2615354,2615419,2615425,2615444,2615447,2615450,2615459,2615468,2615477,2615489,2615559,2615567,2617903,2617918,2617972,2617978,2617984,2617990,2618022,2618039,2618047,2618065,2618071,2618136,2618142,2618161,2618164,2618167,2618176,2618185,2618194,2618206,2618276,2618284,2620610,2620625,2620679,2620685,2620691,2620697,2620729,2620746,2620754,2620772,2620778,2620843,2620849,2620868,2620871,2620874,2620883,2620892,2620901,2620913,2620983,2620991,2623302,2623317,2623371,2623377,2623383,2623389,2623421,2623438,2623446,2623464,2623470,2623535,2623541,2623560,2623563,2623566,2623575,2623584,2623593,2623605,2623675,2623683,2625984,2625999,2626052,2626058,2626064,2626070,2626102,2626119,2626127,2626145,2626151,2626216,2626222,2626241,2626244,2626247,2626256,2626265,2626274,2626286,2626356,2626364,2628665,2628680,2628733,2628739,2628745,2628751,2628783,2628800,2628808,2628826,2628832,2628897,2628903,2628922,2628925,2628928,2628937,2628946,2628955,2628967,2629037,2629045,2631330,2631345,2631398,2631404,2631410,2631416,2631448,2631465,2631473,2631491,2631497,2631562,2631568,2631587,2631590,2631593,2631602,2631611,2631620,2631632,2631702,2631710,2634012,2634065,2634071,2634077,2634083,2634115,2634132,2634140,2634158,2634164,2634229,2634235,2634254,2634257,2634260,2634269,2634278,2634287,2634299,2634369,2634377,2636658,2636711,2636717,2636723,2636729,2636761,2636778,2636786,2636804,2636810,2636875,2636881,2636900,2636903,2636906,2636915,2636924,2636933,2636945,2637015,2637023,2639345,2639351,2639357,2639363,2639395,2639412,2639420,2639438,2639444,2639509,2639515,2639534,2639537,2639540,2639549,2639558,2639567,2639579,2639649,2639657,2641966,2641972,2641978,2641984,2642016,2642033,2642041,2642059,2642065,2642130,2642136,2642155,2642158,2642161,2642170,2642179,2642188,2642200,2642270,2642278,2644575,2644581,2644587,2644593,2644625,2644642,2644650,2644668,2644674,2644739,2644745,2644764,2644767,2644770,2644779,2644788,2644797,2644809,2644879,2644887,2647176,2647182,2647188,2647194,2647226,2647243,2647251,2647269,2647275,2647340,2647346,2647365,2647368,2647371,2647380,2647389,2647398,2647410,2647480,2647488,2649764,2649770,2649776,2649782,2649814,2649831,2649839,2649857,2649863,2649928,2649934,2649953,2649956,2649959,2649968,2649977,2649986,2649998,2650068,2650076,2652343,2652349,2652355,2652361,2652393,2652410,2652418,2652436,2652442,2652507,2652513,2652532,2652535,2652538,2652547,2652556,2652565,2652577,2652647,2652655,2654910,2654916,2654922,2654928,2654960,2654977,2654985,2655003,2655009,2655074,2655080,2655099,2655102,2655105,2655114,2655123,2655132,2655144,2655214,2655222,2657474,2657480,2657512,2657529,2657537,2657555,2657561,2657626,2657632,2657651,2657654,2657657,2657666,2657675,2657684,2657696,2657766,2657774,2660046,2660063,2660071,2660089,2660095,2660160,2660166,2660185,2660188,2660191,2660200,2660209,2660218,2660230,2660300,2660308,2662561,2662578,2662586,2662604,2662610,2662675,2662681,2662700,2662703,2662706,2662715,2662724,2662733,2662745,2662815,2662823,2665062,2665079,2665087,2665105,2665111,2665176,2665182,2665201,2665204,2665207,2665216,2665225,2665234,2665246,2665316,2665324,2667566,2667574,2667592,2667598,2667663,2667669,2667688,2667691,2667694,2667703,2667712,2667721,2667733,2667803,2667811,2670029,2670037,2670055,2670061,2670126,2670132,2670151,2670154,2670157,2670166,2670175,2670184,2670196,2670266,2670274,2672506,2672512,2672577,2672583,2672602,2672605,2672608,2672617,2672626,2672635,2672647,2672717,2672725,2674937,2674943,2675008,2675014,2675033,2675036,2675039,2675048,2675057,2675066,2675078,2675148,2675156,2677420,2677426,2677445,2677448,2677451,2677460,2677469,2677478,2677490,2677560,2677568,2679812,2679818,2679837,2679840,2679843,2679852,2679861,2679870,2679882,2679952,2679960,2682188,2682194,2682213,2682216,2682219,2682228,2682237,2682246,2682258,2682328,2682336,2684555,2684561,2684580,2684583,2684586,2684595,2684604,2684613,2684625,2684695,2684703,2686917,2686923,2686942,2686945,2686948,2686957,2686966,2686975,2686987,2687057,2687065,2689272,2689278,2689297,2689300,2689303,2689312,2689321,2689330,2689342,2689412,2689420,2691616,2691622,2691641,2691644,2691647,2691656,2691665,2691674,2691686,2691756,2691764,2693944,2693950,2693969,2693972,2693975,2693984,2693993,2694002,2694014,2694084,2694092,2696277,2696286,2696308,2696312,2696316,2696326,2696337,2696348,2696363,2696457,2696468,2696574,2696690,2696783,2696821,2696823,2696831,2699360,2699369,2699391,2699395,2699399,2699409,2699421,2699433,2699448,2699542,2699553,2699659,2699775,2699868,2699905,2699907,2699915,2702430,2702439,2702461,2702465,2702469,2702479,2702491,2702503,2702518,2702618,2702629,2702737,2702859,2702951,2702988,2702990,2702998,2705506,2705515,2705537,2705541,2705545,2705555,2705567,2705579,2705594,2705694,2705706,2705814,2705936,2706026,2706063,2706065,2706073,2708584,2708588,2708592,2708602,2708614,2708626,2708641,2708741,2708753,2708861,2708983,2709073,2709110,2709112,2709120,2711627,2711631,2711635,2711645,2711657,2711669,2711684,2711784,2711796,2711904,2712026,2712116,2712153,2712155,2712163,2714662,2714666,2714676,2714688,2714700,2714715,2714815,2714827,2714935,2715056,2715146,2715183,2715185,2715193,2717686,2717696,2717708,2717720,2717735,2717835,2717847,2717955,2718077,2718167,2718204,2718206,2718214,2720761,2720773,2720785,2720800,2720900,2720912,2721020,2721142,2721232,2721269,2721271,2721279,2723881,2723893,2723908,2724008,2724020,2724128,2724250,2724340,2724377,2724379,2724387,2726980,2726992,2727007,2727107,2727119,2727227,2727349,2727439,2727476,2727478,2727486,2730067,2730079,2730094,2730194,2730206,2730314,2730436,2730526,2730563,2730565,2730573,2733178,2733193,2733293,2733305,2733419,2733551,2733641,2733678,2733680,2733689,2736281,2736296,2736396,2736408,2736522,2736654,2736744,2736781,2736783,2736792,2739383,2739483,2739495,2739609,2739741,2739831,2739868,2739870,2739879,2742460,2742560,2742572,2742686,2742818,2742909,2742946,2742948,2742957,2745620,2745632,2745746,2745878,2745969,2746006,2746008,2746017,2748661,2748673,2748787,2748919,2749010,2749047,2749049,2749058,2751690,2751702,2751816,2751948,2752039,2752076,2752078,2752087,2754716,2754728,2754842,2754975,2755066,2755103,2755105,2755114,2757737,2757749,2757862,2757995,2758086,2758123,2758125,2758134,2760758,2760770,2760883,2761015,2761109,2761146,2761148,2761158,2763774,2763786,2763899,2764030,2764124,2764161,2764163,2764173,2766773,2766785,2766898,2767029,2767123,2767160,2767162,2767172,2769757,2769769,2769882,2770013,2770107,2770144,2770146,2770156,2772730,2772742,2772855,2772986,2773080,2773117,2773119,2773129,2775695,2775707,2775820,2775951,2776045,2776082,2776084,2776094,2778684,2778696,2778809,2778940,2779034,2779071,2779073,2779083,2781665,2781677,2781790,2781921,2782015,2782052,2782054,2782064,2784753,2784765,2784878,2785009,2785103,2785140,2785142,2785152,2787839,2787851,2787964,2788095,2788189,2788226,2788228,2788238,2790909,2790921,2791034,2791165,2791259,2791296,2791298,2791308,2793967,2793979,2794092,2794223,2794317,2794354,2794356,2794366,2794573,2794575,2794579,2794640,2797042,2797054,2797167,2797298,2797392,2797429,2797431,2797441,2797648,2797650,2797654,2797715,2800116,2800229,2800360,2800454,2800492,2800494,2800504,2800610,2800711,2800713,2800717,2800778,2803171,2803284,2803415,2803509,2803547,2803549,2803559,2803665,2803766,2803768,2803772,2803833,2806258,2806389,2806483,2806521,2806523,2806533,2806639,2806740,2806742,2806746,2806807,2809214,2809345,2809439,2809477,2809479,2809489,2809595,2809696,2809698,2809702,2809763,2812148,2812279,2812373,2812411,2812413,2812423,2812529,2812630,2812632,2812636,2812697,2815070,2815201,2815295,2815333,2815335,2815345,2815451,2815552,2815554,2815558,2815619,2818053,2818184,2818278,2818316,2818318,2818328,2818434,2818535,2818537,2818541,2818602,2821029,2821160,2821254,2821292,2821294,2821304,2821410,2821511,2821513,2821517,2821578,2824001,2824132,2824226,2824264,2824266,2824276,2824382,2824483,2824485,2824489,2824550,2826977,2827108,2827202,2827240,2827242,2827252,2827358,2827459,2827461,2827465,2827526,2829936,2830067,2830161,2830199,2830201,2830211,2830317,2830418,2830420,2830424,2830485,2832878,2833009,2833103,2833141,2833143,2833153,2833259,2833360,2833362,2833366,2833427,2835805,2835936,2836030,2836068,2836070,2836080,2836186,2836287,2836289,2836293,2836354,2838739,2838870,2838964,2839002,2839004,2839014,2839120,2839221,2839223,2839227,2839288,2841663,2841794,2841888,2841926,2841928,2841938,2842044,2842145,2842147,2842151,2842212,2850237,2850368,2850462,2850500,2850502,2850512,2850618,2850718,2850720,2850725,2850794,2863006,2863099,2863137,2863139,2863149,2863252,2863351,2863353,2863358,2863427,2865783,2865876,2865914,2865916,2865926,2866029,2866128,2866130,2866135,2866204,2880852,2880945,2880977,2880983,2880985,2880995,2881002,2881100,2881202,2881204,2881209,2881278,2883624,2883717,2883749,2883755,2883757,2883767,2883774,2883872,2883974,2883976,2883981,2884050,2886382,2886475,2886507,2886513,2886515,2886525,2886532,2886630,2886730,2886732,2886737,2886801,2889116,2889210,2889242,2889248,2889250,2889260,2889267,2889365,2889465,2889467,2889472,2889536,2891839,2891933,2891965,2891971,2891973,2891983,2891990,2892088,2892188,2892190,2892195,2892259,2894542,2894636,2894668,2894674,2894676,2894686,2894693,2894791,2894891,2894893,2894898,2894962,2897231,2897325,2897357,2897363,2897365,2897375,2897382,2897480,2897580,2897582,2897587,2897651,2899928,2900022,2900054,2900060,2900062,2900072,2900079,2900177,2900277,2900279,2900284,2900348,2902619,2902713,2902745,2902751,2902753,2902763,2902770,2902868,2902968,2902970,2902975,2903039,2905297,2905329,2905335,2905337,2905347,2905354,2905452,2905552,2905554,2905559,2905623,2907889,2907921,2907927,2907929,2907939,2907946,2908044,2908144,2908146,2908151,2908215,2908403,2908410,2910506,2910538,2910544,2910546,2910556,2910563,2910661,2910761,2910763,2910768,2910832,2911020,2911027,2913104,2913136,2913142,2913144,2913154,2913161,2913259,2913359,2913361,2913366,2913430,2913618,2913625,2915692,2915724,2915730,2915732,2915742,2915749,2915847,2915947,2915949,2915954,2916018,2916206,2916213,2918282,2918314,2918320,2918322,2918332,2918339,2918437,2918537,2918539,2918544,2918608,2918796,2918803,2920855,2920887,2920893,2920895,2920905,2920912,2921010,2921110,2921112,2921117,2921181,2921369,2921376,2923420,2923452,2923458,2923460,2923470,2923477,2923575,2923675,2923677,2923682,2923746,2923934,2923941,2925975,2926007,2926013,2926015,2926025,2926032,2926129,2926229,2926231,2926236,2926300,2926488,2926495,2928511,2928543,2928549,2928551,2928561,2928568,2928665,2928765,2928767,2928772,2928836,2929024,2929031,2931030,2931062,2931068,2931070,2931080,2931087,2931184,2931284,2931286,2931291,2931355,2931543,2931550,2933538,2933570,2933576,2933578,2933588,2933595,2933692,2933792,2933794,2933799,2933863,2934052,2934059,2936038,2936070,2936076,2936078,2936088,2936095,2936192,2936292,2936294,2936299,2936363,2936552,2936559,2938546,2938578,2938584,2938586,2938596,2938603,2938700,2938800,2938802,2938807,2938871,2939060,2939067,2941049,2941081,2941087,2941089,2941099,2941106,2941203,2941303,2941305,2941310,2941374,2941563,2941570,2943575,2943581,2943583,2943593,2943600,2943697,2943797,2943799,2943804,2943868,2944057,2944064,2946053,2946059,2946061,2946071,2946078,2946175,2946275,2946277,2946282,2946346,2946535,2946542,2948515,2948521,2948523,2948533,2948540,2948637,2948737,2948739,2948744,2948808,2948997,2949004,2950962,2950968,2950970,2950980,2950987,2951084,2951184,2951186,2951191,2951255,2951444,2951451,2953409,2953415,2953417,2953427,2953434,2953531,2953631,2953633,2953638,2953702,2953891,2953898,2953905,2953920,2955898,2955904,2955906,2955916,2955923,2956020,2956120,2956122,2956127,2956191,2956380,2956387,2956394,2956409,2958387,2958389,2958399,2958406,2958503,2958603,2958605,2958610,2958674,2958859,2958866,2958873,2958888,2960858,2960868,2960875,2960972,2961072,2961074,2961079,2961143,2961328,2961335,2961342,2961357,2963324,2963421,2963521,2963523,2963528,2963592,2963777,2963784,2963791,2963806,2965852,2965952,2965954,2965959,2966023,2966208,2966215,2966222,2966237,2968271,2968371,2968373,2968378,2968441,2968626,2968633,2968640,2968655,2970687,2970787,2970789,2970794,2970857,2971042,2971049,2971056,2971071,2973087,2973187,2973189,2973194,2973257,2973442,2973449,2973456,2973471,2975476,2975576,2975578,2975583,2975646,2975831,2975838,2975845,2975860,2977853,2977953,2977955,2977960,2978023,2978208,2978215,2978222,2978237,2980243,2980343,2980345,2980350,2980413,2980598,2980605,2980612,2980627,2982619,2982719,2982721,2982726,2982789,2982974,2982981,2982988,2983003,2984989,2985088,2985090,2985095,2985158,2985343,2985350,2985357,2985372,2987373,2987472,2987474,2987479,2987542,2987727,2987734,2987741,2987756,2989751,2989850,2989852,2989857,2989920,2990105,2990112,2990119,2990134,2992127,2992226,2992228,2992233,2992296,2992481,2992488,2992495,2992510,2994490,2994589,2994591,2994596,2994659,2994844,2994851,2994858,2994873,2996840,2996939,2996941,2996946,2997009,2997194,2997201,2997208,2997223,2999174,2999273,2999275,2999280,2999343,2999528,2999535,2999542,2999557,3001497,3001592,3001597,3001598,3001667,3001851,3001858,3001864,3001880,3003808,3003907,3003909,3003915,3003979,3004166,3004173,3004180,3004195,3006098,3006197,3006199,3006205,3006269,3006456,3006463,3006470,3006485,3008324,3008423,3008425,3008431,3008495,3008682,3008689,3008696,3008711,3010510,3010609,3010611,3010618,3010683,3010870,3010877,3010884,3010899,3012678,3012777,3012779,3012786,3012851,3013038,3013045,3013052,3013067,3014830,3014929,3014931,3014938,3015003,3015190,3015197,3015204,3015219,3016974,3017073,3017075,3017082,3017147,3017334,3017341,3017348,3017363,3019162,3019261,3019263,3019270,3019335,3019522,3019529,3019536,3019551,3021415,3021416,3021422,3021470,3021598,3021604,3021610,3021622,3022892,3022893,3022899,3022947,3023075,3023081,3023087,3023099,3024361,3024362,3024368,3024416,3024544,3024550,3024556,3024568,3025817,3025818,3025824,3025872,3026000,3026006,3026012,3026024,3027263,3027264,3027270,3027318,3027446,3027452,3027458,3027470,3028701,3028702,3028708,3028756,3028884,3028890,3028896,3028908,3030133,3030134,3030140,3030188,3030316,3030322,3030328,3030340,3031555,3031556,3031562,3031610,3031738,3031744,3031750,3031762,3032967,3032968,3032974,3033022,3033150,3033156,3033162,3033174,3034565,3034566,3034572,3034620,3034748,3034754,3034760,3034772,3036151,3036152,3036158,3036206,3036334,3036340,3036346,3036358,3037726,3037727,3037733,3037781,3037909,3037915,3037921,3037933,3039293,3039294,3039300,3039348,3039476,3039482,3039488,3039500,3040852,3040853,3040859,3040907,3041035,3041041,3041047,3041059,3042402,3042403,3042409,3042457,3042585,3042591,3042597,3042609,3043944,3043945,3043951,3043999,3044127,3044133,3044139,3044151,3045480,3045486,3045534,3045662,3045668,3045674,3045686,3047057,3047185,3047191,3047197,3047209,3048569,3048697,3048703,3048709,3048721,3050074,3050202,3050208,3050214,3050226,3051582,3051710,3051716,3051722,3051734,3053080,3053208,3053214,3053220,3053232,3054565,3054693,3054699,3054705,3054717,3056041,3056169,3056175,3056181,3056193,3057506,3057634,3057640,3057646,3057658,3058959,3059087,3059093,3059099,3059111,3060404,3060532,3060538,3060544,3060556,3061841,3061969,3061975,3061981,3061993,3063576,3063704,3063710,3063716,3063728,3065430,3065436,3065442,3065454,3067145,3067151,3067157,3067169,3068847,3068853,3068859,3068871,3070540,3070546,3070552,3070564,3072224,3072230,3072236,3072248,3073899,3073905,3073911,3073923,3075564,3075570,3075576,3075588,3077222,3077228,3077234,3077246,3078883,3078889,3078895,3078907,3080535,3080541,3080547,3080559,3082178,3082184,3082190,3082202,3083810,3083816,3083822,3083834,3085432,3085438,3085444,3085456,3087080,3087086,3087092,3087104,3088719,3088725,3088731,3088743,3090347,3090353,3090359,3090371,3091963,3091969,3091975,3091987,3093569,3093575,3093581,3093593,3095167,3095173,3095179,3095191,3096757,3096763,3096769,3096781,3098338,3098344,3098350,3098362,3099915,3099921,3099927,3099939,3101481,3101487,3101493,3101505,3103032,3103038,3103044,3103056,3104574,3104580,3104586,3104598,3106108,3106114,3106119,3106132,3107663,3107668,3107681,3109243,3109256)) 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 Borodin (Composer) - uVisitRussia
Alexander Porfir‘yevich Borodin was born in 1833 in Georgia, the illegitimate son of a serf and a Georgian prince. His mother later married a retired doctor, and Alexander was brought up in St. Petersburg with a good education. He got into the Academy of Medicine in St. Petersburg in 1850 where he studied to become a scientist. From 1864 until his death in 1887, he was a professor of chemistry at the St. Petersburg Military Academy; he both taught and did research. He worked hard to establish a medical school for women in Russia. Women were not admitted to the Academy, although there was some relaxation of the restrictions during the more liberal 1860‘s. Borodin‘s laboratory became the first place women were legally allowed to study medicine, but the right was eventually revoked by order of the repressive regime of Tsar Alexander III. Borodin dropped dead of a stroke at a party in 1887. He showed an early interest in music, and from a young age played the flute and piano. He wrote a piano duet at the age of nine. After graduation from the Medical Academy, he fell under the influence of the Russian composer Mily Balakirev and studied composition with him. Balakirev, Bodorin, Nikolai Rimsky-Korsakov, Cesar Cui, and Modest Mussorgsky became known as the Mighty Five or the Mighty Bunch in St. Petersburg cultural circles in the 1860‘s. They started the Free Music Academy, advocating music education for everyone, in opposition to the "official" Academy of Music in St. Petersburg, founded by Anton Rubenstein and supported by the imperial government. As nationalism swept across the European continent and elsewhere, the Mighty Five, along with artists and musicians all over Russia, wanted to create art and music that was distinctly Russian, turning away from the influences of western Europe. While many composers at the time, like Tchaikovsky and Rimsky-Korsakov, drew on Russian folk melodies for inspiration, Borodin did not; but he related his music to images of Russian places and themes. His friend Nikolai Rimsky-Korsokov said about Borodin: "Borodin was an exceedingly cordial and cultured man, pleasant and oddly witty to talk with. On visiting him I often found him working in the laboratory which adjoined his apartment. When he sat over his retorts filled with some colourless gas and distilled it by means of a tube from one vessel into another, Iused to tell him that he was transfusing emptiness into vacancy." Most composers in St. Petersburg did not make their primary living composing, and in this tradition, Borodin kept his job at the St. Petersburg Military Academy, even after he began composing a lot of music. His first symphony was written during the years 1862-1867 and performed in 1869; his second symphony took from 1869-1876; and his third symphony, begun in 1882, was not completed before he died. He never had the time to compose that he wanted to have. Besides his symphonies, he wrote piano music, short works like "In the Steppes of Central Asia" recalling the country of his birth, and a major opera, Prince Igor, which was also unfinished at the time of his death. Rimsky-Korsakov and one of his students, Alexander Glazunof, finished Prince Igor; Glazunof alone finished the two existing movements of Borodin‘s third symphony from notes left by Borodin. The sound clip below is from the second movement of the Third Symphony, which uses many different rhythms and key shifts, and features quick movement between major and minor keys. Long after Borodin‘s death in 1887, his music was used for a Broadway show, Kismet. Kismet had been a play, written in 1911, and had been made into a movie twice. Charles Lederer and Luther Davis adapted it for Broadway, and Borodin‘s music was reworked by Robert Wright and George Forrest to fit the story of a poet-thief who becomes the Emir of Baghdad in a magical day. The two clips below are an example of Borodin‘s original work and the same music in its Broadway rendition. The original comes from the fourth movement of his first symphony. The song from Kismet is entitled "Gesticulate." The best known melody of Borodin‘s was also used in Kismet, where it was the major popular hit song from 1953, "Stranger in Paradise," popularized by Tony Bennett. It came from the Polovtsian Dances (No. 8), which were orchestral pieces in Borodin‘s opera Prince Igor. The dances, like much of Borodin‘s other work, have a noticeable Asian flavor to them. The sound clip below is the first appearance of this musical theme in the 8th Polovtsian dance.
Sign in to our website using your Facebook or Google+ account.
Why Do You Need Our Travel Expert
Contact our experts, and they will help you to plan your best trip to Russia, with attention to every detail!
Our Experts have been in the travel industry for many years, guarantee to offer first class customer service, excellent value for money and unbiased advice. They are standing by to find and build your dream holiday to one of the world's most fascinating destinations - Russia. Your personal Travel Expert will guide you through each stage of the travel process, from choosing a program that fits you best to support during your trip.
Just tell us your e-mail, and we'll take care of everything!
Your tour request has been received. Thank you ! We have sent you the confirmation message to [email]
Please make sure that you receive this message (sometimes e-mail messages may go to the spam/junk mail). If you did not get this message, it means you will not get message with the tours' selection as well. If you use a Yahoo!, Gmail, AOL or Hotmail, we recommend to add request@uvisitrussia.comto your address book.
We recommend to leave your phone number. If we will not heard back that you received the e-mail with the tours' selection, we will contact you by phone. And you will not miss the best tour for you.
Thank you ! Your request for Travel Expert assistance has been sent. We will e-mail you within 1 hour.
Sorry, some changes needed
Add your E-mail
There was a problem with your request
Missing contact person. Please correct and try again.