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 '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 (22576) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54
																 			 
Detail produktu 

Guns N' Roses

44 Caliber Horticulture

 

Nosič: 33" LP
Rok vydání: -
původ: -
Lbl.: CLUB 51 Records ‎– L 31121
kat. číslo: PN 3317649

 

rock

Stav desky: M
- nová, nehraná deska


Stav obalu: M
- bezchybný, nový nebo jako nový


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


nehrana,nova
lezela dlouhy roky ve sklade

A1  They’re Out Ta Get Me 
A2  Rocket Queen I 
A3  Rocket Queen II 
A4  Nightrain 
A5  My Michelle 
A6  You’re Crazy 
B1  Paradise City 
B2  Move To The City 
B3  November Rain I 
B4  November Rain II 
B5  Shadow Of Your Love 
B6  Reckless Life 
C1  One In A Million 
C2  I Used To Love Her 
C3  Patience 
C4  Mr. Brownstone 
C5  Move To The City 
D1  It’s So Easy 
D2  Shadows Of Your Love 
D3  Move To The City 
D4  Knockin’ On Heaven’s Door 
D5  Whole Lotta Rosie 
D6  Sweet Child O’ Mine

 
Cena: 4 000 CZK   (159.7 €)
 

Ostatní náhledy

Guns N' Roses-44 Caliber Horticulture Guns N' Roses-44 Caliber Horticulture Guns N' Roses-44 Caliber Horticulture Guns N' Roses-44 Caliber Horticulture Guns N' Roses-44 Caliber Horticulture Guns N' Roses-44 Caliber Horticulture