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 'Hopkins, Leadbelly, Memphis Slim*' IN BOOLEAN MODE)
AN' 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 ('John Lee Hooker, Lightnin' Hopkins, Leadbelly, Memphis Slim*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (87628)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
John Lee Hooker, Lightnin' Hopkins, Leadbelly, Memphis Slim
The Blues Legend
Nosič: 33" LP
Rok vydání: -
původ: Německo
Lbl.: Time Wind – F/4 50031
kat. číslo: B1 3367105
blues
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
4LP
A1 John Lee Hooker– Little Wheel
A2 John Lee Hooker– I'm In The Mood
A3 John Lee Hooker– Hobo Blues
A4 John Lee Hooker– Crawling King Snake
A5 John Lee Hooker– Blues Before Sunrise
B1 John Lee Hooker– Want Ad Blue
B2 John Lee Hooker– My First Wife Left Me
B3 John Lee Hooker– Wednesday Evening Blues
B4 John Lee Hooker– Maudie
B5 John Lee Hooker– Time Is Marching
C1 Lightnin' Hopkins– Short Haired Woman
C2 Lightnin' Hopkins– Bottle It Up And Go
C3 Lightnin' Hopkins– Long Time
C4 Lightnin' Hopkins– The Foot Race Is On
C5 Lightnin' Hopkins– Prison Blues Come Down On Me
C6 Lightnin' Hopkins– Bunion Stew
D1 Lightnin' Hopkins– Mama And Papa Hopkins
D2 Lightnin' Hopkins– Get Off My Toe
D3 Lightnin' Hopkins– Trouble In Mind
D4 Lightnin' Hopkins– Gonna Pull A Party
D5 Lightnin' Hopkins– Till The Gin Runs Out
D6 Lightnin' Hopkins– When The Saints Go Marchin' In
E1 Leadbelly– The Burgeouis Blues
E2 Leadbelly– Looky, Looky Yonder, Black Betty, Yellow Woman's Doorbells
E3 Leadbelly– Poor Howard Greenhorn
E4 Leadbelly– The Gallis Pole
E5 Leadbelly– Dekalb Woman
F1 Leadbelly– Noted Rider
F2 Leadbelly– Big Fat Woman
F3 Leadbelly– Burrow Love & Co
F4 Leadbelly– Bring Me Li'l Water Silvy
F5 Leadbelly– Julie Ann Johnson
F6 Leadbelly– Line 'Em
F7 Leadbelly– Whoe Back Buck
F8 Leadbelly– John Hardy
G1 Memphis Slim– El Capitan
G2 Memphis Slim– This Is A Good Time To Write A Song
G3 Memphis Slim– I'm So Alone
G4 Memphis Slim– True Love
G5 Memphis Slim– Two Of A Kind
G6 Memphis Slim– Big City Girl
H1 Memphis Slim– Three And One Boogie
H2 Memphis Slim– Bertha May
H3 Memphis Slim– Celeste Boogie No. 2
H4 Memphis Slim– Three Woman Blue
Cena: 1 000 CZK (39.8 €)
