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(111): 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 Friend*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,' 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 ('Lucifer's Friend*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (91575) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54
																 			 
Detail produktu 

Lucifer's Friend

Lucifer's Friend - 2 Original LP's

 

Nosič: 33" LP
Rok vydání: 1979
původ: Německo
Lbl.: Philips – 6623 132
kat. číslo: B1 3370033

 

rock

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


2LP

Lucifer's Friend
A1  Ride The Sky
A2  Everybody's Clown
A3  Keep Goin'
A4  Toxic Shadows
B1  Free Baby
B2  Baby You're A Liar
B3  In The Time Of Job When Mammon Was A Yippie
B4  Lucifer's Friend
 
Where The Groupies Killed The Blues
C1  Hobo
C2  Rose On The Vine
C3  Mother
D1  ...Where The Groupies Killed The Blues
D2  Prince Of Darkness
D3  Summerdream / Delirium / No Reason Or Rhyme
D4  Burning Ships

 
Cena: 2 000 CZK   (79.8 €)
 

Ostatní náhledy

Lucifer's Friend-Lucifer's Friend - 2 Original LP's Lucifer's Friend-Lucifer's Friend - 2 Original LP's Lucifer's Friend-Lucifer's Friend - 2 Original LP's Lucifer's Friend-Lucifer's Friend - 2 Original LP's Lucifer's Friend-Lucifer's Friend - 2 Original LP's Lucifer's Friend-Lucifer's Friend - 2 Original LP's Lucifer's Friend-Lucifer's Friend - 2 Original LP's