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 's And The Papa's*' IN BOOLEAN MODE)
																         AND LP.state IN (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 ('Mama's And The Papa's*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (53172) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54
																 			 
Artist

Mama's And The Papa's

Album

If You Can Believe Your Eyes And Ears

Ostatní náhledy
Specifikace / Specification
Nosič: 33" LP
Rok vydání: 1966
původ: Spojené státy americké
kat. číslo: VT 3337496
Label: Dunhill ‎– DS-50006
Žánry / Genres
folk, ethno, trampské, rock
Stav produktu / product state
Stav desky: EX
- hraná deska, běžné stopy používání (drobné škrábance a šum nebránící normálnímu poslechu)
Stav obalu: EX
- stopy běžného používání

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

Popis

A1  Monday, Monday
A2  Straight Shooter 
A3  Got A Feelin'
A4  I Call Your Name
A5  Do You Wanna Dance
A6  Go Where You Wanna Go 
B1  California Dreamin'
B2  Spanish Harlem
B3  Somebody Groovy 
B4  Hey Girl
B5  You Baby
B6  In Crowd

Koupit
Cena: 800 CZK
Cena: 33.0 €
Vložit produkt do košíku může pouze registrovaný a přihlášený uživatel.