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 (8399,8401,8404,8417,10108,10111,10123,11691,11694,11706,13274,13277,13289,34074,34080,34091,34095,34105,37184,37190,37191,37198,37244,37250,37255,37277,38739,38745,38746,38751,38798,38802,38808,38830,40185,40192,40193,40199,40245,40249,40255,40277,40311,40322,40327,40328,40333,40339,41554,41559,41564,41587,41621,41633,41636,41639,41643,41650,42956,42981,43016,43023,43030,43032,43037,43043,43104,43108,44341,44374,44387,44389,44390,44396,44402,44463,44468,45726,45739,45741,45742,45748,45754,45815,45820,47071,47084,47086,47087,47093,47099,47160,47165,48413,48420,48427,48429,48434,48440,48501,48505,49744,49757,49759,49760,49766,49772,49833,49838,51072,51085,51087,51088,51094,51100,51161,51166,52391,52404,52406,52407,52413,52419,52479,52484,53706,53719,53721,53722,53728,53734,53794,53799,55015,55028,55030,55031,55037,55043,55103,55108,56318,56329,56336,56337,56340,56346,56406,56412,57689,57694,57695,57704,57710,57771,57776,59759,59764,59765,59773,59780,59840,59846,61832,61833,61837,61843,61903,61909,63892,63899,63958,63964,65946,66005,66011,67990,68050,68056,70092,70098,72129,72135,74159,74165,76177,76183,78187,78193,80193,80199,82192,82198,84185,84191,86170,86176,88148,88154,90115,90120,92073,92078,94026,94031,95975,95980,97919,153295,153297,153325,153330,153335,153337,153411,153418,153424,153436,153447,153449,155031,155056,155061,155066,155068,155142,155149,155154,155167,155178,155180,156776,156782,156787,156789,156863,156870,156875,156888,156899,156901,158487,158493,158498,158500,158573,158581,158586,158598,158610,158612,160213,160219,160224,160226,160299,160306,160311,160324,160336,160338,161940,161946,161951,161953,162026,162033,162038,162051,162062,162065,163658,163663,163664,163671,163754,163768,163775,163789,163802,163805,165405,165411,165414,165501,165510,165517,165531,165544,165547,167142,167145,167232,167241,167248,167262,167275,167278,168866,168953,168961,168967,168982,168996,168999,170664,170673,170679,170693,170708,170711,172368,172377,172383,172397,172412,172415,174062,174071,174077,174091,174105,174109,175746,175754,175760,175775,175789,175792,177419,177427,177433,177447,177462,177464,179082,179090,179096,179110,179125,179127,180736,180744,180750,180764,180778,180781,182383,182391,182397,182411,182425,182428,184023,184031,184037,184051,184065,184068,185654,185667,185668,185682,185696,185699,187276,187289,187295,187304,187318,187321,188888,188901,188907,188916,188930,188933,190488,190501,190507,190516,190530,190533,192078,192090,192096,192105,192119,192126,193655,193668,193674,193683,193697,193704,193710,196414,196422,196428,196444,196457,196461,196468,197726,197736,197742,197756,197769,197774,197780,199043,199053,199059,199073,199086,199091,199097,200360,200370,200376,200390,200403,200408,200414,202042,202052,202058,202072,202085,202090,202096,203723,203729,203744,203756,203761,203768,205397,205403,205416,205431,205435,205441,207095,207101,207114,207129,207133,207139,208789,208802,208817,208821,208827,212179,212190,212234,212239,212281,212286,212305,212310,213714,213726,213769,213774,213816,213821,213840,213845,215250,215261,215305,215310,215352,215357,215376,215381,216781,216792,216836,216841,216883,216888,216907,216912,218310,218321,218365,218370,218412,218417,218436,218441,219833,219844,219887,219892,219934,219940,219959,219964,221352,221363,221388,221406,221411,221453,221458,221478,221483,222866,222877,222902,222920,222925,222967,222972,222991,222997,224375,224386,224411,224429,224434,224476,224481,224500,224506,225885,225898,225920,225934,225939,225985,225991,226010,226017,227386,227397,227421,227439,227444,227491,227496,227515,227522,228885,228896,228921,228938,228943,228990,228995,229014,229021,230870,230881,230906,230923,230928,230975,230980,230999,231006,232865,232876,232900,232918,232923,232970,232975,232994,233001,234859,234872,234890,234908,234913,234960,234965,234984,234991,236843,236856,236878,236893,236898,236944,236950,236968,236975,238818,238831,238854,238867,238872,238919,238924,238942,238950,240785,240797,240819,240833,240838,240885,240890,240908,240914,242746,242758,242780,242794,242799,242846,242851,242869,242875,244703,244715,244737,244751,244759,244804,244808,244827,244833,246657,246669,246691,246709,246713,246758,246762,246781,246787,248604,248616,248638,248656,248660,248705,248709,248728,248734,250547,250558,250581,250600,250603,250648,250653,250672,250678,252542,252565,252583,252587,252632,252636,252655,252661,254516,254538,254557,254560,254605,254610,254629,254635,256503,256521,256524,256569,256574,256593,256598,258464,258482,258485,258531,258536,258554,258560,260430,260448,260451,260496,260501,260521,260526,262390,262408,262411,262456,262461,262480,262486,264356,264374,264377,264424,264428,264447,264453,266334,266337,266384,266388,266407,266412,268286,268289,268336,268340,268358,268363,270227,270230,270277,270281,270299,270304,272166,272169,272216,272220,272238,272243,274102,274149,274153,274175,274176,274232,274233,274261,274268,274271,276083,276087,276109,276115,276166,276171,276195,276202,276205,278007,278012,278034,278040,278091,278096,278120,278129,278132,279884,279889,279911,279917,279968,279973,279997,280006,280009,281752,281756,281779,281785,281836,281841,281865,281874,281877,283611,283615,283638,283644,283695,283700,283724,283733,283736,285468,285472,285494,285501,285552,285557,285581,285590,285593,287323,287326,287349,287355,287407,287412,287436,287444,287448,289170,289174,289191,289197,289249,289255,289281,289291,289294,291004,291007,291027,291032,291086,291090,291117,291125,291129,292903,292923,292928,292982,292986,293013,293022,293025,294812,294817,294870,294874,294902,294911,294914,296692,296697,296751,296755,296782,296791,296794,298570,298577,298627,298633,298658,298668,298671,300441,300448,300498,300504,300528,300537,300541,302333,302386,302391,302418,302426,302430,304269,304274,304300,304308,304312,306195,306200,306225,306234,306238,308119,308124,308149,308158,308162,310037,310042,310067,310075,310080,311952,311957,311981,311989,311993,313861,313866,313890,313898,313902,315766,315771,315795,315803,315807,317664,317668,317693,317701,317705,319554,319558,319583,319591,319595,321433,321437,321462,321470,321474,323303,323307,323332,323340,323344,325198,325202,325227,325235,325239,327104,327128,327137,327142,329026,329034,329038,330917,330925,330929,332803,332811,332815,334678,334686,334690,336544,336552,336556,338418,338422,340299,340303,342223,342227,344147,344152,346068,457338,457347,457363,457387,458904,458914,458930,458953,460461,460470,460486,460509,462019,462034,462057,463571,463586,463609,465118,465131,465157,466673,466699,468371,468397,470074,470098,471648,473190,474770,476347,477919,477980,477999,478022,478023,478046,479492,479548,479568,479593,479594,479616,481115,481134,481859,481879,482597,482617,483334,483351,484071,484092,484115,484822,484843,484866,485567,485588,485610,485612,486306,486326,487030,487050,487744,487764,488459,488478,489169,489189,489881,489899,490584,490603,491302,491990,492667,492689,492691,493349,493371,493373,494049,494050,494721,494724,495386,495387,497325,497328,497341,497357,497363,497393,497399,497439,497461,497466,497470,498792,498805,498821,498827,498857,498863,498903,498925,498929,498933,500259,500277,500281,500312,500318,500358,500381,500385,500389,501714,501731,501735,501767,501772,501813,501835,501839,501843,503223,503227,503260,503264,503302,503328,503333,503339,504702,504706,504738,504743,504784,504806,504809,504814,506173,506177,506206,506217,506255,506278,506281,506286,507644,507651,507683,507688,507727,507750,507753,507758,509113,509118,509149,509155,509197,509219,509222,509228,510581,510610,510621,510661,510682,510685,510691,512065,512077,512115,512138,512142,512147,513515,513523,513564,513586,513590,513594,514988,514994,515037,515059,515061,515072,516452,516457,516499,516521,516525,516529,517904,517911,517953,517975,517979,517984,519358,519397,519419,519424,519428,520800,520839,520861,520866,520870,522276,522298,522303,522307,523708,523730,523735,523741,525127,525149,525152,525159,526533,526554,526561,526563,527937,527958,527966,527967,529340,529361,529368,529370,530739,530764,530768,530770,532133,532156,532159,532166,533522,533543,533545,533556,534979,534982,534990,536400,536404,536408,537830,537834,537839,539254,539258,539263,540670,540674,540678,542108,542113,543559,549436,549458,549498,549499,549524,549550,549559,550879,550901,550941,550942,550967,550993,551002,552315,552336,552377,552378,552402,552428,552437,553741,553760,553801,553803,553826,553851,553861,555157,555175,555218,555219,555241,555267,555277,556565,556583,556624,556625,556648,556674,556684,557986,558032,558033,558050,558076,558086,559383,559428,559429,559451,559473,559483,559497,559513,559517,559568,559582,559586,559590,560782,560821,560822,560843,560866,560876,560895,560906,560910,560961,560975,560978,560982,562162,562202,562204,562227,562253,562263,562277,562292,562296,562348,562362,562365,562369,563544,563584,563585,563608,563635,563645,563658,563674,563678,563729,563744,563747,563751,564960,564961,564982,565004,565014,565028,565044,565048,565099,565113,565117,565121,566322,566323,566344,566369,566380,566395,566405,566409,566459,566473,566478,566482,567679,567680,567701,567727,567737,567754,567763,567768,567823,567831,567836,567840,569035,569036,569057,569083,569093,569108,569118,569122,569173,569187,569191,569195,570383,570384,570405,570430,570440,570456,570466,570470,570520,570533,570538,570542,571717,571718,571743,571768,571779,571792,571806,571810,571859,571875,571879,571883,573097,573098,573120,573147,573157,573171,573181,573189,573239,573251,573256,573260,574469,574471,574493,574519,574529,574543,574557,574561,574610,574626,574629,574631,575854,575880,575890,575904,575918,575922,575971,575987,575990,575995,577212,577238,577248,577262,577276,577280,577329,577345,577348,577352,578564,578590,578600,578615,578628,578632,578681,578697,578700,578704,579905,579931,579941,579954,579969,579972,580022,580038,580041,580045,581238,581264,581274,581287,581302,581305,581354,581371,581374,581378,582587,582597,582611,582625,582630,582678,582693,582698,582702,583912,583917,583922,583937,583950,583953,584004,584019,584022,584026,585224,585230,585235,585249,585264,585267,585317,585332,585335,585340,586536,586541,586546,586561,586569,586575,586629,586641,586646,586650,587839,587844,587849,587863,587877,587881,587930,587945,587950,587954,589140,589145,589159,589173,589177,589232,589241,589245,589249,590785,590799,590813,590818,590873,590882,590886,590890,592417,592431,592434,592489,592500,592503,592507,594050,594061,594064,594117,594129,594133,594137,595760,595764,595816,595829,595833,595837,597450,597454,597505,597519,597523,597527,599135,599186,599199,599203,599207,600859,600872,600876,600880,602535,602548,602552,602556,604202,604215,604219,604223,605860,605873,605877,605881,607509,607521,607526,607530,609148,609164,609168,609172,610835,610851,610855,610859,612515,612530,612535,612539,614189,614205,614209,614213,615851,615867,615871,615875,617499,617516,617520,617524,619147,619152,619159,620782,620786,620790,622401,622406,622413,624020,624027,625652,638382,638399,639922,639938,641452,641468,642971,642987,644497,644525,644532,644595,644604,644614,644636,646003,646031,646037,646100,646110,646121,646142,647505,647531,647538,647603,647607,647617,647642,649018,649025,649088,649097,649107,649127,650515,650520,650585,650591,650602,650623,651999,652004,652064,652073,652083,652108,653474,653480,653540,653549,653559,653584,654940,654946,655011,655014,655024,655050,656402,656461,656469,656479,656505,657908,657917,657930,657957,659357,659366,659379,659405,660799,660802,660816,660842,662226,662229,662243,662268,663644,663653,663665,663687,665059,665062,665075,665101,666465,666472,666485,666507,667900,667907,667920,667942,669324,669330,669342,669363,670759,670766,670779,670801,672187,672192,672205,672225,673605,673609,673624,673650,675010,675014,675029,675054,676413,676426,676448,677812,677834,679218,679241,680634,682021,683394,684761,693892,693904,693939,693946,695152,695187,695194,696385,696419,696426,697639,697645,698846,698852,700042,700049,701231,701238,702427,702434,703612,703619,704793,902562,902566,902571,902572,902602,905194,905198,905203,905204,905231,907809,907814,907820,907821,907848,910423,910427,910434,910435,910462,913036,913042,913047,913048,913073,915668,915673,915678,915679,915705,918377,918381,918382,918409,921074,921075,921102,923780,926471,929189,931898,934605,937310,1118869,1118875,1118884,1118885,1118907,1118923,1118948,1118954,1118958,1120999,1121005,1121013,1121019,1121038,1121055,1121080,1121083,1121088,1123139,1123146,1123155,1123156,1123181,1123193,1123219,1123225,1123229,1125277,1125288,1125289,1125315,1125323,1125349,1125355,1125362,1127480,1127481,1127502,1127513,1127539,1127546,1127553,1129700,1129701,1129725,1129741,1129765,1129773,1129775,1131928,1131943,1131969,1131977,1131981,1134119,1134134,1134160,1134168,1134172,1136323,1136338,1136364,1136372,1136376,1138525,1138538,1138563,1138572,1138578,1140723,1140735,1140761,1140769,1140775,1142914,1142924,1142952,1142960,1142966,1145107,1145134,1145143,1145149,1147277,1147304,1147313,1147319,1149460,1149469,1149475,1151613,1151622,1151628,1153766,1153769,1153774,1155901,1155907,1155916,1158074,1158080,1158089,1160239,1160244,1160252,1162395,1162398,1164531,1175169,1175175,1175198,1175205,1175210,1175216,1175239,1175272,1177315,1177338,1177345,1177351,1177356,1177379,1177415,1179468,1179474,1179481,1179486,1179509,1179545,1181594,1181600,1181607,1181612,1181635,1181671,1183708,1183714,1183722,1183727,1183750,1183785,1185815,1185821,1185828,1185833,1185856,1185891,1187925,1187928,1187935,1187941,1187965,1187997,1190026,1190032,1190039,1190044,1190068,1190102,1192125,1192133,1192138,1192162,1192196,1194214,1194218,1194243,1194278,1196292,1196296,1196320,1196356,1198368,1198392,1198428,1200458,1200493,1202512,1202548,1204570,1204605,1206613,1206648,1208644,1208679,1210720,1212756,1214783,1216798,1218803,1220793,1222769,1224743,1285024,1286847,1330755,1330759,1330768,1330779,1330780,1330832,1332641,1332650,1332661,1332662,1332714,1334522,1334531,1334534,1334582,1336383,1336395,1336396,1336448,1338246,1338247,1338300,1338301,1340084,1340085,1340135,1340136,1341958,1341959,1343770,1343772,1345578,1345583,1347382,1347386,1349173,1349178,1350957,1350963,1352860,1352861,1354746,1354747,1356621,1356622,1412272,1414035,1415789,1417531,1447210,1447218,1447245,1447254,1447255,1447280,1447286,1447293,1447299,1447300,1447303,1448769,1448777,1448804,1448812,1448813,1448839,1448845,1448852,1448858,1448859,1448862,1450314,1450321,1450349,1450357,1450358,1450384,1450390,1450397,1450403,1450404,1450408,1451851,1451858,1451882,1451890,1451891,1451916,1451922,1451929,1451936,1451937,1451941,1453377,1453406,1453410,1453413,1453435,1453442,1453452,1453455,1453458,1453462,1454918,1454926,1454927,1454951,1454958,1454965,1454972,1454973,1454977,1456423,1456431,1456432,1456457,1456464,1456471,1456478,1456479,1456482,1457921,1457929,1457930,1457956,1457963,1457969,1457976,1457977,1457981,1459414,1459416,1459421,1459441,1459449,1459456,1459463,1459464,1459472,1460888,1460892,1460913,1460920,1460927,1460935,1460936,1460944,1462375,1462382,1462390,1462396,1462397,1462401,1463821,1463828,1463836,1463842,1463843,1463850,1465264,1465271,1465279,1465285,1465286,1465290,1466691,1466698,1466706,1466712,1466713,1466717,1468113,1468121,1468127,1468128,1468132,1469523,1469529,1469530,1469534,1470917,1470918,1470920,1472296,1553802,1553816,1554836,1554849,1555857,1555867,1556869,1556882,1557880,1557890,1558882,1558894,1559877,1559887,1561240,1562938,1648598,1648599,1648626,1648627,1651404,1651405,1651437,1651438,1654267,1654268,1654301,1654302,1657122,1657123,1657155,1657156,1659963,1659964,1659998,1659999,1662792,1662793,1662827,1662829,1665643,1665644,1668450,1668451,1671254,1671256,1674110,1674111,1676958,1676959,1679801,1679802,1682635,1682636,1802447,1802468,1802478,1802540,1802544,1802553,1802565,1804885,1804905,1804916,1804978,1804982,1804990,1805004,1807306,1807325,1807337,1807399,1807403,1807411,1807425,1809708,1809728,1809740,1809802,1809806,1809814,1809827,1812088,1812109,1812121,1812183,1812187,1812193,1812208,1814442,1814461,1814476,1814537,1814542,1814548,1814562,1816788,1816807,1816822,1816883,1816888,1816894,1816908,1819110,1819128,1819144,1819205,1819213,1819216,1819230,1821409,1821426,1821442,1821507,1821511,1821517,1821528,1823686,1823697,1823714,1823779,1823783,1823789,1823799,1825945,1825962,1826027,1826030,1826036,1826047,1828169,1828186,1828250,1828253,1828260,1828272,1830388,1830452,1830455,1830460,1830473,1832576,1832640,1832643,1832648,1832661,1834776,1834839,1834842,1834846,1834863,1837031,1837034,1837037,1837055,1839215,1839218,1839221,1839239,1841382,1841386,1841396,1841407,1843534,1843539,1843549,1843559,1845674,1845679,1845688,1845699,1847830,1847834,1847837,1847855,1847861,1847867,1849982,1849986,1849996,1850007,1850013,1850018,1852128,1852132,1852142,1852153,1852159,1852164,1854268,1854272,1854282,1854292,1854298,1854303,1856406,1856411,1856420,1856432,1856437,1856441,1858533,1858538,1858547,1858559,1858564,1858568,1860649,1860655,1860661,1860676,1860683,1860687,1862764,1862770,1862776,1862791,1862798,1862802,1864875,1864881,1864887,1864901,1864909,1864913,1866977,1866982,1866989,1867002,1867010,1867014,1869069,1869076,1869089,1869097,1869101,1871154,1871169,1871177,1871181,1873235,1873243,1873247,1875289,1875298,1875302,1877342,1877351,1877355,1879426,1879430,1881493,1881497,1883556,1893913,1895999,1898108,1900261,1902402,1915685,1915698,1915720,1917896,1917909,1917932,1920095,1920108,1920133,1922295,1922308,1922332,1924486,1924498,1924518,1926734,1926746,1926771,1928975,1928987,1929012,1931201,1931215,1931241,1933418,1933429,1933455,1935616,1935626,1935654,1937812,1937822,1937850,1940001,1940010,1940039,1942179,1942196,1942218,1944350,1944367,1944389,1946510,1946526,1946550,1948659,1948675,1948699,1950795,1950811,1950834,1952926,1952943,1952966,1955053,1955069,1955088,1957129,1957144,1957164,1959193,1959208,1959229,1961243,1961255,1961283,1963285,1963293,1963321,1965308,1965323,1965346,1967334,1967348,1967370,1969348,1969363,1969386,1971123,1971141,1971147,1971154,1971364,1971378,1971400,1973130,1973153,1973155,1973163,1973370,1973384,1973407,1975148,1975154,1975161,1975371,1975385,1975407,1977136,1977138,1977146,1977352,1977366,1977391,1979105,1979111,1979118,1979328,1979342,1979364,1981105,1981107,1981115,1981324,1981334,1981360,1983099,1983107,1983316,1983326,1983352,1985093,1985303,1985317,1985339,1987071,1987279,1987289,1987313,1989249,1989259,1989283,1991203,1991214,1991238,1993145,1993159,1993181,1995079,1995096,1995116,1997008,1997025,1997044,1998933,1998947,1998969,2000847,2000861,2000883,2002750,2002764,2002786,2004636,2004652,2004673,2006516,2006530,2006552,2008397,2008412,2008434,2010282,2010296,2010319,2012163,2012173,2012197,2014029,2014042,2014063,2015869,2015882,2015903,2017693,2017704,2017725,2019506,2019519,2019540,2021313,2021326,2021347,2023114,2023127,2023148,2024904,2024918,2024938,2026900,2026913,2026934,2028890,2028903,2028924,2030869,2030882,2030903,2032830,2032843,2032864,2034793,2034806,2034827,2036743,2036756,2036779,2038688,2038701,2038724,2040626,2040639,2040662,2042552,2042564,2042588,2044468,2044481,2044502,2046364,2046377,2046396,2048255,2048268,2048289,2050137,2050148,2050168,2052010,2052021,2052042,2053874,2053887,2053909,2055825,2055838,2055860,2057857,2057870,2057892,2059889,2059903,2059925,2061916,2061929,2061952,2063936,2063949,2063972,2065950,2065958,2065982,2067959,2067984,2067991,2067996,2068030,2068042,2068048,2069965,2069990,2069997,2070002,2070036,2070048,2070054,2071981,2071989,2071993,2072028,2072040,2072046,2073965,2073966,2073971,2074006,2074019,2074024,2075937,2075938,2075943,2075978,2075991,2075996,2077896,2077904,2077909,2077939,2077950,2077959,2079902,2079907,2079936,2079947,2079957,2081897,2081931,2081943,2081948,2083912,2083924,2083931,2085838,2085850,2085856,2087751,2087762,2087770,2089659,2089671,2089679,2091566,2091578,2091583,2093462,2093473,2093478,2095359,2095364,2097231,2097235,2099098,2105006,2105014,2106957,2106964,2108896,2108903,2110825,2110832,2112742,2112748,2114648,2114654,2116546,2116552,2118438,2118444,2120324,2196803,2196810,2196832,2196873,2198338,2198359,2198401,2199876,2199918,2201394,2201436,2202936,2202977,2204508,2206033,2207560,2209075,2210579,2212071,2213771,2496390,2496395,2499302,2499306,2502198,2502201,2505075,2505081,2507947,2507953,2510807,2510813,2513668,2513674,2516522,2516528,2519371,2519377,2522211,2522216,2525038,2525043,2527851,2527858,2530659,2530667,2533467,2533473,2536261,2536269,2539054,2539060,2541844,2541850,2544621,2544629,2547387,2547393,2550155,2550161,2552955,2552961,2555745,2555749,2558552,2558556,2558606,2561358,2561406,2564189,2566958,2566983,2566994,2567018,2567029,2567036,2567050,2567080,2569762,2569788,2569798,2569821,2569835,2569842,2569856,2569879,2572588,2572619,2572625,2572650,2572660,2572665,2572686,2572709,2575409,2575435,2575443,2575468,2575481,2575486,2575505,2575530,2578218,2578244,2578253,2578278,2578289,2578293,2578314,2578339,2581027,2581053,2581062,2581087,2581098,2581102,2581124,2581149,2583818,2583843,2583852,2583877,2583889,2583895,2583914,2583939,2586593,2586619,2586629,2586651,2586666,2586673,2586685,2586717,2589360,2589387,2589397,2589421,2589431,2589436,2589457,2589481,2592126,2592154,2592163,2592184,2592199,2592206,2592218,2592250,2594908,2594917,2594938,2594952,2594960,2594972,2594997,2597653,2597663,2597684,2597698,2597704,2597718,2597749,2600391,2600400,2600424,2600437,2600445,2600459,2600483,2603114,2603123,2603147,2603160,2603168,2603181,2603206,2605825,2605834,2605854,2605868,2605875,2605888,2605920,2608528,2608536,2608559,2608573,2608581,2608594,2608620,2611237,2611258,2611272,2611278,2611292,2611324,2613968,2613984,2613999,2614007,2614020,2614044,2616707,2616720,2616727,2616744,2616767,2619421,2619433,2619441,2619456,2619480,2622122,2622134,2622143,2622158,2622182,2624806,2624819,2624826,2624842,2624873,2627487,2627500,2627506,2627523,2627554,2630174,2630180,2630195,2630219,2632835,2632842,2632856,2632887,2635499,2635504,2635519,2635538,2638151,2638161,2638186,2640793,2640812,2643408,2643428,2646017,2646037,2648636,2651222,2653793,2656358,2658903,2678714,2678746,2678747,2678762,2678774,2678777,2681097,2681128,2681129,2681145,2681160,2681162,2683469,2683504,2683505,2683520,2683532,2683534,2685835,2685866,2685867,2685883,2685894,2685899,2688193,2688224,2688228,2688241,2688256,2688257,2690577,2690578,2690593,2690603,2690604,2692912,2692913,2692929,2692944,2692945,2695235,2695236,2695251,2695261,2695262,2697893,2697894,2697918,2697928,2697929,2700967,2700968,2700992,2701002,2701003,2704049,2704050,2704074,2704084,2704085,2707121,2707122,2707146,2707156,2707157,2710182,2710192,2710193,2713219,2713229,2713235,2716243,2716253,2716259,2719308,2719318,2719324,2722392,2722398,2725491,2725497,2756230,2756239,2756244,2756294,2756339,2759243,2759252,2759257,2759307,2759352,2762258,2762267,2762272,2762322,2762367,2765276,2765281,2765331,2765376,2768271,2768321,2768366,2771295,2771340,2774265,2774310,2777224,2777269,2780208,2780253,2783233,2783278,2786314,2786342,2786349,2786359,2789393,2789421,2789428,2789438,2792480,2792487,2792497,2795536,2795543,2795553,2798605,2798612,2798622,2801663,2801670,2801680,2804713,2804720,2804730,2807681,2807688,2807698,2807725,2810642,2810669,2813593,2816509,2819488,2822458,2825440,2906634,2906642,2906665,2909220,2909228,2909251,2911829,2911837,2911860,2914420,2914428,2914451,2917005,2917013,2917036,2919586,2919594,2919617,2922153,2922161,2922184,2924710,2924717,2924742,2927257,2927264,2927289,2929785,2929792,2929817,2932295,2932302,2932327,2934802,2934809,2934833,2937304,2937328,2939829,2942326,2944813,2947283,2954729,2954733,2954796,2954803,2954845,2957210,2957214,2957282,2957289,2957331,2959685,2959689,2959757,2959764,2959806,2962147,2962151,2962219,2962226,2962268,2964585,2964589,2964657,2964664,2964706,2967005,2967009,2967077,2967084,2967126,2969419,2969423,2969491,2969498,2969540,2971837,2971841,2971909,2971916,2971958,2974229,2974233,2974301,2974308,2974350,2976610,2976614,2976682,2976689,2976731,2978978,2978982,2979049,2979056,2979097,2981358,2981362,2981429,2981436,2981477,2983797,2983804,2983848,2986162,2986169,2986213,2988543,2988550,2988595,2990915,2990922,2990967,2993283,2993290,2993335,2995638,2995645,2995690,2997976,2997983,2998028,3000296,3000303,3000348,3000383,3002614,3002621,3002666,3002701,3002721,3004917,3004962,3004997,3005017,3007194,3007229,3007249,3009381,3009416,3009436,3011562,3011595,3011614,3013719,3013752,3013771,3015862,3015895,3015914,3018001,3018034,3018053,3020227,3020246,3022077,3022091,3022097,3022108,3023553,3023562,3023568,3023578,3025020,3025029,3025035,3025045,3026479,3026485,3026497,3027921,3027926,3027933,3029359,3029370,3030796,3032211,3056675,3056692,3056700,3056716,3056720,3056780,3056784,3056794,3056819,3056827,3058136,3058149,3058161,3058177,3058182,3058239,3058249,3058253,3058277,3058286,3059582,3059596,3059606,3059626,3059629,3059690,3059693,3059698,3059726,3059735,3061027,3061041,3061051,3061066,3061068,3061130,3061133,3061139,3061165,3061175,3062766,3062777,3062790,3062805,3062811,3062870,3062874,3062882,3062905,3062914,3064497,3064508,3064521,3064536,3064542,3064600,3064605,3064614,3064638,3064647,3066233,3066239,3066259,3066260,3066324,3066328,3066333,3066358,3066366,3067942,3067948,3067968,3067971,3068033,3068036,3068041,3068069,3068079,3069638,3069651,3069665,3069668,3069728,3069732,3069738,3069767,3069776,3071336,3071352,3071358,3071416,3071420,3071429,3071453,3071462,3073017,3073032,3073037,3073094,3073099,3073108,3073130,3073141,3074701,3074704,3074762,3074773,3074777,3074801,3074809,3076360,3076362,3076424,3076429,3076434,3076462,3076472,3078013,3078017,3078075,3078086,3078090,3078113,3078129,3079673,3079676,3079735,3079740,3079750,3079774,3079783,3081325,3081383,3081392,3081397,3081420,3081432,3083026,3083032,3083036,3083059,3083075,3084653,3084658,3084662,3084688,3084702,3086304,3086311,3086318,3086340,3086357,3087946,3087956,3087960,3087986,3087994,3089581,3089586,3089593,3089615,3089629,3091203,3091209,3091217,3091239,3091252,3092815,3092821,3092825,3092850,3092863,3094414,3094419,3094427,3094454,3094462,3096008,3096013,3096018,3096044,3096056,3097593,3097599,3097603,3097629,3097639,3099170,3099175,3099177,3099206,3099216,3100746,3100750,3100777,3100788,3102309,3102337,3102347,3103879,3103895,3105418,3105429,3106971,3106982,3108515,3108526,3110084,3110094,3111655,3113202,3210869,3210873,3210881,3210918,3210930,3210935,3212588,3212592,3212600,3212636,3212649,3212654,3214292,3214295,3214303,3214339,3214352,3214361,3215985,3215991,3216000,3216035,3216044,3216052,3217677,3217687,3217694,3217728,3217739,3217747,3219368,3219371,3219382,3219418,3219426,3219435,3221043,3221054,3221061,3221095,3221106,3221115,3222710,3222721,3222727,3222761,3222771,3222782,3224377,3224380,3224391,3224426,3224436,3224447,3226006,3226012,3226022,3226057,3226069,3226074,3227622,3227627,3227637,3227672,3227685,3227690,3229238,3229247,3229254,3229290,3229302,3229308,3230860,3230871,3230877,3230912,3230922,3230932,3232476,3232486,3232494,3232528,3232537,3232547,3234089,3234096,3234100,3234136,3234148,3234155,3235688,3235692,3235699,3235736,3235747,3235754,3237272,3237276,3237283,3237319,3237331,3237338,3238841,3238844,3238855,3238892,3238901,3238909,3240405,3240412,3240423,3240459,3240469,3240477,3242012,3242015,3242023,3242059,3242070,3242078,3243603,3243610,3243618,3243655,3243663,3243675,3245186,3245194,3245199,3245237,3245249,3245257,3246786,3246794,3246804,3246840,3246850,3246859,3248380,3248388,3248426,3248436,3248445,3249958,3249994,3250007,3250015,3251525,3251560,3251572,3251577,3253120,3253127,3253140,3254719,3254726,3254738,3256729,3256739,3256748,3256768,3258742,3258748,3258759,3258782,3260739,3260749,3260756,3260778,3262718,3262730,3262737,3262761,3264702,3264709,3264721,3264741,3266677,3266687,3266697,3266718,3268664,3268671,3268681,3268703,3268709,3268716,3268773,3268784,3270711,3270722,3270732,3270751,3270755,3270764,3270824,3270833,3272849,3272856,3272880,3272884,3272890,3272949,3272959,3274959,3274968,3274991,3274995,3275000,3275059,3275071,3277061,3277083,3277086,3277093,3277152,3277162,3279148,3279170,3279174,3279184,3279244,3279254,3281285,3281306,3281309,3281317,3281377,3281387,3283431,3283434,3283443,3283506,3283516,3285552,3285556,3285562,3285626,3285636,3287702,3287704,3287712,3287775,3287785,3289834,3289837,3289847,3289910,3289920,3291954,3291963,3292024,3292034,3294066,3294129,3294141,3296168,3296231,3296240,3298322,3298333,3300408,3300417,3302483,3302494,3304547,3304557,3306595,3306606,3308641,3308652,3310682,3310693,3312716,3312727,3314735,3314746,3316745,3316755,3318746,3318756,3320735,3320745,3322720,3322730,3324868,3324878,3327136,3327144,3327147,3329526,3329529,3329534,3331907,3331912,3331916,3334272,3334278,3334282,3336625,3336629,3336633,3338974,3338979,3338982,3341323,3341326,3341346,3341401,3341453,3343660,3343663,3343683,3343738,3343792,3346018,3346042,3346093,3346147,3348392,3348447,3348501,3350731,3350783,3350839,3353054,3353107,3353162,3355373,3355426,3355479,3357700,3357731,3357756,3357810,3360048,3360076,3360101,3360156,3362444,3362462,3362516,3364797,3364816,3364872,3367132,3367157,3367212,3369468,3369487,3369540,3371788,3371810,3371868,3374108,3374129,3374182,3376418,3376440,3376496,3376514,3376519,3376522,3376546,3376552,3376555,3376563,3376565,3376639,3378723,3378747,3378802,3378823,3378824,3378831,3378849,3378860,3378863,3378865,3378870,3378945,3381020,3381044,3381098,3381117,3381120,3381127,3381149,3381155,3381159,3381166,3381168,3381242,3383312,3383370,3383389,3383391,3383396,3383418,3383424,3383430,3383434,3383436,3383512,3385601,3385655,3385672,3385677,3385681,3385701,3385709,3385714,3385717,3385720,3385797,3387869,3387923,3387939,3387944,3387946,3387971,3387977,3387981,3387986,3387990,3388065,3390178,3390201,3390203,3390207,3390228,3390239,3390242,3390247,3390248,3390325,3392429,3392453,3392454,3392460,3392481,3392489,3392493,3392495,3392498,3392577,3394670,3394690,3394691,3394699,3394720,3394726,3394728,3394732,3394737,3394814,3396892,3396912,3396915,3396922,3396941,3396948,3396951,3396955,3396960,3397036,3399106,3399125,3399127,3399134,3399155,3399163,3399165,3399173,3399175,3399250,3401307,3401326,3401331,3401335,3401358,3401365,3401369,3401372,3401376,3401453,3403474,3403498,3403519,3403521,3403525,3403547,3403555,3403558,3403563,3403566,3403645,3405680,3405698,3405702,3405707,3405727,3405736,3405738,3405742,3405748,3405825,3407849,3407865,3407870,3407875,3407898,3407904,3407907,3407911,3407916,3407991,3410013,3410032,3410035,3410039,3410060,3410070,3410071,3410079,3410081,3410156,3412157,3412177,3412179,3412181,3412206,3412212,3412217,3412220,3412225,3412301,3414342,3414346,3414354,3414372,3414382,3414383,3414388,3414390,3414468,3416491,3416494,3416498,3416521,3416530,3416533,3416535,3416539,3416617,3418633,3418635,3418641,3418661,3418671,3418675,3418676,3418681,3418758,3420756,3420757,3420762,3420781,3420790,3420794,3420797,3420801,3420879,3422868,3422885,3422892,3422898,3422902,3422904,3422979,3424963,3424973,3424978,3424981,3424983,3425062,3427023,3427032,3427036,3427042,3427044,3427120,3429067,3429076,3429081,3429084,3429087,3429165,3431101,3431106,3431107,3431108,3431188,3433111,3433114,3433121,3433123,3433197,3435117,3435123,3435124,3435203,3437117,3437121,3437198,3439179,3441145,3443110,3445084,3447236,3449384,3451523,3453654,3455776,3457900,3460022,3460029,3462160,3462163,3464286,3464289,3466435,3466439,3468615,3468620,3470783,3470787,3472939,3472941,3475095,3475097,3477246,3477253,3479392,3479399,3481531,3481536,3483668,3534234,3534256,3534289,3534311,3536270,3536282,3536287,3536297,3536327,3536350,3538300,3538312,3538313,3538326,3538360,3538376,3540324,3540338,3540341,3540347,3540380,3540403,3542396,3542409,3542411,3542418,3542452,3542469,3544453,3544464,3544467,3544476,3544509,3544526,3546493,3546504,3546509,3546518,3546548,3546570,3548530,3548540,3548541,3548552,3548585,3548606,3550560,3550574,3550578,3550585,3550619,3550638,3552603,3552615,3552617,3552625,3552658,3552679,3554638,3554649,3554650,3554660,3554694,3554715,3556674,3556688,3556690,3556701,3556731,3556753,3558702,3558715,3558716,3558723,3558757,3558776,3560714,3560725,3560728,3560737,3560769,3560788,3562716,3562726,3562731,3562738,3562771,3562795,3564717,3564728,3564731,3564742,3564775,3564793,3566736,3566747,3566749,3566760,3566792,3566812,3568759,3568761,3568773,3568803,3568822,3570778,3570781,3570791,3570824,3570844,3572790,3572792,3572800,3572831,3572855,3574813,3574846,3574865,3576719,3576754,3576772,3578621,3578657,3578673,3580555,3580574,3582443,3582459,3584305,3584319,3586162,3586178,3588016,3588031,3589866,3589884,3591716,3591729,3593562,3593577,3595510,3595536,3597526,3599500,3601463,3603409,3807826,3807829,3808202,3808205,3808575,3808578,3810782,3811173,3811560,3816960,3816962,3817313,3817314,3817657,3817659,3818043,3818045,3818445,3818449,3827420,3827422,3827762,3827768,3828101,3828104,3828435,3828439,3828757,3828761,3829082,3829086,3829405,3829407,3829726,3829730,3830036,3830038,3830348,3830353,3830652,3830656,3830949,3830953,3835746,3835748,3835988,3835990,3836230,3838765,3839018,3839269,3840266,3840517,3840800,3841079,3841354,3841626,3841893,3845804,3845812,3846050,3846058,3846293,3846301,3846532,3846540,3846770,3846778,3847004,3847012,3847241,3847469,3847701,3848162,3848172,3848179,3848401,3848408,3848626,3848633,3848848,3848855,3849069,3849076,3849295,3849529,3849761,3852385,3852387,3852390,3852981,3852983,3853575,3860814,3860819,3860831,3861608,3861619,3861627,3862405,3862412,3862419,3863194,3863199,3863211,3863978,3863989,3863997,3864765,3864771,3864779,3865541,3865551,3865559,3866322,3866328,3866337,3867097,3867101,3867114,3867866,3867877,3867884,3868637,3868642,3868653,3869403,3869413,3869421,3870170,3870176,3870189,3870932,3870939,3870952,3871695,3871703,3871712,3872443,3872451,3872458,3873182,3873189,3873198,3873937,3873944,3873953,3874688,3874695,3874708,3875441,3875446,3875457,3876188,3876193,3876204,3876933,3876939,3876950,3877680,3877686,3877694,3878420,3878426,3878437,3879164,3879169,3879180,3879903,3879913,3879920,3880643,3880654,3880661,3881390,3881397,3881406,3882131,3882137,3882149,3882876,3882880,3882891,3883617,3883621,3883632,3884354,3884360,3884371,3885092,3885102,3885109,3885832,3885837,3885848,3886566,3886571,3886582,3887298,3887308,3887315,3888031,3888037,3888048,3888761,3888771,3888781,3889493,3889499,3889509,3890216,3890223,3890234,3890941,3890951,3890960,3891659,3891668,3891677,3892380,3892385,3892396,3893095,3893099,3893112,3893808,3893813,3893823,3894533,3894544,3895253,3895263,3895975,3896682,3897389,3897426,3898131,3898832,3899533,3900232,3900949,3901663,3902375,3903088,3903797,3904503,3905199,3905901,3948247,3948889,3949530,3950162,3950794,3951423,3952048,3953296,3953307,3953925,3954539,3955148,3963657,3963660,3964229,3964231,3979872,3979894,3980481,3981060,3981639,3982210,3982785,3983351,3983382,3983384,3983402,3983923,3983955,3983957,3983972,3984494,3984523,3984524,3984543,3985089,3985092,3985105,3985649,3985650,3985667,3986205,3986208,3986223,3986760,3986763,3986779,3987313,3987315,3987328,3987859,3987861,3987875,3988402,3988405,3988420,3988941,3988943,3988957,3989490,3990022,3990562,3991097,3994315,3994317,3994321,3994836,3994840,3994844,3995357,3995359,3995360,3995873,3995876,3995879,3996383,3996385,3996391,3996898,3998399,3998422,3998928,3999430,3999929,4000423,4000921,4001415,4001906,4051483,4051486,4052367,4066022,4066836,4067655,4068464,4069275,4070077,4125912)) 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





	Boris Gruzin (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Boris Gruzin (Conductor)

Boris Gruzin (Conductor)

Graduated from the Moscow Tchaikovsky Conservatoire with distinction in 1963, specialising in three subjects: opera and symphony conducting, piano and the theory of music. As a fifth year student at the Conservatoire, he was invited to be assistant conductor and, upon graduation, conductor at the Novosibirsk Academic Theatre of Opera and Ballet.
1969 - 1976 and 1989 - 1993: Principal Conductor of the Odessa Academic Theatre of Opera and Ballet.
1976 - 1989: Principal Conductor of the Novosibirsk Academic Theatre of Opera and Ballet.
People‘s Artist of Russia (1982).
Honoured Artist of Ukraine (1973).
Conductor at the Mariinsky Theatre since 1993.
Professor at the St Petersburg Rimsky-Korsakov Conservatoire from 1996.

His repertoire includes over eighty operas and ballets.

Repertoire at the Mariinsky Theatre includes:
Operas: Glinka - Ruslan and Lyudmila; Musorgsky - Boris Godunov, Khovanshchina; Borodin - Prince Igor; Tchaikovsky - Eugene Onegin, Mazepa, The Queen of Spades, Iolanta; Rimsky-Korsakov - The Maid of Pskov, The Snow Maiden, The Tsar?s Bride, The Legend of the Invisible City of Kitezh and the Maid Fevronia; Rakhmaninov - Francesca da Rimini, The Miserly Knight; Prokofiev - War and Peace; Verdi - Aida, Otello; Bizet - Carmen; Puccini - La boheme, Madama Butterfly, Tosca; Gounod - Faust; Mozart - Don Giovanni; Bellini - La sonnambula; Donizetti - Don Pasquale.
Ballets: Tchaikovsky - Swan Lake, The Sleeping Beauty, The Nutcracker, Serenade to the music Serenade in C Major for String Orchestra; Glazunov - Raymonda; Prokofiev - Romeo and Juliet, Cinderella; Melikov - The Legend of Love; Stravinsky - Petrouchka, The Firebird, Apollo, Capriccio for piano and orchestra; Rimsky-Korsakov - Scheherazade; Bizet - Symphony in C; Chopiniana; Adam - Giselle, Le Corsaire; Minkus - Don Quixote, La Bayadere, Paquita.

Has toured with the Mariinsky Theatre to the UK, the USA, Canada, Germany, the Netherlands, Finland, France, Switzerland, South Korea, Japan, Italy, Spain and Australia.

Independently of the Mariinsky Theatre, he performs as guest conductor at the Royal Opera House, Covent Garden, the Oulu Theatre (Finland) and the Oviedo Opera House (Spain).

Jury member of the International Glinka Opera Singers? Competition (1986) and the International Rimsky-Korsakov Opera Singers? Competition (1997, 1999).

© State Academic Mariinkiy Opera and Ballettheatre