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 'Red' Hastings* And Danny Turner, Eddie Woodland*' 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 ('Count 'Red' Hastings* And Danny Turner, Eddie Woodland*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (18829)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Product detail
Count 'Red' Hastings* And Danny Turner, Eddie Woodland
Count 'Red' Hastings
Type: 33" LP
Year: 1988
Origin: Great Britain
Lbl.: Krazy Kat – KK 823
cat. no: PN 3314690
blues, jazz, swing
obal a deska jako nove,nepouzite
A1 –Count Hastings Diga Diga Do
A2 –Count Hastings Sugar Cane
A3 –Count Hastings Minor In The Diner
A4 –Count Hastings She's Funny That Way
A5 –Count Hastings Patches
A6 –Count Hastings Begin The Beguine
A7 –Count Hastings Candied Yam
B1 –Count Hastings Patches
B2 –Count Hastings Baboo
B3 –Count Hastings Minor In The Diner
B4 –Danny Turner Midnight Moan
B5 –Eddie Woodland Snap Case
B6 –Eddie Woodland Jumpin' With Pio
B7 –Danny Turner Danny's Jump
Price: 600 CZK (24.6 €)
