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 (210409,210410,210411,210414,210418,211975,211976,211977,211980,211984,213508,213509,213510,213513,213517,215046,215047,215048,215051,215055,216579,216580,216581,216584,216588,218110,218111,218112,218115,218119,219635,219636,219637,219640,219644,221156,221157,221158,221161,221165,222672,222673,222675,222679,222684,224184,224185,224187,224191,224196,225692,225693,225695,225699,225704,227200,227201,227203,227207,227212,228703,228704,228706,228710,228715,230200,230201,230203,230207,230211,232195,232197,232201,232206,232211,234189,234191,234195,234200,234205,236177,236179,236183,236188,236193,238157,238159,238163,238168,238173,240127,240129,240133,240138,240143,242090,242092,242095,242099,242106,244050,244052,244055,244059,244064,246008,246010,246013,246017,246023,247958,247960,247963,247967,247972,249904,249906,249909,249913,249918,251847,251848,251852,251856,251860,253827,253828,253833,253838,253841,255799,255800,255804,255810,255813,257763,257764,257768,257774,257778,259734,259735,259739,259745,259749,261699,261700,261704,261710,261714,263657,263658,263662,263666,263670,265621,265622,265626,265630,265634,267577,267578,267582,267586,267590,269524,269525,269529,269535,269538,271464,271465,271469,271475,271478,273402,273403,273407,273413,273416,275339,275340,275344,275348,275352,277269,277270,277274,277280,277283,279174,279176,279179,279183,279188,281047,281049,281052,281056,281061,282912,282914,282917,282921,282926,284772,284773,284778,284783,284787,286626,286628,286631,286635,286640,288478,288479,288484,288489,288493,290319,290321,290324,290328,290333,292220,292222,292225,292229,292234,294114,294116,294119,294123,294128,296001,296003,296006,296010,296015,297881,297882,297887,297892,297896,299756,299757,299762,299767,299771,301650,301652,301655,301659,301664,303538,303540,303543,303547,303552,305469,305471,305474,305478,305483,307399,307401,307404,307408,307413,309322,309324,309327,309331,309336,311240,311242,311245,311249,311254,313154,313156,313159,313163,313168,315063,315065,315067,315071,315076,316964,316967,316969,316973,316978,318858,318861,318863,318867,318872,320742,320745,320747,320751,320756,322618,322621,322623,322627,322632,324487,324489,324492,324496,324501,326391,326393,326396,326400,326405,328295,328297,328300,328304,328309,330191,330193,330196,330200,330205,332082,332084,332087,332091,332096,333963,333966,333968,333972,333977,335834,335837,335839,335843,335848,337699,337702,337704,337708,337713,339579,339581,339584,339588,339593,341507,341509,341512,341516,341521,343431,343433,343437,343442,343446,345351,345354,345357,345362,345366,347270,347274,347276,347282,347287,349172,349174,349177,349181,349186,351058,351061,351063,351068,351074,352936,352939,352941,352946,352952,354812,354815,354818,354822,354828,356692,356695,356698,356702,356707,358566,358569,358572,358577,358581,358859,358863,358866,358869,360469,360472,360475,360480,360484,360757,360761,360766,360769,360772,362366,362369,362372,362377,362381,362654,362658,362663,362666,362669,364254,364256,364259,364263,364268,364541,364545,364549,364553,364556,366136,366139,366143,366148,366149,366422,366426,366430,366434,366437,368014,368017,368020,368025,368029,368303,368308,368312,368315,368318,369891,369894,369898,369903,370177,370181,370185,370189,370192,371765,371766,371771,372045,372049,372053,372057,372060,373626,373632,373906,373909,373914,373917,373921,375482,375756,375759,375763,375767,375770,377597,377600,377604,377608,377611,379431,379434,379438,379442,379445,381262,381265,381269,381273,381276,383087,383090,383094,383098,383101,384906,384909,384913,384917,384920,386718,386721,386725,386729,386732,388534,388537,388541,388545,388548,390342,390345,390349,390353,390356,392143,392146,392150,392154,392157,393942,393945,393949,393953,393956,395737,395740,395744,395748,395751,397526,397529,397533,397537,397540,399311,399315,399319,399322,399325,401082,401086,401090,401094,401097,402847,402851,402855,402859,402862,404607,404611,404615,404618,404622,406361,406365,406369,406373,406377,408112,408116,408120,408124,408128,409856,409860,409864,409868,409872,411597,411601,411606,411609,411612,413360,413363,413368,413371,413374,415111,415114,415118,415122,415125,416853,416856,416860,416864,416867,418594,418597,418601,418605,418608,420330,420333,420337,420341,420344,422061,422064,422069,422072,422077,423790,423793,423798,423802,423806,425512,425516,425520,425524,425528,427220,427224,427228,427232,427236,428917,428922,428926,428930,428933,430610,430615,430619,430623,430626,432317,432322,432326,432330,432333,434022,434026,434030,434035,434038,435717,435721,435725,435730,435733,437405,437409,437413,437418,437421,439080,439084,439088,439094,439097,440744,440748,440752,440757,440760,442395,442399,442403,442408,442411,444033,444037,444041,444046,444049,445661,445665,445669,445674,445677,447283,447287,447291,447296,447299,448892,448897,448900,448905,448908,450490,450494,450497,450502,450506,452081,452085,452088,452093,452097,453671,453675,453678,453683,453687,455257,455261,455264,455268,455273,456835,456839,456842,456847,456851,458407,458411,458414,458419,458423,459971,459975,459978,459983,459987,461526,461530,461533,461538,461542,463074,463078,463081,463086,463090,464626,464630,464633,464638,464642,466173,466177,466180,466185,466189,467711,467715,467719,467724,467727,469416,469420,469424,469429,469432,471133,471137,471140,471145,471149,472682,472686,472690,472694,472698,474223,474227,474231,474237,474240,475803,475807,475811,475817,475820,477383,477387,477391,477395,477399,478954,478958,478962,478966,478970,480521,480525,480529,480534,480537,481275,481279,481284,481288,481292,482018,482022,482026,482031,482034,482755,482759,482763,482768,482771,483490,483494,483498,483503,483506,484236,484240,484244,484249,484252,484985,484989,484993,484998,485001,485728,485732,485736,485741,485744,486457,486461,486465,486469,486474,487178,487182,487187,487192,487195,487893,487897,487901,487906,487909,488605,488609,488613,488618,488621,489317,489321,489325,489330,489333,490024,490028,490032,490037,490040,490724,490728,490732,490737,490740,491419,491423,491427,491432,491435,492103,492107,492112,492117,492120,492786,492790,492794,492800,492803,493468,493472,493476,493482,493485,494144,494148,494152,494157,494160,494814,494818,494822,494827,494830,495475,495479,495483,495488,495491,496124,496128,496132,496137,496140,496762,496767,496770,496775,496778,498232,498237,498240,498245,498248,499695,499699,499702,499707,499711,501150,501154,501157,501162,501166,502599,502603,502607,502611,502615,504082,504086,504090,504095,504098,505558,505562,505566,505570,505574,507030,507034,507038,507043,507046,508502,508506,508510,508515,508518,509968,509972,509977,509982,509985,511428,511432,511436,511441,511444,512880,512884,512888,512892,512896,514360,514364,514368,514373,514376,515830,515834,515838,515843,515846,517291,517295,517299,517304,517307,518742,518747,518750,518755,518758,520188,520189,520193,520197,520201,521627,521632,521635,521640,521643,523063,523064,523068,523072,523076,524488,524489,524493,524497,524501,525902,525907,525910,525915,525919,527310,527314,527317,527322,527326,528716,528720,528723,528728,528732,530119,530123,530126,530132,530136,531517,531521,531524,531530,531534,532907,532911,532915,532920,532924,534345,534349,534353,534357,534362,535776,535780,535784,535790,535794,537202,537206,537211,537216,537220,538630,538634,538639,538644,538648,540055,540060,540065,540068,541471,541475,541480,542927,542931,544408,1012880,1012884,1012889,1012894,1015447,1015451,1015455,1015460,1018006,1018010,1018015,1018020,1020553,1020557,1020562,1020567,1023096,1023100,1023104,1023109,1025638,1025642,1025647,1025652,1028173,1028177,1028182,1028187,1030703,1030707,1030708,1030713,1033214,1033218,1033223,1033228,1035709,1035713,1035718,1035723,1038200,1038204,1038209,1038210,1040686,1040690,1040695,1040696,1043166,1043170,1043175,1043180,1045637,1045641,1045646,1045650,1048098,1048102,1048107,1048112,1050549,1050553,1050558,1050563,1052984,1052989,1052994,1052997,1055413,1055417,1055422,1055427,1057839,1057843,1057848,1057853,1060248,1060253,1060258,1060264,1062652,1062657,1062661,1062667,1065050,1065055,1065060,1065066,1067435,1067440,1067444,1067450,1069812,1069817,1069822,1069828,1072178,1072183,1072187,1072193,1074575,1074579,1074583,1074588,1076962,1076967,1076972,1076978,1079338,1079343,1079348,1079354,1081703,1081707,1081713,1081718,1084055,1084060,1084065,1084071,1086393,1086398,1086403,1086409,1088716,1088721,1088726,1088731,1091050,1091055,1091060,1091066,1093377,1093382,1093387,1093393,1095692,1095697,1095702,1095708,1097992,1097997,1098002,1098008,1100274,1100278,1100282,1100290,1102546,1102551,1102556,1102562,1104804,1104810,1104814,1104821,1107042,1107047,1107052,1107057,1109258,1109262,1109267,1109273,1111453,1111457,1111463,1111469,1113629,1113632,1113638,1113645,1115786,1115789,1115795,1115800,1117929,1117933,1117939,1117945,1120063,1120067,1120073,1120079,1122198,1122202,1122209,1122214,1124336,1124340,1124347,1124352,1126531,1126535,1126542,1126547,1128754,1128760,1128767,1128774,1130968,1130973,1130980,1130987,1133164,1133168,1133176,1133183,1135352,1135358,1135366,1135372,1137556,1137562,1137569,1137576,1139762,1139767,1139774,1139783,1141952,1141958,1141965,1141970,1144142,1144148,1144154,1144164,1146315,1146321,1146329,1146335,1148479,1148485,1148493,1148499,1150633,1150639,1150647,1150653,1152784,1152790,1152798,1152804,1154932,1154936,1154943,1154951,1157066,1157072,1157079,1157085,1159239,1159244,1159251,1159260,1161394,1161399,1161406,1161415,1163530,1163536,1163544,1163550,1165666,1165671,1165678,1165687,1167799,1167805,1167813,1167819,1169933,1169938,1169945,1169954,1172054,1172060,1172067,1172074,1174166,1174172,1174180,1174186,1176312,1176318,1176326,1176332,1178447,1178453,1178461,1178467,1180575,1180581,1180589,1180595,1182694,1182700,1182708,1182714,1184804,1184810,1184818,1184824,1186916,1186922,1186927,1186937,1189022,1189028,1189033,1189043,1191121,1191127,1191132,1191141,1193209,1193215,1193220,1193230,1195289,1195295,1195299,1195309,1197365,1197371,1197376,1197386,1199429,1199435,1199443,1199449,1201490,1201496,1201504,1201510,1203545,1203552,1203556,1203567,1205593,1205599,1205607,1205613,1207630,1207636,1207644,1207650,1209659,1209665,1209673,1209679,1211699,1211707,1211712,1211721,1213729,1213735,1213743,1213749,1215751,1215757,1215765,1215771,1217760,1217766,1217774,1217780,1219754,1219760,1219768,1219774,1221737,1221743,1221751,1221757,1223713,1223719,1223727,1223733,1225684,1225690,1225698,1225704,1227677,1227683,1227691,1227697,1229691,1229697,1229705,1229711,1231703,1231707,1231715,1231723,1233697,1233703,1233711,1233717,1235685,1235691,1235698,1235704,1237665,1237671,1237679,1237685,1239633,1239639,1239647,1239653,1241589,1241595,1241603,1241609,1243572,1243578,1243586,1243592,1245549,1245553,1245560,1245567,1247508,1247513,1247519,1247529,1249490,1249496,1249504,1249510,1251468,1251474,1251482,1251488,1253449,1253455,1253463,1253469,1255426,1255431,1255439,1255445,1257393,1257399,1257407,1257413,1259353,1259359,1259367,1259373,1261300,1261306,1261314,1261320,1263234,1263240,1263248,1263254,1265159,1265165,1265173,1265179,1267089,1267095,1267103,1267109,1269015,1269023,1269029,1270932,1270938,1272836,1483003,1483007,1483010,1483014,1483019,1484359,1484363,1484366,1484370,1484375,1485703,1485707,1485710,1485714,1485719,1487038,1487042,1487045,1487049,1487054,1488362,1488366,1488369,1488373,1488378,1489668,1489672,1489675,1489679,1489684,1490963,1490967,1490970,1490974,1490979,1492249,1492253,1492256,1492260,1492265,1493563,1493567,1493570,1493574,1493579,1494868,1494872,1494875,1494879,1494884,1496165,1496169,1496172,1496176,1496181,1497462,1497466,1497469,1497473,1497479,1498765,1498769,1498772,1498776,1498782,1500058,1500062,1500065,1500069,1500075,1501341,1501345,1501348,1501352,1501358,1502617,1502621,1502624,1502628,1502634,1503885,1503889,1503892,1503896,1503902,1505146,1505150,1505153,1505157,1505163,1506399,1506403,1506406,1506410,1506416,1507646,1507650,1507653,1507657,1507663,1508883,1508887,1508890,1508894,1508900,1510111,1510115,1510118,1510122,1510128,1511339,1511343,1511346,1511351,1511357,1512564,1512568,1512571,1512576,1512582,1513792,1513796,1513799,1513804,1513810,1515013,1515017,1515020,1515025,1515031,1516236,1516240,1516243,1516248,1516254,1517451,1517455,1517458,1517463,1517469,1518657,1518661,1518664,1518669,1518675,1519860,1519864,1519867,1519872,1519878,1521056,1521060,1521063,1521068,1521074,1522246,1522250,1522253,1522258,1522264,1523428,1523432,1523435,1523441,1523447,1524603,1524607,1524610,1524616,1524622,1525771,1525775,1525778,1525784,1525790,1526932,1526936,1526939,1526945,1526951,1528087,1528091,1528094,1528100,1528106,1529236,1529240,1529243,1529249,1529255,1530381,1530385,1530388,1530394,1530400,1531522,1531526,1531529,1531535,1531541,1532658,1532662,1532667,1532672,1532674,1533790,1533794,1533799,1533804,1533806,1534918,1534922,1534927,1534932,1534934,1536042,1536046,1536051,1536056,1536058,1537161,1537165,1537170,1537175,1537177,1538274,1538278,1538283,1538288,1538290,1539411,1539415,1539420,1539425,1539427,1540541,1540545,1540550,1540555,1540557,1541666,1541670,1541675,1541680,1541682,1542785,1542789,1542794,1542799,1542801,1543896,1543900,1543905,1543910,1543912,1545001,1545005,1545010,1545015,1545017,1546099,1546103,1546108,1546113,1546115,1547184,1547188,1547193,1547198,1547200,1548257,1548261,1548266,1548271,1548273,1549320,1549324,1549329,1549334,1549336,1550377,1550381,1550384,1550390,1550396,1551425,1551429,1551432,1551438,1551444,1552464,1552468,1552471,1552477,1552483,1553505,1553509,1553512,1553518,1553524,1554540,1554544,1554547,1554553,1554559,1555567,1555571,1555574,1555580,1555586,1556585,1556589,1556592,1556598,1556604,1557595,1557599,1557602,1557608,1557614,1558603,1558607,1558610,1558616,1558622,1559601,1559605,1559608,1559614,1559620,1560959,1560963,1560966,1560972,1560978,1562308,1562312,1562315,1562321,1562327,1564151,1564155,1564158,1564164,1564170,1565984,1565988,1565991,1565997,1566003,1567809,1567813,1567817,1567819,1567824,1570729,1570733,1570738,1570744,1570748,1573621,1573626,1573630,1573637,1573640,1576505,1576509,1576512,1576518,1576524,1579378,1579382,1579387,1579392,1579397,1582239,1582243,1582246,1582252,1582258,1585086,1585090,1585093,1585099,1585105,1587925,1587929,1587934,1587939,1587943,1590759,1590763,1590766,1590772,1590778,1593584,1593588,1593591,1593597,1593603,1596441,1596445,1596448,1596454,1596460,1599312,1599316,1599319,1599325,1599331,1602172,1602176,1602181,1602186,1602190,1605020,1605024,1605027,1605033,1605039,1607859,1607863,1607868,1607871,1607877,1610695,1610699,1610704,1610709,1610713,1613520,1613524,1613529,1613533,1613539,1616336,1616339,1616344,1616348,1616354,1619142,1619146,1619149,1619155,1619161,1621931,1621934,1621939,1621943,1621948,1624708,1624712,1624715,1624721,1624727,1627477,1627481,1627484,1627490,1627496,1630234,1630238,1630242,1630248,1630253,1632981,1632985,1632989,1632994,1633000,1635782,1635785,1635789,1635794,1635799,1638610,1638614,1638617,1638623,1638629,1641451,1641455,1641458,1641464,1641470,1644277,1644282,1644287,1644292,1644297,1647092,1647096,1647101,1647106,1647111,1649904,1649907,1649911,1649917,1649921,1652773,1652776,1652780,1652786,1652790,1655633,1655637,1655640,1655646,1655652,1658481,1658485,1658488,1658494,1658500,1661318,1661322,1661325,1661331,1661337,1664141,1664145,1664148,1664154,1664160,1666952,1666955,1666959,1666964,1666969,1669760,1669764,1669767,1669773,1669779,1672619,1672623,1672626,1672632,1672638,1675471,1675475,1675478,1675484,1675490,1678315,1678320,1678324,1678330,1678334,1681155,1681159,1681164,1681169,1681174,1683982,1683986,1683991,1683992,1683997,1686799,1686803,1686806,1686812,1686818,1689653,1689658,1689663,1689667,1689673,1692512,1692515,1692521,1692527,1695282,1695289,1695292,1698048,1698054,1700807,1799101,1799106,1799112,1799119,1799122,1799124,1801562,1801569,1801575,1801580,1801583,1801585,1804007,1804014,1804020,1804025,1804028,1804030,1806432,1806439,1806445,1806450,1806453,1806455,1808843,1808849,1808853,1808858,1808862,1808865,1811234,1811238,1811243,1811248,1811252,1811256,1813596,1813603,1813609,1813614,1813617,1813619,1815945,1815952,1815958,1815963,1815966,1815968,1818277,1818284,1818290,1818295,1818298,1818300,1820586,1820593,1820599,1820604,1820607,1820609,1822867,1822874,1822880,1822885,1822888,1822890,1825123,1825130,1825136,1825141,1825144,1825146,1827356,1827363,1827369,1827374,1827377,1827379,1829568,1829572,1829577,1829585,1829588,1829591,1831760,1831767,1831773,1831778,1831781,1831783,1833946,1833953,1833959,1833964,1833967,1833969,1836143,1836149,1836154,1836159,1836162,1836163,1838333,1838336,1838342,1838348,1838352,1838354,1840513,1840516,1840522,1840528,1840532,1840534,1842672,1842676,1842682,1842688,1842692,1842694,1844820,1844824,1844830,1844834,1844837,1844839,1846972,1846979,1846985,1846989,1846992,1846993,1849126,1849133,1849136,1849142,1849145,1849147,1851275,1851282,1851285,1851291,1851294,1851296,1853417,1853424,1853430,1853434,1853437,1853438,1855555,1855563,1855570,1855574,1855577,1855578,1857688,1857696,1857703,1857707,1857710,1857711,1859810,1859816,1859822,1859829,1859832,1859834,1861926,1861934,1861941,1861945,1861948,1861949,1864040,1864046,1864052,1864058,1864062,1864064,1866148,1866157,1866163,1866165,1866167,1866168,1868238,1868247,1868253,1868255,1868257,1868258,1870327,1870332,1870337,1870339,1870341,1870344,1872396,1872405,1872411,1872413,1872415,1872416,1874461,1874467,1874472,1874474,1874476,1874479,1876515,1876521,1876526,1876528,1876530,1876533,1878563,1878572,1878578,1878580,1878582,1878583,1880636,1880645,1880651,1880653,1880655,1880656,1882700,1882709,1882715,1882717,1882719,1882720,1884755,1884764,1884770,1884772,1884774,1884775,1886836,1886841,1886846,1886848,1886850,1886853,1888899,1888905,1888911,1888913,1888915,1888918,1890959,1890965,1890971,1890973,1890975,1890978,1893035,1893044,1893050,1893052,1893054,1893055,1895125,1895134,1895140,1895142,1895144,1895145,1897233,1897241,1897249,1897252,1897255,1897256,1899380,1899389,1899398,1899404,1899408,1899410,1901528,1901537,1901546,1901552,1901556,1901558,1903665,1903674,1903683,1903689,1903693,1903695,1905794,1905801,1905809,1905818,1905821,1905825,1907942,1907950,1907957,1907961,1907965,1907969,1910098,1910106,1910115,1910118,1910121,1910126,1912243,1912252,1912261,1912267,1912271,1912273,1914408,1914415,1914423,1914431,1914434,1914439,1916624,1916633,1916642,1916648,1916652,1916654,1918835,1918843,1918852,1918856,1918859,1918864,1921030,1921039,1921048,1921054,1921058,1921060,1923227,1923236,1923245,1923251,1923255,1923257,1925433,1925442,1925451,1925457,1925461,1925463,1927680,1927686,1927696,1927705,1927707,1927712,1929915,1929921,1929930,1929939,1929941,1929945,1932135,1932144,1932153,1932159,1932163,1932165,1934347,1934356,1934364,1934367,1934371,1934375,1936545,1936554,1936562,1936565,1936566,1936570,1938734,1938743,1938752,1938758,1938762,1938764,1940919,1940928,1940937,1940943,1940947,1940949,1943094,1943103,1943112,1943118,1943122,1943124,1945258,1945267,1945276,1945282,1945286,1945288,1947417,1947425,1947434,1947438,1947441,1947446,1949558,1949565,1949574,1949579,1949582,1949587,1951692,1951699,1951708,1951713,1951716,1951721,1953818,1953827,1953836,1953842,1953846,1953848,1955897,1955906,1955915,1955921,1955925,1955927,1957966,1957975,1957984,1957990,1957994,1957996,1960027,1960037,1960044,1960048,1960052,1960056,1962070,1962080,1962087,1962091,1962095,1962099,1964103,1964112,1964120,1964123,1964127,1964131,1966128,1966137,1966145,1966147,1966149,1966153,1968145,1968151,1968159,1968168,1968170,1968174,1970163,1970172,1970180,1970183,1970187,1970191,1972176,1972185,1972193,1972196,1972200,1972204,1974178,1974187,1974196,1974198,1974200,1974204,1976171,1976180,1976189,1976192,1976196,1976200,1978150,1978159,1978168,1978171,1978175,1978179,1980120,1980129,1980137,1980140,1980144,1980148,1982114,1982118,1982127,1982135,1982137,1982141,1984105,1984114,1984122,1984125,1984129,1984133,1986088,1986097,1986105,1986108,1986112,1986116,1988058,1988067,1988075,1988078,1988082,1988086,1990019,1990028,1990036,1990039,1990043,1990047,1991967,1991976,1991984,1991987,1991991,1991995,1993906,1993915,1993923,1993926,1993930,1993934,1995836,1995841,1995850,1995858,1995861,1995866,1997766,1997775,1997783,1997786,1997790,1997794,1999685,1999694,1999702,1999705,1999709,1999713,2001594,2001603,2001611,2001614,2001618,2001622,2003490,2003499,2003507,2003510,2003514,2003518,2005373,2005382,2005390,2005393,2005397,2005401,2007245,2007251,2007261,2007267,2007270,2007274,2009131,2009140,2009148,2009151,2009155,2009159,2011009,2011015,2011025,2011031,2011034,2011038,2012879,2012885,2012894,2012903,2012906,2012909,2014729,2014738,2014746,2014749,2014753,2014757,2016561,2016570,2016578,2016581,2016585,2016589,2018379,2018388,2018396,2018399,2018403,2018407,2020189,2020198,2020206,2020209,2020210,2020214,2021994,2022002,2022011,2022014,2022018,2022019,2023791,2023800,2023808,2023811,2023815,2023819,2025789,2025798,2025806,2025809,2025813,2025817,2027784,2027793,2027801,2027804,2027808,2027812,2029767,2029774,2029784,2029789,2029793,2029797,2031739,2031746,2031756,2031761,2031765,2031769,2033701,2033708,2033718,2033723,2033727,2033731,2035660,2035667,2035677,2035682,2035686,2035690,2037610,2037617,2037627,2037632,2037636,2037640,2039553,2039560,2039570,2039575,2039579,2039583,2041496,2041504,2041507,2041511,2041515,2043418,2043424,2043428,2043430,2045328,2045332,2045334,2047224,2047228,2047230,2049114,2049118,2050996,2205544,2205549,2205555,2205561,2207067,2207072,2207078,2207083,2208589,2208594,2208600,2208605,2210100,2210105,2210111,2210116,2211599,2211604,2211610,2211615,2213306,2213311,2213317,2213323,2215001,2215006,2215012,2215018,2216686,2216691,2216697,2216703,2218472,2218477,2218483,2218489,2220713,2220718,2220724,2220730,2222945,2222950,2222956,2222962,2225168,2225173,2225179,2225185,2227375,2227380,2227386,2227392,2229571,2229576,2229582,2229588,2231756,2231761,2231767,2231773,2233934,2233939,2233945,2233951,2236345,2236350,2236356,2236362,2238964,2238969,2238975,2238981,2241869,2241874,2241879,2241884,2245043,2245048,2245054,2245060,2248206,2248211,2248217,2248223,2251359,2251364,2251370,2251376,2254504,2254509,2254515,2254521,2257640,2257645,2257651,2257657,2260766,2260771,2260777,2260783,2263883,2263888,2263894,2263900,2266989,2266994,2267000,2267006,2270087,2270092,2270098,2270104,2273188,2273193,2273199,2273207,2276297,2276302,2276308,2276316,2279438,2279443,2279449,2279457,2282572,2282577,2282583,2282591,2285718,2285723,2285729,2285737,2288856,2288861,2288867,2288875,2291986,2291991,2291997,2292005,2295107,2295112,2295118,2295126,2298224,2298229,2298235,2298243,2301345,2301350,2301356,2301364,2304472,2304477,2304483,2304491,2307616,2307621,2307627,2307635,2310784,2310789,2310795,2310803,2313947,2313952,2313958,2313966,2317106,2317111,2317117,2317125,2320260,2320265,2320271,2320279,2323409,2323414,2323420,2323428,2326547,2326552,2326558,2326566,2329677,2329682,2329688,2329696,2332788,2332793,2332799,2332807,2335890,2335895,2335901,2335909,2338986,2338991,2338997,2339005,2342082,2342087,2342093,2342101,2345189,2345194,2345200,2345208,2348288,2348293,2348299,2348307,2351384,2351389,2351395,2351403,2354503,2354508,2354514,2354522,2357610,2357615,2357621,2357629,2360711,2360716,2360722,2360730,2363806,2363811,2363817,2363825,2366891,2366896,2366902,2366910,2369965,2369970,2369976,2369984,2373030,2373035,2373041,2373049,2376080,2376085,2376091,2376099,2379118,2379123,2379129,2379137,2382150,2382155,2382161,2382169,2385177,2385182,2385188,2385196,2388192,2388197,2388203,2388211,2391265,2391273,2394321,2394329,2397364,2397372,2400393,2400401,2403411,2403419,2489398,2489402,2489410,2492331,2492335,2492343,2495253,2495258,2495267,2498167,2498172,2498181,2501068,2501073,2501082,2503956,2503961,2503970,2506832,2506837,2506846,2509698,2509703,2509712,2512560,2512565,2512574,2515417,2515422,2515431,2518268,2518273,2518282,2521111,2521116,2521125,2523943,2523948,2523957,2526763,2526768,2526777,2529576,2529581,2529590,2532384,2532389,2532398,2535185,2535190,2535199,2537980,2537985,2537994,2540774,2540779,2540788,2543558,2543563,2543572,2546331,2546336,2546345,2549097,2549102,2549111,2551902,2551907,2551916,2554698,2554703,2554712,2557509,2557514,2557523,2560312,2560317,2560326,2563101,2563106,2563115,2565875,2565879,2565887,2568641,2568645,2568653,2571474,2571479,2571488,2574296,2574301,2574310,2577110,2577115,2577124,2579919,2579924,2579933,2582716,2582721,2582730,2585498,2585503,2585512,2588269,2588274,2588283,2591037,2591042,2591051,2593796,2593801,2593810,2596547,2596552,2596561,2599289,2599294,2599303,2602018,2602023,2602032,2604734,2604739,2604748,2607438,2607441,2607446,2607455,2610141,2610144,2610149,2610158,2612835,2612838,2612843,2612852,2615559,2615562,2615567,2615576,2618276,2618279,2618284,2618293,2620983,2620986,2620991,2621000,2623675,2623678,2623683,2623692,2626356,2626359,2626364,2626373,2629037,2629040,2629045,2629054,2631702,2631705,2631710,2631719,2634369,2634372,2634377,2634386,2637015,2637018,2637023,2637032,2639649,2639652,2639657,2639666,2642270,2642273,2642278,2642287,2644879,2644882,2644887,2644896,2647480,2647483,2647488,2647497,2650068,2650071,2650076,2650085,2652647,2652650,2652655,2652664,2655214,2655217,2655222,2655231,2657766,2657769,2657774,2657783,2660300,2660303,2660308,2660317,2662815,2662818,2662823,2662832,2665316,2665319,2665324,2665333,2667803,2667806,2667811,2667820,2670266,2670269,2670274,2670283,2672717,2672720,2672725,2672734,2675148,2675151,2675156,2675165,2677560,2677563,2677568,2677577,2679952,2679955,2679960,2679969,2682328,2682331,2682336,2682345,2684695,2684698,2684703,2684712,2687057,2687060,2687065,2687074,2689412,2689415,2689420,2689428,2691756,2691759,2691764,2691772,2694084,2694087,2694092,2694100,2696457,2696461,2696468,2696479,2699542,2699546,2699553,2699564,2702618,2702622,2702629,2702640,2705694,2705698,2705706,2705717,2708741,2708745,2708753,2708764,2711784,2711788,2711796,2711807,2714815,2714819,2714827,2714838,2717835,2717839,2717847,2717858,2720900,2720904,2720912,2720923,2724008,2724012,2724020,2724031,2727107,2727111,2727119,2727130,2730194,2730198,2730206,2730217,2733293,2733297,2733305,2733316,2736396,2736400,2736408,2736419,2739483,2739487,2739495,2739506,2742560,2742564,2742572,2742583,2745620,2745624,2745632,2745643,2748661,2748665,2748673,2748684,2751690,2751694,2751702,2751713,2754716,2754720,2754728,2754739,2757737,2757741,2757749,2757760,2760758,2760762,2760770,2760781,2763774,2763778,2763786,2763797,2766773,2766777,2766785,2766796,2769757,2769761,2769769,2769780,2772730,2772734,2772742,2772753,2775695,2775699,2775707,2775718,2778684,2778688,2778696,2778707,2781665,2781669,2781677,2781688,2784753,2784757,2784765,2784776,2787839,2787843,2787851,2787862,2790909,2790913,2790921,2790932,2793967,2793971,2793979,2793990,2797042,2797046,2797054,2797065,2800108,2800116,2800127,2803171,2803182,2806156)) 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





	Giacomo Sagripanti (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Giacomo Sagripanti (Conductor)
			

																
Giacomo Sagripanti (Conductor)

														
				


        




    

        After successfully completing his studies in piano and composition, 
he was selected and admitted to “Scuola dell’Opera Italiana” 
of Teatro Comunale di Bologna, a specialized opera center where 
he could study professional opera conducting and lyric vocality. 
He participated in several master classes, studying under the 
following and receiving unanimous appreciation of his talent: Bruno 
Bartoletti, Donato Renzetti, Gianandrea Noseda, Renato Palumbo, Riccardo Frizza, 
Nicola Luisotti, Piero Bellugi, Colin Metters, Jorma Panula, Vladimir Ponkin, 
Dejan Pavlov, Tamas Pаl and Eythan Pessen. 

Despite his youth, 
he has already developed a wide range of symphonic activity, 
conducting numerous orchestras, both in Italy and abroad. These include 
Fondazione del Teatro Verdi di Trieste, Fondazione Teatro Comunale 
di Bologna, Fondazione Teatro Carlo Felice di Genova, Fondazione 
Toscanini di Parma, Fondazione del Teatro di San Carlo di Napoli, 
Philharmonische Orchester der Hansestadt Lьbeck, RTV Symphony Orchestra 
Ljubljana, Filarmonica Marchigiana, Orchestra Internazionale d’Italia, Orchestra 
Rossini di Pesaro, Orchestra Sinfonica Pescarese, Orchestra Sinfonica del 
Teatro F. Cilea di Reggio Calabria, Orchestra 1813, Moscow Symphony 
Orchestra, the RNCM Northern College of Manchester Orchestra, Orchestra 
Sinfonica Nazionale della RAI and Filarmonica del Teatro La Fenice 
di Venezia. In January 2013 he made his American debut conducting 
La Cenerentola with Seattle Opera Orchestra. 

He conducted 
Stabat Mater by G. B. Pergolesi during the Pergolesi’s 
celebrations of Teatro San Carlo di Napoli, and Gianni di Parigi 
by G. Donizetti at the XXXVI Festival della Valle d’Itria 
di Martina Franca, with unanimous acclaim both from critics and audiences. 


In September 2010 he appeared at Festival Pergolesi 
in Jesi, where he conducted the first Italian performance 
of Pergolesi’s Servante Maitresse, directed by J. Deschamps, 
receiving excellent reviews from national critics. 

His Cenerentola 
by G. Rossini in Circuito Lirico Lombardo and at Fondazione 
Toscanini of Piacenza impressed many and elicited unanimous praise from the 
most important national magazines (“L’Opera” and “Classic Voice”). 


In June 2011 he conducted La Traviata in Cagliari 
and Madama Butterfly at Carlo Felice in Genoa. In April 
2011 he received outstanding reviews from the public and critics for his 
performance of Mozart’s Requiemwith Orchestra del Teatro Filarmonico 
di Verona. He also made his official debut in Germany conducting 
Boito’s Mefistofele in Lьbeck, with enthusiastic reviews by two 
of the most important German magazines, Die Welt and Orpheus. In the 
same Theater he conducted Carmen and Hansel und Gretel. 

His 
performance at the opening of Festival Valle d’Itria in 2011 was 
widely acclaimed and his Rossini’sAureliano in Palmira (with Franco Fagioli 
in the role of Arsaces) drew unanimous applause from the major Italian 
critics as did the Gianni di Parigi he conducted at Wexford 
Festival (October 2011). 

Most recently, he conducted Cenerentola 
in Paris (Palais Garnier), and in Seattle Opera House (making his USA 
debut), Elisir d’amore in Verona, Madama Butterfly in Venezia 
La Fenice, La Traviata in Limoges and in Reims; a cycle 
of symphonic concerts in Tel Aviv, at Teatro Filarmonico 
in Verona and with Orchestra Sinfonica della RAI; Zaira (by Bellini) 
in Martina Franca, La Forza del Destino in Essen, I Puritani 
in Jesi, Cenerentola at Dresden Semperoper, La Bohиme 
in Bolzano.         

    

    

            


			

		





	


	

	

		


			

				

					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