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 'Roses*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,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 ('Guns N' Roses*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (80131) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54

Artist

Guns N' Roses

Album

Use Your Illusion I II

Ostatní náhledy

Specifikace / Specification

Nosič: 33" LP

Rok vydání: 1991

původ: Německo

kat. číslo: B1 3360188

Label: Geffen Records - GEF-24415

Žánry / Genres

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

2LP

A1 Right Next Door To Hell
A2 Dust N' Bones
A3 Live And Let Die
A4 Don't Cry (Original)
A5 Perfect Crime
B1 You Ain't The First
B2 Bad Obsession
B3 Back Off Bitch
B4 Double Talkin' Jive
C1 November Rain
C2 The Garden
C3 Garden Of Eden
C4 Don't Damn Me
D1 Bad Apples
D2 Dead Horse
D3 Coma

Koupit

Cena: 5 000 CZK

Cena: 205.3 €

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