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 Swallow Band, Ambrose Sam's Old Time Zydeco*' 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 ('Preston Frank's Swallow Band, Ambrose Sam's Old Time Zydeco*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (64122)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Preston Frank's Swallow Band, Ambrose Sam's Old Time Zydeco
Zydeco Vol. 2
Nosič: 33" LP
Rok vydání: 1985
původ: Spojené státy americké
Lbl.: Arhoolie Records – 1090
kat. číslo: B1 3346555
cajun, zydeco, country, folk, ethno, trampské
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 –Preston Frank's Swallow Band Shake What You Got
A2 –Preston Frank's Swallow Band Bals De Lake Charles
A3 –Preston Frank's Swallow Band Mon Chere Tite Monde
A4 –Preston Frank's Swallow Band Tanta Na-Na
A5 –Preston Frank's Swallow Band Ton Aller La Bas
A6 –Preston Frank's Swallow Band Font Kilo
A7 –Preston Frank's Swallow Band Why Do You Want To Make Me Cry
B1 –Ambrose Sam's Old Time Zydeco Ow Yes, I'm Going Away
B2 –Ambrose Sam's Old Time Zydeco Santa Fe Blues
B3 –Ambrose Sam's Old Time Zydeco I'm Going In The Country
B4 –Ambrose Sam's Old Time Zydeco Ma Negress La Bas
B5 –Ambrose Sam's Old Time Zydeco Please Don't Go
B6 –Ambrose Sam's Old Time Zydeco Old Time Zydeco
Cena: 1 000 CZK (40.0 €)
