Email   Heslo 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(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 College Cambridge, The, London Symphony Orchestra, The, Hervey Alan Directed B' 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 ('Choir Of King's College Cambridge, The, London Symphony Orchestra, The, Hervey Alan Directed By David Willcocks*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (14314) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54
																 			 
Detail produktu 

Choir Of King's College Cambridge, The, London Symphony Orchestra, The, Hervey Alan Directed By David Willcocks

On Christmas Night

 

Nosič: 33" LP
Rok vydání: 1962
původ: Velká Británie
Lbl.: Argo Records ‎– RG 5333
kat. číslo: MC 3311261

 

vánoční muzika, koledy


- obal a deska výborný stav

 
Cena: 400 CZK   (16.2 €)
 

Ostatní náhledy

Choir Of King's College Cambridge, The, London Symphony Orchestra, The, Hervey Alan Directed By David Willcocks-On Christmas Night Choir Of King's College Cambridge, The, London Symphony Orchestra, The, Hervey Alan Directed By David Willcocks-On Christmas Night Choir Of King's College Cambridge, The, London Symphony Orchestra, The, Hervey Alan Directed By David Willcocks-On Christmas Night