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 Cathedral On 29th July 1981*' IN BOOLEAN MODE)
																         AND L' at line 10 

query: SELECT LP.*,CAT.name_en as catname, CNT.name_en as countryname, CNT.code as countrycode, GROUP_CONCAT(GEN.name_en ORDER BY GEN.name_en 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 ('The BBC Recording From St. Paul's Cathedral On 29th July 1981*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (38744) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54
																 			 

Product detail 

The BBC Recording From St. Paul's Cathedral On 29th July 1981

The Royal Wedding Of H.R.H. The Prince Of Wales And The Lady Diana Spencer

 

Type: 33" LP
Year: 1981
Origin: Great Britain
Lbl.: BBC Records ‎– REP 413
cat. no: RL 3326765

 

classical music, opera, spoken word

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

 

Price: 500 CZK   (20.0 €)

 

Other images