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 (590064,590446,590763,591684,592067,592384,593321,593706,594026,595029,595412,595730,596726,597109,597427,598409,598795,599115,600088,600471,600789,601766,602152,602472,603441,603824,604142,605101,605486,605807,606758,607141,607459,608403,608786,609104,610041,610424,610754,611725,612108,612438,613402,613785,614115,615069,615452,615782,616725,617107,617439,618366,618749,619079,619999,620382,620712,621627,622009,622341,623245,623628,623958,624855,625242,625587,626476,626863,627208,628087,628474,628819,629687,630074,630419,631280,631667,632012,632867,633254,633599,634445,634832,635177,636012,636399,636744,637570,637957,638302,639114,639502,639849,640652,641039,641384,642178,642565,642908,643699,644084,644424,645210,645594,645938,646712,647099,647439,648207,648594,648934,649706,650093,650433,651194,651581,651921,652675,653062,653402,654147,654534,654874,655608,655995,656335,657059,657446,657786,658901,659241,660342,660684,661776,662116,663200,663540,664617,664957,666027,666367,667465,667807,668896,669236,670337,670677,671769,672109,673193,673533,674604,674944,676006,676346,677399,677737,678778,679151,680179,680552,681571,681944,682953,683326,684325,684698,685683,686050,687023,687390,688331,688697,689630,689996,690916,691282,692192,692558,693457,693825,694714,695080,695953,696319,697179,697545,698392,698758,699594,699960,700788,701154,701975,702354,703167,703546,704348,704727,705518,705891,706668,707041,707807,708180,708935,709307,710053,710460,711201,711608,712339,712752,713470,713885,714592,715005,715701,716114,716799,717212,717887,718300,718965,719378,720031,720444,721086,721499,722144,722557,723206,723619,724258,724671,725301,725714,726334,726747,727359,727773,728376,728790,729383,729797,730383,730797,731375,731789,732362,732776,733356,733770,734343,734757,735322,735736,736289,736703,737261,737675,738225,738639,739183,739598,740132,740545,742100,742513,744073,744486,746038,746451,747999,748439,749981,750421,751963,752403,754842,755282,757715,758155,760581,761022,763443,763884,766302,766743,769156,769596,772002,772442,774842,775281,777677,778118,780508,780954,783341,783785,786173,786619,788999,789443,791821,792265,794640,795070,797449,797879,800254,800684,803053,803485,805850,806281,808638,809070,811419,811853,814198,814632,816972,817406,819743,820172,822932,825682,828428,831169,833908,836642,839368,842093,844813,847552,850285,853014,855746,858471,861191,863903,866604,869294,871979,874672,877344,880028,882708,885391,888065,890726,893386,896044,898697,901338,903981,906604,909220,911829,912404,914466,915041,917172,917750,919877,920450,922563,923136,925263,925836,927955,928553,930668,931267,933376,933975,936084,936684,938802,939418,941526,942142,944238,944855,946943,947562,949658,950270,952357,952973,955057,955669,957734,958354,960404,961015,963051,963659,965687,966299,968321,968934,970953,971565,973576,974188,976190,976804,978800,979417,981398,982016,983987,984604,986614,987232,989236,989854,991856,992468,994460,995082,997058,997681,999655,1000269,1002237,1002851,1004814,1005428,1007383,1007999,1009947,1010564,1012498,1013147,1015071,1015719,1017624,1018273,1020171,1020820,1022719,1023368,1025255,1025905,1027790,1028440,1030318,1030972,1032828,1033481,1035323,1035976,1037811,1038468,1040296,1040954,1042774,1043433,1045243,1045904,1047703,1048365,1050154,1050815,1052589,1053251,1055021,1055681,1057447,1058107,1059866,1060520,1062267,1062924,1064668,1065322,1067053,1067709,1069433,1070086,1071794,1072488,1074192,1074886,1076580,1077271,1078956,1079647,1081317,1082012,1083667,1084364,1086005,1086702,1088337,1089025,1090669,1091359,1093685,1096001,1098302,1100587,1102859,1105117,1107353,1109569,1111764,1113941,1116099,1118242,1120376,1122518,1124656,1126851,1129077,1131290,1133486,1135693,1137898,1140100,1142293,1144481,1146657,1148821,1150975,1153126,1155271,1157447,1159616,1161770,1163910,1166042,1168179,1170309,1172431,1174546,1176692,1178827,1180955,1183074,1185184,1187298,1189405,1191504,1193592,1195671,1197746,1199817,1201878,1203939,1205990,1208027,1210070,1212111,1214142,1216164,1218173,1220167,1222150,1224126,1226097,1228090,1230107,1232116,1234113,1236096,1238077,1240045,1242020,1244003,1245976,1247938,1249921,1251899,1253880,1255853,1257824,1259784,1261731,1263665,1265590,1267520,1269440,1271349,1273247,1275131,1276998,1278860,1280714,1282556,1284390,1286214,1288025,1289819,1291604,1293415,1295217,1297012,1298798,1300569,1302325,1304077,1305825,1307565,1309295,1311016,1312935,1314860,1316794,1318721,1320640,1322549,1324451,1326338,1328207,1330067,1331954,1333831,1335698,1337554,1339399,1341229,1343046,1344855,1346662,1348459,1350249,1352154,1354046,1355927,1357798,1359659,1361511,1363354,1365186,1367005,1368814,1370618,1372411,1374191,1376051,1377894,1379723,1381541,1383357,1385165,1386969,1388763,1390543,1392312,1394072,1395850,1397616,1399373,1399784,1401125,1401538,1402867,1403280,1404600,1405013,1406323,1406736,1408044,1408456,1409768,1410193,1411495,1411920,1413245,1413689,1415005,1415449,1416755,1417197,1418490,1418934,1420217,1420661,1421934,1422378,1423637,1424081,1425326,1425770,1427000,1427444,1428664,1429108,1430314,1430758,1432398,1434029,1435645,1437252,1438873,1440481,1442083,1443677,1445261,1446834,1448398,1449950,1451490,1453020,1454540,1454848,1456057,1456360,1457559,1457865,1459051,1459359,1460530,1460838,1461996,1462304,1463452,1463760,1464898,1465206,1466330,1466638,1467752,1468060,1469161,1469469,1470555,1470863,1471936,1472244,1473304,1473612,1474663,1474971,1476009,1476317,1477360,1477668,1478708,1479045,1480092,1480429,1481464,1481801,1482825,1483163,1484181,1484519,1485525,1485863,1486860,1487198,1488184,1488522,1489490,1489828,1490785,1491123,1492071,1492409,1493385,1493723,1494690,1495028,1495987,1496325,1497282,1497623,1498585,1498926,1499878,1500219,1501161,1501502,1502437,1502778,1503705,1504046,1504966,1505307,1506219,1506560,1507466,1507807,1508703,1509044,1509931,1510272,1511153,1511505,1512378,1512730,1513606,1513959,1514827,1515180,1516050,1516403,1517265,1517618,1518471,1518824,1519670,1520027,1520866,1521223,1522056,1522413,1523239,1523595,1524414,1524770,1525582,1525938,1526743,1527099,1527898,1528254,1529047,1529403,1530192,1530548,1531333,1531689,1532470,1532825,1533602,1533957,1534730,1535085,1535854,1536209,1536973,1537328,1538086,1538460,1539223,1539597,1540353,1540728,1541478,1541853,1542597,1542972,1543708,1544083,1544813,1545188,1545911,1546285,1546996,1547370,1548069,1548443,1549132,1549506,1550188,1550560,1551236,1551608,1552275,1552647,1553316,1553690,1554351,1554727,1555378,1555754,1556396,1556772,1557406,1557784,1558414,1558792,1559412,1559790,1560770,1561148,1562119,1562497,1563962,1564340,1565795,1566173,1567623,1567996,1570544,1570916,1573437,1573809,1576693,1579566,1582427,1585274,1588113,1590947,1593772,1596641,1599512,1602375,1605220,1608064,1610898,1613722,1616541,1619342,1622136,1624908,1627677,1630434,1633180,1635984,1638810,1641651,1644476,1647291,1650105,1652973,1655834,1658682,1661519,1664342,1667156,1669961,1672820,1675672,1678521,1681360,1684183,1687013,1689866,1692722,1695494,1698249,1701002,1703746,1706482,1709253,1712017,1714801,1717576,1720338,1723091,1725826,1728561,1731287,1733995,1736694,1739382,1742056,1744720,1747378,1750027,1752669,1755302,1757925,1760535,1763141,1765738,1768331,1770916,1773492,1776066,1778625,1781174,1783716,1786248,1788753,1791247,1793723,1796180,1798625,2199782,2201311,2202859,2204394,2205923,2207447,2208969,2210480,2211979,2213685,2215380,2217065,2218851,2221092,2223324,2225544,2227751,2229947,2232132,2234310,2236720,2239339,2242252,2245419,2248582,2251735,2254880,2258016,2261142,2264259,2267365,2270463,2273573,2273661,2276718,2276810,2279859,2279951,2282993,2283085,2283146,2286139,2286231,2286292,2289277,2289369,2289430,2292407,2292499,2292560,2295528,2295620,2295681,2298643,2298735,2298796,2301764,2301856,2301917,2304891,2304983,2305044,2308035,2308127,2308188,2311203,2311295,2311356,2314366,2314458,2314519,2317525,2317617,2317678,2320679,2320771,2320832,2323826,2323918,2323979,2326964,2327056,2327117,2330094,2330186,2330247,2333205,2333297,2333358,2336307,2336399,2336460,2339411,2339503,2339564,2342501,2342593,2342654,2345608,2345700,2345761,2348708,2348801,2348862,2351833,2351930,2351991,2354952,2355049,2355110,2358059,2358156,2358217,2361162,2361260,2361321,2364257,2364355,2364416,2367342,2367440,2367501,2370416,2370514,2370575,2373481,2373579,2373640,2376531,2376629,2376690,2379569,2379667,2379728,2382601,2382699,2382760,2385627,2385725,2385786,2388649,2388762,2388848,2391709,2391823,2391911,2394765,2394879,2394967,2397808,2397922,2398010,2400837,2400951,2401039,2403855,2403969,2404057,2406869,2406983,2407071,2409874,2409988,2410076,2412869,2412983,2413071,2415856,2415970,2416058,2418870,2418984,2419072,2421872,2421986,2422074,2424863,2424977,2425065,2427849,2427963,2428051,2430826,2430940,2431028,2433793,2433907,2433995,2436750,2436864,2436952,2439696,2439810,2439898,2442633,2442743,2442834,2445559,2445669,2445761,2448480,2448590,2448682,2451390,2451500,2451592,2454294,2454391,2454483,2457178,2457275,2457367,2460057,2460154,2460246,2462921,2463018,2463110,2465776,2465873,2465965,2468654,2468751,2468843,2471592,2471689,2471781,2474506,2474603,2474695,2477449,2477546,2477638,2480381,2480478,2480570,2483299,2483396,2483488,2486207,2486304,2486396,2489110,2489207,2489299,2492043,2492140,2492232,2494967,2495064,2495156,2497881,2497978,2498070,2500782,2500879,2500971,2503670,2503767,2503859,2506546,2506643,2506735,2509412,2509509,2509601,2512273,2512370,2512463,2515128,2515225,2515320,2517978,2518075,2518171,2520821,2520918,2521014,2523653,2523750,2523846,2526473,2526570,2526666,2529286,2529383,2529479,2532094,2532191,2532287,2534895,2534992,2535088,2537689,2537786,2537883,2540483,2540580,2540677,2543267,2543364,2543461,2546040,2546137,2546234,2548806,2548903,2549000,2551611,2551708,2551805,2554407,2554504,2554601,2557218,2557315,2557412,2560021,2560118,2560215,2562810,2562907,2563004,2565576,2565679,2565779,2568342,2568445,2568545,2571182,2571279,2571377,2574004,2574101,2574199,2576818,2576915,2577013,2579620,2579724,2579822,2582417,2582521,2582619,2585199,2585303,2585401,2587970,2588074,2588172,2590738,2590842,2590940,2593497,2593601,2593699,2596248,2596352,2596450,2598990,2599094,2599192,2601719,2601823,2601921,2604435,2604539,2604637,2607142,2607246,2607344,2609845,2609949,2610047,2612539,2612643,2612741,2615263,2615367,2615465,2617980,2618084,2618182,2620687,2620791,2620889,2623379,2623483,2623581,2626060,2626164,2626262,2628741,2628845,2628943,2631406,2631510,2631608,2634073,2634177,2634275,2636719,2636823,2636921,2639353,2639457,2639555,2641974,2642078,2642176,2644583,2644687,2644785,2647184,2647288,2647386,2649772,2649876,2649974,2652351,2652455,2652553,2654918,2655022,2655120,2657574,2657672,2660108,2660206,2662623,2662721,2665124,2665222,2667611,2667709,2670074,2670172,2672525,2672623,2674956,2675054,2677368,2677466,2679858,2682234,2684601,2686963,2689318,2691662,2693990,2696334,2699417,2702487,2705563,2708610,2711653,2714684,2717704,2720769,2723877,2726976)) 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
Nikolai Lugansky (Piano) - uVisitRussia
One of the brightest pianists of our time, Nikolai luganskiy was borne in 1972 in Moscow in the family of scientific workers. Initial musical formation was obtained in the central musical school (teacher t.E.Kestner), and then in the Moscow state conservatory of the name Of p.I.Chaykovskogo and the graduate study, where its teachers were T.P.Nikolayeva and S.L.Dorenskiy.
N.Luganskiy - conqueror OF THE I All-Union competition of young musicians in Tbilisi (1988), the laureate OF THE VIII international competition of the name Of i.S.Bakha in Leipzig (II reward, 1988), the All-Union competition of the name Of s.V.Rakhmaninova in Moscow (II reward, 1990), the possessor of the special reward to the international summer academy Mozarteum (Salzburg, 1992), the conqueror X of the international competition of the name Of p.I.Chaykovskogo in Moscow (1994) and the possessor of the special prize of the fund For e.Neizvestnogo "for ispovedal‘nost‘ of tone and artistic contribution to the new interpretation of Russian music - to student and Uchitelyu".
In 1995 N.Luganskiy was rewarded with the reward to the name of Judd‘s Terensa as the most promising pianist of young generation. In 2003 it obtained the prize of German criticism for the record of Rakhmaninoff‘s concerts, in the same year the newspaper "musical review" named Luganskogo the best soloist of season 2001-2002. In 200shchg. the pianist was rewarded with the prestige German reward Echo klassik for "better performance of instrument concert" (sound-recording firm Warner Classics).
The concert activity of pianist began as early as his school years. It much came out in the capital and other cities of Russia. In 1988 took place Nikolai luganskiy‘s debut abroad, when it came out on the concerts of the international festival MIDEM in Kannakh. Since then the artist gave many solo concerts and appearances with the orchestras more than in 150 cities of peace.
Nikolai luganskiy appears in the most prestige halls of the peace: Large hall of Moscow conservatory and Petersburg philharmonic society, Theatre du Chatelet, London Royal Festival Hall, Barbican Centre, and Wigmore Hall, Concertgebouw in Amsterdam, Hoolliwood Boul in Los Angeles, Gasteig in Munich, A.lte Of or.er in Frankfurt, halls of France, Switzerland, Greece, Spain, USA, South Korea, Japan, Belgium and other countries.
He collaborates with the most important symphonic orchestras (Orchestre De Paris, Royal Concertgebouw, Philharmonia, Halle Orchestra, Dresdner Philharmonic, Tokyo Symphonic, Netherlands Philharmonic, Rotterdam Philharmonic, San Francisco Symphony).
It played with such renowned conductors as Ye.Svetlanov, G.Rozhdestvenskiy, V.Gergiyev, V.Fedoseyev, M.Pletnev, Yu.Simonov, V.Spivakov, V.Sinayskiy, S.Sondetskis, I.Shpiller, F.Bryuggen, G.Dzhenkins, G.Shelli, K.Mazur, R.Shayi, K.Nagano, M.Yanovski, P.Berglund, N.Yarvi, sir ch.Makkerras, L.Slatkin, Yu.Temirkanov, 3. de vaart, E.Krivin, etc.
Pianist is well known as excellent it ansamblist and the thin interpreter of chamber music. His repertoire includes more than 40 concerts for fortepiano with the orchestra, the work of different styles and epochs - from Bach to contemporary kompozitorov.
N.Luganskiy wrote down three long-playing plates and 17 CDS (in Russia, Japan, Holland), which received appreciation in the musical press. The records of pianist, released on Warner -Classics, several times were favored reward Golden Diapason. In 2004 are released the disks with the works of Prokofiev and Rakhmaninoff - composers, especially dear pianistom.
Besides the saturated theatrical- concert activity the musician teaches in the Moscow conservatory, being the assistant of professor s.L.Dorenskogo.
Sign in to our website using your Facebook or Google+ account.
Why Do You Need Our Travel Expert
Contact our experts, and they will help you to plan your best trip to Russia, with attention to every detail!
Our Experts have been in the travel industry for many years, guarantee to offer first class customer service, excellent value for money and unbiased advice. They are standing by to find and build your dream holiday to one of the world's most fascinating destinations - Russia. Your personal Travel Expert will guide you through each stage of the travel process, from choosing a program that fits you best to support during your trip.
Just tell us your e-mail, and we'll take care of everything!
Your tour request has been received. Thank you ! We have sent you the confirmation message to [email]
Please make sure that you receive this message (sometimes e-mail messages may go to the spam/junk mail). If you did not get this message, it means you will not get message with the tours' selection as well. If you use a Yahoo!, Gmail, AOL or Hotmail, we recommend to add request@uvisitrussia.comto your address book.
We recommend to leave your phone number. If we will not heard back that you received the e-mail with the tours' selection, we will contact you by phone. And you will not miss the best tour for you.
Thank you ! Your request for Travel Expert assistance has been sent. We will e-mail you within 1 hour.
Sorry, some changes needed
Add your E-mail
There was a problem with your request
Missing contact person. Please correct and try again.