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 (1434141,1435757,1437392,1439013,1440621,1442223,1443818,1445402,1446975,1448539,1450091,1451631,1453161,1454681,1456203,1457708,1459200,1460679,1462145,1463601,1465047,1466479,1467901,1469310,1470704,1472085,1473453,1474812,1476158,1477509,1478872,1480256,1481628,1482989,1484345,1485689,1487024,1488348,1489654,1490949,1492235,1493549,1494854,1496151,1497449,1498752,1500045,1501328,1502604,1503872,1505133,1506386,1507633,1508870,1510098,1511326,1512551,1513779,1515000,1516223,1517438,1518644,1519847,1521043,1522233,1523418,1524593,1525761,1526922,1528077,1529226,1530371,1531512,1532650,1533782,1534910,1536034,1537153,1538266,1539403,1540533,1541658,1542777,1543888,1544993,1546091,1547176,1548249,1549312,1550367,1551415,1552454,1553495,1554530,1555557,1556575,1557585,1558593,1559591,1560949,1562298,1564141,1565974,1567802,1570724,1573617,1576495,1579368,1582229,1585076,1587914,1590749,1593574,1596431,1599302,1602163,1605010,1607853,1610684,1613514,1616329,1619132,1621922,1624698,1627467,1630226,1632973,1635773,1638600,1641441,1644270,1647084,1649899,1652768,1655623,1658471,1661308,1664131,1666947,1669750,1672606,1675458,1678306,1681145)) 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





	Gidon Kremer (Violin soloist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Gidon Kremer (Violin soloist)

Gidon Kremer (Violin soloist)

Gidon Kremer was born in Riga (Latvia) in 1947, the only child of parents of German origin. After receiving his first musical instruction at home - both father and grandfather were professional violinists - he studied at the Riga School of Music and then at the Moscow Conservatory under David Oistrakh. Kremer enjoyed notable success at competitions in Brussels (1967), Montreal and Genoa (1969), and Moscow (1970). After extended tours through the former Soviet Union, he began appearing with increasing frequency in the West: his first concert in Germany came in 1975, followed by debuts at the Salzburg Festival (1976) and in New York (1977). Gidon Kremer was also one of the artistic directors of the music festival "Art Projekt ‘92" in Munich.

The international chamber music festival in Lockenhaus (Austria), founded by Gidon Kremer in 1981, has been a forum for young artists to present challenging and innovative chamber music concerts - programmes which are also taken on tour. In 1992 the festival in Lockenhaus was named "KREMERata MUSICA". In 1996 Gidon Kremer founded the KREMERata BALTICA chamber orchestra to foster outstanding young musicians from the three Baltic states. He undertakes regular concert tours with this orchestra. Gidon Kremer is also Director of the Musiksommer Gstaad (Switzerland).

Gidon Kremer‘s repertoire ranges from the Baroque to works by Henze and Stockhausen. Composers of the former Soviet Union such as Schnittke, Pдrt, Gubaidulina and Denisov have been introduced to Western audiences largely through Kremer‘s efforts. Martha Argerich, Valery Afanassiev, Oleg Maisenberg and Vadim Sakharov are his favorite musical partners. Gidon Kremer plays a Guarneri del Gesщ - ex David - dating from 1730.

Since 1978 Gidon Kremer has recorded for Deutsche Grammophon, and he signed his first exclusive contract with the Yellow Label in 1987.