An exception was thrown :
Exception code : 0
Exception message :
#0 /data/web/virtuals/38425/virtual/www/inc/mysql.class.php(173): mysql->error('SELECT LP.*,CAT...',...)
#1 /data/web/virtuals/38425/virtual/www/inc/lp.class.php(62): mysql->query('SELECT LP.*,CAT...',...)
#2 /data/web/virtuals/38425/virtual/www/templates/vinyl-detail.tpl(78): LP->getLP('SELECT LP.*,CAT...',...)
#3 /data/web/virtuals/38425/virtual/www/inc/phptemplate.class.php(81): require_once('/data/web/virtu...')
#4 /data/web/virtuals/38425/virtual/www/inc/phptemplate.class.php(138): PHPTemplate->fetch('templates/vinyl...')
#5 /data/web/virtuals/38425/virtual/www/index.php(105): PHPTemplate->load('content',...)
#6 {main}

error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Band with whistling by Billy Murray & Margaret McKee / Shellac / Šelak / 78rp' at line 10 

query: SELECT LP.*,CAT.name_cz as catname, CNT.name_cz as countryname, CNT.code as countrycode, GROUP_CONCAT(GEN.name_cz ORDER BY GEN.name_cz SEPARATOR ', ') as genres, 
																		         COALESCE((SELECT IM.name FROM lpimage AS IM WHERE IM.position='1' AND IM.idlp=LP.id),0) as mainimg, USR.inicials,
																						 DATE_FORMAT(LP.dt_insert,'%Y') as year_insert, DATE_FORMAT(LP.dt_insert,'%m') as month  
	    																	FROM lp AS LP
																				JOIN user USR ON USR.id = LP.iduser 
																				JOIN country CNT ON CNT.id = LP.idcountry
																				JOIN category CAT ON CAT.id = LP.idcategory
									      								JOIN vz_lp_genre VZLG ON VZLG.idlp = LP.id
																				JOIN genre GEN ON GEN.id = VZLG.idgenre 	    																	
																 WHERE MATCH(groupname) AGAINST ('Arthur Pryor's Band with whistling by Billy Murray & Margaret McKee / Shellac / Šelak / 78rpm records*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (10378) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54

Detail produktu

Arthur Pryor's Band with whistling by Billy Murray & Margaret McKee / Shellac / Šelak / 78rpm records

The Whistler And Hit Dog / The Warbler's Serenade

Nosič: 78" LP - šelak
Rok vydání: 1925
původ: Česká republika
kat. číslo: PN 7800187

nezařazeno

This article is about the American bandleader. For the Australian physicist, see A. W. Pryor.
Arthur Pryor ca. 1900

Arthur Willard Pryor (September 22, 1870 – June 18, 1942) was a trombone virtuoso, bandleader, and soloist with the Sousa Band. He was a prolific composer of band music, his best known composition being "The Whistler and His Dog".[1] In later life, he was an American Democratic Party politician from New Jersey, who served on the Monmouth County, New Jersey Board of Chosen Freeholders during the 1930s.

Pryor was born on the second floor of the Lyceum Theater in Saint Joseph, Missouri. He first took up music at a very young age and was playing the valve trombone by age 11. By age 15 he had mastered the slide trombone and was awarded a spot in his father's band. He was hailed as a prodigy after this. Shifted to another band, Pryor went on to direct the Stanley Opera Company in Denver, Colorado until joining the John Philip Sousa Band in 1892. He played his first solo with the Sousa Band at age 22 during the World's Columbian Exposition in Chicago in 1893. During his 12 years with the Sousa Band, Pryor estimated that he played 10,000 solos. From 1895 to 1903 Pryor was assistant conductor of the Sousa Band. After leaving the Sousa Band, he formed his own band, which made its debut at the Majestic Theatre in New York City on November 15, 1903. The Pryor Band toured until 1909, when he decided to settle down and make Asbury Park, New Jersey the home of the band. Also at this time he became a staff conductor and arranger for the Victor Talking Machine Company in Camden, New Jersey.

He set to work on an opera titled Peter and Paul, with a libretto by L. Frank Baum, though the whereabouts of libretto or score are unknown. It was intended to star Fred Stone and David Montgomery in several roles in several time periods.[2]

He retired from full-time conducting in 1933. On November 7 of that year, he and Henry W. Herbert were elected to the Monmouth County Board of Chosen Freeholders, defeating Director Bryant B. Newcomb and his running mate, Arthur Johnson.[3] Pryor and Herbert would each serve one, three year term in office. They were defeated by Republicans J. Russell Woolley and Edgar O. Murphy.[4]

He was elected an honorary member of the Beta Tau chapter of Phi Mu Alpha Sinfonia at the University of Miami in 1940.

During his career, Pryor wrote some of today's most famous trombone literature, including an arrangement of the heralded "Bluebells of Scotland", as well as band novelty works such as "The Whistler and His Dog", with its piccolo solo, his best known composition.[1] Much of this literature has been recorded by Ian Bousfield on his CD Pryor Engagement (Doyen DOY CD212).

In 1985, thousands of early Pryor scores were discovered by conductor Rick Benjamin who has played many of Pryor's compositions with his Paragon Ragtime Orchestra.[5]

Pryor was married to Maud Russell Pryor and their son Roger Pryor (1901 – 1974) was also a bandleader as well as a film actor.

sbírka

Ostatní náhledy