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 (590056,591676,593315,595022,596719,598404,600081,601761,603434,605100,606751,608396,610034,611718,613396,615063,616717,618360,619993,621619,623239,624849,626470,628081,629681,631274,632861,634439,636006,637564,639109,640646,642173,643693,645203,646706,648201,649700,651188,652669,654141,655602,877484,880168,882850,885533,888204,890868,893529,896185,898836,901480,904116,906741,909354,911968,914605,917314,920013,922699,925399,928090,930803,933508,936217,938952,941676,944389,947094,949804,952507,955203,957885,960548,963194,965833,968468,971099,973722,976338,978951,981549,984137,986764,989385,992001,994611,997209,999797,1002379,1004959,1007528,1010091,1012643,1015213,1017769,1020316,1022862,1025401,1027936,1030465,1032977,1035472,1037959,1040445,1042923,1045394,1047855,1050306,1052742,1055171,1057597,1060016,1062420,1064818,1067205,1069579,1071946,1074343,1076730,1079106,1081470,1083822,1086160,1088483,1090819,1093145,1095461,1097761,1100045,1102317,1104575,1106812,1109028,1111223,1113400,1115558,1117699,1119834,1121964,1124102,1126297,1128488,1130701,1132897,1135086,1137291,1139492,1892865,1894937,1895009,1897020,1897092,1899155,1899227,1901303,1901375,1903440,1903512,1905568,1905638,1907712,1907783,1909869,1909940,1912018,1912090,1914181,1914251,1916399,1916471,1918606,1918678,1920805,1920877,1923002,1923074,1925208,1925280,1927455,1927525,1929690,1929760,1931910,1931982,1934117,1934187,1936385,1938581,1940766,1942941,1945105,1947260,1949401,1951535,1953665,1955744,1957813,1959870,1961913,1963944,1965970,1967991,2196538,2198065,2199585,2201114,2202662,2204197,2205724,2207249,2208771,2210282,2211781,2213486,2215181,2216866,2218652,2220893,2223125,2225345,2227552,2229748,2231933,2234111,2236520,2239139,2242046,2245219,2248382,2251535,2254680,2257816,2260942,2264060,2267166,2270264,2273374,2276482,2279623,2282757,2285903,2289041,2292171,2295292,2298407,2298850,2301528,2301971,2304655,2305098,2307799,2308242,2310967,2311410,2314130,2314573,2317289,2317732,2320443,2320886,2323591,2324033,2326729,2327171,2329859,2330301,2332970,2333412,2336072,2336514,2339173,2339618,2342269,2342708,2345376,2345815,2348475,2348916,2351571,2352045,2354690,2355164,2357797,2358271,2360899,2361375,2363994,2364470,2367079,2367555,2370153,2370629,2373218,2373694,2376268,2376744,2379306,2379782,2382338,2382814,2385365,2385840,2388380,2388908,2391442,2391971,2394498,2395027,2397541,2398070,2400570,2401099,2403588,2404117,2406602,2407131,2409607,2410136,2412602,2413131,2415589,2416118,2418603,2419132,2421605,2422134,2424596,2425125,2427582,2428111,2430559,2431088,2433527,2434055,2436486,2437012,2439432,2439958,2442367,2442893,2445293,2445820,2448214,2448741,2451124,2451651,2454027,2454544,2456911,2457428,2459790,2460307,2462654,2463171,2465509,2466026,2468386,2468904,2471324,2471842,2474238,2474756,2477181,2477699,2480113,2480631,2483031,2483549,2485939,2486457,2488842,2489388,2491775,2492321,2494699,2495242,2497613,2498156,2500514,2501057,2503402,2503945,2506278,2506821,2509145,2509687,2512006,2512549,2514861,2515406,2517711,2518257,2520554,2521100,2523386,2523932,2526206,2526752,2529565,2532373,2535174,2537969,2540763,2543547,2546320,2549086,2551891,2554687,2557498,2560301,2563090,2565866,2568632,2571463,2574285,2577099,2579908,2582705,2585487,2588258,2591026,2593785,2596536,2599278,2602007,2604723,2607430,2610133,2612827,2615551,2618268,2620975,2623667,2626348,2629029,2631694,2634361,2637007,2639641,2642262,2644871,2647472,2650060,2652639,2655206,2657758,2660292,2662807,2665308,2667795,2670258,2672709,2675140,2677552,2679944,2682320,2684687,2687049,2689404,2691748,2694076,2696449,2699534,2702610,2705686,2708733,2711776,2714807,2717827,2720892,2724000,2727099,2730186,2733285,2736388,2739475,2742552,2745612,2748653,2751682,2754708,2757729,2760750,2763766,2766765,2769749,2772722,2775687,2778676,2781657,2784745,2787831,2790901)) 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





	Ivan Pochekin (Violin soloist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Ivan Pochekin (Violin soloist)

Ivan Pochekin (Violin soloist)

The first prize winner of the 3rd Paganini Violin Competition in Moscow (2005), Ivan Pochekin was born in 1987 in a family of musicians — his father is a famous violin maker and mother is a violin teacher. At the age of 5 he started to play violin and 2 years later gave his first performance with the symphonic orchestra. In 1994 he entered the Moscow Conservatory’s central music school. He also owed his earliest success to his mother who has been helping Ivan with his professional studies for 10 years. From 2001 to 2004 violinist studied at the Moscow Conservatory’s College of Music, and subsequently entered Hochschule for music in Kцln where he studies with Viktor Tretyakov.
In 2002 Ivan performed at the Tchaikovsky Conservatory for the first time, and his interpretation of Violin Concerto No. 2 by Prokofiev created a tremendous sensation. Since then his performed in Russia, Japan, Austria and other European countries with great success.

Ivan is a scholar of some significant funds in Russia, Liechtenstein and Croatia. He participates regularly in international festivals together with many leading chamber and symphonic orchestras including Moscow Philharmonic, Svetlanov Symphonic Orchestra, Zagreb Philharmonic Orchestra, Dubrovnik Symphonic Orchestra (Croatia), Oviedo Philharmonic Orchestra (Spain), German Chamber Orchestra and collaborated with the most known conductors as Friedrich Heider, Eugeny Bushkov, Alexander Skulsky, Sergey Skripka and many others. He appeared in a number of major concert halls such as Moscow State Conservatory, Tchaikovsky Concert Hall in Moscow, Vatroslav Lisinski Concert Hall (Zagreb), Bunka Kaikan (Tokyo), Auditorium (Oviedo) etc.

After winning the Paganini Competition in Moscow, with a support by Russian Violin Art Fund, Ivan released a CD with Paganini and Chausson’s compositions. “Chanson Russe”, his first CD that he recorded for “Philartists” label, included works by Tchaikovsky (Meditation, op.42), Prokofiev (Sonata in D major, op.94bis), Stravinsky (Chanson Russe), Szymanovski (Sonatas, op.9) and Khachaturian (Nocturne and Waltzes from "Masquerade"). Margarita Kravchenko, one of the most striking personalities on the Moscow music scene, accompanies him on the piano. In 2007 the young violinist signed a contract with the worldly famous “Naxos” label for the recordings of all Paganini violin concertos.

Starting from 2008/2009 concert season Ivan Pochekin joined the Moscow Philharmonic Society Artists Management which represents him exclusively in Russia.