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 Band, Armand Hug's Trio*' IN BOOLEAN MODE)
AND LP.st' 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 ('Eddie Pierson's Band, Armand Hug's Trio*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (66432)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Eddie Pierson's Band, Armand Hug's Trio
Recorded In New Orleans Vol. 2
Nosič: 33" LP
Rok vydání: 1957
původ: Spojené státy americké
Lbl.: Good Time Jazz – L-12020
kat. číslo: B1 3348455
jazz, swing
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 Johnny Wiggs' New Orleans Music Gallatin Street Grind
A2 Johnny Wiggs' New Orleans Music Sweet Substitute
A3 Johnny Wiggs' New Orleans Music Everybody Loves My Baby
A4 Eddie Pierson's Band Gettysburg March
A5 Eddie Pierson's Band In Gloryland
A6 Eddie Pierson's Band Bill Bailey
B1 Santo Pecora & The Tailgaters Alabamy Bound
B2 Santo Pecora & The Tailgaters Zero
B3 Santo Pecora & The Tailgaters Struttin' With Some Barbecue
B4 Armand Hug's Trio My Old Time Sweetheart
B5 Armand Hug's Trio Doodle Doo Doo
B6 Armand Hug's Trio Dixie Bug
Cena: 1 000 CZK (39.8 €)