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 Sing-Along Chorus*' IN BOOLEAN MODE)
																         AND LP.state IN' 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 ('Larry Groce And The Disneyland Children's Sing-Along Chorus*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (44312) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54
																 			 

Detail produktu 

Larry Groce And The Disneyland Children's Sing-Along Chorus

Disney's Children's Favorites Volume I

 

Nosič: 33" LP
Rok vydání: 1979
původ: Spojené státy americké
Lbl.: Disneyland ‎– 2505
kat. číslo: TL 3330592

 

pohádky, pro děti

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

A1 The Old Man
A2 I've Been Working On The Railroad
A3 Three Blind Mice
A4 Oh, Susanna!
A5 The Man On The Flying Trapeze
A6 Blue-Tail Fly
A7 The Mail Must Go Through
A8 Home On The Range
A9 It Ain't Gonna Rain No More
A10 A Bicycle Built For Two
A11 Mary Had A Little Lamb
A12 Take Me Out To The Ballgame
A13 Friends Lullaby
B1 Old MacDonald Had A Farm
B2 The Hokey Pokey
B3 She'll Be Comin' Round The Mountain
B4 Ten Little Indians
B5 The Green Grass Grew All Around
B6 In The Good Old Summertime
B7 Animal Fair
B8 Row, Row, Row Your Boat
B9 I'm A Policeman
B10 Pop! Goes The Weasel
B11 Dixie
B12 Twinkle, Twinkle, Little Star

 

Cena: 500 CZK   (19.8 €)

 

Ostatní náhledy