nová registrace

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(114): 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 'Pate's Debonairs*' IN BOOLEAN MODE)
																         AND LP.state IN (1' 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 ('Ron 'Pate's Debonairs*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (78669) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54

Artist

Ron 'Pate's Debonairs

Album

Raudelunas Pataphysical Revue

Ostatní náhledy

Specifikace / Specification

Nosič: 33" LP

Rok vydání: 1977

původ: Spojené státy americké

kat. číslo: B1 3358754

Label: Say Day-Bew Records - NR6155

Žánry / Genres

elektronická hudba, jazz, swing, rock

Stav produktu / product state

Stav desky: NM
- jako nová, téměř nehraná

Stav obalu: EX+
- stopy běžného používání

Pozn.: znaménko + nebo - upřesňuje stav desky, obalu

Popis

A1 Introduction
A2 My Kind Of Town (Chicago Is)
A3 Monolgue
A4 Concerto For Active Frogs
A5 The Captains Of Industry
B1 The Lonely Astronauts
B2 The Shemp Howard Story
B3 The Chief Divisions Of The Peoples Of Gaul
B4 Monologue
B5 Volare

A1 Introduction
Voice – Chuck Oggman
A2 My Kind Of Town (Chicago Is)
Alto Saxophone – Johnny Fent-Lister
Bass – Abdul "Ben" Camel
Drums – "Bill" The Kid Dap
Guitar, Saxophone [Alto 'pataphone] – Cyd Cherise
Harp, Percussion – Nips "Napes" Newton
Oboe, Tenor Saxophone, Musette – Dick Foote
Performer – Ron 'Pate's Debonairs
Piano – Omar Bagh-dad-a
Trombone – Bob "Cheapskate" Cashion, Ron 'Pate
Trumpet – Don "Pretty Boy" Smith
Vocals, Featuring, Other [Comic, M. C., Star] – Fred Lane
Written-By – Cahn, Van Heusen
A3 Monolgue
Vocals – Fred Lane
A4 Concerto For Active Frogs
Alto Saxophone – Davey Williams
Oboe, Musette – Roger Hagerty
Other [Species] – Jack Reese
Performer [Chorus] – Frog Chorus
Vocals [Chorus] – Craig Nutt, Janice Hathaway, Johnny Williams (8), LaDonna Smith, Mitchell Cashion, Nolan Hatcher, Theodore Bowen
Vocals [Soloist] – Adrian Dye
Written-By, Percussion, Tape – Anne LeBaron
A5 The Captains Of Industry
Other [Various Appliances] – The Captains Of Industry

B1 The Lonely Astronauts
Alto Saxophone – Johnny Williams
Alto Saxophone, Guitar – Davey Williams
Bass – Theodore Bowen
Cello – Cathy Mehler
Cornet [Coronet] – Nolan Hatcher
Drums – Mark Lanter
Drums [Steel Drum] – Charles Ogden
Harp, Percussion – Anne LeBaron
Performer – The Blue Denim Deals Without The Arms
Piano – Adrian Dye
Soprano Saxophone – Fred McGann
Tenor Saxophone – Roger Hagerty
Trombone, Baritone Saxophone, Horn, Percussion [Gourd] – Craig Nutt
Trumpet, Trombone, Baritone Saxophone, Horn, Percussion [Gourd] – Mitchell Cashion
Viola, Trumpet – LaDonna Smith
B2 The Shemp Howard Story
Vocals, Written-By – Fred Lane
B3 The Chief Divisions Of The Peoples Of Gaul
Cornet [Coronet], Voice [Recitation] – Nolan Hatcher
Cymbal [Cymbals] – Theodore Bowen
Guitar, Written-By – Mitchell Cashion
Harp – Anne LeBaron
Horn [Baritone] – Davey Williams
Lyrics By – Julius Caesar
Musette – Roger Hagerty
Percussion – Mark Lanter
Percussion [Gourd], Voice [Recitation] – Craig Nutt
Viola – LaDonna Smith
B4 Monologue
Vocals, Written-By – Fred Lane
B5 Volare
Alto Saxophone – Johnny Fent-Lister
Bass – Abdul "Ben" Camel
Drums – "Bill" The Kid Dap
Guitar, Saxophone [Alto 'pataphone] – Cyd Cherise
Harp, Percussion – Nips "Napes" Newton
Oboe, Tenor Saxophone, Musette – Dick Foote
Performer – Ron 'Pate's Debonairs
Piano – Omar Bagh-dad-a
Trombone – Bob "Cheapskate" Cashion, Ron 'Pate
Trumpet – Don "Pretty Boy" Smith
Vocals, Featuring, Other [Comic, M. C., Star] – Fred Lane
Written-By – Modugno, Parish

Koupit

Cena: 5 000 CZK

Cena: 206.7 €

Vložit produkt do košíku může pouze registrovaný a přihlášený uživatel.