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 (8554,10253,11836,13419,14774,14791,16226,16243,17836,17853,19229,19241,20670,20683,22154,22166,23608,23620,25071,25086,26862,26892,27848,27915,29199,29230,31019,31034,32537,32549,34057,34073,34100,34209,35593,35600,35612,35654,35662,35677,35694,35719,35732,37134,37144,37155,37196,37206,37221,37240,37266,37282,38685,38695,38702,38749,38761,38771,38792,38820,38831,40144,40156,40197,40209,40225,40240,40266,40281,40294,40307,40335,41548,41575,41589,41604,41616,41630,41646,42970,42984,43001,43012,43027,43039,44346,44362,44369,44384,44400,45698,45714,45721,45736,45752,47059,47066,47081,47097,48398,48409,48424,48436,49732,49743,49754,49770,51060,51071,51082,51098,52390,52401,52417,53705,53716,53732,55014,55025,55041,56327,56343,57692,57705,59762,59775,61839,63894,65941,105628,105668,105713,107522,107562,107607,109409,109449,109493,111286,111326,111370,113155,113195,113239,115016,115055,115100,116892,116931,116976,118806,118851,120676,120720,122542,122586,124400,124444,126249,126293,128089,128133,129918,129961,131747,131790,133580,133623,135405,135448,137226,137269,139087,140897,142698,144488,146268,148038,149795,149942,151545,151692,153321,153376,153433,153451,155052,155107,155164,155182,156773,156828,156885,156903,158484,158539,158599,158614,160210,160269,160325,160340,161936,161996,162052,162067,163718,163784,163807,165460,165526,165549,167191,167257,167280,168912,168978,169001,170624,170695,170713,172328,172399,172417,174026,174093,174111,175710,175777,175794,177383,177449,177467,179047,179112,179130,180700,180766,180784,182347,182413,182431,183987,184053,184071,185684,185702,187306,187324,188919,188936,190519,190536,192108,192124,193686,193702,196445,196462,197757,197775,198504,199074,199092,199821,200391,200409,201138,202073,202091,202820,203745,203762,204492,205417,205436,206197,207115,207134,207895,208803,208822,209583,211247,212228,212264,212308,212314,212783,213763,213799,213843,213849,214322,215299,215335,215379,215385,215858,216830,216866,216910,216916,217389,218359,218395,218439,218445,218918,219882,219918,219962,219968,220441,221401,221437,221481,221487,221960,222915,222951,222995,223001,223474,224424,224464,224504,224510,224983,225929,225971,226015,226021,226494,227434,227471,227520,227526,227999,228933,228975,229019,229025,229498,230918,230960,231004,231010,231483,232913,232955,232999,233005,233477,234903,234945,234989,234994,235467,236888,236930,236973,236982,237452,238863,238904,238948,238956,239427,240829,240869,240912,240922,241393,242790,242830,242873,242883,243354,244746,244787,244831,244841,245315,246700,246741,246785,246795,247267,248647,248688,248732,248742,249214,250589,250632,250676,250686,251158,252574,252615,252659,252669,253141,254550,254589,254633,254643,255115,256514,256553,256602,256608,257080,258471,258514,258558,258568,259053,260442,260480,260530,260535,261020,262402,262440,262490,262495,262980,264363,264408,264451,264461,264946,266328,266368,266416,266421,266906,268279,268320,268368,268373,268857,270261,270309,270314,270798,272200,272248,272253,272737,274133,274181,274186,274237,274266,274283,274286,274295,274305,274324,274670,276066,276114,276120,276170,276200,276217,276220,276229,276239,276258,276604,277990,278039,278045,278095,278126,278144,278147,278156,278166,278185,278531,279867,279916,279922,279972,280003,280021,280024,280033,280043,280062,280408,281735,281784,281790,281840,281871,281889,281892,281901,281911,281930,282276,283594,283643,283649,283699,283730,283748,283751,283760,283770,283789,284135,285451,285500,285506,285556,285586,285605,285608,285617,285627,285646,285992,287354,287360,287411,287441,287460,287463,287475,287482,287501,287846,289196,289206,289254,289284,289302,289307,289319,289329,289344,289689,291036,291041,291093,291123,291136,291144,291153,291163,291178,291594,292932,292937,292989,293019,293032,293040,293049,293059,293074,293490,294821,294826,294877,294908,294926,294929,294941,294948,294967,295379,296701,296706,296758,296788,296806,296809,296821,296828,296847,297259,298575,298580,298631,298661,298679,298684,298696,298706,298720,299133,300444,300451,300501,300531,300550,300554,300566,300576,300590,301022,302335,302342,302393,302424,302438,302445,302457,302464,302479,302913,304221,304275,304305,304324,304327,304339,304346,304364,304794,306201,306231,306253,306256,306269,306278,306297,306726,308125,308154,308177,308180,308193,308202,308220,308650,310043,310072,310095,310098,310111,310120,310138,310568,311958,311986,312009,312012,312025,312034,312052,312482,313867,313895,313918,313921,313934,313943,313961,314391,315772,315800,315821,315826,315839,315848,315866,316296,317670,317698,317718,317724,317737,317746,317764,318195,319560,319588,319608,319613,319627,319636,319654,320085,321439,321467,321487,321492,321506,321515,321533,321964,323309,323337,323356,323362,323375,323385,323402,323834,325204,325232,325252,325257,325271,325280,325298,325739,327101,327133,327153,327159,327168,327180,327198,327644,329031,329051,329057,329070,329079,329097,329545,330922,330943,330948,330961,330970,330987,331438,332808,332828,332834,332847,332856,332873,333324,334683,334702,334709,334722,334731,334748,335199,336549,336568,336574,336588,336597,336614,337065,338415,338435,338440,338454,338463,338480,338946,340296,340318,340321,340333,340344,340362,340876,342242,342245,342257,342268,342286,342799,344163,344169,344183,344194,344210,344723,346079,346085,346099,346110,346125,346646,347986,347993,348006,348017,348033,348553,349876,349882,349896,349907,349921,350443,351763,351775,351783,351801,352323,353638,353652,353663,353676,354200,355522,355533,355553,356083,357399,357410,357430,357960,359306,359317,359337,359867,361216,361236,361251,361768,363108,363126,363141,363656,365010,365024,365542,366888,366903,367421,368767,368782,369296,370636,370651,371170,372500,372516,373034,374370,374500,374889,376215,376344,376734,378050,378179,378568,379883,380012,380401,381844,382229,383664,384049,385480,385865,387287,387673,389099,389484,390900,391285,392699,393085,394494,394878,396286,396671,398071,398456,399845,400232,401617,402003,403373,403760,405132,405520,406884,407272,408631,409018,410371,410758,412138,412525,413894,414283,415637,416026,417376,417769,419117,419509,420849,421242,422579,422972,424304,424697,426017,426411,427720,428110,429410,429804,431099,431518,433231,434929,436623,438306,439974,441631,443272,444902,446526,448141,449743,451335,452925,454513,456093,457364,457369,457383,457667,458931,458936,458949,459234,460487,460492,460505,460790,462035,462040,462053,462338,463587,463592,463605,463890,465132,465138,465153,465437,466674,466680,466695,466979,468372,468377,468396,468686,470075,470081,470093,470401,471631,471644,471952,473189,473493,474766,475073,476346,476650,477918,478225,479794,497387,497392,497394,497397,497568,498851,498855,498856,498860,499032,500305,500310,500311,500316,500492,501759,501765,501766,501770,501946,503253,503257,503258,503261,503437,504730,504735,504736,504742,504917,506199,506211,506212,506214,506389,507675,507680,507681,507684,507861,509141,509146,509147,509154,509245,509330,510605,510614,510616,510618,510707,510793,512059,512069,512070,512073,512163,512249,513511,513516,513517,513520,513613,513714,514979,514990,514991,514993,515086,515187,516444,516449,516451,516455,516547,516650,517902,517903,517910,518000,518104,519354,519444,519548,520886,520990,522326,522427,523755,523858,525174,525279,526583,526687,527987,528092,529390,529496,530790,530892,532184,532286,533570,533672,535003,535110,536428,536530,537854,537960,539282,539384,540698,540800,542127,542233,543573,543677,545043,545147,546497,546601,547953,548058,549432,549438,549510,549554,550875,550881,550953,551001,552309,552317,552388,552436,553736,553742,553811,553859,555152,555158,555228,555275,556564,556635,556681,558037,558083,559434,559480,560826,560873,562213,562259,563594,563641,564964,565010,566327,566371,567689,567730,569040,569084,570387,570432,571727,571773,573105,573150,574477,574522,575839,575883,577197,577241,578593,579934,581267,582592,583916,583933,583934,585229,585251,585252,586540,586557,586558,587843,587865,587866,589139,589161,589162,590801,590802,592419,592420,592430,594048,594049,594059,595758,597448,644554,644584,644589,644637,646061,646089,646094,646143,647559,647590,647596,647637,649050,649080,649086,649128,650542,650572,650580,650625,652026,652057,652062,652103,653502,653533,653538,653579,654968,654999,655004,655045,656421,656454,656460,656500,657866,657901,657907,657952,659315,659350,659355,659400,660752,660787,660791,660837,662178,662214,662217,662264,663634,663637,663690,665048,665051,665104,666451,666459,666509,667886,667894,667944,669311,669317,669364,670745,670753,670803,672174,672180,672227,673598,673644,675055,676450,677836,679242,680636,682023,683396,684763,693898,693957,695146,695205,696435,697655,698864,700059,701248,702445,703629,704804,705960,707107,732024,732032,733008,733017,733995,734006,734978,734989,735952,735961,736929,736935,737896,737903,738856,738863,739809,739819,741780,741790,743756,743766,745725,745735,747686,747696,749671,749681,751653,751663,753635,753645,756511,756521,759381,759391,762248,762257,765111,765120,767966,767976,770815,770825,773658,773668,776495,776505,779328,779338,782164,782174,784998,785007,787826,787835,790650,790659,793470,793479,796275,796284,799082,799091,801887,801894,804685,804692,807477,807484,810264,810270,813045,813051,815822,815828,818593,818599,821357,821363,824113,824119,826862,826868,829606,829612,832343,832352,835081,835086,837810,837815,840537,840542,843260,843265,846005,846010,848741,848750,851472,851481,854205,854214,856934,856943,859656,859665,862373,862382,865079,865089,867774,867784,870457,870467,873140,873150,875833,878520,958999,959041,959047,959050,961653,961696,961701,961705,964293,964335,964340,964345,966929,966971,966976,966981,969561,969603,969608,969613,972189,972231,972236,972241,974854,974856,974861,977446,977466,977468,977473,980052,980073,980075,980080,982644,982664,982667,982672,985231,985249,985255,985259,987855,987873,987879,987883,990492,990498,990502,993106,993108,993114,995713,995719,995723,998308,998313,998318,1000892,1000897,1000902,1003473,1003478,1003483,1006053,1006058,1008625,1118868,1118873,1118893,1118960,1118964,1121001,1121004,1121022,1121090,1121092,1123138,1123144,1123164,1123231,1123235,1125280,1125297,1125363,1125367,1127489,1127554,1127559,1129709,1129774,1129779,1131913,1131980,1131983,1134171,1134174,1136375,1136378,1138577,1138580,1140774,1140780,1142965,1142970,1145148,1145153,1147318,1147323,1149474,1149479,1151627,1151632,1153776,1153778,1155915,1155919,1158087,1158091,1160250,1160253,1162396,1162399,1164532,1164533,1166662,1285064,1286888,1288690,1290473,1292285,1294093,1295892,1297685,1299466,1301232,1330786,1330787,1330801,1330865,1330879,1332668,1332669,1332683,1332747,1332761,1334538,1334539,1334555,1334616,1334634,1336401,1336402,1336417,1336481,1336500,1338253,1338254,1338269,1338334,1338353,1340091,1340092,1340106,1340172,1340190,1341914,1341915,1341929,1341995,1342012,1343741,1343807,1343824,1345552,1345613,1345631,1347351,1347419,1347436,1349211,1349228,1350995,1351010,1352893,1352907,1354778,1354799,1356652,1356674,1358516,1358536,1360374,1360394,1362222,1362242,1364060,1364080,1365885,1365903,1367696,1367714,1369503,1369521,1371321,1373107,1374882,1412324,1412378,1414087,1414140,1415842,1415892,1417583,1417634,1419314,1419364,1421035,1421084,1422744,1422794,1424440,1424490,1426123,1426173,1427791,1427841,1429448,1429497,1431088,1431142,1432780,1434402,1436013,1437642,1439256,1440859,1442454,1444044,1445622,1447191,1447199,1447235,1447261,1447277,1447297,1448758,1448794,1448820,1448836,1448856,1450345,1450364,1450380,1450401,1451878,1451897,1451911,1451934,1453396,1453418,1453437,1453456,1454913,1454933,1454953,1454969,1456417,1456438,1456459,1456474,1457916,1457936,1457958,1457979,1459423,1459443,1459466,1460895,1460916,1460938,1462358,1462377,1462394,1463824,1463845,1465266,1465283,1466693,1466710,1468125,1469527,1470913,1553781,1554814,1648642,1648646,1648665,1651449,1651456,1651474,1654313,1654319,1654338,1657167,1657173,1657192,1660010,1660016,1660035,1662839,1662845,1662864,1665658,1665662,1665679,1668464,1668468,1668486,1671267,1671274,1671290,1674122,1674129,1674148,1676969,1676976,1676992,1679813,1679820,1679838,1682646,1682653,1682672,1685465,1685472,1685490,1688323,1688330,1688347,1691181,1691188,1691205,1693959,1693976,1696724,1696741,1699499,1702248,1704987,1707760,1710527,1716104,1716158,1718874,1718928,1721628,1721683,1724370,1724427,1727109,1727166,1729841,1729898,1732553,1732610,1735257,1735314,1738010,1740691,1743358,1746020,1748673,1751317,1753956,1756584,1759201,1761806,1764407,1767003,1769593,1802479,1802480,1802484,1802513,1802517,1802534,1802538,1804917,1804918,1804922,1804954,1804961,1804972,1804975,1807338,1807339,1807343,1807375,1807382,1807393,1807396,1809741,1809742,1809746,1809778,1809785,1809796,1809797,1812122,1812123,1812127,1812159,1812166,1812177,1812178,1814477,1814481,1814485,1814513,1814519,1814532,1814533,1816823,1816827,1816831,1816859,1816865,1816878,1816879,1819145,1819148,1819152,1819180,1819186,1819200,1819201,1821443,1821445,1821449,1821478,1821484,1821498,1821502,1823715,1823717,1823721,1823752,1823754,1823770,1823774,1825963,1825965,1825969,1826000,1826005,1826017,1826021,1828187,1828189,1828193,1828223,1828229,1828241,1828245,1830389,1830391,1830395,1830425,1830431,1830443,1830447,1832577,1832579,1832583,1832613,1832619,1832631,1832635,1834774,1834777,1834784,1834812,1834818,1834830,1834834,1836972,1836975,1837004,1837010,1837022,1837026,1839159,1839188,1839194,1839206,1839209,1841358,1841362,1841373,1841377,1843511,1843515,1843526,1843531,1845652,1845658,1845666,1845671,1847806,1847808,1847822,1847824,1847900,1849958,1849960,1849974,1849976,1850046,1852104,1852106,1852120,1852122,1852191,1854244,1854246,1854260,1854262,1854331,1856389,1856399,1856404,1856470,1858526,1858531,1858598,1860642,1860647,1860714,1862757,1862762,1862829,1864873,1864940,1867041,1869128,1871208,1873273,1875329,1877382,1879457,1881524,1883583,1885635,1887704,1889761,1891819,1893894,1895981,1915752,1917962,1920166,1922365,1924552,1926801,1929040,1931269,1933488,1935687,1937883,1940072,1942251,1944422,1946583,1948731,1950867,1952999,1955119,1957195,1959263,1961312,1963350,1965379,1967398,1969418,1971185,1971195,1971428,1973194,1973201,1973440,1975192,1975202,1975435,1977176,1977187,1977423,1979149,1979159,1979392,1981144,1981155,1981393,1983136,1983147,1983385,1985124,1985134,1985367,1987099,1987109,1987348,1989068,1989078,1989318,1991023,1991033,1991273,1992966,1992976,1993209,1994900,1994909,1995149,1996832,1996838,1997078,1998754,1998764,1998997,2000678,2000911,2002582,2002814,2004706,2006580,2008466,2010351,2012227,2014091,2015931,2017760,2019568,2021375,2023176,2024972,2026962,2028952,2030931,2032898,2034855,2036812,2038757,2040695,2042621,2044530,2046430,2048317,2050200,2052073,2053938,2055889,2057926,2059959,2061987,2064007,2066017,2068019,2068028,2070025,2070035,2072017,2072027,2073993,2074007,2075965,2075979,2077929,2077941,2079927,2079938,2081919,2081928,2083904,2083914,2085829,2085840,2087742,2087753,2089651,2089661,2091564,2093460,2196804,2196856,2196862,2196883,2196890,2196895,2196944,2196949,2198383,2198391,2198411,2198416,2198423,2198471,2198475,2199901,2199908,2199923,2199929,2199935,2199985,2199989,2201423,2201424,2201448,2201452,2201460,2201508,2201513,2202959,2202966,2202986,2202994,2202998,2203048,2203053,2204490,2204496,2204519,2204525,2204531,2204579,2204584,2206015,2206023,2206044,2206050,2206056,2206104,2206110,2207542,2207550,2207570,2207577,2207582,2207631,2207636,2209058,2209065,2209085,2209092,2209097,2209146,2209151,2210568,2210589,2210594,2210601,2210650,2210655,2212081,2212087,2212093,2212142,2212147,2213781,2213787,2213793,2213842,2213847,2215466,2215473,2215478,2215528,2215533,2217150,2217156,2217162,2217211,2217216,2218937,2218941,2218991,2218996,2221176,2221225,2221230,2223452,2223457,2225665,2225670,2227867,2227872,2230056,2230061,2232236,2232241,2234653,2234659,2237276,2237281,2240187,2240193,2243363,2243369,2246535,2296758,2299879,2303010,2306157,2309326,2312491,2315652,2318809,2321956,2325103,2328237,2331363,2334470,2337568,2340668,2343777,2346882,2349979,2353102,2356217,2359320,2362419,2386950,2386960,2386961,2390013,2390024,2390025,2393075,2393084,2393085,2396125,2396136,2396137,2399161,2399172,2399173,2402184,2402195,2402196,2405195,2405204,2405205,2408207,2408217,2408218,2411209,2411220,2411221,2414200,2414206,2414212,2417182,2417192,2417193,2420190,2420201,2420202,2423181,2423192,2423193,2426171,2426182,2426183,2429154,2429164,2429165,2432125,2432136,2432137,2435099,2435100,2438051,2438052,2446870,2446896,2446937,2449782,2449812,2449853,2452689,2452718,2452756,2455605,2455647,2458486,2458524,2461358,2461397,2464212,2464254,2467065,2467106,2469978,2472909,2475818,2478760,2481684,2484594,2487500,2490441,2496299,2533492,2536289,2539079,2541870,2544651,2547416,2550179,2552979,2555770,2558577,2561376,2564159,2566928,2566956,2566966,2566990,2567005,2569731,2569759,2569768,2569793,2569806,2572563,2572590,2572598,2572623,2572635,2575379,2575406,2575417,2575441,2575456,2578216,2578227,2578251,2578263,2581025,2581035,2581060,2581072,2583816,2583826,2583850,2583863,2586591,2586599,2586622,2586637,2589363,2589369,2589393,2589408,2592124,2592133,2592156,2592171,2594887,2594910,2594926,2597636,2597660,2597669,2600396,2600411,2603119,2603134,2605826,2605841,2608531,2608546,2608572,2611233,2611247,2611271,2613973,2613997,2616696,2616719,2619410,2619434,2622135,2624820,2627501,2630176,2632837,2635501,2678704,2678731,2678755,2681115,2681138,2683487,2683509,2685851,2685877,2688211,2688233,2690561,2690584,2692899,2692921,2695219,2695245,2697903,2700977,2704059,2707131,2710167,2713204,2756224,2756281,2756312,2756325,2756338,2756354,2759237,2759294,2759325,2759338,2759351,2759367,2762309,2762340,2762353,2762366,2762382,2765318,2765349,2765362,2765375,2765391,2768308,2768339,2768352,2768365,2768381,2771282,2771313,2771326,2771339,2771355,2774252,2774283,2774296,2774309,2774325,2777211,2777242,2777255,2777268,2777284,2780195,2780226,2780239,2780252,2780268,2783220,2783251,2783264,2783277,2783293,2786301,2786332,2786345,2786358,2786374,2789411,2789424,2789437,2789453,2792470,2792483,2792496,2792512,2795515,2795526,2795539,2795552,2795568,2798595,2798608,2798621,2798637,2801653,2801666,2801679,2801696,2804716,2804729,2804746,2807684,2807697,2807714,2807746,2807767,2807777,2807808,2807930,2810641,2810658,2810690,2810711,2810721,2810752,2810874,2813582,2813614,2813635,2813645,2813676,2813798,2816498,2816530,2816551,2816561,2816592,2816714,2819477,2819509,2819530,2819541,2819573,2819695,2822479,2822500,2822511,2822543,2822665,2825461,2825482,2825493,2825525,2825647,2828430,2828451,2828462,2828494,2828616,2831381,2831402,2831413,2831445,2831567,2834332,2834343,2834375,2834497,2837255,2837266,2837298,2837420,2840182,2840193,2840225,2840348,2843099,2843110,2843142,2843266,2844549,2844581,2844705,2846009,2846133,2847428,2847552,2848836,2848960,2851690,2851814,2853110,2853234,2854647,2856057,2857460,2858856,2860243,2861619,2864395,2867172,2868545,2869924,2871300,2872671,2874036,2875393,2876739,2878082,2879454,2882230,2884995,2887736,2890464,2906681,2909267,2911876,2914467,2917052,2919633,2922200,2924759,2927306,2929834,2932344,2934850,2937345,2939846,2942343,2944830,2947300,2949749,2952195,2954709,2954755,2954772,2957190,2957237,2957257,2959665,2959712,2959732,2962127,2962174,2962194,2964565,2964612,2964632,2966985,2967032,2967052,2969399,2969446,2969466,2969480,2971817,2971864,2971884,2971898,2974209,2974256,2974276,2974290,2976590,2976637,2976657,2976671,2979005,2979025,2979038,2981385,2981405,2981418,2983753,2983773,2983786,2986118,2986138,2986151,2988499,2988519,2988532,2990871,2990891,2990904,2993259,2993272,2995614,2995627,2997965,3002747,3005043,3007275,3009462,3011640,3013797,3015940,3018079,3020272,3022107,3023577,3025044,3026496,3027938,3029369,3030797,3030832,3030841,3032212,3032250,3032259,3033655,3033664,3035247,3035256,3036829,3036835,3038397,3038403,3039956,3039963,3041507,3041517,3043062,3044597,3056660,3056734,3056740,3056761,3056790,3056808,3056815,3058122,3058198,3058200,3058220,3058250,3058265,3058278,3059568,3059645,3059648,3059669,3059700,3059716,3059723,3061086,3061094,3061107,3061140,3061152,3061166,3062827,3062831,3062846,3062880,3062895,3062906,3064554,3064560,3064580,3064612,3064627,3064636,3066279,3066285,3066299,3066335,3066344,3066357,3067989,3067991,3068011,3068043,3068057,3068066,3069687,3069688,3069708,3069739,3069753,3069765,3071371,3071376,3071395,3071430,3071439,3071455,3073053,3073056,3073073,3073107,3073122,3073132,3074720,3074725,3074741,3074774,3074788,3074799,3076377,3076384,3076400,3076435,3076451,3076460,3078033,3078042,3078056,3078091,3078101,3078115,3079692,3079697,3079716,3079746,3079759,3079773,3081341,3081348,3081365,3081396,3081413,3081425,3082978,3082987,3083003,3083038,3083047,3083061,3084605,3084612,3084631,3084661,3084675,3084687,3086262,3086266,3086282,3086317,3086330,3086342,3087907,3087924,3087958,3087970,3087985,3089560,3089591,3089604,3089619,3091183,3091215,3091230,3091242,3092790,3092823,3092841,3092848,3094426,3094438,3094453,3096020,3096034,3096043,3097605,3097616,3097632,3097880,3097897,3099179,3099194,3099202,3099452,3099474,3100748,3100763,3100778,3101022,3101046,3102307,3102322,3102333,3102582,3102606,3103870,3103881,3104130,3104151,3105408,3105419,3105668,3105684,3106961,3106972,3107220,3107238,3108511,3108763,3108782,3110081,3110330,3110353,3111890,3111911,3113434,3113454,3114971,3114991,3116489,3116508,3118004,3118023,3119516,3119532,3121019,3121040,3122545,3122565,3124244,3124262,3125932,3125949,3127602,3127624,3129269,3129286,3130925,3130942,3132572,3132589,3134212,3134229,3135852,3135869,3137485,3137502,3137519,3139106,3139123,3139140,3140718,3140735,3140752,3142322,3142339,3142356,3143916,3143933,3143950,3145506,3145523,3145540,3147086,3147103,3147120,3147722,3147739,3147756,3148352,3148369,3148386,3148976,3148993,3149010,3149600,3149617,3149634,3151147,3151164,3151181,3152686,3152703,3152720,3154219,3154236,3154253,3155742,3155759,3155776,3157258,3157275,3157292,3158765,3158782,3158799,3160259,3160276,3160293,3161744,3161761,3161778,3163221,3163238,3163255,3164693,3164710,3164727,3166156,3166173,3166190,3167609,3167622,3167636,3169003,3169016,3169030,3170388,3170401,3170415,3171765,3171778,3171792,3173136,3173149,3173163,3174501,3174514,3174528,3175901,3175914,3175928,3177299,3177312,3177326,3178690,3178702,3178716,3180162,3180174,3180188,3181630,3181642,3181656,3183096,3183108,3183122,3184559,3184571,3184585,3186020,3186032,3186046,3187477,3187489,3187503,3188928,3188940,3188954,3190374,3190388,3190398,3191812,3191830,3191844,3193251,3193266,3193280,3194942,3194957,3194966,3196723,3196741,3196751,3198699,3198715,3198731,3200668,3200685,3200694,3202368,3202382,3202392,3204058,3204076,3204086,3205750,3205764,3205778,3207436,3207449,3207462,3209116,3209129,3209143,3210790,3210804,3210818,3210831,3210861,3210862,3210880,3210895,3210940,3212510,3212524,3212538,3212549,3212580,3212582,3212599,3212612,3212659,3214226,3214239,3214254,3214282,3214286,3214306,3214315,3214365,3215921,3215936,3215946,3215974,3215981,3215999,3216010,3216057,3217616,3217626,3217641,3217668,3217675,3217692,3217705,3217752,3219303,3219315,3219327,3219356,3219362,3219379,3219391,3219438,3220992,3221008,3221035,3221041,3221058,3221072,3221120,3222660,3222675,3222702,3222708,3222726,3222739,3222786,3224327,3224338,3224367,3224374,3224393,3224404,3224449,3225968,3225999,3226003,3226019,3226034,3226081,3227584,3227614,3227616,3227636,3227647,3227697,3229201,3229232,3229233,3229253,3229264,3229314,3230854,3230856,3230876,3230890,3230936,3232468,3232472,3232492,3232504,3232550,3234079,3234082,3234101,3234114,3234160,3235679,3235682,3235702,3235712,3235761,3237262,3237266,3237286,3237297,3237345,3238833,3238837,3238854,3238866,3238915,3240400,3240404,3240422,3240434,3240480,3242000,3242007,3242025,3242036,3242084,3243596,3243599,3243619,3243632,3243677,3245180,3245201,3245213,3245259,3246801,3246813,3246861,3248389,3248399,3248449,3249957,3249970,3250017,3251523,3251534,3251582,3253094,3253141,3254696,3254740,3256704,3256753,3258765,3260761,3262742,3264722,3266701,3268686,3268690,3268726,3270733,3270741,3270775,3272863,3272865,3272902,3274970,3274976,3275010,3277063,3277067,3277105,3279153,3279159,3279193,3281286,3281292,3281326,3283412,3283420,3283453,3285537,3285572,3287721,3289856,3291971,3294076,3296176,3298269,3300355,3302431,3357783,3360128,3362491,3364843,3367184,3369514,3371838,3374157,3376469,3378774,3381073,3383342,3385626,3387893,3390154,3392404,3394641,3396864,3399078,3401281,3460046,3460090,3460096,3460109,3462182,3462228,3462230,3462245,3464307,3464351,3464358,3464369,3466456,3466502,3466506,3466517,3468635,3468681,3468688,3468698,3470804,3470848,3470852,3470864,3472960,3473006,3473009,3473024,3475117,3475162,3475165,3475180,3477268,3477314,3477318,3477330,3479413,3479462,3479466,3479476,3481553,3481599,3481601,3481613,3483683,3483731,3483736,3483746,3485808,3485851,3485858,3485867,3487918,3487965,3487967,3487980,3490025,3490070,3490074,3490086,3492153,3492202,3492204,3492219,3494324,3494327,3494339,3496437,3496441,3496454,3498592,3498595,3498608,3500737,3500741,3500751,3502870,3502873,3502888,3505003,3505006,3505019,3507127,3507130,3507145,3509245,3509249,3509262,3511359,3511363,3511377,3513469,3513472,3513483,3515565,3515568,3515584,3517652,3517656,3517669,3519738,3519744,3519757,3521820,3521834,3523904,3525967,3528019,3538357,3538364,3540382,3540388,3542453,3542458,3544508,3544515,3546550,3546553,3548588,3548589,3550617,3550624,3552661,3552662,3554693,3554700,3556734,3556736,3558759,3558763,3560768,3560775,3562773,3562777,3564774,3564778,3566794,3566796,3568806,3568807,3570822,3570828,3572833,3572839,3574844,3574851,3576752,3576758,3578656,3578659,3580554,3580559,3582444,3582446,3584303,3584308,3586161,3586163,3588014,3588017,3589868,3589869,3591714,3591718,3593561,3593564,3595513,3595515,3597507,3848167,3848396,3848621,3897455,3898160,3898860,3899561,3900262,3900982,3901694,3902407,3903120,3903829,3904531,3905233,3905929,3906622,3907316,3908005,3908691,3909374,3910055,3910744,3911430,3912115,3912797,3926446,3927108,3927766,3928425,3929080,3929733,3930383,3931029,3931675,3932316,3932956,3933600,3934241,3934878,3935514,3936147,3936803,3937456,3938106,3938753,3939395,3940036,3979905,3979916,3980492,3980504,3981071,3981085,3981647,3981659,3982223,3982234,3982794,3982805,3983362,3983374,3983396,3983936,3983947,3983970,3984504,3984515,3984539,3985069,3985079,3985100,3985628,3985639,3985659,3986186,3986197,3986221,3986752,3986776,3987304,3987323,3987849,3987870,3988417,3988954,3989488,3990019,3990559)) 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





	Pavel Smelkov (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Pavel Smelkov (Conductor)
			

																
Pavel Smelkov (Conductor)

														
				


        




    

        Graduated from the St Petersburg State Rimsky-Korsakov Conservatoire (opera and symphony conducting, class of Professor Musin and M. G. Kukushkin). 
Artistic Director and Conductor of the Baltika youth chamber orchestra since 1999. Composer, author of two string quartets, a piano concerto, a piano sonata, a flute and piano sonata and romances among other works. 

With the Mariinsky Theatre since 2000; over five seasons he has conducted such productions as Eugene Onegin, The Nutcracker, The Legend of the Invisible City of Kitezh and the Maiden Fevronia, Boris Godunov, The Demon, The Enchantress, The Nose and The Gamblers.
        

    

    

            


			

		





	


	

	

		


			

				

					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