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 (1915702,1917914,1920115,1922314,1924507,1926755,1928997,1931227,1933439,1935638,1937834,1940023,1942202,1944373,1946534,1948683,1950819,1952951,1955073,1957149,1959213,1961268,1963305,1965328,1967349,1969368,1971379,1973390,1975386,1977373,1979343,1981342,1983334,1985318,1987296,1989266,1991221,1993160,1995098,1997027,1998948,2000862,2002765,2004657,2006531,2008417,2010302,2012179,2014043,2015883,2017716,2019520,2021327,2023128,2024923,2026914,2028904,2030883,2032848,2034807,2036763,2038709,2040647,2042573,2044482,2046381,2048269,2050153,2052025,2053888,2055839,2057880,2059913,2061940,2063960,2065970,2067971,2069975,2071968)) 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





	Thomas Trotter (Organist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Thomas Trotter (Organist)

Thomas Trotter (Organist)

Thomas Trotter is one of Britain’s most widely admired musicians. The excellence of his musicianship is reflected internationally in his musical partnerships. He performs as soloist with, amongst many others, the conductors Sir Simon Rattle, Bernard Haitink, Riccardo Chailly and Sir Charles Mackerras. He has performed recitals in Berlin’s “Philharmonie”, the “Gewandhaus” in Leipzig, both the “Musikverein” and the “Konzerthaus” in Vienna and London’s Royal Festival Hall. He has played inaugural concerts in places such as Princeton University Chapel USA, the “Concertgebouw” in Amsterdam, the Royal Albert Hall, and Moscow's International Performing Arts Centre. He appears at major Festivals such as Salzburg, Edinburgh and London’s BBC Proms, and he performs with leading orchestras such as the Vienna, Berlin and London Philharmonic. In May 2002 he was the recipient of the Royal Philharmonic Society award for Best Instrumentalist, the first organist ever to win this award.

Thomas Trotter was appointed Birmingham City Organist in 1983 in succession to Sir George Thalben-Ball, and he is also Organist at St Margaret’s Church, Westminster Abbey and Visiting Fellow in Organ Studies at the Royal Northern College of Music. Earlier in his career he was organ scholar at King’s College, Cambridge, winning the First Prize at the St Albans International Organ Competition in his final year. He received an Honorary Doctorate from Birmingham City University in 2003 and from Birmingham University in 2006.

Alongside his weekly recitals in Birmingham, Thomas Trotter regularly performs throughout the USA and Europe. He is an active recording artist and several of his recordings have been named “Critics Choice” by The Gramophone magazine. This season he will play two of the opening concerts on the restored organ at Auckland Town Hall New Zealand, as well as inaugurating the new organ at Llandaff Cathedral. Other engagements include concerts in Europe, Russia, South Korea and Australia.