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 (8418,8474,8482,10124,10173,10184,11707,11756,11767,13290,13339,13350,14688,14695,14704,16138,16143,16158,17748,17753,17768,19161,19170,34114,34118,34121,34177,35516,35519,35566,35626,35667,35693,35697,37106,37170,37211,37238,37245,38718,38763,38790,38796,40167,40211,40237,40243,40312,40317,40326,40331,40346,41550,41551,41623,41627,41640,41645,41663,43017,43021,43031,43038,43055,44376,44380,44393,44398,44415,45728,45732,45745,45750,45767,47073,47077,47090,47095,47112,48414,48418,48428,48435,48452,49746,49749,49763,49768,49785,51074,51077,51091,51096,51111,52393,52397,52411,52416,52430,53708,53712,53726,53731,53745,55017,55021,55035,55040,55054,56320,56324,56335,56342,56358,57686,57699,57703,57718,59769,59772,59787,61831,61836,61851,63891,63906,65953,67998,70040,72077,74107,153314,153333,153351,153355,153464,153465,155043,155064,155082,155086,155195,155196,156764,156785,156803,156808,156916,156917,158475,158496,158514,158519,158627,158628,160201,160222,160240,160245,160353,160354,161949,161967,161972,162080,162081,163667,163684,163695,163821,163826,165408,165426,165437,165563,165568,167139,167157,167168,167294,167299,168878,168889,169014,169020,170590,170601,170726,170732,172294,172305,172430,172436,173994,173999,174128,174130,175683,175812,175814,177485,177487,179147,179150,180800,180803,182447,182450,184088,184091,185719,185723,187342,187345,188954,188957,190554,190557,192143,192146,193721,193724,196480,196482,197792,197794,199109,199111,200426,200428,202108,202110,203780,203782,205453,205455,207151,207153,208839,208841,210502,210504,212224,212261,212271,212275,212306,212331,213759,213796,213806,213810,213841,213866,215295,215332,215342,215346,215377,215402,216826,216863,216873,216877,216908,216933,218355,218392,218402,218406,218437,218462,219878,219915,219925,219929,219960,219985,221397,221434,221443,221448,221479,221504,222911,222948,222957,222962,222992,223018,224420,224457,224466,224471,224501,224527,225925,225962,225973,225979,226011,226039,227430,227467,227478,227485,227516,227544,228929,228966,228976,228983,229015,229044,230914,230951,230961,230968,231000,231029,232909,232946,232956,232963,232995,233024,234899,234936,234946,234953,234985,235013,236884,236921,236931,236937,236969,236997,238859,238895,238905,238912,238943,238971,240825,240861,240871,240878,240909,240937,242786,242822,242832,242839,242870,242898,244748,244779,244789,244796,244828,244860,246702,246733,246743,246750,246782,246814,248649,248680,248690,248697,248730,248761,250591,250624,250639,250645,250674,250705,252576,252607,252622,252623,252657,252688,254546,254581,254596,254601,254631,254662,256511,256543,256560,256565,256595,256626,258473,258506,258521,258527,258556,258587,260438,260470,260487,260492,260523,260553,262398,262430,262447,262452,262482,262513,264365,264399,264414,264420,264449,264480,266324,266359,266374,266380,266409,266440,268276,268309,268326,268332,268361,268391,270250,270267,270273,270302,270332,272188,272206,272212,272241,272271,274121,274139,274145,274173,274204,274269,274272,274277,276055,276073,276079,276107,276138,276203,276206,276211,277982,277996,278002,278032,278063,278130,278133,278138,279859,279873,279879,279910,279940,280007,280010,280014,281727,281741,281747,281778,281808,281875,281878,281882,283600,283606,283637,283667,283734,283737,283741,285457,285463,285493,285524,285591,285594,285598,287311,287318,287348,287380,287445,287449,287453,289160,289195,289222,289288,289292,289295,291028,291060,291127,291130,291132,292924,292956,293023,293026,293028,294814,294844,294912,294915,294917,296694,296724,296792,296795,296797,298572,298599,298665,298669,298672,300442,300468,300535,300539,300542,302360,302428,302431,302433,304241,304310,304313,304317,306167,306236,306240,306245,308091,308160,308164,308169,310009,310077,310082,310086,311924,311991,311995,312000,313900,313904,313908,315805,315809,315813,317703,317707,317711,319593,319597,319601,321472,321476,321480,323342,323346,323350,325237,325241,325245,327135,327140,327148,329036,329040,329044,330927,330931,330935,332813,332817,332821,334688,334692,334696,336554,336558,336562,338420,338424,338428,340300,340305,340311,342225,342229,342235,344149,344153,344155,346069,346071,347978,374384,374401,374408,374493,376228,376245,376253,376338,378063,378081,378088,378173,379896,379914,379921,380006,381724,381742,381750,381834,383544,383561,383569,383655,385359,385377,385385,385470,387184,387192,387278,388996,389004,389089,390796,390804,390890,392596,392604,392689,394401,394485,396190,396276,398060,399839,401606,403367,405121,406874,408621,410361,412127,413884,415627,417366,419106,420839,422569,424294,426008,427707,457400,458966,460525,462072,463623,465171,466713,468411,470113,471664,473204,474784,476361,477933,477993,479499,479559,481066,481128,481808,481869,482613,483347,484089,484840,485585,486323,487047,487762,488473,489186,489895,490597,491296,491984,497476,498946,500401,501856,503344,504826,506299,507770,509239,510703,512159,513607,515077,516541,517995,519440,520882,522319,523747,525166,526576,527980,529383,530783,532177,533561,534995,536418,537849,539273,540689,542123,543568,545038,549461,550904,552340,553764,555181,556588,557991,559388,559525,559529,559581,560780,560918,560922,560974,562167,562304,562308,562361,563549,563686,563690,563743,565056,565061,565114,566417,566422,566474,567776,567781,567832,569131,569135,569188,570479,570483,570535,571818,571823,571876,573197,573202,573254,574568,574573,574624,575929,575933,575985,577287,577291,577343,578639,578644,578695,579981,579985,580036,581314,581317,581369,582635,582640,582691,583962,583966,584018,585275,585279,585331,586586,586587,586642,587889,587893,587946,589185,589190,589242,590825,590831,590883,592443,592447,592498,594072,594079,594130,595771,595777,595830,597461,597467,597520,599142,599148,599200,600814,600820,600873,602491,602497,602549,604164,604216,605874,607523,609161,610848,612528,614202,615864,617513,619150,620778,622404,644547,644565,644606,646054,646071,646112,647556,647573,647613,649041,649063,649099,650538,650554,650596,652022,652039,652075,653498,653515,653555,654964,654981,655021,656419,656436,656472,657859,657881,657921,659313,659330,659375,660749,660766,660812,662192,662238,663612,663656,665026,665072,666431,666478,667913,669337,670772,672200,673618,675023,676419,677805,693900,693927,694035,694039,694045,695148,695175,695283,695287,695293,696404,696514,696518,696524,697624,697733,697737,697743,698831,698941,698945,698950,700028,700137,700143,700148,701217,701326,701331,701337,702523,702527,702533,703707,703711,703717,704882,704886,704891,706039,706042,706047,707185,707189,707195,708315,708322,708323,709437,709444,709450,710582,710589,710595,711722,711730,711736,712860,712868,712873,713990,713994,714000,715099,715107,715112,716202,716210,716215,717299,717303,717309,718381,718384,718389,719452,719456,719462,720511,720515,720521,721564,721570,722619,732008,732014,732073,732995,733000,733057,733979,733985,734048,734967,734968,735030,735940,735946,736003,736914,736921,736979,737882,737889,737947,738842,738849,738907,739795,739802,739859,741767,741773,741830,743743,743749,743806,745712,745718,745775,747674,747680,747735,749658,749664,749720,751640,751646,751702,753622,753628,753684,756498,756504,756560,759368,759374,759430,762235,762241,762297,765098,765104,765160,767954,767960,768015,770803,770809,770864,773646,773653,773707,776483,776490,776544,779316,779323,779377,782152,782159,782213,784985,784992,785046,787813,787820,787874,790636,790644,790698,793456,793464,793518,796263,796271,796327,799070,799078,799134,801873,801879,801937,804670,804677,804735,807463,807469,807528,810250,810256,810315,813031,813037,813096,815807,815813,815872,818578,818584,818643,821342,821347,821407,824098,824103,824163,826847,826852,826912,829590,829596,829655,832332,832339,832396,835065,835071,835130,837794,837800,837859,840521,840527,840586,843244,843250,843309,845989,845995,846055,848725,848731,848790,851456,851462,851526,854194,854195,854259,856922,856929,856988,859644,859650,859709,862361,862367,862426,865067,865074,865133,867769,867829,870513,873196,875879,878566,881250,883936,886611,889276,891937,894592,897246,899895,902533,902555,902581,902582,902596,905187,905209,905210,905227,907804,907826,907827,907844,910418,910440,910441,910458,913031,913051,913052,913070,915683,915684,915701,918386,918387,918405,921079,921080,921098,923757,923758,923777,926467,929184,931894,934601,959012,959029,961667,961684,964305,964324,966941,966960,969573,969592,972201,972220,974821,974840,977433,977452,980040,980059,982651,985237,987861,990480,993091,1031631,1031686,1031723,1034134,1034189,1034226,1036624,1036679,1036715,1039113,1039168,1039204,1041596,1041652,1041688,1044072,1044127,1044164,1046539,1046594,1046631,1048995,1049051,1049088,1051439,1051494,1051532,1053924,1053961,1056351,1056388,1058773,1058810,1061182,1061219,1063583,1063620,1065977,1066014,1068358,1068396,1070732,1070770,1073132,1073170,1075525,1075563,1077908,1077946,1080279,1080316,1082638,1082675,1085020,1087348,1089669,1091999,1094321,1096630,1098927,1118913,1121042,1123185,1125317,1127508,1129729,1131932,1134123,1136332,1138534,1140732,1142923,1145106,1279528,1281377,1283217,1285047,1286865,1288667,1290455,1292267,1294074,1330775,1330848,1330885,1330886,1332657,1332730,1332767,1332768,1334524,1334599,1334640,1334643,1336390,1336467,1336508,1336509,1338242,1338320,1338361,1338362,1340157,1340199,1340200,1341980,1342021,1342022,1343792,1343833,1343834,1345598,1345637,1345639,1347404,1347445,1347446,1349196,1349237,1349238,1350982,1351016,1351017,1352880,1352914,1352915,1354765,1354800,1354801,1356640,1356675,1356676,1358504,1358539,1358540,1360362,1360397,1360398,1362211,1362245,1362246,1364048,1364083,1364085,1365915,1365916,1367726,1367727,1369532,1369533,1371332,1371333,1373118,1373120,1374894,1374895,1376747,1376748,1412263,1412269,1412270,1414026,1414032,1414033,1415780,1415786,1415787,1417528,1417529,1447339,1448898,1450443,1451975,1453497,1455012,1456517,1458015,1459501,1460972,1462436,1463886,1465325,1466752,1468167,1469569,1470954,1472331,1473689,1473697,1475045,1475049,1476384,1476388,1477726,1477733,1479098,1479104,1480481,1648688,1651492,1654356,1657210,1660053,1662887,1665704,1668511,1671310,1674165,1677017,1679861,1682694,1685513,1688371,1691229,1694000,1696765,1699523,1702272,1705011,1707784,1710551,1713309,1716089,1716109,1716117,1716128,1716131,1716140,1716175,1716208,1716242,1718859,1718878,1718887,1718898,1718901,1718910,1718945,1718977,1719012,1721614,1721634,1721640,1721652,1721656,1721665,1721699,1721732,1721765,1724375,1724382,1724394,1724398,1724407,1724440,1724474,1724506,1727114,1727121,1727134,1727137,1727146,1727179,1727213,1727245,1729846,1729853,1729866,1729870,1729878,1729911,1729945,1729976,1732558,1732564,1732578,1732582,1732589,1732623,1732656,1732687,1735262,1735268,1735282,1735286,1735293,1735327,1735360,1735391,1737957,1737963,1737976,1737980,1737989,1738021,1738055,1738086,1740644,1740660,1740664,1740671,1740705,1740743,1740771,1743324,1743328,1743337,1743369,1743403,1743434,1745986,1745990,1745999,1746031,1746065,1746096,1748639,1748643,1748652,1748684,1748718,1748749,1751288,1751297,1751327,1751361,1751392,1753936,1753966,1754000,1754031,1756565,1756600,1756629,1756668,1759217,1759254,1759286,1761822,1761859,1761891,1764423,1764460,1764492,1767019,1767055,1767088,1769610,1769644,1769678,1772190,1772224,1772256,1774763,1774799,1774830,1777332,1777368,1777399,1779919,1779951,1782465,1782498,1785003,1785035,1787531,1787561,1790030,1790060,1792519,1792549,1794987,1795015,1797464,1799935,1802392,1802436,1802437,1802532,1802535,1804830,1804874,1804875,1804970,1804973,1807259,1807295,1807296,1807391,1807394,1809662,1809697,1809698,1809794,1809799,1812077,1812085,1812175,1812181,1814439,1814440,1814530,1814536,1816785,1816786,1816876,1816882,1819107,1819108,1819198,1819204,1821405,1821406,1821496,1821501,1823768,1823773,1826018,1826022,1828242,1828246,1830444,1830448,1832632,1832636,1834831,1834835,1837023,1837027,1839207,1839210,1841374,1841378,1843527,1843529,1845667,1845669,1847823,1847826,1847883,1849975,1849978,1850032,1852121,1852124,1852178,1854261,1854264,1854318,1856400,1856402,1856454,1858527,1858529,1858581,1860643,1860645,1860697,1862758,1862760,1862812,1864871,1864923,1867024,1869110,1871190,1873256,1875312,1877365,1879439,1881507,1883568,1885617,1887687,1971194,1973202,1975201,1977184,1979158,1981152,1983144,1985133,1987112,1989082,1991037,1992975,1994914,1996843,1998763,2000677,2002581,2068021,2068037,2068044,2070027,2070043,2070050,2072019,2072035,2072042,2073998,2074014,2074020,2075970,2075986,2075992,2077933,2077952,2077957,2079931,2079949,2079955,2081922,2081939,2081946,2083909,2083926,2083932,2085834,2085852,2085857,2087747,2087765,2087771,2089656,2089674,2089680,2091560,2091576,2091584,2093471,2093479,2095357,2095365,2097229,2097236,2099097,2196900,2198428,2199944,2201464,2203004,2204536,2206058,2207587,2209102,2210605,2212098,2213796,2215484,2217167,2218946,2221184,2223408,2386931,2386932,2386966,2386972,2389996,2389997,2390029,2390030,2393059,2393060,2393089,2393091,2396109,2396110,2396142,2396143,2399144,2399145,2399178,2399179,2402163,2402165,2402201,2402203,2405178,2405179,2405215,2405216,2408189,2408190,2408222,2408223,2411189,2411190,2411226,2411227,2414180,2414181,2414217,2414218,2417160,2417161,2417197,2417198,2420168,2420169,2420207,2420208,2423197,2423198,2426187,2426189,2429171,2429173,2432141,2432143,2435105,2435107,2438056,2438058,2440998,2440999,2446877,2446878,2446885,2449794,2449795,2449801,2452701,2452702,2452710,2455588,2455589,2455595,2458469,2458470,2458478,2461345,2496303,2496354,2496414,2499210,2499265,2499326,2502161,2502221,2505038,2505098,2507906,2507969,2510770,2510828,2513630,2513689,2516484,2516543,2519334,2519393,2522170,2522233,2524997,2525060,2527813,2527872,2530623,2530682,2533427,2533489,2536283,2539076,2541866,2544645,2547410,2550177,2552977,2555769,2558576,2561374,2564157,2566926,2566971,2566979,2567000,2567038,2567091,2569730,2569772,2569779,2569809,2569838,2569889,2572559,2572603,2572610,2572638,2572669,2572719,2575422,2575430,2575453,2575490,2575541,2578232,2578240,2578266,2578296,2578347,2581041,2581049,2581075,2581104,2581157,2583831,2583839,2583860,2583897,2583948,2586603,2586610,2586639,2586667,2586718,2589374,2589383,2589409,2589438,2589491,2592137,2592145,2592172,2592200,2592251,2594891,2594899,2594927,2594955,2595005,2597639,2597648,2597670,2597707,2597759,2600376,2600383,2600412,2600440,2600493,2603106,2603135,2603162,2603216,2605843,2605877,2605921,2608548,2608575,2608630,2611243,2611280,2611333,2613974,2614002,2614052,2616697,2616722,2616778,2619411,2619436,2619490,2622138,2622192,2624830,2624882,2627510,2627563,2630177,2630229,2632839,2632888,2635503,2635546,2638150,2638194,2640819,2643434,2646043,2648644,2651230,2653799,2656365,2658910,2661442,2678700,2678717,2678743,2678744,2678768,2681106,2681125,2681126,2681150,2683477,2683496,2683497,2683521,2685838,2685863,2685864,2685889,2688201,2688220,2688221,2688245,2690552,2690571,2690572,2690602,2692909,2692910,2692933,2695231,2695232,2695257,2697870,2697880,2697884,2697922,2697944,2700944,2700954,2700958,2700996,2701018,2704036,2704040,2704078,2704100,2707108,2707112,2707150,2707172,2710186,2710208,2713220,2713244,2716244,2716268,2719309,2719333,2722383,2722407,2725506,2728595,2731680,2756216,2756243,2756253,2756268,2756283,2756319,2759256,2759266,2759281,2759296,2759332,2762271,2762281,2762296,2762311,2762347,2765280,2765290,2765305,2765320,2765356,2768270,2768280,2768295,2768310,2768346,2771254,2771269,2771284,2771320,2774239,2774254,2774290,2777198,2777213,2777249,2780182,2780197,2780233,2783222,2783258,2786303,2786339,2789418,2792477,2795533,2798602,2801660,2804710,2807678,2807723,2807733,2807737,2807762,2807782,2807824,2807843,2807879,2807927,2807938,2810667,2810677,2810681,2810706,2810726,2810768,2810787,2810823,2810871,2810882,2813591,2813601,2813605,2813630,2813650,2813692,2813711,2813747,2813795,2813806,2816507,2816517,2816521,2816546,2816566,2816608,2816627,2816663,2816711,2816722,2819486,2819496,2819500,2819525,2819547,2819589,2819608,2819644,2819692,2819703,2822456,2822466,2822470,2822495,2822517,2822559,2822578,2822614,2822662,2822673,2825438,2825448,2825452,2825477,2825499,2825541,2825560,2825596,2825644,2825655,2828417,2828421,2828446,2828468,2828510,2828529,2828565,2828613,2828624,2831372,2831397,2831419,2831461,2831480,2831516,2831564,2831575,2834327,2834349,2834391,2834410,2834446,2834494,2834505,2837250,2837272,2837314,2837333,2837369,2837417,2837428,2840177,2840199,2840241,2840261,2840297,2840345,2840356,2843116,2843158,2843178,2843215,2843263,2843274,2844555,2844597,2844617,2844654,2844702,2844713,2845983,2846025,2846045,2846082,2846130,2846141,2847444,2847464,2847501,2847549,2847560,2848852,2848872,2848909,2848957,2848968,2851706,2851726,2851763,2851811,2851822,2853126,2853146,2853183,2853231,2853242,2854539,2854559,2854596,2854644,2854655,2855949,2855969,2856006,2856054,2856065,2857352,2857372,2857409,2857457,2857468,2858768,2858805,2858853,2858864,2860155,2860192,2860240,2860251,2861568,2861616,2861627,2864344,2864392,2864403,2867121,2867169,2867180,2868494,2868542,2868553,2869873,2869921,2869932,2871249,2871297,2871308,2872620,2872668,2872679,2873985,2874033,2874044,2875390,2875401,2876736,2876747,2878079,2878090,2878107,2879451,2879462,2879479,2882227,2882238,2882255,2884992,2885003,2885020,2887733,2887744,2887761,2890461,2890472,2890489,2893186,2893203,2895895,2898580,2906596,2906619,2906659,2906700,2906706,2909182,2909205,2909245,2909286,2909292,2911791,2911814,2911854,2911895,2911901,2914382,2914405,2914445,2914486,2914492,2916967,2916990,2917030,2917071,2917077,2919548,2919571,2919611,2919652,2919658,2922115,2922138,2922178,2922219,2922225,2924696,2924734,2924776,2924782,2927243,2927281,2927323,2927329,2929771,2929809,2929851,2929857,2932319,2932361,2932367,2934825,2934867,2934873,2937320,2937362,2937368,2939821,2939863,2939869,2942318,2942360,2942366,2944805,2944847,2944853,2947317,2947323,2949766,2949772,2952210,2952218,2954651,2954657,2954696,2954712,2954728,2954748,2954781,2957132,2957138,2957177,2957193,2957209,2957229,2957267,2959613,2959652,2959668,2959684,2959704,2959742,2962114,2962130,2962146,2962166,2962204,2964552,2964568,2964584,2964604,2964642,2966972,2966988,2967004,2967024,2967062,2969386,2969402,2969418,2969438,2969476,2971804,2971820,2971836,2971856,2971894,2974212,2974228,2974248,2974286,2976593,2976609,2976629,2976667,2978977,2978997,2979034,2981357,2981377,2981414,2983745,2983782,2986110,2986147,2988491,2988528,2990900,2993268,2995623,2997961,3000391,3002709,3005005,3007237,3009424,3011603,3013760,3015903,3018042,3020235,3022086,3023555,3025022,3026474,3056707,3056727,3056774,3056811,3058164,3058183,3058236,3058269,3059613,3059633,3059683,3059717,3061053,3061076,3061123,3061163,3062797,3062813,3062865,3062903,3064529,3064545,3064583,3064595,3064629,3066246,3066268,3066305,3066313,3066354,3067956,3067974,3068013,3068024,3068059,3069657,3069671,3069714,3069724,3069757,3071340,3071362,3071400,3071408,3071445,3073021,3073040,3073080,3073092,3073125,3074691,3074711,3074750,3074758,3074797,3076367,3076406,3076419,3076453,3078023,3078061,3078069,3078106,3079682,3079721,3079730,3079767,3081329,3081369,3081382,3081414,3082969,3083007,3083016,3083058,3084635,3084648,3084684,3086291,3086298,3086336,3087931,3087943,3087979,3089565,3089576,3089611,3091188,3091200,3091237,3092796,3092807,3092846,3094399,3094410,3094447,3096003,3096037,3097587,3097623,3097848,3097865,3097874,3099196,3099424,3099439,3099448,3100772,3100995,3101010,3101021,3102330,3102555,3102570,3102578,3103874,3104099,3104117,3104124,3105413,3105638,3105652,3105662,3106966,3107191,3107204,3107214,3108508,3108732,3108747,3108757,3110300,3110317,3110326,3111860,3111875,3111883,3113407,3113422,3113431,3114942,3114957,3114964,3116460,3116478,3116486,3117977,3117990,3117999,3119485,3119500,3119509,3120989,3121004,3121014,3122335,3122518,3122534,3122542,3124031,3124215,3124229,3124238,3125719,3125901,3125917,3125927,3127577,3127590,3127601,3129240,3129255,3129265,3130896,3130911,3130921,3132543,3132558,3132568,3134183,3134198,3134208,3135823,3135838,3135848,3137456,3137471,3137481,3139077,3139092,3139102,3140689,3140704,3140714,3142293,3142308,3142318,3143887,3143902,3143912,3145477,3145492,3145502,3147057,3147072,3147082,3147693,3147708,3147718,3148323,3148338,3148348,3148947,3148962,3148972,3149571,3149586,3149596,3151118,3151133,3151143,3152657,3152672,3152682,3154190,3154205,3154215,3155713,3155728,3155738,3157229,3157244,3157254,3158736,3158751,3158761,3160230,3160245,3160255,3161715,3161730,3161740,3163192,3163207,3163217,3164664,3164679,3164689,3166127,3166142,3166152,3167588,3167598,3167605,3168982,3168992,3168999,3170367,3170377,3170384,3171744,3171754,3171761,3173115,3173125,3173132,3174480,3174490,3174497,3175880,3175890,3175897,3177278,3177288,3177295,3178669,3178679,3178686,3180141,3180151,3180158,3181609,3181619,3181626,3183075,3183085,3183092,3184538,3184548,3184555,3185999,3186009,3186016,3187456,3187466,3187473,3188907,3188917,3188924,3190352,3190362,3190367,3191792,3191802,3191808,3193227,3193239,3193245,3194919,3194930,3194936,3196704,3196714,3196721,3198689,3198695,3200658,3200663,3202356,3202361,3204048,3204054,3205738,3205746,3207432,3209112,3210786,3210889,3210914,3210926,3210927,3212608,3212634,3212646,3212647,3214312,3214338,3214349,3214350,3216007,3216032,3216043,3216047,3217702,3217726,3217736,3217738,3219388,3219413,3219425,3219429,3221069,3221093,3221103,3221105,3222735,3222760,3222770,3222773,3224398,3224425,3224435,3224438,3226027,3226054,3226065,3226068,3227643,3227668,3227680,3227684,3229260,3229285,3229297,3229300,3230883,3230909,3230920,3230923,3232500,3232524,3232538,3232541,3234110,3234135,3234145,3234150,3235709,3235734,3235745,3235749,3237292,3237318,3237329,3237333,3238862,3238888,3238899,3238902,3240430,3240453,3240467,3240470,3242033,3242057,3242072,3242073,3243626,3243651,3243665,3243667,3245210,3245232,3245244,3245248,3246812,3246835,3246849,3246851,3248398,3248420,3248435,3248437,3249966,3249990,3250004,3250005,3251533,3251557,3251570,3251571,3253091,3253116,3253130,3253132,3254691,3254715,3254729,3254731,3256727,3256737,3256742,3258737,3258752,3258753,3260734,3260746,3260747,3262716,3262728,3262732,3264696,3264711,3264713,3266674,3266688,3266690,3268659,3268673,3268675,3268700,3268719,3268730,3268733,3268747,3268791,3270720,3270721,3270749,3270769,3270777,3270778,3270800,3270839,3272847,3272851,3272877,3272893,3272904,3272907,3272923,3272964,3274956,3274958,3274990,3275005,3275014,3275015,3275036,3275072,3277079,3277096,3277107,3277108,3277125,3277165,3279167,3279188,3279198,3279200,3279219,3279259,3281305,3281319,3281330,3281332,3281351,3281389,3283429,3283448,3283458,3283459,3283481,3283522,3285551,3285565,3285577,3285579,3285600,3285639,3287698,3287715,3287726,3287728,3287749,3287790,3289830,3289850,3289860,3289863,3289885,3289923,3291967,3291976,3291978,3291998,3292042,3294070,3294080,3294084,3294102,3294144,3296169,3296181,3296183,3296206,3296246,3298263,3298274,3298277,3298295,3298337,3300358,3300362,3300381,3300423,3302433,3302437,3302456,3302498,3304496,3304498,3304523,3304560,3306567,3306612,3308615,3308658,3310658,3310698,3312688,3312728,3314712,3314747,3316719,3316762,3318724,3318763,3320749,3322732,3324879,3327152,3329539,3331917,3334284,3336636,3338986,3341328,3341337,3341347,3341355,3341356,3341386,3341387,3341397,3343668,3343673,3343685,3343692,3343696,3343722,3343726,3343733,3346021,3346028,3346039,3346047,3346052,3346079,3346082,3346091,3348377,3348383,3348394,3348401,3348407,3348430,3348435,3348444,3350717,3350730,3350736,3350744,3350768,3350770,3350781,3353051,3353060,3353063,3353090,3353091,3353104,3355371,3355379,3355384,3355408,3355411,3355421,3357701,3357708,3357711,3357740,3357743,3357751,3357767,3357798,3360046,3360052,3360061,3360083,3360089,3360096,3360112,3360141,3362415,3362418,3362445,3362448,3362458,3362469,3362506,3364768,3364775,3364799,3364801,3364812,3364826,3364858,3367114,3367141,3367143,3367154,3367163,3367200,3369469,3369473,3369484,3369496,3369528,3371795,3371797,3371809,3371819,3371855,3374114,3374117,3374125,3374135,3374172,3376427,3376429,3376438,3376450,3376481,3376542,3376558,3376559,3376564,3376619,3376621,3376625,3376635,3378732,3378733,3378744,3378755,3378785,3378853,3378862,3378869,3378871,3378924,3378926,3378931,3378941,3381027,3381030,3381041,3381053,3381081,3381150,3381158,3381165,3381167,3381220,3381225,3381228,3381239,3383311,3383320,3383352,3383419,3383427,3383435,3383437,3383490,3383494,3383496,3383510,3385599,3385611,3385640,3385703,3385713,3385716,3385718,3385771,3385779,3385780,3385795,3387878,3387908,3387969,3387982,3387984,3387987,3388040,3388047,3388049,3388063,3390134,3390164,3390232,3390240,3390249,3390250,3390301,3390308,3390310,3390323,3392387,3392418,3392478,3392491,3392496,3392497,3392553,3392559,3392561,3392572,3394653,3394717,3394730,3394733,3394738,3394788,3394794,3394795,3394808,3396874,3396942,3396950,3396954,3396959,3397014,3397016,3397017,3397031,3399094,3399156,3399168,3399172,3399174,3399225,3399230,3399235,3399246,3401292,3401354,3401370,3401373,3401374,3401429,3401433,3401437,3401447,3403487,3403548,3403560,3403562,3403564,3403620,3403624,3403626,3403638,3405668,3405729,3405741,3405743,3405745,3405798,3405804,3405807,3405820,3407834,3407896,3407908,3407910,3407915,3407966,3407975,3407976,3407988,3410062,3410072,3410078,3410080,3410132,3410136,3410137,3410152,3412202,3412215,3412219,3412224,3412274,3412281,3412285,3412295,3414371,3414386,3414387,3414389,3414447,3414448,3414453,3414464,3416522,3416532,3416536,3416540,3416594,3416598,3416600,3416613,3418663,3418673,3418677,3418682,3418735,3418738,3418741,3418752,3420785,3420793,3420802,3420803,3420853,3420858,3420863,3420875,3422883,3422897,3422901,3422903,3422955,3422961,3422965,3422978,3424968,3424976,3424980,3424986,3425039,3425043,3425046,3425056,3427025,3427035,3427043,3427045,3427095,3427100,3427104,3427116,3429069,3429080,3429082,3429088,3429139,3429145,3429147,3429158,3431103,3431112,3431113,3431164,3431170,3431172,3431183,3433113,3433119,3433120,3433174,3433180,3433183,3433195,3435120,3435121,3435122,3435180,3435185,3435186,3435199,3437120,3437122,3437177,3437178,3437179,3437194,3439152,3439159,3439163,3439176,3441118,3441127,3441128,3441139,3443086,3443093,3443094,3443107,3445059,3445065,3445066,3445078,3447215,3447221,3447222,3447233,3449359,3449365,3449369,3449380,3451501,3451506,3451507,3451519,3453632,3453636,3453639,3453651,3455752,3455756,3455757,3455771,3457879,3457880,3457881,3457896,3460001,3460006,3460007,3460020,3460061,3460062,3462134,3462139,3462141,3462153,3462196,3462198,3464259,3464265,3464267,3464280,3464320,3464323,3466410,3466417,3466418,3466429,3466471,3466473,3468591,3468596,3468600,3468610,3468650,3468652,3470765,3470767,3470776,3470817,3470820,3472932,3472975,3472976,3475091,3475130,3475132,3477243,3477282,3477286,3479387,3479429,3479432,3481566,3481570,3483699,3483701,3485822,3485823,3487931,3487933,3490040,3490043,3492171,3492172,3494290,3494292,3496406,3496408,3498559,3498561,3500704,3500706,3534219,3534248,3534271,3534304,3536256,3536263,3536265,3536285,3536308,3536338,3538288,3538292,3538293,3538317,3538341,3538369,3540313,3540315,3540317,3540337,3540361,3540394,3542379,3542387,3542389,3542406,3542432,3542466,3544438,3544442,3544446,3544465,3544489,3544517,3546481,3546482,3546484,3546506,3546529,3546562,3548514,3548522,3548524,3548543,3548568,3548600,3550549,3550552,3550554,3550572,3550601,3550628,3552587,3552592,3552594,3552619,3552642,3552670,3554625,3554626,3554629,3554653,3554674,3554707,3556659,3556665,3556668,3556691,3556715,3556740,3558685,3558692,3558694,3558711,3558737,3558766,3560702,3560707,3560724,3560751,3560784,3562730,3562755,3562780,3564730,3564757,3564782,3566752,3566775,3566802,3568763,3568787,3568812,3570780,3570806,3570831,3572786,3572812,3572842,3574828,3574858,3576732,3576761,3578636,3578666,3580537,3580565,3582428,3582455,3584289,3584311,3586147,3586171,3588021,3589875,3591724,3593568,3595526,3597518,3599491,3827417,3827425,3827427,3827757,3827764,3827766,3828097,3828099,3828102,3828425,3828431,3828433,3828753,3828760,3828763,3829077,3829085,3829088,3829400,3829404,3829412,3829720,3829722,3829728,3830035,3830037,3830044,3830342,3830350,3830352,3830645,3830650,3830651,3830948,3830950,3845782,3850715,3850718,3850937,3850940,3851154,3851157,3851368,3851371,3851579,3851582,3851787,3851790,3851993,3851996,3852197,3852200,3852400,3852405,3852995,3852997,3853585,3853588,3854172,3854177,3854758,3854760,3855341,3855343,3855923,3855924,3856504,3897403,3897410,3897451,3898108,3898116,3898156,3898809,3898817,3898858,3899512,3899519,3899558,3900208,3900217,3900259,3900927,3900935,3900978,3901649,3901692,3902362,3902405,3903075,3903117,3903825,3904528,3905229,3905927,3906620,3907312,3907332,3907347,3907350,3908000,3908021,3908036,3908039,3908689,3908710,3908725,3908729,3909372,3909393,3909408,3909409,3910051,3910071,3910089,3910092,3910742,3910762,3910780,3910783,3911428,3911449,3911463,3911468,3912131,3912150,3912152,3912815,3912831,3912834,3913495,3913514,3913515,3914172,3914188,3914191,3914845,3914861,3914865,3915526,3915544,3915546,3916204,3916220,3916223,3916878,3916894,3916899,3917568,3917572,3918237,3918240,3918911,3918913,3918946,3919603,3919604,3919636,3920288,3920290,3920323,3921003,3921681,3922354,3923034,3923713,3924388,3925058,3926415,3926417,3926418,3926435,3927078,3927080,3927081,3927099,3927736,3927739,3927740,3927757,3928396,3928398,3928399,3928418,3929050,3929053,3929055,3929072,3929704,3929705,3929707,3929726,3930353,3930354,3930356,3930374,3931000,3931001,3931003,3931021,3931645,3931647,3931648,3931666,3932286,3932289,3932292,3932309,3932926,3932929,3932931,3932950,3933570,3933574,3933576,3933593,3934214,3934216,3934232,3934870,3935506,3936141,3936796,3937447,3938099,3941321,3941959,3942598,3948230,3948248,3948874,3948890,3949529,3950164,3950795,3951424,3952050,3953315,3953931,3954542,3955157,3955757,3963651,3963674,3964247,3964819,3965386,3965970,3966549,3967128,3969976,3970548,3971114,3979875,3979897,3979900,3980460,3980480,3980483,3981063,3981068,3981638,3981645,3982211,3982214,3982784,3982790,3983354,3983356,3983385,3983386,3983416,3983418,3983926,3983930,3983954,3983956,3983986,3983990,3984493,3984499,3984525,3984527,3984552,3984554,3985066,3985088,3985090,3985118,3985124,3985648,3985651,3985680,3985683,3986206,3986207,3986235,3986239,3986761,3986762,3986793,3986794,3987311,3987314,3987340,3987343,3987858,3987862,3987891,3987894,3988401,3988404,3988431,3988437,3988939,3988940,3988971,3988973,3989507,3989508,3990036,3990039,3990574,3990579,3991108,3991111,3991636,3991641,3992177,3992183,3992711,3992715,3994322,3994848,3995367,3995881,3996398,3996901,3997402,3998409,3998410,3998914,3998918,3999416,3999420,3999915,3999919,4260343,4260345,4260649,4260651,4260951,4260953)) 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





	Zaurbek Gugkaev (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Zaurbek Gugkaev (Conductor)
			

																
Zaurbek Gugkaev (Conductor)

														
				


        




    

        Zaurbek Gugkaev was born in Vladikavkaz. In 2004 he graduated from the Vladikavkaz School of the Arts. He is currently a fourth-year student at the St Petersburg State Rimsky-Korsakov Conservatoire (faculty of opera and symphony conducting, class of Professor Leonid Korchmar). He has worked with various orchestras in St Petersburg, among them the Mariinsky Theatre Orchestra, the Orchestra of the St Petersburg Conservatoire and the Orchestra of the Children’s Philharmonic. Collaborates with the St Petersburg House of Music. In 2010 he performed in the cycle Music of the Stars with the Orchestra of the State Philharmonic in Mineralnye Vody in the Caucasus and young Russian soloists Alyona Bayeva (violin), Nikita Borisoglebsky (violin), Vyacheslav Gryaznov (piano) and Alexei Stadler (cello) and at the Stars of the White Nights Festival with the Mariinsky Orchestra.        

    

    

            


			

		





	


	

	

		


			

				

					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