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 Creole Jazz Band, Piccadilly Revels Band & další*' 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 ('King Oliver's Creole Jazz Band, Piccadilly Revels Band & další*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (85781)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
King Oliver's Creole Jazz Band, Piccadilly Revels Band & další
Písně Otce Vod 3
Nosič: 33" LP
Rok vydání: 1981
původ: Česká republika
Lbl.: Supraphon – 1015 2748, Gramofonový Klub – 1015 2748
kat. číslo: B1 3365457
blues, jazz, swing, pop
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 King Oliver's Creole Jazz Band– Riverside Blues
A2 The Kit-Cat Band– Riverboat Shuffle
A3 The Kit-Cat Band– Muddy Water
A4 Frankie Trumbauer And His Orchestra– Blue River
A5 Piccadilly Revels Band– Deep River Blues
A6 The Rhythmic Eight– Mississippi Mud
A7 Bix Beiderbecke And His Gang– Ol'Man River
B1 Ray Noble & His New Mayfair Dance Orchestra– Roll On, Mississippi, Roll On
B2 Unknown Artist– Steamboat Bill
B3 Ray Noble & His New Mayfair Dance Orchestra– Sailin On The Robert E.lee
B4 Adrian Rollini And His Orchestra– Mississippi Basin
B5 Billy Cotton And His Band– Waiting For The Robert E. Lee
B6 Lew Stone And His Orchestra– Down By The River
B7 Nat Gonella & His Georgians– Where The Lazy Rivergoes By
Cena: 250 CZK (10.0 €)
