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 'Reebop' Kwaku Baah*, Jim Gordon – Welcome To The Canteen*' IN BOOLEAN MODE)
' 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 ('Steve Winwood, Jim Capaldi, Dave Mason, Chris Wood (2), Rick Grech, 'Reebop' Kwaku Baah*, Jim Gordon – Welcome To The Canteen*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (93427)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Artist
Steve Winwood, Jim Capaldi, Dave Mason, Chris Wood (2), Rick Grech, 'Reebop' Kwaku Baah*, Jim Gordon – Welcome To The Canteen
Album
Welcome To The Canteen
Nosič:
33" LP
Rok vydání:
1971
původ:
Spojené státy americké
kat. číslo:
B1 3371581
Label:
United Artists Records – UAS-5550
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 Medicated Goo
A2 Sad And Deep As You
A3 40,000 Headmen
A4 Shouldn't Have Took More Than You Gave
B1 Dear Mr. Fantasy
B2 Gimme Some Lovin'
Cena: 1 000 CZK
Cena: 41.4 €
Vložit produkt do košíku může pouze
registrovaný a přihlášený uživatel.