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 (22298)
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: PN 3317374
blues
Stav desky: M
- nová, nehraná deska
Stav obalu: M-
- bezchybný, nový nebo jako nový
Pozn.: znaménko + nebo - upřesňuje stav desky, obalu
NEHRANE,PERFEKT
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 Bues 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: 2 000 CZK (79.3 €)
