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 'Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richa' 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 ('Lightnin' Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richard "Groove" Holmes*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (27086)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Lightnin' Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richard "Groove" Holmes
The Blues Box
Nosič: 33" LP
Rok vydání: 1966
původ: Spojené státy americké
Lbl.: Verve Folkways – FT-3011-3
kat. číslo: PN 3320337
blues, R 'n' B
Stav desky: NM
- jako nová, téměř nehraná
Stav obalu: VG+
- větší pomačkání obalu, můžou být odřeniny apod.
Pozn.: znaménko + nebo - upřesňuje stav desky, obalu
A1 –Lightnin' Hopkins Big Car Blues 7:13
A2 –Lightnin' Hopkins Coffee House Blues 2:15
A3 –Lightnin' Hopkins Stool Pigeon Blues 3:15
A4 –Lightnin' Hopkins Ball Of Twine 2:30
B1 –Sonny Terry & Brownie McGhee Walk On 4:20
B2 –Sonny Terry & Brownie McGhee Blues For The Lowlands 4:50
B3 –Sonny Terry & Brownie McGhee Gonna Lay My Body Down 3:17
B4 –Sonny Terry & Brownie McGhee Just Rode In Your Town 3:59
B5 –Sonny Terry & Brownie McGhee Sun's Gonna Shine 3:15
C1 –Sonny Terry & Brownie McGhee Drinking In The Blues 5:08
C2 –Sonny Terry & Brownie McGhee Po' Boy 3:05
C3 –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams Everybody's Blues (Three Aces On The Bottom Of The Deal) 6:42
C4 –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams Razor Sharp Blues 4:50
D1 –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams Chain Gang Blues 5:17
D2 –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams Brand New Car 5:29
D3 –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams I've Been Scorned 5:10
D4 –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams Great Gospel Blues 2:50
E1 –Jimmy Witherspoon, Richard "Groove" Holmes Tell Him I Was Flyin', Pt. 1 2:09
E2 –Jimmy Witherspoon, Richard "Groove" Holmes Goin' To Chicago Blues 3:57
E3 –Jimmy Witherspoon, Richard "Groove" Holmes In Blues 3:31
E4 –Jimmy Witherspoon, Richard "Groove" Holmes Gee Baby, Ain't I Good To You? 2:35
E5 –Jimmy Witherspoon, Richard "Groove" Holmes Loser's Blues 2:10
E6 –Jimmy Witherspoon, Richard "Groove" Holmes Please Send Me Someone To Love 2:20
F1 –Jimmy Witherspoon, Richard "Groove" Holmes Life's Highway (Key To The Highway) 2:25
F2 –Jimmy Witherspoon, Richard "Groove" Holmes Cry The Blues 2:05
F3 –Jimmy Witherspoon, Richard "Groove" Holmes Out Blues 2:30
F4 –Jimmy Witherspoon, Richard "Groove" Holmes Since I Fell For You 3:35
F5 –Jimmy Witherspoon, Richard "Groove" Holmes Everything 2:18
F6 –Jimmy Witherspoon, Richard "Groove" Holmes Tell Him I Was Flyin', Pt. 2 3:05
Cena: 3 000 CZK (119.8 €)
