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 (1434154,1435770,1437405,1439026,1440634,1442236,1443831,1445415,1446988,1448552,1450104,1451644,1453174,1454694,1456213,1457718,1459210,1460689,1462155,1463611,1465057,1466489,1467911,1469320,1470714,1472095,1473463,1474822,1476168,1477519,1478884,1480268,1481640,1483001,1484357,1485701,1487036,1488360,1489666,1490961,1492247,1493561,1494866,1496163,1497460,1498763,1500056,1501339,1502615,1503883,1505144,1506397,1507644,1508881,1510109,1511337,1512562,1513790,1515011,1516234,1517449,1518655,1519858,1521054,1522244,1523427,1524602,1525770,1526931,1528086,1529235,1530380,1531521,1532657,1533789,1534917,1536041,1537160,1538273,1539410,1540540,1541665,1542784,1543895,1545000,1546098,1547183,1548256,1549319,1550376,1551424,1552463,1553504,1554539,1555566,1556584,1557594,1558602,1559600,1560958,1562307,1564150,1565983,1567808,1570728,1573623,1576504,1579376,1582238,1585085,1587923,1590758,1593583,1596440,1599311,1602170,1605019,1607860,1610693,1613518,1616337,1619141,1621932,1624707,1627476,1630233,1632980,1635781,1638609,1641450,1644276,1647090,1649903,1652772,1655632,1658480,1661317,1664140,1666954,1669759,1672617,1675469,1678316,1681152,1683980,1686797,1689651)) 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





	Anastasiya Sidelnikova (Organist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Anastasiya Sidelnikova (Organist)

Anastasiya Sidelnikova (Organist)

Anastasiya Sidelnikova has ended the Moscow state conservatory it. Tchaikovsky on specialities "piano" (a class of professor L.Naumov) and "body", and also postgraduate study at professor L.Rojzmana and the senior lecturer B.Romanov. Passed training on the master-classes of leading European teachers: H.Fagiusa (Denmark, Sweden), H.Fogelja (Germany), Z.Gijju (France), J.Laukvika (Norway) and others. The student of the All-Russia competition of organists, International organ festivals in Kaliningrad and Luebeck (Germany). In 1994 at the International festival in a of Calgary (Canada) has noted been as one of the best among organists of young generation. Concert activity has begun in student‘s years. Went on tour across Russia, the countries of near and far abroad much. Acts with solo concerts and in ensembles with known Russian musicians instrumentalists, vocalists. Has prepared many interesting programs (" Bach and German of romanticism ", " Bach and its contemporaries ", " Bach and organ music of Scandinavia ", etc.), fruitfully works on expansion of repertoir, executing not only music of a baroque, but also product of the most various epoch and styles. Took part in author‘s evenings of modern domestic composers. Is a member of the Russian association " New organ movement ". Has records on compact discs of music of I.S.Baha, N.Brunsa and the father - known native the composer and teacher N.N.Sidelnikova. Soloist the Moscow Academic philarmonic society.