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(111): 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 '' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,1' 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 ('Jimmie Haskell, White Lightnin' & Others*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (84573)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Jimmie Haskell, White Lightnin' & Others
Zachariah (Original Motion Picture Soundtrack)
Nosič: 33" LP
Rok vydání: 1970
původ: Spojené státy americké
Lbl.: ABC Records – ABCS-OC-13
kat. číslo: B1 3364297
blues, filmová hudba, jazz, swing, 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 Jimmie Haskell– Zachariah (Main Title)
A2 The James Gang– Laguna Salada
A3 Country Joe And The Fish– We're The Crackers
A4 Jimmie Haskell– William Tell Overture
A5 Country Joe And The Fish– All I Need
A6 Doug Kershaw– Ballad Of Job Cain
A7 The James Gang– Country Fever
B1 Jimmie Haskell– The Lonely Ride
B2 Jimmie Haskell– Camino/Used Horse Salesman
B3 Jimmie Haskell– Camino Waltz
B4 The New York Rock And Roll Ensemble*– Gravedigger
B5 White Lightnin'– Shy Ann
B6 Jimmie Haskell– Matthew
B7 Jimmie Haskell– Zachariah (End Title)
Cena: 300 CZK (12.0 €)
