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 'Spoonful & Others /Paul Butterfield/Eric Clapton*' IN BOOLEAN MODE)
' at line 10
query: SELECT LP.*,CAT.name_en as catname, CNT.name_en as countryname, CNT.code as countrycode, GROUP_CONCAT(GEN.name_en ORDER BY GEN.name_en 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 ('The Lovin' Spoonful & Others /Paul Butterfield/Eric Clapton*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (80613)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Product detail
The Lovin' Spoonful & Others /Paul Butterfield/Eric Clapton
What's Shakin'
Type: 33" LP
Year: 1968
Origin: Germany
Lbl.: Elektra - EKS 74 002
cat. no: B1 3360597
blues, rock
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 Lovin' Spoonful– Good Time Music
A2 The Lovin' Spoonful– Almost Grown
A3 The Paul Butterfield Blues Band– Spoonful
A4 The Paul Butterfield Blues Band– Off The Wall
A5 Al Kooper– Can't Keep From Crying Sometimes
A6 Eric Clapton And The Powerhouse– I Want To Know
A7 Eric Clapton And The Powerhouse– Crossroads
B1 The Paul Butterfield Blues Band– Lovin' Cup
B2 The Paul Butterfield Blues Band– Good Morning Little Schoolgirl
B3 Eric Clapton And The Powerhouse– Steppin' Out
B4 Tom Rush– I'm In Love Again
B5 The Lovin' Spoonful– Don't Bank On It Baby
B6 The Lovin' Spoonful– Searchin'
B7 The Paul Butterfield Blues Band– One More Mile
Price: 1 000 CZK (39.6 €)