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
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Nikolai Lugansky (Piano)

Nikolai Lugansky (Piano)

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.