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 (2107188,2109127,2111056,2112973,2114879,2116778,2118670,2120552,2122422,2124281,2126130,2127964,2129794,2131615,2133431,2135232,2137022,2138864,2140703,2142532,2144350,2146157,2147954,2149743,2151517,2153280,2155033,2156777,2158509,2160269,2162014,2163750,2165473,2167181,2168877,2176634,2178238,2179836,2181419,2182983,2184535,2186081,2187629,2196816,2198345,2199861,2649975,2649983,2652554,2652562,2655121,2655129,2657673,2657681,2660207,2660215,2662722,2662730,2665223,2665231,2667710,2667718,2670173,2670181,2672624,2672632,2675055,2675063,2677467,2677475,2679859,2679867,2682235,2682243,2684602,2684610,2686964,2686972,2689319,2689327,2691663,2691671,2693991,2693999,2696335,2696345,2699419,2699430,2702489,2702500,2705565,2705576,2708612,2708623,2711655,2711666,2714686,2714697,2717706,2717717,2720771,2720782,2723879,2723890,2726978,2726989,2730065,2730076,2733175,2736278,3096755,3096765,3098336,3098346,3099913,3099923,3101479,3101489,3103030,3103040,3104572,3104582,3106109,3106120,3107669,3109244)) 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





	David Hallberg (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters David Hallberg (Dancer)

David Hallberg (Dancer)

Born in Rapid City, South Dakota, David Hallberg began jazz and tap classes at the age of ten. He began his formal ballet training at 13 with Kee Juan Han at the Arizona Ballet School in Phoenix where he studied intensively for four years. In 1999, he was accepted into the Paris Opera Ballet School where he continued his studies under the direction of Claude Bessy, Jacques Namont and Gilbert Meyer.

Hallberg attended American Ballet Theatre’s New York Summer Intensive in 1999 and 2000 and was an ABT National Training Scholar for both of those years.

Hallberg joined ABT’s Studio Company (now ABT II) in September 2000 and then joined American Ballet Theatre as a member of the corps de ballet in April 2001, was promoted to Soloist in January 2004 and Principal in May 2005. His roles with the Company include the Boy in Afternoon of a Faun, the title role in Apollo, Solor in La Bayadиre, Prince Charming in Cinderella, Conrad in Le Corsaire, Basilio and Espada in Don Quixote, Oberon in The Dream, the second sailor in Fancy Free, Albrecht in Giselle, Death in The Green Table, the Cavalier in The Nutcracker, Othello in Othello, Other Dances, A Friend of the Family in Pillar of Fire, Bernard and Jean de Brienne in Raymonda, Romeo, Paris and Benvolio in Romeo and Juliet, , Romeo in Romeo and Juliet (Romeo’s Farewell to Juliet), Prince Dйsirй in The Sleeping Beauty, Prince Siegfried, von Rothbart (Act III) and Benno in Swan Lake, James in La Sylphide, Aminta in Sylvia, the first movement in George Balanchine’s Symphony in C, the Tchaikovsky Pas de Deux, and leading roles in Ballet Imperial, Ballo della Regina, Clear, Drink To Me With Thine Eyes, From Here On Out, Glow - Stop, Gong, Kaleidoscope, In The Upper Room, Meadow, Petite Mort, Pretty Good Year, Seven Sonatas, Sinfonietta, Les Sylphides, Symphonic Variations, Theme and Variations and Within You Without You: A Tribute to George Harrisonand featured roles in Clear, Overgrown Path and workwithinwork. He created the title role in Robert Hill’s Dorian, Olga's Fiancй in On the Dnieper and leading roles in Citizen and Rabbit and Rogue.

Hallberg was a recipient of the Princess Grace Fellowship and the Chris Hellman Dance Award for 2002-2003. He received a nomination for the Benois de la Danse Award in 2006. Hallberg has guested and danced in galas throughout the world from Japan to the Bolshoi Theatre in Moscow, to name a few.