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

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

Album

Disney's Children's Favorites Volume II / USA

Ostatní náhledy
Specifikace / Specification
Nosič: 33" LP
Rok vydání: 1979
původ: Spojené státy americké
kat. číslo: B1 3371324
Label: Disneyland – 2508
Žánry / Genres
pohádky, pro děti
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

A1  The Farmer In The Dell
A2  Yankee Doodle
A3  On Top Of Old Smoky
A4  Sailing Medley
A4.a  Blow The Man Down
A4.b  My Bonnie Lies Over The Ocean
A4.c  Sailing, Sailing
A4.d  Up She Rises
A5  Camptown Races
A6  Old Blue
A7  Here We Go Loopty-Loo
A8  The Sidewalks Of New York (East Side, West Side)
A9  Shortnin' Bread
A10  John Jacob Jingleheimer Schmidt
A11  Thumbelina
A12  The Bear Went Over The Mountain
A13  Red River Valley
B1  Skip To My Lou
B2  Swanee River (Old Folks At Home)
B3  Western Medley
B3.a  The Yellow Rose Of Texas
B3.b  Buffalo Gals
B4  London Bridge
B5  Here We Go 'Round The Mulberry Bush
B6  Frere Jacques
B7  The Dumptruck Song
B8  Bingo
B9  Polly Wolly Doodle
B10  There Was An Old Lady
B11  Carrot Stew
B12  When The Saints Go Marching In

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